SAP ABAP Table DB2_DB02_IX_PART_DETAILS (DB02 partition details for indexes)

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_PART_DETAILS	Table Relationship Diagram
Short Description	DB02 partition details for indexes

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	PARTNO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
2	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
3	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
4	PQTY	☐	INT4	INT4	INT4	10	0	Natural number
5	SQTY	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
6	STORNAME	☐	DB2STOGROUP		CHAR	128	0	Storage group
7	LEAFDIST	☐	INT4	INT4	INT4	10	0	Natural number
8	LIMITKEY	☐	DB2LIMITKEY		CHAR	128	0	limitkey
9	FREEPAGE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
10	PCT_FREE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
11	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
12	GBPCACHE	☐	DB2GBPCACHL		CHAR	8	0	Group buffer pool cache option
13	FAROFF	☐	DB2DB02CARDF		DEC	19	0	cardf
14	NEAROFF	☐	DB2DB02CARDF		DEC	19	0	cardf
15	#ROWS	☐	DB2DB02CARDF		DEC	19	0	cardf
16	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
17	#DS	☐	INT4	INT4	INT4	10	0	Natural number
18	#EXTENTS	☐	INT4	INT4	INT4	10	0	Natural number
19	PSEUDO_DEL	☐	INT4	INT4	INT4	10	0	Natural number
20	LEAFNEAR	☐	INT4	INT4	INT4	10	0	Natural number
21	LEAFFAR	☐	INT4	INT4	INT4	10	0	Natural number
22	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
23	AVGKEYLEN	☐	INT4	INT4	INT4	10	0	Natural number

History

Last changed by/on	SAP	20130604
SAP Release Created in