Data Element list used by SAP ABAP Table DB2DB02TBSIZE (Transaction DB02: List of tables and tablespace (Details))
SAP ABAP Table
DB2DB02TBSIZE (Transaction DB02: List of tables and tablespace (Details)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CCCHGA | RUN.:Changed rows (insert, delete or update) absolute number | ||
| 2 | DB2CREATOR | DB2 creator name | ||
| 3 | DB2DBNAME | Database name | ||
| 4 | DB2NUMPART | Number of partitions of a tablespace or index | ||
| 5 | DB2RTSTBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | ||
| 6 | DB2STATSTM | Date and time of last RUNSTATS | ||
| 7 | DB2STODATE | Date when the storage information has been collected | ||
| 8 | DB2STOTIME | Time when the storage information has been collected | ||
| 9 | DB2TBAVGROWLEN | Average row length of table | ||
| 10 | DB2TBNAME | Name of the table on which the index is defined | ||
| 11 | DB2TBSPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | ||
| 12 | DB2TBTOTALROWS | Real Time Statistics: Number of rows in Table | ||
| 13 | DB2TSFREE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 14 | DB2TSNAME | Name of the tablespace | ||
| 15 | DB2TSPCTU | Percentage of used size to allocated size of a tablespace | ||
| 16 | DB2TSSIZ | Total size of a tablespace (allocated storage in KB) |