The DB2DB02EXTENTS table in SAP ERP or S/4HANA stores Tx DB02: Data for DB02’s Extent Monitor data. There are total 10 fields in DB2DB02EXTENTS table. The Tx DB02: Data for DB02’s Extent Monitor table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DB2DB02EXTENTS table. It is in CCMS for DB2 for OS/390 (STU2) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DB2DB02EXTENTS Table Fields
Following is the list of fields that are available in SAP DB2DB02EXTENTS table. The primary key fields of Tx DB02: Data for DB02’s Extent Monitor table in SAP are QUAL1 (First part of name qualifiying the object that got ext.alert), QUAL2 (Sec. part of name qualifiying the object that got ext. alert).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| QUAL1 | First part of name qualifiying the object that got ext.alert | DB2XMQ1 | CHAR (8) | |
| QUAL2 | Sec. part of name qualifiying the object that got ext. alert | DB2XMQ2 | CHAR (18) | |
| 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) | |
| LAST_REORG | Timestamp of last REORG | DB2CCOTIME | CHAR (26) | |
| LAST_ALTER | Date of last ALTER INDEX|TABLESPACE SECQTY | DB2XMLALT | DATS (8) | |
| EXTENSION | Last qualifier of dataset name of a DB2 tablespace or index | DB2DSEXT | CHAR (4) |
