The DB2DB02TSSIZE table in SAP ERP or S/4HANA stores Transaction DB02: List of tablespace datasets data. There are total 11 fields in DB2DB02TSSIZE table. The Transaction DB02: List of tablespace datasets 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 DB2DB02TSSIZE 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 DB2DB02TSSIZE Table Fields
Following is the list of fields that are available in SAP DB2DB02TSSIZE table. The primary key fields of Transaction DB02: List of tablespace datasets table in SAP are DBNAME (Database name), TSNAME (Name of the tablespace), STORDATE (Date when the storage information has been collected), STORTIME (Time when the storage information has been collected).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DBNAME | Database name | DB2DBNAME | CHAR (8) | |
| TSNAME | Name of the tablespace | DB2TSNAME | CHAR (8) | |
| STORDATE | Date when the storage information has been collected | DB2STODATE | DATS (8) | |
| STORTIME | Time when the storage information has been collected | DB2STOTIME | TIMS (6) | |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR (8) | |
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 (5) | |
| DSNAME | Dataset name | DB2DSNAME | CHAR (44) | |
| ALLOCSIZE | Allocated storage of a partition of a tablespace in KB | DB2TSSIZP | DEC (11) | |
| FREESIZE | Free size of partition of a tablespace in KB | DB2TSFREEP | DEC (11) | |
| PCTUSED | Percentage of used size to allocated size of a tablespace | DB2TSPCTU | DEC (3) | |
| QTYUNIT | Unit in which primary and secondary allocation are given | DB2QTYUNIT | CHAR (8) |
