DB2DB02TBDYN - Tx DB02: Dynamics of the size of tables
Tx DB02: Dynamics of the size of tables information is stored in SAP table DB2DB02TBDYN.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2DB02TBDYN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CREATOR | DB2 creator name | X | DB2CREATOR | CHAR | 8 | |
| TBNAME | Name of the table on which the index is defined | X | DB2TBNAME | CHAR | 18 | |
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 | ||
| TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | DB2RTSTBSIZE | FLTP | 8 | ||
| TBSIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| TBSIZE_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| TBSIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | DB2CHGTBSD | FLTP | 8 | ||
| W_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | DB2CHGTBSW | FLTP | 8 | ||
| M_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | DB2CHGTBSM | FLTP | 8 | ||
| RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | FLTP | 8 | ||
| TOTALROWS_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| TOTALROWS_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| TOTALROWS_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_TOTALROWS | Number of Rows: changes per day | DB2CHGROWD | FLTP | 8 | ||
| W_TOTALROWS | Number of Rows: changes per week | DB2CHGROWW | FLTP | 8 | ||
| M_TOTALROWS | Number of Rows: changes per month | DB2CHGROWM | FLTP | 8 | ||
| SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | DB2TBSPACEF | FLTP | 8 | ||
| SPACEF_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| SPACEF_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| SPACEF_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_SPACEF | Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFD | FLTP | 8 | ||
| W_SPACEF | Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFW | FLTP | 8 | ||
| M_SPACEF | Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFM | FLTP | 8 |