SAP ABAP Table DB2IXDETL (Detailed Information on a DB2 Index)

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	DB2IXDETL	Table Relationship Diagram
Short Description	Detailed Information on a DB2 Index

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	NAME	☐	DB2IDXNAME	CHAR18	CHAR	18	0	Name of a DB2 for OS/390 index
2	CREATOR	☐	DB2CREATOR	CHAR8	CHAR	8	0	DB2 creator name
3	TBNAME	☐	DB2TBNAME	CHAR18	CHAR	18	0	Name of the table on which the index is defined
4	TBCREATOR	☐	DB2TBCREA	CHAR8	CHAR	8	0	Authorization ID of the owner of the table
5	UNIQUERULE	☐	DB2UNIQUE	DB2UNIQUE	CHAR	1	0	Whether the index is unique
6	COLCOUNT	☐	DB2KCOLCNT	DB2SINT	INT2	5	0	Number of columns in the key
7	CLUSTERING	☐	DB2CLUSTER	DB2YNFLAG	CHAR	1	0	Whether CLUSTER was specified when the index was created
8	CLUSTERED	☐	DB2CLUSTRD	DB2YNFLAG	CHAR	1	0	Whether the table is actually clustered by the index
9	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
10	INDEXSPACE	☐	DB2IXSPACE	CHAR8	CHAR	8	0	Name of the indexspace that contains the index
11	PARTITIONS	☐	DB2NUMPART	DB2SINT	INT2	5	0	Number of partitions of a tablespace or index
12	NLEAF	☐	DB2NLEAF		INT4	10	0	Number of active leaf pages in the index
13	NLEVELS	☐	DB2NLEVELS	DB2SINT	INT2	5	0	DB2 for OS/390 number of levels in the index tree
14	BPOOL	☐	DB2BUFPOOL	DB2BUFPOOL	CHAR	8	0	DB2/390: Buffer pool
15	PGSIZE	☐	DB2PGSIZE	DB2PGSIZE	INT2	5	0	DB2 for OS/390 page size in KBytes
16	CLURATIO	☐	DB2CLURAT2	DB2SINT	INT2	5	0	Clusterratio: Percentage of rows in clustering order
17	STATSTIME	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
18	INDEXTYPE	☐	DB2IXTYPE	DB2IXTYPE	CHAR	1	0	Index type
19	FIRSTKEY	☐	DB2FRSTKEY	FLTP	FLTP	16	16	Number of distinct values in the first key column
20	FULLKEY	☐	DB2FULLKEY	FLTP	FLTP	16	16	Number of distinct values of the key
21	CREATEDTS	☐	DB2CREADTS	DB2TMSTMP	CHAR	26	0	Time when the CREATE statement was executed
22	ALTEREDTS	☐	DB2ALTEDTS	DB2TMSTMP	CHAR	26	0	Time of most recent ALTER statement on the object

History

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