DD12DB2 - DB2/390: Index Parameters
DB2/390: Index Parameters information is stored in SAP table DD12DB2.
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 DD12DB2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| INDNAME | Database index | X | DBINDEX_D | CHAR | 80 | |
| SOURCE | Source, originator of the DB values parameter | X | TPARSOURCE | CHAR | 6 | |
| USEFLAG | Storage parameters used for conversion/creation | NEWSTOPAR | CHAR | 2 | ||
| .INCLUDE | DB2INDSTOR | 0 | ||||
| ISTOGROUP | DB2/390: Stogroup (Indexes) | ISTOGROUP | CHAR | 16 | ||
| DB2PRIQTY | DB2/390: Primary quantity | DB2PRIQTY | NUMC | 20 | ||
| DB2SECQTY | DB2/390: Secondary quantity | DB2SECQTY | NUMC | 20 | ||
| DB2PCTFREE | DB2/390: Free space percentage on each page | DB2PCTFREE | NUMC | 4 | ||
| DB2BUFPOOL | DB2/390: Buffer pool | DB2BUFPOOL | CHAR | 16 |