DB2DB02TS_SUM - Tx DB02: Summary of TS info. Partitions are summed up
Tx DB02: Summary of TS info. Partitions are summed up information is stored in SAP table DB2DB02TS_SUM.
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 DB2DB02TS_SUM
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 | |
| 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 | ||
| MAX_EXTENTS | Maximum number of extents of a partition of the TS or IX | DB2MAXEXTS | INT4 | 4 | ||
| SUM_EXTENTS | Total number of extents of a TS or index (parts summed up) | DB2SUMEXTS | INT4 | 4 | ||
| SUM_DASD_USAGE | Actual DASD usage (in KB) of TS (sum of partitions) | DB2DASD_USE_SUM | FLTP | 8 | ||
| SUM_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DB2TSSIZ | DEC | 6 | ||
| SUM_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 | ||
| RTS_LAST_REORG | Timestamp of last REORG | DB2CCOTIME | CHAR | 26 | ||
| RTS_TOTALROWS | DB2/zOS: Real-Time Statistics tablespace TOTALROWS | DB2RTSTOTALROWS | FLTP | 8 | ||
| RTS_CHANGES | REO.:Changed rows (insert, delete or update) absolute number | DB2CCRCHGA | INT4 | 4 | ||
| RTS_REORG_RECS | DB2/zOS: Number of REORG recommendations by DSNACCOR | DB2CCREORGRECS | INT4 | 4 | ||
| BASE_TS_DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| BASE_TS_TSNAME | Name of the tablespace | DB2TSNAME | CHAR | 8 |