SAP ABAP Table DB4_EXPLAIN (iSeries: Database Monitor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4_EXPLAIN	Table Relationship Diagram
Short Description	iSeries: Database Monitor

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	QQRID	☐			DEC	15	0
2	QQTIME	☐	QQTIME	QQTIME	CHAR	26	0	iSeries: Record Creation Timestamp (Database Monitor)
3	QQJFLD	☐	QQJFLD	QQJFLD	RAW	46	0	Join field
4	QQRDBN	☐	QQRDBN	QQRDBN	CHAR	18	0	Relational database name
5	QQSYS	☐	QQSYS	QQSYS	CHAR	8	0	System name
6	QQJOB	☐	QQJOB	QQJOB	CHAR	10	0	iSeries: Job Name (Database Monitor)
7	QQUSER	☐	QQUSER	QQUSER	CHAR	10	0	iSeries: Job User (Database Monitor)
8	QQJNUM	☐	QQJNUM	QQJNUM	CHAR	6	0	iSeries: Job Number (Database Monitor)
9	QQUCNT	☐			DEC	15	0
10	QQUDEF	☐	QQUDEF	QQUDEF	CHAR	100	0	User-defined field
11	QQSTN	☐			DEC	15	0
12	QQQDTN	☐			DEC	15	0
13	QQQDTL	☐			DEC	15	0
14	QQMATN	☐			DEC	15	0
15	QQMATL	☐			DEC	15	0
16	QQTLN	☐	QQTLN	QQTLN	CHAR	10	0	iSeries: System Name of Library (Database Monitor)
17	QQTFN	☐	QQTFN	QQTFN	CHAR	10	0	File name
18	QQTMN	☐	QQTMN	QQTMN	CHAR	10	0	Member name
19	QQPTLN	☐	QQPTLN	QQTLN	CHAR	10	0	iSeries: System Name of Base Library (Database Monitor)
20	QQPTFN	☐	QQPTFN	QQTFN	CHAR	10	0	iSeries: Physical File (Dtabhase Monitor)
21	QQPTMN	☐	QQPTMN	QQTMN	CHAR	10	0	iSeries: Physical Member (Database Monitor)
22	QQILNM	☐	QQILNM	QQTLN	CHAR	10	0	iSeries: System Name of Index Library (Database Monitor)
23	QQIFNM	☐	QQIFNM	QQTFN	CHAR	10	0	Index file
24	QQIMNM	☐	QQIMNM	QQTMN	CHAR	10	0	Index member
25	QQNTNM	☐	QQNTNM	QQTFN	CHAR	10	0	iSeries: System Name of NLSS Table (Database Monitor)
26	QQNLNM	☐	QQNLNM	QQTLN	CHAR	10	0	iSeries: System Name of NLSS Library (Database Monitor)
27	QQSTIM	☐	QQSTIM	QQTIME	CHAR	26	0	Start timestamp
28	QQETIM	☐	QQETIM	QQTIME	CHAR	26	0	End timestamp
29	QQKP	☐	QQKP	QQYN	CHAR	1	0	iSeries: Key Positioning (Database Monitor)
30	QQKS	☐	QQKS	QQYN	CHAR	1	0	iSeries: Key Selection (Database Monitor)
31	QQTOTR	☐			DEC	15	0
32	QQTMPR	☐			DEC	15	0
33	QQJNP	☐			DEC	15	0
34	QQEPT	☐			DEC	15	0
35	QQDSS	☐	QQDSS	QQYN	CHAR	1	0	iSeries: Dataspace Selection (Database Monitor)
36	QQIDXA	☐	QQIDXA	QQYN	CHAR	1	0	iSeries: Optimizer Advised Index (Database Monitor)
37	QQORDG	☐	QQORDG	QQYN	CHAR	1	0	Ordering
38	QQGRPG	☐	QQGRPG	QQYN	CHAR	1	0	Grouping
39	QQJNG	☐	QQJNG	QQYN	CHAR	1	0	Join criterion
40	QQUNIN	☐	QQUNIN	QQYN	CHAR	1	0	UNION clause specified
41	QQSUBQ	☐	QQSUBQ	QQYN	CHAR	1	0	Subquery
42	QQHSTV	☐	QQHSTV	QQYN	CHAR	1	0	Host variables
43	QQRCDS	☐	QQRCDS	QQYN	CHAR	1	0	Record selection
44	QQRCOD	☐	QQRCOD	QQRCOD	CHAR	2	0	Reason code
45	QQRSS	☐			DEC	15	0
46	QQREST	☐			DEC	15	0
47	QQRIDX	☐			DEC	15	0
48	QQFKEY	☐			DEC	15	0
49	QQKSEL	☐			DEC	15	0
50	QQAJN	☐			DEC	15	0
51	QQIDXD_1	☐			CHAR	255	0
52	QQIDXD_2	☐			CHAR	255	0
53	QQIDXD_3	☐			CHAR	255	0
54	QQIDXD_4	☐			CHAR	255	0
55	QQC11	☐	QQC11	QQC11	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
56	QQC12	☐	QQC12	QQC12	CHAR	1	0	iSeries: Reserved Field (Database Monitor)
57	QQC13	☐	QQC13	QQC13	CHAR	1	0	QQC13: Parse required? (Y/N)
58	QQC14	☐	QQC14	QQC14	CHAR	1	0	QQC14: Statement outcome
59	QQC15	☐			CHAR	1	0
60	QQC16	☐	QQC16	QQC16	CHAR	1	0	QQC16: Data conversion
61	QQC18	☐			CHAR	1	0
62	QQC21	☐	QQC21	QQC21	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
63	QQC22	☐	QQC22	QQC22	CHAR	2	0	iSeries: Reserved Field (Database Monitor)
64	QQC23	☐	QQC23	QQC23	CHAR	2	0	QQC23: Used for different purposes
65	QQI1	☐			DEC	15	0
66	QQI2	☐			DEC	15	0
67	QQI3	☐			DEC	15	0
68	QQI4	☐			DEC	15	0
69	QQI5	☐			DEC	15	0
70	QQI6	☐			DEC	15	0
71	QQI7	☐			DEC	15	0
72	QQI8	☐			DEC	15	0
73	QQI9	☐			DEC	15	0
74	QQIA	☐			DEC	15	0
75	QQF1	☐			DEC	15	0
76	QQF2	☐			DEC	15	0
77	QQF3	☐			DEC	15	0
78	QQC61	☐			CHAR	6	0
79	QQC81	☐			CHAR	8	0
80	QQC82	☐			CHAR	8	0
81	QQC83	☐			CHAR	8	0
82	QQC84	☐			CHAR	8	0
83	QQC101	☐			CHAR	10	0
84	QQC102	☐			CHAR	10	0
85	QQC103	☐			CHAR	10	0
86	QQC104	☐			CHAR	10	0
87	QQC105	☐			CHAR	10	0
88	QQC106	☐			CHAR	10	0
89	QQC181	☐			CHAR	18	0
90	QQC182	☐			CHAR	18	0
91	QQC183	☐			CHAR	18	0
92	QQC301	☐			CHAR	30	0
93	QQC302	☐			CHAR	30	0
94	QQC303	☐			CHAR	30	0
95	QQ1000_1	☐			CHAR	255	0
96	QQ1000_2	☐			CHAR	255	0
97	QQ1000_3	☐			CHAR	255	0
98	QQ1000_4	☐			CHAR	255	0
99	QQTIM1	☐			CHAR	26	0
100	QQTIM2	☐			CHAR	26	0
101	QVQTBL	☐			CHAR	128	0
102	QVQLIB	☐			CHAR	128	0
103	QVPTBL	☐			CHAR	128	0
104	QVPLIB	☐			CHAR	128	0
105	QVINAM	☐			CHAR	128	0
106	QVILIB	☐			CHAR	128	0
107	QVQTBLI	☐			CHAR	1	0
108	QVPTBLI	☐			CHAR	1	0
109	QVINAMI	☐			CHAR	1	0
110	QVBNDY	☐			CHAR	1	0
111	QVJFANO	☐			CHAR	1	0
112	QVPARPF	☐			CHAR	1	0
113	QVPARPL	☐			CHAR	1	0
114	QVC11	☐			CHAR	1	0
115	QVC12	☐			CHAR	1	0
116	QVC13	☐			CHAR	1	0
117	QVC14	☐			CHAR	1	0
118	QVC15	☐			CHAR	1	0
119	QVC16	☐			CHAR	1	0
120	QVC17	☐			CHAR	1	0
121	QVC18	☐			CHAR	1	0
122	QVC19	☐			CHAR	1	0
123	QVC1A	☐			CHAR	1	0
124	QVC1B	☐			CHAR	1	0
125	QVC1C	☐			CHAR	1	0
126	QVC1D	☐			CHAR	1	0
127	QVC1E	☐			CHAR	1	0
128	QVC1F	☐			CHAR	1	0
129	QWC11	☐			CHAR	1	0
130	QWC12	☐			CHAR	1	0
131	QWC13	☐			CHAR	1	0
132	QWC14	☐			CHAR	1	0
133	QWC15	☐			CHAR	1	0
134	QWC16	☐			CHAR	1	0
135	QWC17	☐			CHAR	1	0
136	QWC18	☐			CHAR	1	0
137	QWC19	☐			CHAR	1	0
138	QWC1A	☐			CHAR	1	0
139	QWC1B	☐			CHAR	1	0
140	QWC1C	☐			CHAR	1	0
141	QWC1D	☐			CHAR	1	0
142	QWC1E	☐			CHAR	1	0
143	QWC1F	☐			CHAR	1	0
144	QVC21	☐			CHAR	2	0
145	QVC22	☐			CHAR	2	0
146	QVC23	☐			CHAR	2	0
147	QVC24	☐			CHAR	2	0
148	QVCTIM	☐			DEC	15	0
149	QVPARD	☐			DEC	15	0
150	QVPARU	☐			DEC	15	0
151	QVPARRC	☐			DEC	15	0
152	QVRCNT	☐			DEC	15	0
153	QVFILES	☐			DEC	15	0
154	QVP151	☐			DEC	15	0
155	QVP152	☐			DEC	15	0
156	QVP153	☐			DEC	15	0
157	QVP154	☐			DEC	15	0
158	QVP155	☐			DEC	15	0
159	QVP156	☐			DEC	15	0
160	QVP157	☐			DEC	15	0
161	QVP158	☐			DEC	15	0
162	QVP159	☐			DEC	15	0
163	QVP15A	☐			DEC	15	0
164	QVP15B	☐			DEC	15	0
165	QVP15C	☐			DEC	15	0
166	QVP15D	☐			DEC	15	0
167	QVP15E	☐			DEC	15	0
168	QVP15F	☐			DEC	15	0
169	QVC41	☐			CHAR	4	0
170	QVC42	☐			CHAR	4	0
171	QVC43	☐			CHAR	4	0
172	QVC44	☐			CHAR	4	0
173	QVC81	☐			CHAR	8	0
174	QVC82	☐			CHAR	8	0
175	QVC83	☐			CHAR	8	0
176	QVC84	☐			CHAR	8	0
177	QVC85	☐			CHAR	8	0
178	QVC86	☐			CHAR	8	0
179	QVC87	☐			CHAR	8	0
180	QVC88	☐			CHAR	8	0
181	QVC101	☐			CHAR	10	0
182	QVC102	☐			CHAR	10	0
183	QVC103	☐			CHAR	10	0
184	QVC104	☐			CHAR	10	0
185	QVC105	☐			CHAR	10	0
186	QVC106	☐			CHAR	10	0
187	QVC107	☐			CHAR	10	0
188	QVC108	☐			CHAR	10	0
189	QVC1281	☐			CHAR	128	0
190	QVC1282	☐			CHAR	128	0
191	QVC1283	☐			CHAR	128	0
192	QVC1284	☐			CHAR	128	0
193	QVC3001	☐			CHAR	300	0
194	QVC3002	☐			CHAR	300	0
195	QVC3003	☐			CHAR	300	0
196	QVC3004	☐			CHAR	300	0
197	QVC3005	☐			CHAR	300	0
198	QVC3006	☐			CHAR	300	0
199	QVC3007	☐			CHAR	300	0
200	QVC3008	☐			CHAR	300	0
201	QVC5001	☐			CHAR	500	0
202	QVC5002	☐			CHAR	500	0
203	QVC1000	☐			CHAR	1000	0
204	QWC1000	☐			CHAR	1000	0
205	IDXDLEN	☐			CHAR	1000	0
206	LONGLEN	☐			INT4	10	0
207	TOTTIM	☐			DEC	15	6

History

Last changed by/on	SAP	20070813
SAP Release Created in	630