SAP ABAP Table DB2QPLANHIST (History plan table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QPLANHIST	Table Relationship Diagram
Short Description	History plan 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	MEMBNM	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
2	USERID	☐	DB2USERID	DB2SINT	INT2	5	0
3	QUERYNO	☐			INT4	10	0
4	PLANDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
5	PLANTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
6	PLANMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
7	PLANNO	☐			INT2	5	0
8	QBLOCKNO	☐			INT2	5	0
9	ACCESSCREATOR	☐			CHAR	128	0
10	ACCESSNAME	☐			CHAR	128	0
11	ACCESSTYPE	☐			CHAR	2	0
12	ACCESS_DEGREE	☐			INT2	5	0
13	ACCESS_PGROUP_ID	☐			INT2	5	0
14	APPLNAME	☐			CHAR	8	0
15	BIND_TIME	☐			CHAR	26	0
16	COLLID	☐			CHAR	128	0
17	COLUMN_FN_EVAL	☐			CHAR	1	0
18	CORRELATION_NAME	☐			CHAR	128	0
19	CREATOR	☐			CHAR	128	0
20	CTEREF	☐			INT2	5	0
21	GROUP_MEMBER	☐			CHAR	8	0
22	HINT_USED	☐			CHAR	128	0
23	IBM_SERVICE_DATA	☐			CHAR	254	0
24	INDEXONLY	☐			CHAR	1	0
25	JOIN_DEGREE	☐			INT2	5	0
26	JOIN_PGROUP_ID	☐			INT2	5	0
27	JOIN_TYPE	☐			CHAR	1	0
28	MATCHCOLS	☐			INT2	5	0
29	MERGE_JOIN_COLS	☐			INT2	5	0
30	METHOD	☐			INT2	5	0
31	MIXOPSEQ	☐			INT2	5	0
32	OPTHINT	☐			CHAR	128	0
33	PAGE_RANGE	☐			CHAR	1	0
34	PARALLELISM_MODE	☐			CHAR	1	0
35	PARENT_QBLOCKNO	☐			INT2	5	0
36	PREFETCH	☐			CHAR	1	0
37	PRIMARY_ACCESSTY	☐			CHAR	1	0
38	PROGNAME	☐			CHAR	128	0
39	QBLOCK_TYPE	☐			CHAR	6	0
40	REMARKS	☐			CHAR	254	0
41	ROUTINE_ID	☐			CHAR	1	0
42	SORTC_GROUPBY	☐			CHAR	1	0
43	SORTC_JOIN	☐			CHAR	1	0
44	SORTC_ORDERBY	☐			CHAR	1	0
45	SORTC_PGROUP_ID	☐			INT2	5	0
46	SORTC_UNIQ	☐			CHAR	1	0
47	SORTN_GROUPBY	☐			CHAR	1	0
48	SORTN_JOIN	☐			CHAR	1	0
49	SORTN_ORDERBY	☐			CHAR	1	0
50	SORTN_PGROUP_ID	☐			INT2	5	0
51	SORTN_UNIQ	☐			CHAR	1	0
52	STMTTOKEN	☐			CHAR	240	0
53	TABLE_DCCSID	☐			INT2	5	0
54	TABLE_ENCODE	☐			CHAR	1	0
55	TABLE_MCCSID	☐			INT2	5	0
56	TABLE_SCCSID	☐			INT2	5	0
57	TABLE_TYPE	☐			CHAR	1	0
58	TABNO	☐			INT2	5	0
59	TIMESTAMP	☐			CHAR	16	0
60	TNAME	☐			CHAR	128	0
61	TSLOCKMODE	☐			CHAR	3	0
62	VERSION	☐			CHAR	64	0
63	WHEN_OPTIMIZE	☐			CHAR	1	0

History

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