DB2DB02EXTENTS is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of DB2DB02EXTENTS in SAP.
- Table description : Tx DB02: Data for DB02's Extent Monitor
- Module : BC-DB-DB2
- Parent Module : BC
- Package : STU2
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP DB2DB02EXTENTS Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| QUAL1 | First part of name qualifiying the object that got ext.alert | DB2XMQ1 | CHAR8 |
| QUAL2 | Sec. part of name qualifiying the object that got ext. alert | DB2XMQ2 | CHAR18 |
| PARTNR | Number of partition | DB2PARTNRI | |
| TYPE | Type of object that got an extent alert | DB2XMTYP | DB2XMTYP |
| CREATOR | DB2 creator name | DB2CREATOR | CHAR8 |
| ALERT_DATE | Date of the last check | DB2BCKDATE | DATUM |
| ALERT_TIME | Time of the last check | DB2BCKTIME | TIME |
| SEVERITY | Severity of an extent alert | DB2XMSEV | NUMC2 |
| EXTENTS | Number of extents | DB2NUMEXTI | |
| LAST_REORG | Timestamp of last REORG | DB2CCOTIME | DB2TMSTMP |
| LAST_ALTER | Date of last ALTER INDEX|TABLESPACE SECQTY | DB2XMLALT | DATS |
| EXTENT_OLD | Number of extents before last ALTER SECQTY | DB2XMEXTOL | |
| EXTENSION | Last qualifier of dataset name of a DB2 tablespace or index | DB2DSEXT | CHAR4 |
DB2DB02EXTENTS related tables
| Table | Note |
|---|