SAP ABAP Table DB6CATIX (DB6: System Catalog Information of Index)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     ⤷ STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)

Basic Data

Table Category	INTTAB	Structure
Structure	DB6CATIX	Table Relationship Diagram
Short Description	DB6: System Catalog Information of 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	INDSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
2	INDNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
3	DEFINER	☐	DB6PATH	DB6PATH	CHAR	255	0	DB6: File Path
4	TABSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
5	TABNAME	☐	DB6TABNAML		CHAR	128	0	DB6: long table name
6	COLNAMES	☐			CHAR	640	0
7	UNIQUERULE	☐			CHAR	1	0
8	MADE_UNIQUE	☐			CHAR	1	0
9	COLCOUNT	☐			INT2	5	0
10	UNIQUE_COLCOUNT	☐			INT2	5	0
11	INDEXTYPE	☐			CHAR	4	0
12	ENTRYTYPE	☐			CHAR	1	0
13	PCTFREE	☐			INT2	5	0
14	IID	☐			INT2	5	0
15	NLEAF	☐			DEC	22	0
16	NLEVELS	☐			INT2	5	0
17	FIRSTKEYCARD	☐			DEC	22	0
18	FIRST2KEYCARD	☐			DEC	22	0
19	FIRST3KEYCARD	☐			DEC	22	0
20	FIRST4KEYCARD	☐			DEC	22	0
21	FULLKEYCARD	☐			DEC	22	0
22	CLUSTERRATIO	☐			INT2	5	0
23	CLUSTERFACTOR	☐			DEC	5	0
24	SEQUENTIAL_PAGES	☐			DEC	22	0
25	DENSITY	☐			INT4	10	0
26	USER_DEFINED	☐			INT2	5	0
27	SYSTEM_REQUIRED	☐			INT2	5	0
28	CREATE_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
29	STATS_TIME	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
30	MINPCTUSED	☐			INT2	5	0
31	REVERSE_SCANS	☐			CHAR	1	0
32	INTERNAL_FORMAT	☐			INT2	5	0
33	REMARKS	☐			CHAR	254	0
34	INDEX_OBJECTID	☐			INT4	10	0
35	NUMRIDS	☐			DEC	22	0
36	NUMRIDS_DELETED	☐			DEC	22	0
37	NUM_EMPTY_LEAFS	☐			DEC	22	0
38	AVERAGE_RANDOM_FETCH_PAGES	☐			DEC	22	0
39	AVERAGE_RANDOM_PAGES	☐			DEC	22	0
40	AVERAGE_SEQUENCE_GAP	☐			DEC	22	0
41	AVERAGE_SEQUENCE_FETCH_GAP	☐			DEC	22	0
42	AVERAGE_SEQUENCE_PAGES	☐			DEC	22	0
43	AVERAGE_SEQUENCE_FETCH_PAGES	☐			DEC	22	0
44	TBSPACEID	☐			INT4	10	0
45	PCTPAGESSAVED	☐			INT4	10	0
46	COMPRESSION	☐			CHAR	1	0
47	INDCARD	☐			DEC	22	0
48	AVGLEAFKEYSIZE	☐			INT4	10	0
49	AVGNLEAFKEYSIZE	☐			INT4	10	0
50	COLLECTSTATISTICS	☐			CHAR	1	0
51	LASTUSED	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission
52	SNAPSHOT_TIMESTAMP	☐	DB6DATETIM		CHAR	26	0	DBA: ISO conform timestamp with ms precission

History

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