The DB2DB02TBDYN table in SAP ERP or S/4HANA stores Tx DB02: Dynamics of the size of tables data. There are total 22 fields in DB2DB02TBDYN table. The Tx DB02: Dynamics of the size of tables table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DB2DB02TBDYN table. It is in CCMS for DB2 for OS/390 (STU2) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DB2DB02TBDYN Table Fields
Following is the list of fields that are available in SAP DB2DB02TBDYN table. The primary key fields of Tx DB02: Dynamics of the size of tables table in SAP are CREATOR (DB2 creator name), TBNAME (Name of the table on which the index is defined).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CREATOR | DB2 creator name | DB2CREATOR | CHAR (8) | |
| TBNAME | Name of the table on which the index is defined | 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 (16) | |
| TBSIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP (16) | |
| TBSIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP (16) | |
| D_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | DB2CHGTBSD | FLTP (16) | |
| W_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | DB2CHGTBSW | FLTP (16) | |
| M_TBSIZE | RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | DB2CHGTBSM | FLTP (16) | |
| RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | FLTP (16) | |
| TOTALROWS_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP (16) | |
| TOTALROWS_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP (16) | |
| D_TOTALROWS | Number of Rows: changes per day | DB2CHGROWD | FLTP (16) | |
| W_TOTALROWS | Number of Rows: changes per week | DB2CHGROWW | FLTP (16) | |
| M_TOTALROWS | Number of Rows: changes per month | DB2CHGROWM | FLTP (16) | |
| SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | DB2TBSPACEF | FLTP (16) | |
| SPACEF_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP (16) | |
| SPACEF_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP (16) | |
| D_SPACEF | Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFD | FLTP (16) | |
| W_SPACEF | Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFW | FLTP (16) | |
| M_SPACEF | Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | DB2CHGSPFM | FLTP (16) |
