SAP ABAP Table DB2_DB02_IX_GEN (general data for indexes)

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	DB2_DB02_IX_GEN	Table Relationship Diagram
Short Description	general data for indexes

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	☐	DB2IXNAML		CHAR	128	0	Index name
2	CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
3	TBNAME	☐	DB2TABNAML		CHAR	128	0	DB2 long table name
4	TBCREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
5	DB	☐	DB2DBNAML		CHAR	24	0	DB2 DB Name
6	IXSPACE	☐	DB2IXSPACEL		CHAR	24	0	Index Space
7	TYPE	☐	DB2IXTYP		CHAR	34	0	IX Type
8	UNIQUE_RULE	☐	DB2UNIQUERULE		CHAR	40	0	unique rule
9	CLUSTER	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
10	BP	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
11	DS_SIZE	☐	INT4	INT4	INT4	10	0	Natural number
12	COMPRESSED	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
13	CLUSTERING	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag

History

Last changed by/on	SAP	20110908
SAP Release Created in