SAP ABAP Table DB2KPIIX (Index Info)

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	DB2KPIIX	Table Relationship Diagram
Short Description	Index Info

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	IDX_AUX_NAME	☐	DB2IXNAML		CHAR	128	0	Index name
2	IDX_AUX_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
3	BASE_TABLE_NAME	☐	DB2TABNAML		CHAR	128	0	DB2 long table name
4	BASE_TABLE_CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
5	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
6	SPACENAME	☐	DB2IXSPACE	CHAR8	CHAR	8	0	Name of the indexspace that contains the index
7	OBJECT_TYPE	☐	DB2IXTYPE	DB2IXTYPE	CHAR	1	0	Index type
8	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
9	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
10	NUM_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
11	GROWTH_DAY_USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
12	SPACE_TYPE	☐	DB2IXTYPE	DB2IXTYPE	CHAR	1	0	Index type

History

Last changed by/on	SAP	20130604
SAP Release Created in