The DB2DB02TSDYN table in SAP ERP or S/4HANA stores Tx DB02: Dynamics of the size of tablespaces data. There are total 16 fields in DB2DB02TSDYN table. The Tx DB02: Dynamics of the size of tablespaces 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 DB2DB02TSDYN 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 DB2DB02TSDYN Table Fields
Following is the list of fields that are available in SAP DB2DB02TSDYN table. The primary key fields of Tx DB02: Dynamics of the size of tablespaces table in SAP are DBNAME (Database name), TSNAME (Name of the tablespace), PART_NR (Partition number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DBNAME | Database name | DB2DBNAME | CHAR (8) | |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR (8) | |
| PART_NR | Partition number | DB2PARTNRS | INT2 (5) | |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR (8) | |
| ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DB2TSSIZ | DEC (11) | |
| D_ALLOCSIZ | Allocated storage in KB: change per day | DB2CHGSIZD | DEC (11) | |
| W_ALLOCSIZ | Allocated storage in KB: change per week | DB2CHGSIZW | DEC (11) | |
| M_ALLOCSIZ | Allocated storage in KB: change per month | DB2CHGSIZM | DEC (11) | |
| FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | DB2TSFREE | DEC (11) | |
| D_FREESIZ | Free storage (allocated minus used) in KB: change per day | DB2CHGFRED | DEC (11) | |
| W_FREESIZ | Free storage (allocated minus used) in KB: change per week | DB2CHGFREW | DEC (11) | |
| M_FREESIZ | Free storage (allocated minus used) in KB: change per month | DB2CHGFREM | DEC (11) | |
| RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | 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) |
