Data Element list used by SAP ABAP Table DB2DB02TS_SUM (Tx DB02: Summary of TS info. Partitions are summed up)
SAP ABAP Table
DB2DB02TS_SUM (Tx DB02: Summary of TS 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 | DB2DBNAME | Database name | ||
| 8 | DB2MAXEXTS | Maximum number of extents of a partition of the TS or IX | ||
| 9 | DB2NUMPART | Number of partitions of a tablespace or index | ||
| 10 | DB2RTSTOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | ||
| 11 | DB2STODATE | Date when the storage information has been collected | ||
| 12 | DB2STOTIME | Time when the storage information has been collected | ||
| 13 | DB2SUMEXTS | Total number of extents of a TS or index (parts summed up) | ||
| 14 | DB2TSFREE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 15 | DB2TSNAME | Name of the tablespace | ||
| 16 | DB2TSNAME | Name of the tablespace | ||
| 17 | DB2TSPCTU | Percentage of used size to allocated size of a tablespace | ||
| 18 | DB2TSSIZ | Total size of a tablespace (allocated storage in KB) |