DB2DB02TSSIZE - Transaction DB02: List of tablespace datasets
Transaction DB02: List of tablespace datasets information is stored in SAP table DB2DB02TSSIZE.
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 DB2DB02TSSIZE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DBNAME | Database name | X | DB2DBNAME | CHAR | 8 | |
| TSNAME | Name of the tablespace | X | DB2TSNAME | CHAR | 8 | |
| PART_EXTENSION | Extension or Partition (non-partitioned TS) number | X | DB2PARTEXT | INT4 | 4 | |
| STORDATE | Date when the storage information has been collected | X | DB2STODATE | DATS | 8 | |
| STORTIME | Time when the storage information has been collected | X | DB2STOTIME | TIMS | 6 | |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 | 2 | ||
| DSNAME | Dataset name | DB2DSNAME | CHAR | 44 | ||
| EXTENTS | Number of extents | DB2NUMEXTI | INT4 | 4 | ||
| DASD_USAGE | Actual DASD usage (in KB) of dataset | DB2DASD_USAGE | INT4 | 4 | ||
| ALLOCSIZE | Allocated storage of a partition of a tablespace in KB | DB2TSSIZP | DEC | 6 | ||
| FREESIZE | Free size of partition of a tablespace in KB | DB2TSFREEP | DEC | 6 | ||
| PCTUSED | Percentage of used size to allocated size of a tablespace | DB2TSPCTU | DEC | 2 | ||
| 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 |