SAP ABAP Table DB6PMCIDX (DB6: Configuration of All Indexes of a Table)

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	DB6PMCIDX	Table Relationship Diagram
Short Description	DB6: Configuration of All Indexes of a Table

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	IDXSCHEMA	☐	DB6SCHEMA		CHAR	20	0	DB6: Schema Name
2	INDEXNAME	☐			CHAR	128	0
3	RCKTSPACE	☐	DB6TSPNAME		CHAR	30	0	DB6: Tablespace Name
4	SYSNLEAF	☐			DEC	22	0
5	SYSNLEVELS	☐			DEC	22	0
6	SYS1STKCD	☐			DEC	22	0
7	SYS1ST2KCD	☐			DEC	22	0
8	SYS1ST3KCD	☐			DEC	22	0
9	SYS1ST4KCD	☐			DEC	22	0
10	SYSFULLKCD	☐			DEC	22	0
11	SYSCSTRATI	☐			DEC	22	2
12	SYSCSTFACT	☐			CHAR	22	0
13	SYSSEQ_PGS	☐			DEC	22	0
14	SYSDENSITY	☐			DEC	22	0
15	SYSSTATDAT	☐			DATS	8	0
16	SYSSTATTIM	☐			TIMS	6	0
17	RCKTOTALKB	☐			DEC	22	0
18	PCTFREE	☐			INT4	10	0
19	INDEXTYPE	☐			CHAR	4	0
20	DIMENSIONSEQ	☐			CHAR	200	0
21	INDEXTYPE_TEXT	☐			CHAR	15	0
22	COMPRESSION	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False
23	PCTPAGESSAVED	☐			INT2	5	0
24	LASTUSED	☐	SYDATUM	SYDATS	DATS	8	0	System Date
25	REVERSE_SCANS	☐	WDY_BOOLEAN	WDY_BOOLEAN	CHAR	1	0	Replacement for Real Boolean Type: 'X' == True '' == False

History

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