SAP ABAP Table DB2DB02EXTENTS (Tx DB02: Data for DB02's Extent Monitor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DB2DB02EXTENTS	Table Relationship Diagram
Short Description	Tx DB02: Data for DB02's Extent Monitor

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	QUAL1	☑	DB2XMQ1	CHAR8	CHAR	8	0	First part of name qualifiying the object that got ext.alert
2	QUAL2	☑	DB2XMQ2	CHAR18	CHAR	18	0	Sec. part of name qualifiying the object that got ext. alert
3	PARTNR	☑	DB2PARTNRI		INT4	10	0	Number of partition
4	TYPE	☐	DB2XMTYP	DB2XMTYP	CHAR	2	0	Type of object that got an extent alert
5	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
6	ALERT_DATE	☐	DB2BCKDATE	DATUM	DATS	8	0	Date of the last check
7	ALERT_TIME	☐	DB2BCKTIME	TIME	TIMS	6	0	Time of the last check
8	SEVERITY	☐	DB2XMSEV	NUMC2	NUMC	2	0	Severity of an extent alert
9	EXTENTS	☐	DB2NUMEXTI		INT4	10	0	Number of extents
10	LAST_REORG	☐	DB2CCOTIME	DB2TMSTMP	CHAR	26	0	Timestamp of last REORG
11	LAST_ALTER	☐	DB2XMLALT	DATS	DATS	8	0	Date of last ALTER INDEX|TABLESPACE SECQTY
12	EXTENT_OLD	☐	DB2XMEXTOL		INT4	10	0	Number of extents before last ALTER SECQTY
13	EXTENSION	☐	DB2DSEXT	CHAR4	CHAR	4	0	Last qualifier of dataset name of a DB2 tablespace or index

History

Last changed by/on	SAP	20130604
SAP Release Created in	700