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 |