SAP ABAP Table DB2KPI_IXLIMITS (structure with infos on ix near DB2 limits)

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	DB2KPI_IXLIMITS	Table Relationship Diagram
Short Description	structure with infos on ix near DB2 limits

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	SPACENAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
4	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
5	PARTITIONS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
6	SPACE_TYPE	☐	DB2IXTYPE	DB2IXTYPE	CHAR	1	0	Index type
7	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
8	PIECESIZE	☐	INT4	INT4	INT4	10	0	Natural number
9	DSSIZE	☐	INT4	INT4	INT4	10	0	Natural number
10	TYPE	☐	DB2TYPE	DB2TYPE	CHAR	1	0	Tablespace type
11	LIMIT	☐	DB2SIZEKB		DEC	19	0	Size in KB
12	PARTNO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
13	PCTUSED	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)

History

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