DD02DB2 - DB2/390: Table Parameters
DB2/390: Table Parameters information is stored in SAP table DD02DB2.
It is part of development package SDB2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "DB2/390: DDIC".
It is part of development package SDB2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "DB2/390: DDIC".
Fields for table DD02DB2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TABNAME | Table Name | X | TABNAME | CHAR | 30 | * |
| SOURCE | Source, originator of the DB values parameter | X | TPARSOURCE | CHAR | 3 | |
| USEFLAG | Storage parameters used for conversion/creation | NEWSTOPAR | CHAR | 1 | ||
| .INCLUDE | DB2TABSTOR | 0 | ||||
| STABFLAG | Determines whether table is created in a separate tablespace | CHAR | 1 | |||
| TABSPACE | DB2/MVS - Tablespace in which tables reside | CHAR | 8 | |||
| DBNAME | DB2/MVS database name | CHAR | 8 | |||
| DSTOGROUP | DB2 for OS/390: Storage group for tables | CHAR | 8 |