DB2DB02EXTENTS - Tx DB02: Data for DB02's Extent Monitor
Tx DB02: Data for DB02's Extent Monitor information is stored in SAP table DB2DB02EXTENTS.
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 DB2DB02EXTENTS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| QUAL1 | First part of name qualifiying the object that got ext.alert | X | DB2XMQ1 | CHAR | 8 | |
| QUAL2 | Sec. part of name qualifiying the object that got ext. alert | X | DB2XMQ2 | CHAR | 18 | |
| PARTNR | Number of partition | X | DB2PARTNRI | INT4 | 4 | |
| TYPE | Type of object that got an extent alert | DB2XMTYP | CHAR | 2 | ||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | ||
| ALERT_DATE | Date of the last check | DB2BCKDATE | DATS | 8 | ||
| ALERT_TIME | Time of the last check | DB2BCKTIME | TIMS | 6 | ||
| SEVERITY | Severity of an extent alert | DB2XMSEV | NUMC | 2 | ||
| EXTENTS | Number of extents | DB2NUMEXTI | INT4 | 4 | ||
| LAST_REORG | Timestamp of last REORG | DB2CCOTIME | CHAR | 26 | ||
| LAST_ALTER | Date of last ALTER INDEX|TABLESPACE SECQTY | DB2XMLALT | DATS | 8 | ||
| EXTENT_OLD | Number of extents before last ALTER SECQTY | DB2XMEXTOL | INT4 | 4 | ||
| EXTENSION | Last qualifier of dataset name of a DB2 tablespace or index | DB2DSEXT | CHAR | 4 |