DB2DB02TS_HIS - Tx DB02: Short history of TS info
Tx DB02: Short history of TS info information is stored in SAP table DB2DB02TS_HIS.
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_HIS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| STORDATE | Date when the storage information has been collected | X | DB2STODATE | DATS | 8 | |
| 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 | |
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 | 2 | ||
| EXTENTS | Number of extents | DB2NUMEXTI | 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 | ||
| 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 |