SAP ABAP Table DB2_DB02_IX_DETAILS (DB02: Detail Index Information)

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	INTTAB	Structure
Structure	DB2_DB02_IX_DETAILS	Table Relationship Diagram
Short Description	DB02: Detail Index Information

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
2	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
3	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
4	CLUSTERRATIO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
5	FIRSTKEY	☐	DB2DB02CARDF		DEC	19	0	cardf
6	FULLKEY	☐	DB2DB02CARDF		DEC	19	0	cardf
7	LAST_ALTER	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
8	PGSIZE	☐	DB2IXPGSIZ	DB2SINT	INT2	5	0	Size in bytes of the leaf pages in the index
9	NLEAF	☐	INT4	INT4	INT4	10	0	Natural number
10	NLEVELS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
11	LAST_RUNST	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
12	AVG_LEN	☐	INT4	INT4	INT4	10	0	Natural number
13	PADDED	☐	DB2PADDED		CHAR	24	0	Index - padded
14	NUM_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)

History

Last changed by/on	SAP	20130604
SAP Release Created in