SAP ABAP Table DB2IXDETLP (Detailed Information on a Partition of 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	DB2IXDETLP	Table Relationship Diagram
Short Description	Detailed Information on a Partition of 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	PART	☐	DB2PARTNRS	DB2SINT	INT2	5	0	Partition number
4	STORNAME	☐	DB2STOGRP	CHAR8	CHAR	8	0	Name of the storage group used for space allocation
5	VCATNAME	☐	DB2VCAT	CHAR8	CHAR	8	0	Name of the integrated catalog facility catalog
6	LEAFDIST	☐	DB2LEAFDIS		INT4	10	0	100 * avg number of leaf pages between successive leaf pages
7	FREEPAGE	☐	DB2FREEPG	DB2SINT	INT2	5	0	Number of pages loaded before a page is left as free space
8	PCTFREE	☐	DB2PCTFRES	DB2SINT	INT2	5	0	Percentage of each page left as free space
9	STATSTIME	☐	DB2STATSTM	DB2TMSTMP	CHAR	26	0	Date and time of last RUNSTATS
10	GBPCACHE	☐	DB2GBPCACH	DB2GBPCACH	CHAR	1	0	Group buffer pool cache option
11	FAROFFPOSF	☐	DB2FAROFFP	FLTP	FLTP	16	16	Number of referred to rows far from optimal position
12	NEAROFFPOS	☐	DB2NEAROFF	FLTP	FLTP	16	16	Number of referred to rows near the optimal position
13	CARDF	☐	DB2IXCARDF	FLTP	FLTP	16	16	Number of keys in the index that refer to data rows or LOBs
14	SPACE	☐	DB2SPACE	DB2SPACE	INT4	10	0	Number of KB of DASD Storage Allocated to Tablespace

History

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