DB2CCDL_OUTTS - DSNACCDL: History of output table
DSNACCDL: History of output table information is stored in SAP table DB2CCDL_OUTTS.
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 DB2CCDL_OUTTS
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 | |
| STORTIME | Time when the storage information has been collected | X | DB2STOTIME | TIMS | 6 | |
| DSNAME | Dataset name | X | DB2DSNAME | CHAR | 44 | |
| VOLUME | Serial number of the volume | X | DB2VOLID | CHAR | 6 | |
| CREATE_YEAR | Year of creation of data set | DB2DS_CREATYEAR | INT4 | 4 | ||
| CREATE_DAY | Day of creation of data set (Julian date) | DB2DS_CREATDAY | INT4 | 4 | ||
| DS_TYPE | Data set type in integer | DB2DS_TYPE | INT4 | 4 | ||
| PRIMARY_QTY | Primary space allocation | DB2PQTY | INT4 | 4 | ||
| SECONDARY_QTY | Secondary space allocation | DB2SQTY | INT4 | 4 | ||
| QTY_UNIT | Unit of primary and secondary allocation (Format CHAR9) | DB2QTYUNIT9 | CHAR | 9 | ||
| EXTENTS_IN_USE | Number of extents | DB2NUMEXTI | INT4 | 4 | ||
| DASD_USAGE | Actual DASD usage (in KB) of dataset | DB2DASD_USAGE | INT4 | 4 | ||
| DS_HARBA | Dataset High-Allocated RBA | DB2DS_HARBA | INT4 | 4 | ||
| DS_HURBA | Dataset High-Used RBA | DB2DS_HURBA | INT4 | 4 |