DB2TSSIZE_T - DB2/390: Storage Information on R/3 Tablespaces
DB2/390: Storage Information on R/3 Tablespaces information is stored in SAP table DB2TSSIZE_T.
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 DB2TSSIZE_T
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TSNAME | Name of the tablespace | X | DB2TSNAME | CHAR | 8 | |
| DBNAME | Database name | X | DB2DBNAME | CHAR | 8 | |
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 | 2 | ||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| DSNAME | Dataset name | DB2DSNAME | CHAR | 44 | ||
| EXTENTS | Total number of extents of a tablespace or index | DB2NUMEXT5 | DEC | 3 | ||
| ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DB2TSSIZ | DEC | 6 | ||
| FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | DB2TSFREE | DEC | 6 | ||
| PCTUSED | Percentage of used size to allocated size of a tablespace | DB2TSPCTU | DEC | 2 | ||
| MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | DB2MAXEXTS | INT4 | 4 | ||
| PQTY | Primary space allocation | DB2PQTY | INT4 | 4 | ||
| SQTY | Secondary space allocation | DB2SQTY | INT4 | 4 | ||
| QTYUNIT | Unit in which primary and secondary allocation are given | DB2QTYUNIT | 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 |