Data Element list used by SAP ABAP Table DB2DB02TBDYN (Tx DB02: Dynamics of the size of tables)
SAP ABAP Table
DB2DB02TBDYN (Tx DB02: Dynamics of the size of tables) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CHGROWD | Number of Rows: changes per day | ||
| 2 | DB2CHGROWM | Number of Rows: changes per month | ||
| 3 | DB2CHGROWW | Number of Rows: changes per week | ||
| 4 | DB2CHGSPFD | Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ||
| 5 | DB2CHGSPFM | Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ||
| 6 | DB2CHGSPFW | Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ||
| 7 | DB2CHGTBSD | RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | ||
| 8 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 9 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 10 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 11 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 12 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 13 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 14 | DB2CHGTBSM | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | ||
| 15 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 16 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 17 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 18 | DB2CHGTBSW | RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | ||
| 19 | DB2CREATOR | DB2 creator name | ||
| 20 | DB2DBNAME | Database name | ||
| 21 | DB2RTSTBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | ||
| 22 | DB2RTSTOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | ||
| 23 | DB2TBNAME | Name of the table on which the index is defined | ||
| 24 | DB2TBSPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | ||
| 25 | DB2TSNAME | Name of the tablespace |