DB2DB02IX_SUM - Tx DB02: Summary of Index info. Partitions are summed up
Tx DB02: Summary of Index info. Partitions are summed up information is stored in SAP table DB2DB02IX_SUM.
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 DB2DB02IX_SUM
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 | |
| 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 | ||
| MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | DB2MAXEXTS | INT4 | 4 | ||
| SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | DB2SUMEXTS | INT4 | 4 | ||
| SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | DB2DASD_USE_SUM | FLTP | 8 | ||
| SUM_ALLOCSIZE | Total size of an index (allocated storage in KB) | DB2IXSIZ | DEC | 6 | ||
| SUM_FREESIZE | Free size of an index in KB (allocated minus used storage) | DB2IXFREE | DEC | 6 | ||
| PCTUSED | Percentage of used size to allocated size of an index | DB2IXPCTUS | DEC | 2 | ||
| RTS_LAST_REORG | Timestamp of last REORG | DB2CCOTIME | CHAR | 26 | ||
| RTS_TOTALENTRIES | DB2/zOS: Real-Time Statistics index TOTALENTRIES | DB2RTSTOTALENTRY | FLTP | 8 | ||
| RTS_CHANGES | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | INT4 | 4 | ||
| RTS_REORG_RECS | DB2/zOS: Number of REORG recommendations by DSNACCOR | DB2CCREORGRECS | INT4 | 4 | ||
| TBCREATOR | Authorization ID of the owner of the table | DB2TBCREA | CHAR | 8 | ||
| TBNAME | Name of the table on which the index is defined | DB2TBNAME | CHAR | 18 | ||
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 |