SAP ABAP Table DB2QXST (RDS Statistics Block)

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	DB2QXST	Table Relationship Diagram
Short Description	RDS Statistics Block

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	QXSELECT	☐	DB2XSELECT	DB2DEC19V	DEC	19	0	Number of SELECT statements executed
2	QXINSRT	☐	DB2XINSRT	DB2DEC19V	DEC	19	0	Number of INSERT statements executed
3	QXUPDTE	☐	DB2XUPDTE	DB2DEC19V	DEC	19	0	Number of UPDATE statements executed
4	QXDELET	☐	DB2XDELET	DB2DEC19V	DEC	19	0	Number of DELETE statements executed
5	QXDESC	☐	DB2XDESC	DB2DEC19V	DEC	19	0	Number of DESCRIBE statements executed
6	QXPREP	☐	DB2XPREP	DB2DEC19V	DEC	19	0	Number of PREPARE statements executed
7	QXOPEN	☐	DB2XOPEN	DB2DEC19V	DEC	19	0	Number of OPEN CURSOR statements executed
8	QXCLOSE	☐	DB2XCLOSE	DB2DEC19V	DEC	19	0	Number of CLOSE CURSOR statements executed
9	QXCRTAB	☐	DB2XCRTAB	DB2DEC19V	DEC	19	0	Number of CREATE TABLE statements executed
10	QXCRINX	☐	DB2XCRINX	DB2DEC19V	DEC	19	0	Number of CREATE INDEX statements executed
11	QXCTABS	☐	DB2XCTABS	DB2DEC19V	DEC	19	0	Number of CREATE TABLE SPACE statements executed
12	QXCRSYN	☐	DB2XCRSYN	DB2DEC19V	DEC	19	0	Number of CREATE SYNONYM statements executed
13	QXCRDAB	☐	DB2XCRDAB	DB2DEC19V	DEC	19	0	Number of CREATE DATABASE statements executed
14	QXCRSTG	☐	DB2XCRSTG	DB2DEC19V	DEC	19	0	Number of CREATE STORAGE GROUP statements executed
15	QXDEFVU	☐	DB2XDEFVU	DB2DEC19V	DEC	19	0	Number of CREATE VIEW statements executed
16	QXDRPIX	☐	DB2XDRPIX	DB2DEC19V	DEC	19	0	Number of DROP INDEX statements executed
17	QXDRPTA	☐	DB2XDRPTA	DB2DEC19V	DEC	19	0	Number of DROP TABLE statements executed
18	QXDRPTS	☐	DB2XDRPTS	DB2DEC19V	DEC	19	0	Number of DROP TABLE SPACE statements executed
19	QXDRPDB	☐	DB2XDRPDB	DB2DEC19V	DEC	19	0	Number of DROP DATABASE statements executed
20	QXDRPSY	☐	DB2XDRPSY	DB2DEC19V	DEC	19	0	Number of DROP SYNONYM statements executed
21	QXDRPST	☐	DB2XDRPST	DB2DEC19V	DEC	19	0	Number of DROP STORAGE GROUP statements executed
22	QXDRPVU	☐	DB2XDRPVU	DB2DEC19V	DEC	19	0	Number of DROP VIEW statements executed
23	QXALTST	☐	DB2XALTST	DB2DEC19V	DEC	19	0	Number of ALTER STORAGE GROUP statements executed
24	QXFETCH	☐	DB2XFETCH	DB2DEC19V	DEC	19	0	Number of FETCH statements executed
25	QXALTTS	☐	DB2XALTTS	DB2DEC19V	DEC	19	0	Number of ALTER TABLE SPACE statements executed
26	QXALTTA	☐	DB2XALTTA	DB2DEC19V	DEC	19	0	Number of ALTER TABLE statements executed
27	QXALTIX	☐	DB2XALTIX	DB2DEC19V	DEC	19	0	Number of ALTER INDEX statements executed
28	QXCMTON	☐	DB2XCMTON	DB2DEC19V	DEC	19	0	Number of COMMENT ON statements executed
29	QXLOCK	☐	DB2XLOCK	DB2DEC19V	DEC	19	0	Number of LOCK TABLE statements executed
30	QXGRANT	☐	DB2XGRANT	DB2DEC19V	DEC	19	0	Number of GRANT statements executed
31	QXREVOK	☐	DB2XREVOK	DB2DEC19V	DEC	19	0	Number of REVOKE statements executed
32	QXINCRB	☐	DB2XINCRB	DB2DEC19V	DEC	19	0	Number of INCREMENTAL BINDs executed
33	QXLABON	☐	DB2XLABON	DB2DEC19V	DEC	19	0	Number of LABEL ON statements executed
34	QXSETSQL	☐	DB2XSETSQL	DB2DEC19V	DEC	19	0	Number of SET CURRENT SQLID statements executed
35	QXCRALS	☐	DB2XCRALS	DB2DEC19V	DEC	19	0	Number of CREATE ALIAS statements executed
36	QXDRPAL	☐	DB2XDRPAL	DB2DEC19V	DEC	19	0	Number of DROP ALIAS statements executed
37	QXMIAP	☐	DB2XMIAP	DB2DEC19V	DEC	19	0	Number of times RID list processing is used
38	QXNSMIAP	☐	DB2XNSMIAP	DB2DEC19V	DEC	19	0	RID list processing failed - no storage
39	QXMRMIAP	☐	DB2XMRMIAP	DB2DEC19V	DEC	19	0	RID list processing failed - limit exeeded
40	QXSETHV	☐	DB2XSETHV	DB2DEC19V	DEC	19	0	Number of SET HOST VARIABLE statements executed
41	QXALDAB	☐	DB2XALDAB	DB2DEC19V	DEC	19	0	Number of ALTER DATABASE statements executed
42	QXDRPPKG	☐	DB2XDRPPKG	DB2DEC19V	DEC	19	0	Number of DROP PACKAGE statements executed
43	QXDSCRTB	☐	DB2XDSCRTB	DB2DEC19V	DEC	19	0	Number of DESCRIBE TABLE statements executed
44	QXMAXDEG	☐	DB2XMAXDEG	DB2DEC19V	DEC	19	0	Maximum parallelism degree
45	QXTOTGRP	☐	DB2XTOTGRP	DB2DEC19V	DEC	19	0	Parallel groups: total executed
46	QXDEGCUR	☐	DB2XDEGCUR	DB2DEC19V	DEC	19	0	Parallel groups fell to sequential due to updatable cursor
47	QXDEGESA	☐	DB2XDEGESA	DB2DEC19V	DEC	19	0	Par. groups fell to sequ. due to lack of ESA sort support
48	QXDEGBUF	☐	DB2XDEGBUF	DB2DEC19V	DEC	19	0	Parallel groups fell to sequential due to storage shortage
49	QXREDGRP	☐	DB2XREDGRP	DB2DEC19V	DEC	19	0	Parallel groups: executed with reduced degree
50	QXNORGRP	☐	DB2XNORGRP	DB2DEC19V	DEC	19	0	Parallel groups: executed as planned
51	QXCON1	☐	DB2XCON1	DB2DEC19V	DEC	19	0	Number of CONNECT TYPE 1 statements executed
52	QXCON2	☐	DB2XCON2	DB2DEC19V	DEC	19	0	Number of CONNECT TYPE 2 statements executed
53	QXREL	☐	DB2XREL	DB2DEC19V	DEC	19	0	Number of RELEASE statements executed
54	QXSETCON	☐	DB2XSETCON	DB2DEC19V	DEC	19	0	Number of SET CONNECTION statements executed
55	QXSETCDG	☐	DB2XSETCDG	DB2DEC19V	DEC	19	0	Number of SET CURRENT DEGREE statements executed
56	QXSETCRL	☐	DB2XSETCRL	DB2DEC19V	DEC	19	0	Number of SET CURRENT RULES statements executed
57	QXCALL	☐	DB2XCALL	DB2DEC19V	DEC	19	0	Number of SQL CALL statements executed
58	QXCALLAB	☐	DB2XCALLAB	DB2DEC19V	DEC	19	0	# of times a stored procedure ABENDed
59	QXCALLTO	☐	DB2XCALLTO	DB2DEC19V	DEC	19	0	# of times an SQL CALL stmt timedout waiting to be scheduled
60	QXCALLRJ	☐	DB2XCALLRJ	DB2DEC19V	DEC	19	0	# of times an SQL CALL statement was rejected
61	QXDEGENC	☐	DB2XDEGENC	DB2DEC19V	DEC	19	0	Par.groups fell to sequ. due to unavailable enclave services
62	QXRLFDPA	☐			CHAR	1	0
63	QXSTRES1	☐	DB2RES03	DB2CHAR03	CHAR	3	0	Field type char, length 3, reserved
64	QXCOORNO	☐	DB2XCOORNO	DB2DEC19V	DEC	19	0	COORDINATOR setting mismatch
65	QXISORR	☐	DB2XISORR	DB2DEC19V	DEC	19	0	Isolation level RR or RS
66	QXCRGTT	☐	DB2XCRGTT	DB2DEC19V	DEC	19	0	# OF CREATE GLBL TEMP TABLE
67	QXSTREOP	☐	DB2XREOP	DB2DEC19V	DEC	19	0	Total Number of Times Reoptimization Occurs
68	QXXCBPNX	☐	DB2XXCBPNX	DB2DEC19V	DEC	19	0	Parallel groups: intended to run across data sharing group
69	QXXCSKIP	☐	DB2XXCSKIP	DB2DEC19V	DEC	19	0	Member bypasses due to storage shortage
70	QXALOCL	☐	DB2XALOCL	DB2DEC19V	DEC	19	0	# of ASSOCIATE LOCATOR statements executed
71	QXALOCC	☐	DB2XALOCC	DB2DEC19V	DEC	19	0	# of ALLOCATE CURSOR statements executed
72	QXSTFND	☐	DB2XSTFND	DB2DEC19V	DEC	19	0	Number of Times that DB2 Found the Statement in the Cache
73	QXSTNFND	☐	DB2XSTNFND	DB2DEC19V	DEC	19	0	Number of times statement could not be found in cache
74	QXSTIPRP	☐	DB2XSTIRP	DB2DEC19V	DEC	19	0	Number of implicit prepares
75	QXSTNPRP	☐	DB2XSTNPRP	DB2DEC19V	DEC	19	0	Number of avoided prepares
76	QXSTDEXP	☐	DB2XSTDEXP	DB2DEC19V	DEC	19	0	MAXKEEPD parameter exceeded
77	QXSTDINV	☐	DB2XSTINV	DB2DEC19V	DEC	19	0	Statement invalidated
78	QXRNTAB	☐	DB2XRNTAB	DB2DEC19V	DEC	19	0	RENAME TABLE
79	QXFULLP	☐	DB2FULLP	DB2DEC19V	DEC	19	0	Total number of prepares: full prepares + short prepares
80	QXCTRIG	☐	DB2XCTRIG	DB2DEC19V	DEC	19	0	Number of SQL CREATE TRIGGER statements
81	QXDRPTR	☐	DB2XDRPTR	DB2DEC19V	DEC	19	0	Number of SQL DROP TRIGGER statements
82	QXSETPTH	☐	DB2XSETPTH	DB2DEC19V	DEC	19	0	Number of SQL SET CURRENT PATH statements
83	QXDRPFN	☐	DB2XDRPFN	DB2DEC19V	DEC	19	0	Number of DROP UDF statements
84	QXDRPPR	☐	DB2XDRPPR	DB2DEC19V	DEC	19	0	Number of DROP PROCEDURE statements
85	QXCDIST	☐	DB2XCDIST	DB2DEC19V	DEC	19	0	Number of CREATE DISTINCT TYPE statements
86	QXDDIST	☐	DB2XDDIST	DB2DEC19V	DEC	19	0	Number of DROP DISTINCT TYPE statements
87	QXCRUDF	☐	DB2XCRUDF	DB2DEC19V	DEC	19	0	Number of CREATE FUNCTION statements
88	QXCRPRO	☐	DB2XCRPRO	DB2DEC19V	DEC	19	0	Number of CREATE PROCEDURE statements
89	QXHOLDL	☐	DB2XHOLDL	DB2DEC19V	DEC	19	0	Number of HOLD LOCATOR statements
90	QXFREEL	☐	DB2XFREEL	DB2DEC19V	DEC	19	0	Number of FREE LOCATOR statements
91	QXREPOP1	☐	DB2XREPOP1	DB2DEC19V	DEC	19	0	Parallel groups with reformulated access path (Sysplex conf)
92	QXREPOP2	☐	DB2XREPOP2	DB2DEC19V	DEC	19	0	Parallel groups with reformulated access path (buffer pool)
93	QXCRATB	☐	DB2XCRATB	DB2DEC19V	DEC	19	0	Number of CREATE AUXILIARY TABLE statements
94	QXSTLOBV	☐	DB2XSTLOBV	DB2DEC19V	DEC	19	0	Maximum storage used for LOB values (MB)
95	QXALUDF	☐	DB2XALUDF	DB2DEC19V	DEC	19	0	Number of ALTER FUNCTION statements
96	QXALPRO	☐	DB2XALPRO	DB2DEC19V	DEC	19	0	Number of ALTER PROCEDURE statements
97	QXROIMAT	☐	DB2XROIMAT	DB2DEC19V	DEC	19	0	Number of times DB2 used dir. row access to locate a record
98	QXROIIDX	☐	DB2XROIIDX	DB2DEC19V	DEC	19	0	Direct row access attempted, but reverted to using index
99	QXROITS	☐	DB2XROITS	DB2DEC19V	DEC	19	0	Direct row access attempted, reverted to tablespace scan
100	QXSTTRG	☐	DB2XSTTRG	DB2DEC19V	DEC	19	0	Number of times a statement trigger is activated
101	QXROWTRG	☐	DB2XROWTRG	DB2DEC19V	DEC	19	0	Number of times a row trigger is activated
102	QXTRGERR	☐	DB2XTRGERR	DB2DEC19V	DEC	19	0	No. of times an SQL error occurred during a triggered action
103	QXCASCDP	☐	DB2XCASCDP	DB2DEC19V	DEC	19	0	Maximum level of nested SQL cascading
104	QXCAUD	☐	DB2XCAUD	DB2DEC19V	DEC	19	0	Number of user-defined functions executed
105	QXCAUDAB	☐	DB2XCAUDAB	DB2DEC19V	DEC	19	0	Number of times a user-defined function abended
106	QXCAUDTO	☐	DB2XCAUDTO	DB2DEC19V	DEC	19	0	No. of times a user-defined funct. timed out before sched.
107	QXCAUDRJ	☐	DB2XCAUDRJ	DB2DEC19V	DEC	19	0	Number of times a user-defined function was rejected
108	GHITRATIO	☐	DB2GHITRAT		CHAR	7	0	Dynamic Statement Cache Global Hit Ratio
109	LHITRATIO	☐	DB2LHITRAT		CHAR	7	0	Dynamic Statement Cache Local Hit Ratio
110	REPREPRAT	☐	DB2RPRERAT		CHAR	7	0	Reprepare Ratio
111	PREPREQ	☐	DB2PREPR	DB2DEC19V	DEC	19	0	Number of Prepare Requests
112	SHORTPREP	☐	DB2SHPREP	DB2DEC19V	DEC	19	0	Number of Short Prepares
113	QXALTJR	☐	DB2XALTJR	DB2DEC19V	DEC	19	0	alter jar
114	QXMERGE	☐	DB2XMERGE	DB2DEC19V	DEC	19	0	# of times merge sql statement was executed
115	QXTRTBL	☐	DB2XTRTBL	DB2DEC19V	DEC	19	0	# of times truncate table stmt was exec.
116	QXCRROL	☐	DB2XCRROL	DB2DEC19V	DEC	19	0	create role
117	QXDRPROL	☐	DB2XDRPROL	DB2DEC19V	DEC	19	0	drop role
118	QXCRCTX	☐	DB2XCRCTX	DB2DEC19V	DEC	19	0	create trusted context
119	QXALTCTX	☐	DB2XALTCTX	DB2DEC19V	DEC	19	0	alter trusted context
120	QXDRPCTX	☐	DB2XDRPCTX	DB2DEC19V	DEC	19	0	drop trusted context
121	QXRNIX	☐	DB2XRNIX	DB2DEC19V	DEC	19	0	rename index

History

Last changed by/on	SAP	20110908
SAP Release Created in