DB2DB02IXSIZE - Tx DB02: List of indexspace datasets
Tx DB02: List of indexspace datasets information is stored in SAP table DB2DB02IXSIZE.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2DB02IXSIZE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| IXCREATOR | DB2 creator name | X | DB2CREATOR | CHAR | 8 | |
| IXNAME | Name of a DB2 for OS/390 index | X | DB2IDXNAME | CHAR | 18 | |
| PART_EXTENSION | Extension or Partition (non-partitioned TS) number | X | DB2PARTEXT | INT4 | 4 | |
| STORDATE | Date when the storage information has been collected | X | DB2STODATE | DATS | 8 | |
| STORTIME | Time when the storage information has been collected | X | DB2STOTIME | TIMS | 6 | |
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| IXSPACE | Name of the indexspace that contains the index | DB2IXSPACE | CHAR | 8 | ||
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 | 2 | ||
| DSNAME | Dataset name | DB2DSNAME | CHAR | 44 | ||
| EXTENTS | Number of extents | DB2NUMEXTI | INT4 | 4 | ||
| DASD_USAGE | Actual DASD usage (in KB) of dataset | DB2DASD_USAGE | INT4 | 4 | ||
| ALLOCSIZE | Allocated storage of a partition of an index in KB | DB2IXSIZP | DEC | 6 | ||
| FREESIZE | Free size of an index partition in KB | DB2IXFREEP | DEC | 6 | ||
| PCTUSED | Percentage of used to alloc. size of a partition of an IX | DB2IXPCTUP | DEC | 2 | ||
| PQTY | Primary space allocation | DB2PQTY | INT4 | 4 | ||
| SQTY | Secondary space allocation | DB2SQTY | INT4 | 4 | ||
| QTYUNIT | Unit in which primary and secondary allocation are given | DB2QTYUNIT | CHAR | 8 |