SAP ABAP Table DB2_VIEW_IX_DETAILS (DB2: structure for VIEW_DATA of ..._ACTION_DB02_IX_DETAILS)

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_VIEW_IX_DETAILS	Table Relationship Diagram
Short Description	DB2: structure for VIEW_DATA of ..._ACTION_DB02_IX_DETAILS

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	GENERAL_DATA	☐	DB2_DB02_IX_GEN		STRU	0	0
2	NAME	☐	DB2IXNAML		CHAR	128	0	Index name
3	CREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
4	TBNAME	☐	DB2TABNAML		CHAR	128	0	DB2 long table name
5	TBCREATOR	☐	DB2CREATORL		CHAR	128	0	DB2 creator name
6	DB	☐	DB2DBNAML		CHAR	24	0	DB2 DB Name
7	IXSPACE	☐	DB2IXSPACEL		CHAR	24	0	Index Space
8	TYPE	☐	DB2IXTYP		CHAR	34	0	IX Type
9	UNIQUE_RULE	☐	DB2UNIQUERULE		CHAR	40	0	unique rule
10	CLUSTER	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
11	BP	☐	DB2BPNAME	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
12	DS_SIZE	☐	INT4	INT4	INT4	10	0	Natural number
13	COMPRESSED	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
14	CLUSTERING	☐	DB2YESNO		CHAR	3	0	Yes / NO Flag
15	TAB_PART_DETAILS	☐	DB2_DB02_IX_PART_DETAILS		STRU	0	0
16	PARTNO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
17	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
18	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
19	PQTY	☐	INT4	INT4	INT4	10	0	Natural number
20	SQTY	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
21	STORNAME	☐	DB2STOGROUP		CHAR	128	0	Storage group
22	LEAFDIST	☐	INT4	INT4	INT4	10	0	Natural number
23	LIMITKEY	☐	DB2LIMITKEY		CHAR	128	0	limitkey
24	FREEPAGE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
25	PCT_FREE	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
26	STATSTIME	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
27	GBPCACHE	☐	DB2GBPCACHL		CHAR	8	0	Group buffer pool cache option
28	FAROFF	☐	DB2DB02CARDF		DEC	19	0	cardf
29	NEAROFF	☐	DB2DB02CARDF		DEC	19	0	cardf
30	#ROWS	☐	DB2DB02CARDF		DEC	19	0	cardf
31	ALTEREDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
32	#DS	☐	INT4	INT4	INT4	10	0	Natural number
33	#EXTENTS	☐	INT4	INT4	INT4	10	0	Natural number
34	PSEUDO_DEL	☐	INT4	INT4	INT4	10	0	Natural number
35	LEAFNEAR	☐	INT4	INT4	INT4	10	0	Natural number
36	LEAFFAR	☐	INT4	INT4	INT4	10	0	Natural number
37	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
38	AVGKEYLEN	☐	INT4	INT4	INT4	10	0	Natural number
39	TAB_HISTORY	☐	DB2_DB02_IX_HIST		STRU	0	0
40	FROM_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
41	TO_INTERVAL	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
42	IT_IX	☐	DB_T_TABHIST		TTYP	0	0
43	RANGE	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
44	RANGE_LIST	☐	DBA_LISTBOX_LIST		TTYP	0	0
45	COLLAPSED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
46	EXPANDED	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
47	RANGE_PREV	☐	DB2HIST_RANGE		CHAR	8	0	Range for History ( daily, weekly, monthly )
48	HIST_KEEP_DAYS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
49	HIST_KEEP_WEEKS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
50	HIST_KEEP_MONTHS	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
51	TAB_STRUCTURE	☐	DB2_DB02_TAB_STRUCTURE		STRU	0	0
52	IT_COLS	☐	DB2_T_TABSTRUC		TTYP	0	0
53	TAB_PARTITIONS	☐	DB2_DB02_TS_PARTITIONS		STRU	0	0
54	IT_PARTITIONS	☐	DB2TBPARTLIST		TTYP	0	0
55	TAB_DATASETS	☐	DB2_DB02_TS_DATASETS		STRU	0	0
56	IT_DATASETS	☐	DB2DATASETS		TTYP	0	0
57	TAB_DETAILS	☐	DB2_DB02_IX_DETAILS		STRU	0	0
58	ALLOC_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
59	USED_KB	☐	DB2SIZEKB		DEC	19	0	Size in KB
60	CREATEDTS	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
61	CLUSTERRATIO	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
62	FIRSTKEY	☐	DB2DB02CARDF		DEC	19	0	cardf
63	FULLKEY	☐	DB2DB02CARDF		DEC	19	0	cardf
64	LAST_ALTER	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
65	PGSIZE	☐	DB2IXPGSIZ	DB2SINT	INT2	5	0	Size in bytes of the leaf pages in the index
66	NLEAF	☐	INT4	INT4	INT4	10	0	Natural number
67	NLEVELS	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
68	LAST_RUNST	☐	DB2TIMESTRING		CHAR	26	0	Character Representation of DB2 Timestamp
69	AVG_LEN	☐	INT4	INT4	INT4	10	0	Natural number
70	PADDED	☐	DB2PADDED		CHAR	24	0	Index - padded
71	NUM_PART	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)
72	PARTLIST	☐	DBA_LISTBOX_LIST		TTYP	0	0

History

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