SAP ABAP Table DB2QSYSW2 (DB2 statistics (part 2))

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	DB2QSYSW2	Table Relationship Diagram
Short Description	DB2 statistics (part 2)

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	.INCLUDE	☐				0	0	RDS Statistics Block
3	QXSELECT	☐	DB2XSELECT	DB2DEC19V	DEC	19	0	Number of SELECT statements executed
4	QXINSRT	☐	DB2XINSRT	DB2DEC19V	DEC	19	0	Number of INSERT statements executed
5	QXUPDTE	☐	DB2XUPDTE	DB2DEC19V	DEC	19	0	Number of UPDATE statements executed
6	QXDELET	☐	DB2XDELET	DB2DEC19V	DEC	19	0	Number of DELETE statements executed
7	QXDESC	☐	DB2XDESC	DB2DEC19V	DEC	19	0	Number of DESCRIBE statements executed
8	QXPREP	☐	DB2XPREP	DB2DEC19V	DEC	19	0	Number of PREPARE statements executed
9	QXOPEN	☐	DB2XOPEN	DB2DEC19V	DEC	19	0	Number of OPEN CURSOR statements executed
10	QXCLOSE	☐	DB2XCLOSE	DB2DEC19V	DEC	19	0	Number of CLOSE CURSOR statements executed
11	QXCRTAB	☐	DB2XCRTAB	DB2DEC19V	DEC	19	0	Number of CREATE TABLE statements executed
12	QXCRINX	☐	DB2XCRINX	DB2DEC19V	DEC	19	0	Number of CREATE INDEX statements executed
13	QXCTABS	☐	DB2XCTABS	DB2DEC19V	DEC	19	0	Number of CREATE TABLE SPACE statements executed
14	QXCRSYN	☐	DB2XCRSYN	DB2DEC19V	DEC	19	0	Number of CREATE SYNONYM statements executed
15	QXCRDAB	☐	DB2XCRDAB	DB2DEC19V	DEC	19	0	Number of CREATE DATABASE statements executed
16	QXCRSTG	☐	DB2XCRSTG	DB2DEC19V	DEC	19	0	Number of CREATE STORAGE GROUP statements executed
17	QXDEFVU	☐	DB2XDEFVU	DB2DEC19V	DEC	19	0	Number of CREATE VIEW statements executed
18	QXDRPIX	☐	DB2XDRPIX	DB2DEC19V	DEC	19	0	Number of DROP INDEX statements executed
19	QXDRPTA	☐	DB2XDRPTA	DB2DEC19V	DEC	19	0	Number of DROP TABLE statements executed
20	QXDRPTS	☐	DB2XDRPTS	DB2DEC19V	DEC	19	0	Number of DROP TABLE SPACE statements executed
21	QXDRPDB	☐	DB2XDRPDB	DB2DEC19V	DEC	19	0	Number of DROP DATABASE statements executed
22	QXDRPSY	☐	DB2XDRPSY	DB2DEC19V	DEC	19	0	Number of DROP SYNONYM statements executed
23	QXDRPST	☐	DB2XDRPST	DB2DEC19V	DEC	19	0	Number of DROP STORAGE GROUP statements executed
24	QXDRPVU	☐	DB2XDRPVU	DB2DEC19V	DEC	19	0	Number of DROP VIEW statements executed
25	QXALTST	☐	DB2XALTST	DB2DEC19V	DEC	19	0	Number of ALTER STORAGE GROUP statements executed
26	QXFETCH	☐	DB2XFETCH	DB2DEC19V	DEC	19	0	Number of FETCH statements executed
27	QXALTTS	☐	DB2XALTTS	DB2DEC19V	DEC	19	0	Number of ALTER TABLE SPACE statements executed
28	QXALTTA	☐	DB2XALTTA	DB2DEC19V	DEC	19	0	Number of ALTER TABLE statements executed
29	QXALTIX	☐	DB2XALTIX	DB2DEC19V	DEC	19	0	Number of ALTER INDEX statements executed
30	QXCMTON	☐	DB2XCMTON	DB2DEC19V	DEC	19	0	Number of COMMENT ON statements executed
31	QXLOCK	☐	DB2XLOCK	DB2DEC19V	DEC	19	0	Number of LOCK TABLE statements executed
32	QXGRANT	☐	DB2XGRANT	DB2DEC19V	DEC	19	0	Number of GRANT statements executed
33	QXREVOK	☐	DB2XREVOK	DB2DEC19V	DEC	19	0	Number of REVOKE statements executed
34	QXINCRB	☐	DB2XINCRB	DB2DEC19V	DEC	19	0	Number of INCREMENTAL BINDs executed
35	QXLABON	☐	DB2XLABON	DB2DEC19V	DEC	19	0	Number of LABEL ON statements executed
36	QXSETSQL	☐	DB2XSETSQL	DB2DEC19V	DEC	19	0	Number of SET CURRENT SQLID statements executed
37	QXCRALS	☐	DB2XCRALS	DB2DEC19V	DEC	19	0	Number of CREATE ALIAS statements executed
38	QXDRPAL	☐	DB2XDRPAL	DB2DEC19V	DEC	19	0	Number of DROP ALIAS statements executed
39	QXMIAP	☐	DB2XMIAP	DB2DEC19V	DEC	19	0	Number of times RID list processing is used
40	QXNSMIAP	☐	DB2XNSMIAP	DB2DEC19V	DEC	19	0	RID list processing failed - no storage
41	QXMRMIAP	☐	DB2XMRMIAP	DB2DEC19V	DEC	19	0	RID list processing failed - limit exeeded
42	QXSETHV	☐	DB2XSETHV	DB2DEC19V	DEC	19	0	Number of SET HOST VARIABLE statements executed
43	QXALDAB	☐	DB2XALDAB	DB2DEC19V	DEC	19	0	Number of ALTER DATABASE statements executed
44	QXDRPPKG	☐	DB2XDRPPKG	DB2DEC19V	DEC	19	0	Number of DROP PACKAGE statements executed
45	QXDSCRTB	☐	DB2XDSCRTB	DB2DEC19V	DEC	19	0	Number of DESCRIBE TABLE statements executed
46	QXMAXDEG	☐	DB2XMAXDEG	DB2DEC19V	DEC	19	0	Maximum parallelism degree
47	QXTOTGRP	☐	DB2XTOTGRP	DB2DEC19V	DEC	19	0	Parallel groups: total executed
48	QXDEGCUR	☐	DB2XDEGCUR	DB2DEC19V	DEC	19	0	Parallel groups fell to sequential due to updatable cursor
49	QXDEGESA	☐	DB2XDEGESA	DB2DEC19V	DEC	19	0	Par. groups fell to sequ. due to lack of ESA sort support
50	QXDEGBUF	☐	DB2XDEGBUF	DB2DEC19V	DEC	19	0	Parallel groups fell to sequential due to storage shortage
51	QXREDGRP	☐	DB2XREDGRP	DB2DEC19V	DEC	19	0	Parallel groups: executed with reduced degree
52	QXNORGRP	☐	DB2XNORGRP	DB2DEC19V	DEC	19	0	Parallel groups: executed as planned
53	QXCON1	☐	DB2XCON1	DB2DEC19V	DEC	19	0	Number of CONNECT TYPE 1 statements executed
54	QXCON2	☐	DB2XCON2	DB2DEC19V	DEC	19	0	Number of CONNECT TYPE 2 statements executed
55	QXREL	☐	DB2XREL	DB2DEC19V	DEC	19	0	Number of RELEASE statements executed
56	QXSETCON	☐	DB2XSETCON	DB2DEC19V	DEC	19	0	Number of SET CONNECTION statements executed
57	QXSETCDG	☐	DB2XSETCDG	DB2DEC19V	DEC	19	0	Number of SET CURRENT DEGREE statements executed
58	QXSETCRL	☐	DB2XSETCRL	DB2DEC19V	DEC	19	0	Number of SET CURRENT RULES statements executed
59	QXCALL	☐	DB2XCALL	DB2DEC19V	DEC	19	0	Number of SQL CALL statements executed
60	QXCALLAB	☐	DB2XCALLAB	DB2DEC19V	DEC	19	0	# of times a stored procedure ABENDed
61	QXCALLTO	☐	DB2XCALLTO	DB2DEC19V	DEC	19	0	# of times an SQL CALL stmt timedout waiting to be scheduled
62	QXCALLRJ	☐	DB2XCALLRJ	DB2DEC19V	DEC	19	0	# of times an SQL CALL statement was rejected
63	QXDEGENC	☐	DB2XDEGENC	DB2DEC19V	DEC	19	0	Par.groups fell to sequ. due to unavailable enclave services
64	QXRLFDPA	☐			CHAR	1	0
65	QXSTRES1	☐	DB2RES03	DB2CHAR03	CHAR	3	0	Field type char, length 3, reserved
66	QXCOORNO	☐	DB2XCOORNO	DB2DEC19V	DEC	19	0	COORDINATOR setting mismatch
67	QXISORR	☐	DB2XISORR	DB2DEC19V	DEC	19	0	Isolation level RR or RS
68	QXCRGTT	☐	DB2XCRGTT	DB2DEC19V	DEC	19	0	# OF CREATE GLBL TEMP TABLE
69	QXSTREOP	☐	DB2XREOP	DB2DEC19V	DEC	19	0	Total Number of Times Reoptimization Occurs
70	QXXCBPNX	☐	DB2XXCBPNX	DB2DEC19V	DEC	19	0	Parallel groups: intended to run across data sharing group
71	QXXCSKIP	☐	DB2XXCSKIP	DB2DEC19V	DEC	19	0	Member bypasses due to storage shortage
72	QXALOCL	☐	DB2XALOCL	DB2DEC19V	DEC	19	0	# of ASSOCIATE LOCATOR statements executed
73	QXALOCC	☐	DB2XALOCC	DB2DEC19V	DEC	19	0	# of ALLOCATE CURSOR statements executed
74	QXSTFND	☐	DB2XSTFND	DB2DEC19V	DEC	19	0	Number of Times that DB2 Found the Statement in the Cache
75	QXSTNFND	☐	DB2XSTNFND	DB2DEC19V	DEC	19	0	Number of times statement could not be found in cache
76	QXSTIPRP	☐	DB2XSTIRP	DB2DEC19V	DEC	19	0	Number of implicit prepares
77	QXSTNPRP	☐	DB2XSTNPRP	DB2DEC19V	DEC	19	0	Number of avoided prepares
78	QXSTDEXP	☐	DB2XSTDEXP	DB2DEC19V	DEC	19	0	MAXKEEPD parameter exceeded
79	QXSTDINV	☐	DB2XSTINV	DB2DEC19V	DEC	19	0	Statement invalidated
80	QXRNTAB	☐	DB2XRNTAB	DB2DEC19V	DEC	19	0	RENAME TABLE
81	QXFULLP	☐	DB2FULLP	DB2DEC19V	DEC	19	0	Total number of prepares: full prepares + short prepares
82	QXCTRIG	☐	DB2XCTRIG	DB2DEC19V	DEC	19	0	Number of SQL CREATE TRIGGER statements
83	QXDRPTR	☐	DB2XDRPTR	DB2DEC19V	DEC	19	0	Number of SQL DROP TRIGGER statements
84	QXSETPTH	☐	DB2XSETPTH	DB2DEC19V	DEC	19	0	Number of SQL SET CURRENT PATH statements
85	QXDRPFN	☐	DB2XDRPFN	DB2DEC19V	DEC	19	0	Number of DROP UDF statements
86	QXDRPPR	☐	DB2XDRPPR	DB2DEC19V	DEC	19	0	Number of DROP PROCEDURE statements
87	QXCDIST	☐	DB2XCDIST	DB2DEC19V	DEC	19	0	Number of CREATE DISTINCT TYPE statements
88	QXDDIST	☐	DB2XDDIST	DB2DEC19V	DEC	19	0	Number of DROP DISTINCT TYPE statements
89	QXCRUDF	☐	DB2XCRUDF	DB2DEC19V	DEC	19	0	Number of CREATE FUNCTION statements
90	QXCRPRO	☐	DB2XCRPRO	DB2DEC19V	DEC	19	0	Number of CREATE PROCEDURE statements
91	QXHOLDL	☐	DB2XHOLDL	DB2DEC19V	DEC	19	0	Number of HOLD LOCATOR statements
92	QXFREEL	☐	DB2XFREEL	DB2DEC19V	DEC	19	0	Number of FREE LOCATOR statements
93	QXREPOP1	☐	DB2XREPOP1	DB2DEC19V	DEC	19	0	Parallel groups with reformulated access path (Sysplex conf)
94	QXREPOP2	☐	DB2XREPOP2	DB2DEC19V	DEC	19	0	Parallel groups with reformulated access path (buffer pool)
95	QXCRATB	☐	DB2XCRATB	DB2DEC19V	DEC	19	0	Number of CREATE AUXILIARY TABLE statements
96	QXSTLOBV	☐	DB2XSTLOBV	DB2DEC19V	DEC	19	0	Maximum storage used for LOB values (MB)
97	QXALUDF	☐	DB2XALUDF	DB2DEC19V	DEC	19	0	Number of ALTER FUNCTION statements
98	QXALPRO	☐	DB2XALPRO	DB2DEC19V	DEC	19	0	Number of ALTER PROCEDURE statements
99	QXROIMAT	☐	DB2XROIMAT	DB2DEC19V	DEC	19	0	Number of times DB2 used dir. row access to locate a record
100	QXROIIDX	☐	DB2XROIIDX	DB2DEC19V	DEC	19	0	Direct row access attempted, but reverted to using index
101	QXROITS	☐	DB2XROITS	DB2DEC19V	DEC	19	0	Direct row access attempted, reverted to tablespace scan
102	QXSTTRG	☐	DB2XSTTRG	DB2DEC19V	DEC	19	0	Number of times a statement trigger is activated
103	QXROWTRG	☐	DB2XROWTRG	DB2DEC19V	DEC	19	0	Number of times a row trigger is activated
104	QXTRGERR	☐	DB2XTRGERR	DB2DEC19V	DEC	19	0	No. of times an SQL error occurred during a triggered action
105	QXCASCDP	☐	DB2XCASCDP	DB2DEC19V	DEC	19	0	Maximum level of nested SQL cascading
106	QXCAUD	☐	DB2XCAUD	DB2DEC19V	DEC	19	0	Number of user-defined functions executed
107	QXCAUDAB	☐	DB2XCAUDAB	DB2DEC19V	DEC	19	0	Number of times a user-defined function abended
108	QXCAUDTO	☐	DB2XCAUDTO	DB2DEC19V	DEC	19	0	No. of times a user-defined funct. timed out before sched.
109	QXCAUDRJ	☐	DB2XCAUDRJ	DB2DEC19V	DEC	19	0	Number of times a user-defined function was rejected
110	GHITRATIO	☐	DB2GHITRAT		CHAR	7	0	Dynamic Statement Cache Global Hit Ratio
111	LHITRATIO	☐	DB2LHITRAT		CHAR	7	0	Dynamic Statement Cache Local Hit Ratio
112	REPREPRAT	☐	DB2RPRERAT		CHAR	7	0	Reprepare Ratio
113	PREPREQ	☐	DB2PREPR	DB2DEC19V	DEC	19	0	Number of Prepare Requests
114	SHORTPREP	☐	DB2SHPREP	DB2DEC19V	DEC	19	0	Number of Short Prepares
115	QXALTJR	☐	DB2XALTJR	DB2DEC19V	DEC	19	0	alter jar
116	QXMERGE	☐	DB2XMERGE	DB2DEC19V	DEC	19	0	# of times merge sql statement was executed
117	QXTRTBL	☐	DB2XTRTBL	DB2DEC19V	DEC	19	0	# of times truncate table stmt was exec.
118	QXCRROL	☐	DB2XCRROL	DB2DEC19V	DEC	19	0	create role
119	QXDRPROL	☐	DB2XDRPROL	DB2DEC19V	DEC	19	0	drop role
120	QXCRCTX	☐	DB2XCRCTX	DB2DEC19V	DEC	19	0	create trusted context
121	QXALTCTX	☐	DB2XALTCTX	DB2DEC19V	DEC	19	0	alter trusted context
122	QXDRPCTX	☐	DB2XDRPCTX	DB2DEC19V	DEC	19	0	drop trusted context
123	QXRNIX	☐	DB2XRNIX	DB2DEC19V	DEC	19	0	rename index
124	.INCLUDE	☐				0	0	service controller statistics block
125	QTID	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
126	QTLEN	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
127	QTEYE	☐	DB2CHAR04	DB2CHAR04	CHAR	4	0	Field type char, length 4
128	QTALLOCA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
129	QTALLOC	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
130	QTABINDA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
131	QTABIND	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
132	QTINVRID	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
133	QTBINDA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
134	QTBINDR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
135	QTTESTB	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
136	QTPLNBD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
137	QTREBIND	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
138	QTRBINDA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
139	QTPLNRBD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
140	QTFREE	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
141	QTFREEA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
142	QTPLNFRD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
143	QTAUCHK	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
144	QTAUSUC	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
145	QTDSOPN	☐	DB2TDSOPN	DB2INT4U	INT4	10	0	Number of datasets open concurrently
146	QTMAXDS	☐	DB2TMAXDS	DB2INT4U	INT4	10	0	Max. no. of datasets open concurrently
147	QTAUCCH	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
148	QTAUPUB	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
149	QTMAXPB	☐	DB2TMAXPB	DB2INT4U	INT4	10	0	Page sets available to drain since last statistics interval
150	QTPACAUT	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
151	QTPACPUB	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
152	QTPACNOT	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
153	QTREOPN	☐	DB2TREOPN	DB2INT4	INT4	10	0	Number of times a previously unused dataset was used
154	QTPACOW1	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
155	QTPACOW2	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
156	QTSTRES1	☐	DB2RES04	DB2CHAR04	CHAR	4	0	Field type char, length 4, reserved
157	QTDSDRN	☐	DB2TDSDRN	DB2INT4U	INT4	10	0	Number of datasets that were closed via the DRAIN process
158	QTPCCT	☐	DB2TPCCT	DB2INT4U	INT4	10	0	No. of infrequently updated datasets conv. from R/W to R/O
159	QTSLWDD	☐	DB2TSLWDD	DB2INT4U	INT4	10	0	Datasets not used, but not closed due to deferred close
160	QTBINDPA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
161	QTBINDPR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
162	QTPKGBD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
163	QTRBINDP	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
164	QTRBNDPA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
165	QTPKGRBD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
166	QTFREEP	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
167	QTFREEAP	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
168	QTPKGFRD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
169	QTAUTOBA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
170	QTPKABND	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
171	QTPKALLA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
172	QTPKALL	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
173	QTRACAUT	☐	DB2TRACAUT	DB2INT4	INT4	10	0	Number of successful authorization checks
174	QTRACPUB	☐	DB2RACPUB	DB2INT4	INT4	10	0	Number of successful public authorization checks
175	QTRACNOT	☐	DB2RANOT	DB2INT4	INT4	10	0	Number of authorization checks without authorization cache
176	QTRACOW1	☐	DB2RACOW1	DB2INT4	INT4	10	0	Number of authorization ID overrides in authorization cache
177	QTRACOW2	☐	DB2RACOW2	DB2INT4	INT4	10	0	Number of routine entry overrides in authorization cache
178	QTRACNAC	☐	DB2RACNAC	DB2INT4	INT4	10	0	Number of failures in adding an entry to authorization cache
179	.INCLUDE	☐				0	0	DB2/390 Datamanager Statistics
180	QISTRLLM	☐	DB2ISTRLLM	DEC_10	DEC	10	0	RDS limit exceeded
181	QISTRPLM	☐	DB2ISTRPLM	DEC_10	DEC	10	0	Physical limit reached
182	QISTRHIG	☐	DB2ISTRHIG	DEC_10	DEC	10	0	RID blocks allocated - maximum
183	QISTRCUR	☐	DB2ISTRCUR	DEC_10	DEC	10	0	RID block allocated - current
184	QISTRSTG	☐	DB2ISTRSTG	DEC_10	DEC	10	0	RID list processing exhausted virtual storage
185	QISTRMAX	☐	DB2ISTRMAX	DEC_10	DEC	10	0	Process limit exceeded
186	QISTCOLS	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
187	QISTRCCI	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
188	QISTRCCD	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
189	QISTRCCU	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
190	.INCLUDE	☐				0	0	DB2/390 Datamanager Statistics
191	QISTWFNE	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
192	QISTWFP1	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
193	QISTWFP2	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
194	QISTWMXA	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
195	QISTWMXU	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
196	QISTWCTO	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
197	QISTW4K	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
198	QISTW32K	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
199	QISTIMAC	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
200	QISTIMSC	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
201	QISTIMAH	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
202	QISTIMSH	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
203	QISTSIAC	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
204	QISTSISC	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
205	QISTSIAH	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
206	QISTSISH	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
207	QISTWFRHIG	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
208	QISTWFRCUR	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
209	QISTI2AC	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
210	QISTI2AH	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
211	QISTI2OF	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
212	QISTIMNC	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
213	QISTASTH	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
214	QISTSSTH	☐	DB2DEC10V	DB2DEC10V	DEC	10	0	Field Type DEC, Length 10
215	QISTAMXU	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
216	QISTWSTG	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
217	QISTDGTTSTG	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
218	QISTDGTTCTO	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
219	QISTDGTTMXU	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
220	QISTWFSTG	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
221	QISTWFCTO	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
222	QISTWFMXU	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
223	.INCLUDE	☐				0	0	SSC statitics and accounting data mapping
224	QTXADEA	☐	DB2TXADEA	DB2INT4	INT4	10	0	Number of deadlocks
225	QTXASLOC	☐	DB2TXASLOC	DB2INT4	INT4	10	0	Number of lock suspensions
226	QTXATIM	☐	DB2TXATIM	DB2INT4	INT4	10	0	Number of timeouts
227	QTXALES	☐	DB2TXALES	DB2INT4	INT4	10	0	Number of lock escalations (shared)
228	QTXALEX	☐	DB2TXALEX	DB2INT4	INT4	10	0	Number of lock escalations (exclusive)
229	QTXANPL	☐	DB2TXANLP	DB2INT4	INT4	10	0	Maximum page or row locks held
230	QTXAFLG1	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
231	QTXARES1	☐	DB2RES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
232	QTXARLID	☐	DB2CHAR02	DB2CHAR02	CHAR	2	0	Field type char, length 2
233	QTXAPREC	☐	DB2TXAPREC	DB2INT4	INT4	10	0	Precedence How Limit determined
234	QTXASLMT	☐	DB2TXASLMT	DB2INT4	INT4	10	0	Limit in SU's - ASUTIME Column
235	QTXACLMT	☐	DB2TXACLMT	DB2INT4	INT4	10	0	Limit in CPU 16 microseconds
236	QTXACHUS	☐	DB2TXACHUS	DB2INT4	INT4	10	0	Highest amt CPU 16 microsec used in successful DB2 call
237	QTXASLAT	☐	DB2TXASLAT	DB2INT4	INT4	10	0	Number of latch suspensions
238	QTXASOTH	☐	DB2TXASOTH	DB2INT4	INT4	10	0	Number of other suspensions
239	QTXALOCK	☐	DB2TXALOCK	DB2INT4	INT4	10	0	Number of lock requests
240	QTXALOCKD	☐	DB2TXALOCKD	DB2DEC10V	DEC	10	0	Number of lock requests
241	QTXAUNLK	☐	DB2TXAUNLK	DB2INT4	INT4	10	0	Number of unlock requests
242	QTXAUNLKD	☐	DB2TXAUNLKD	DB2DEC10V	DEC	10	0	Number of unlock requests
243	QTXAQRY	☐	DB2TXAQRY	DB2INT4	INT4	10	0	Number of query requests
244	QTXACHG	☐	DB2TXACHG	DB2INT4	INT4	10	0	Number of change requests
245	QTXAIRLM	☐	DB2TXAIRLM	DB2INT4	INT4	10	0	Number of other requests
246	QTXACLNO	☐	DB2TXACLNO	DB2INT4	INT4	10	0	Number of claim requests
247	QTXACLUN	☐	DB2TXACLUN	DB2INT4	INT4	10	0	Number of claim requests that were unsuccessful
248	QTXADRNO	☐	DB2TXADRNO	DB2INT4	INT4	10	0	Number of drain requests
249	QTXADRUN	☐	DB2TXADRUN	DB2INT4	INT4	10	0	Number of drain requests that were unsuccessful
250	.INCLUDE	☐				0	0	EDM Pool Statistics
251	QISEFAIL	☐	DB2NUMC10	DB2INT4	INT4	10	0	Field type numc, length 10, integer
252	QISEPAGE	☐	DB2ISEPAGE	DB2DEC10V	DEC	10	0	Current number of pages in the EDM pool
253	QISECTG	☐	DB2ISECTG	DB2DEC10V	DEC	10	0	Number of requests for cursor table sections
254	QISECTL	☐	DB2ISECTL	DB2DEC10V	DEC	10	0	Number of CT sections not found in EDM pool
255	QISECT	☐	DB2ISECT	DB2DEC10V	DEC	10	0	Current number of pages in EDM pool used for cursor tables
256	QISEFREE	☐	DB2ISEFREE	DB2DEC10V	DEC	10	0	Current number of free pages in the free chain
257	QISEDBD	☐	DB2ISEDBD	DB2DEC10V	DEC	10	0	Current number of pages in EDM pool used for DB descriptor
258	QISESKCT	☐	DB2ISESKCT	DB2DEC10V	DEC	10	0	Current number of pages in EDM pool used for skeleton CT
259	QISEDBDG	☐	DB2ISEDBDG	DB2DEC10V	DEC	10	0	Number of requests for database descriptor
260	QISEDBDL	☐	DB2ISEDBDL	DB2DEC10V	DEC	10	0	Number of DB descriptors not found in EDM pool
261	QISEKTG	☐	DB2ISEKTG	DB2DEC10V	DEC	10	0	Number of requests for package table sections
262	QISEKTL	☐	DB2ISEKTL	DB2DEC10V	DEC	10	0	Number of times a PT section was not found in EDM pool
263	QISEKT	☐	DB2ISEKT	DB2DEC10V	DEC	10	0	Current number of pages in EDM pool used for package tables
264	QISESKPT	☐	DB2ISESKPT	DB2DEC10V	DEC	10	0	Current number of pages in EDM pool used for skeleton PT
265	QISEDSI	☐	DB2ISEDSI	DB2DEC10V	DEC	10	0	Number of inserts into EDM pool for dynamic statement cache
266	QISEDSG	☐	DB2ISEDSG	DB2DEC10V	DEC	10	0	Number of requests for DSC sections
267	QISEDSC	☐	DB2ISEDSC	DB2DEC10V	DEC	10	0	Number of pages used for DSC
268	QISEDFAL	☐	DB2ISEDFAL	DB2DEC10V	DEC	10	0	Number of failures because the data space is full
269	QISEDPGE	☐	DB2ISEDPGE	DB2DEC10V	DEC	10	0	Number of pages in the data space used by the EDM pool
270	QISEDFRE	☐	DB2ISEDFRE	DB2DEC10V	DEC	10	0	Number of free pages in the data space free chain
271	QISECPGE	☐	DB2ISECPGE	DB2INT4	INT4	10	0	Number of pages in EDM statement pool
272	QISECFRE	☐	DB2ISECFRE	DB2INT4	INT4	10	0	Number of free pages in EDM statement pool
273	QISESTMT	☐	DB2ISESTMT	DB2DEC10V	DEC	10	0	Number of statements in EDM pool for dynamic statement cache
274	.INCLUDE	☐				0	0	DB2 star join pool statistics
275	QISJTRY	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
276	QISJFAIL	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
277	QISJSIZE	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
278	QISJMAX	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10

History

Last changed by/on	SAP	20141013
SAP Release Created in	620