Data Element list used by SAP ABAP Table DB2DB02IX_SUM (Tx DB02: Summary of Index info. Partitions are summed up)
SAP ABAP Table
DB2DB02IX_SUM (Tx DB02: Summary of Index info. Partitions are summed up) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CCOTIME | Timestamp of last REORG | ||
| 2 | DB2CCRCHGA | REO.:Changed rows (insert, delete or update) absolute number | ||
| 3 | DB2CCREORGRECS | DB2/zOS: Number of REORG recommendations by DSNACCOR | ||
| 4 | DB2CREATOR | DB2 creator name | ||
| 5 | DB2DASD_USE_SUM | Actual DASD usage (in KB) of TS (sum of partitions) | ||
| 6 | DB2DBNAME | Database name | ||
| 7 | DB2IDXNAME | Name of a DB2 for OS/390 index | ||
| 8 | DB2IXFREE | Free size of an index in KB (allocated minus used storage) | ||
| 9 | DB2IXPCTUS | Percentage of used size to allocated size of an index | ||
| 10 | DB2IXSIZ | Total size of an index (allocated storage in KB) | ||
| 11 | DB2IXSPACE | Name of the indexspace that contains the index | ||
| 12 | DB2MAXEXTS | Maximum number of extents of a partition of the TS or IX | ||
| 13 | DB2NUMPART | Number of partitions of a tablespace or index | ||
| 14 | DB2RTSTOTALENTRY | DB2/zOS: Real-Time Statistics index TOTALENTRIES | ||
| 15 | DB2STODATE | Date when the storage information has been collected | ||
| 16 | DB2STOTIME | Time when the storage information has been collected | ||
| 17 | DB2SUMEXTS | Total number of extents of a TS or index (parts summed up) | ||
| 18 | DB2TBCREA | Authorization ID of the owner of the table | ||
| 19 | DB2TBNAME | Name of the table on which the index is defined | ||
| 20 | DB2TSNAME | Name of the tablespace |