SAP ABAP Table DB2QTHDDTL (DB2MONI: thread details)

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	DB2QTHDDTL	Table Relationship Diagram
Short Description	DB2MONI: thread 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	MEMBNM	☑	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
2	USERID	☑	DB2USERID	DB2SINT	INT2	5	0
3	ACE	☑	DB2RAW04	DB2INT4	INT4	10	0	Field type raw, length 8, 4 bytes
4	.INCLUDE	☐				0	0	RDS Statistics Block
5	QXSELECT	☐	DB2XSELECT	DB2DEC19V	DEC	19	0	Number of SELECT statements executed
6	QXINSRT	☐	DB2XINSRT	DB2DEC19V	DEC	19	0	Number of INSERT statements executed
7	QXUPDTE	☐	DB2XUPDTE	DB2DEC19V	DEC	19	0	Number of UPDATE statements executed
8	QXDELET	☐	DB2XDELET	DB2DEC19V	DEC	19	0	Number of DELETE statements executed
9	QXDESC	☐	DB2XDESC	DB2DEC19V	DEC	19	0	Number of DESCRIBE statements executed
10	QXPREP	☐	DB2XPREP	DB2DEC19V	DEC	19	0	Number of PREPARE statements executed
11	QXOPEN	☐	DB2XOPEN	DB2DEC19V	DEC	19	0	Number of OPEN CURSOR statements executed
12	QXCLOSE	☐	DB2XCLOSE	DB2DEC19V	DEC	19	0	Number of CLOSE CURSOR statements executed
13	QXCRTAB	☐	DB2XCRTAB	DB2DEC19V	DEC	19	0	Number of CREATE TABLE statements executed
14	QXCRINX	☐	DB2XCRINX	DB2DEC19V	DEC	19	0	Number of CREATE INDEX statements executed
15	QXCTABS	☐	DB2XCTABS	DB2DEC19V	DEC	19	0	Number of CREATE TABLE SPACE statements executed
16	QXCRSYN	☐	DB2XCRSYN	DB2DEC19V	DEC	19	0	Number of CREATE SYNONYM statements executed
17	QXCRDAB	☐	DB2XCRDAB	DB2DEC19V	DEC	19	0	Number of CREATE DATABASE statements executed
18	QXCRSTG	☐	DB2XCRSTG	DB2DEC19V	DEC	19	0	Number of CREATE STORAGE GROUP statements executed
19	QXDEFVU	☐	DB2XDEFVU	DB2DEC19V	DEC	19	0	Number of CREATE VIEW statements executed
20	QXDRPIX	☐	DB2XDRPIX	DB2DEC19V	DEC	19	0	Number of DROP INDEX statements executed
21	QXDRPTA	☐	DB2XDRPTA	DB2DEC19V	DEC	19	0	Number of DROP TABLE statements executed
22	QXDRPTS	☐	DB2XDRPTS	DB2DEC19V	DEC	19	0	Number of DROP TABLE SPACE statements executed
23	QXDRPDB	☐	DB2XDRPDB	DB2DEC19V	DEC	19	0	Number of DROP DATABASE statements executed
24	QXDRPSY	☐	DB2XDRPSY	DB2DEC19V	DEC	19	0	Number of DROP SYNONYM statements executed
25	QXDRPST	☐	DB2XDRPST	DB2DEC19V	DEC	19	0	Number of DROP STORAGE GROUP statements executed
26	QXDRPVU	☐	DB2XDRPVU	DB2DEC19V	DEC	19	0	Number of DROP VIEW statements executed
27	QXALTST	☐	DB2XALTST	DB2DEC19V	DEC	19	0	Number of ALTER STORAGE GROUP statements executed
28	QXFETCH	☐	DB2XFETCH	DB2DEC19V	DEC	19	0	Number of FETCH statements executed
29	QXALTTS	☐	DB2XALTTS	DB2DEC19V	DEC	19	0	Number of ALTER TABLE SPACE statements executed
30	QXALTTA	☐	DB2XALTTA	DB2DEC19V	DEC	19	0	Number of ALTER TABLE statements executed
31	QXALTIX	☐	DB2XALTIX	DB2DEC19V	DEC	19	0	Number of ALTER INDEX statements executed
32	QXCMTON	☐	DB2XCMTON	DB2DEC19V	DEC	19	0	Number of COMMENT ON statements executed
33	QXLOCK	☐	DB2XLOCK	DB2DEC19V	DEC	19	0	Number of LOCK TABLE statements executed
34	QXGRANT	☐	DB2XGRANT	DB2DEC19V	DEC	19	0	Number of GRANT statements executed
35	QXREVOK	☐	DB2XREVOK	DB2DEC19V	DEC	19	0	Number of REVOKE statements executed
36	QXINCRB	☐	DB2XINCRB	DB2DEC19V	DEC	19	0	Number of INCREMENTAL BINDs executed
37	QXLABON	☐	DB2XLABON	DB2DEC19V	DEC	19	0	Number of LABEL ON statements executed
38	QXSETSQL	☐	DB2XSETSQL	DB2DEC19V	DEC	19	0	Number of SET CURRENT SQLID statements executed
39	QXCRALS	☐	DB2XCRALS	DB2DEC19V	DEC	19	0	Number of CREATE ALIAS statements executed
40	QXDRPAL	☐	DB2XDRPAL	DB2DEC19V	DEC	19	0	Number of DROP ALIAS statements executed
41	QXMIAP	☐	DB2XMIAP	DB2DEC19V	DEC	19	0	Number of times RID list processing is used
42	QXNSMIAP	☐	DB2XNSMIAP	DB2DEC19V	DEC	19	0	RID list processing failed - no storage
43	QXMRMIAP	☐	DB2XMRMIAP	DB2DEC19V	DEC	19	0	RID list processing failed - limit exeeded
44	QXSETHV	☐	DB2XSETHV	DB2DEC19V	DEC	19	0	Number of SET HOST VARIABLE statements executed
45	QXALDAB	☐	DB2XALDAB	DB2DEC19V	DEC	19	0	Number of ALTER DATABASE statements executed
46	QXDRPPKG	☐	DB2XDRPPKG	DB2DEC19V	DEC	19	0	Number of DROP PACKAGE statements executed
47	QXDSCRTB	☐	DB2XDSCRTB	DB2DEC19V	DEC	19	0	Number of DESCRIBE TABLE statements executed
48	QXMAXDEG	☐	DB2XMAXDEG	DB2DEC19V	DEC	19	0	Maximum parallelism degree
49	QXTOTGRP	☐	DB2XTOTGRP	DB2DEC19V	DEC	19	0	Parallel groups: total executed
50	QXDEGCUR	☐	DB2XDEGCUR	DB2DEC19V	DEC	19	0	Parallel groups fell to sequential due to updatable cursor
51	QXDEGESA	☐	DB2XDEGESA	DB2DEC19V	DEC	19	0	Par. groups fell to sequ. due to lack of ESA sort support
52	QXDEGBUF	☐	DB2XDEGBUF	DB2DEC19V	DEC	19	0	Parallel groups fell to sequential due to storage shortage
53	QXREDGRP	☐	DB2XREDGRP	DB2DEC19V	DEC	19	0	Parallel groups: executed with reduced degree
54	QXNORGRP	☐	DB2XNORGRP	DB2DEC19V	DEC	19	0	Parallel groups: executed as planned
55	QXCON1	☐	DB2XCON1	DB2DEC19V	DEC	19	0	Number of CONNECT TYPE 1 statements executed
56	QXCON2	☐	DB2XCON2	DB2DEC19V	DEC	19	0	Number of CONNECT TYPE 2 statements executed
57	QXREL	☐	DB2XREL	DB2DEC19V	DEC	19	0	Number of RELEASE statements executed
58	QXSETCON	☐	DB2XSETCON	DB2DEC19V	DEC	19	0	Number of SET CONNECTION statements executed
59	QXSETCDG	☐	DB2XSETCDG	DB2DEC19V	DEC	19	0	Number of SET CURRENT DEGREE statements executed
60	QXSETCRL	☐	DB2XSETCRL	DB2DEC19V	DEC	19	0	Number of SET CURRENT RULES statements executed
61	QXCALL	☐	DB2XCALL	DB2DEC19V	DEC	19	0	Number of SQL CALL statements executed
62	QXCALLAB	☐	DB2XCALLAB	DB2DEC19V	DEC	19	0	# of times a stored procedure ABENDed
63	QXCALLTO	☐	DB2XCALLTO	DB2DEC19V	DEC	19	0	# of times an SQL CALL stmt timedout waiting to be scheduled
64	QXCALLRJ	☐	DB2XCALLRJ	DB2DEC19V	DEC	19	0	# of times an SQL CALL statement was rejected
65	QXDEGENC	☐	DB2XDEGENC	DB2DEC19V	DEC	19	0	Par.groups fell to sequ. due to unavailable enclave services
66	QXRLFDPA	☐			CHAR	1	0
67	QXSTRES1	☐	DB2RES03	DB2CHAR03	CHAR	3	0	Field type char, length 3, reserved
68	QXCOORNO	☐	DB2XCOORNO	DB2DEC19V	DEC	19	0	COORDINATOR setting mismatch
69	QXISORR	☐	DB2XISORR	DB2DEC19V	DEC	19	0	Isolation level RR or RS
70	QXCRGTT	☐	DB2XCRGTT	DB2DEC19V	DEC	19	0	# OF CREATE GLBL TEMP TABLE
71	QXSTREOP	☐	DB2XREOP	DB2DEC19V	DEC	19	0	Total Number of Times Reoptimization Occurs
72	QXXCBPNX	☐	DB2XXCBPNX	DB2DEC19V	DEC	19	0	Parallel groups: intended to run across data sharing group
73	QXXCSKIP	☐	DB2XXCSKIP	DB2DEC19V	DEC	19	0	Member bypasses due to storage shortage
74	QXALOCL	☐	DB2XALOCL	DB2DEC19V	DEC	19	0	# of ASSOCIATE LOCATOR statements executed
75	QXALOCC	☐	DB2XALOCC	DB2DEC19V	DEC	19	0	# of ALLOCATE CURSOR statements executed
76	QXSTFND	☐	DB2XSTFND	DB2DEC19V	DEC	19	0	Number of Times that DB2 Found the Statement in the Cache
77	QXSTNFND	☐	DB2XSTNFND	DB2DEC19V	DEC	19	0	Number of times statement could not be found in cache
78	QXSTIPRP	☐	DB2XSTIRP	DB2DEC19V	DEC	19	0	Number of implicit prepares
79	QXSTNPRP	☐	DB2XSTNPRP	DB2DEC19V	DEC	19	0	Number of avoided prepares
80	QXSTDEXP	☐	DB2XSTDEXP	DB2DEC19V	DEC	19	0	MAXKEEPD parameter exceeded
81	QXSTDINV	☐	DB2XSTINV	DB2DEC19V	DEC	19	0	Statement invalidated
82	QXRNTAB	☐	DB2XRNTAB	DB2DEC19V	DEC	19	0	RENAME TABLE
83	QXFULLP	☐	DB2FULLP	DB2DEC19V	DEC	19	0	Total number of prepares: full prepares + short prepares
84	QXCTRIG	☐	DB2XCTRIG	DB2DEC19V	DEC	19	0	Number of SQL CREATE TRIGGER statements
85	QXDRPTR	☐	DB2XDRPTR	DB2DEC19V	DEC	19	0	Number of SQL DROP TRIGGER statements
86	QXSETPTH	☐	DB2XSETPTH	DB2DEC19V	DEC	19	0	Number of SQL SET CURRENT PATH statements
87	QXDRPFN	☐	DB2XDRPFN	DB2DEC19V	DEC	19	0	Number of DROP UDF statements
88	QXDRPPR	☐	DB2XDRPPR	DB2DEC19V	DEC	19	0	Number of DROP PROCEDURE statements
89	QXCDIST	☐	DB2XCDIST	DB2DEC19V	DEC	19	0	Number of CREATE DISTINCT TYPE statements
90	QXDDIST	☐	DB2XDDIST	DB2DEC19V	DEC	19	0	Number of DROP DISTINCT TYPE statements
91	QXCRUDF	☐	DB2XCRUDF	DB2DEC19V	DEC	19	0	Number of CREATE FUNCTION statements
92	QXCRPRO	☐	DB2XCRPRO	DB2DEC19V	DEC	19	0	Number of CREATE PROCEDURE statements
93	QXHOLDL	☐	DB2XHOLDL	DB2DEC19V	DEC	19	0	Number of HOLD LOCATOR statements
94	QXFREEL	☐	DB2XFREEL	DB2DEC19V	DEC	19	0	Number of FREE LOCATOR statements
95	QXREPOP1	☐	DB2XREPOP1	DB2DEC19V	DEC	19	0	Parallel groups with reformulated access path (Sysplex conf)
96	QXREPOP2	☐	DB2XREPOP2	DB2DEC19V	DEC	19	0	Parallel groups with reformulated access path (buffer pool)
97	QXCRATB	☐	DB2XCRATB	DB2DEC19V	DEC	19	0	Number of CREATE AUXILIARY TABLE statements
98	QXSTLOBV	☐	DB2XSTLOBV	DB2DEC19V	DEC	19	0	Maximum storage used for LOB values (MB)
99	QXALUDF	☐	DB2XALUDF	DB2DEC19V	DEC	19	0	Number of ALTER FUNCTION statements
100	QXALPRO	☐	DB2XALPRO	DB2DEC19V	DEC	19	0	Number of ALTER PROCEDURE statements
101	QXROIMAT	☐	DB2XROIMAT	DB2DEC19V	DEC	19	0	Number of times DB2 used dir. row access to locate a record
102	QXROIIDX	☐	DB2XROIIDX	DB2DEC19V	DEC	19	0	Direct row access attempted, but reverted to using index
103	QXROITS	☐	DB2XROITS	DB2DEC19V	DEC	19	0	Direct row access attempted, reverted to tablespace scan
104	QXSTTRG	☐	DB2XSTTRG	DB2DEC19V	DEC	19	0	Number of times a statement trigger is activated
105	QXROWTRG	☐	DB2XROWTRG	DB2DEC19V	DEC	19	0	Number of times a row trigger is activated
106	QXTRGERR	☐	DB2XTRGERR	DB2DEC19V	DEC	19	0	No. of times an SQL error occurred during a triggered action
107	QXCASCDP	☐	DB2XCASCDP	DB2DEC19V	DEC	19	0	Maximum level of nested SQL cascading
108	QXCAUD	☐	DB2XCAUD	DB2DEC19V	DEC	19	0	Number of user-defined functions executed
109	QXCAUDAB	☐	DB2XCAUDAB	DB2DEC19V	DEC	19	0	Number of times a user-defined function abended
110	QXCAUDTO	☐	DB2XCAUDTO	DB2DEC19V	DEC	19	0	No. of times a user-defined funct. timed out before sched.
111	QXCAUDRJ	☐	DB2XCAUDRJ	DB2DEC19V	DEC	19	0	Number of times a user-defined function was rejected
112	GHITRATIO	☐	DB2GHITRAT		CHAR	7	0	Dynamic Statement Cache Global Hit Ratio
113	LHITRATIO	☐	DB2LHITRAT		CHAR	7	0	Dynamic Statement Cache Local Hit Ratio
114	REPREPRAT	☐	DB2RPRERAT		CHAR	7	0	Reprepare Ratio
115	PREPREQ	☐	DB2PREPR	DB2DEC19V	DEC	19	0	Number of Prepare Requests
116	SHORTPREP	☐	DB2SHPREP	DB2DEC19V	DEC	19	0	Number of Short Prepares
117	QXALTJR	☐	DB2XALTJR	DB2DEC19V	DEC	19	0	alter jar
118	QXMERGE	☐	DB2XMERGE	DB2DEC19V	DEC	19	0	# of times merge sql statement was executed
119	QXTRTBL	☐	DB2XTRTBL	DB2DEC19V	DEC	19	0	# of times truncate table stmt was exec.
120	QXCRROL	☐	DB2XCRROL	DB2DEC19V	DEC	19	0	create role
121	QXDRPROL	☐	DB2XDRPROL	DB2DEC19V	DEC	19	0	drop role
122	QXCRCTX	☐	DB2XCRCTX	DB2DEC19V	DEC	19	0	create trusted context
123	QXALTCTX	☐	DB2XALTCTX	DB2DEC19V	DEC	19	0	alter trusted context
124	QXDRPCTX	☐	DB2XDRPCTX	DB2DEC19V	DEC	19	0	drop trusted context
125	QXRNIX	☐	DB2XRNIX	DB2DEC19V	DEC	19	0	rename index
126	QTXADEA	☐	DB2TXADEA	DB2INT4	INT4	10	0	Number of deadlocks
127	QTXASLOC	☐	DB2TXASLOC	DB2INT4	INT4	10	0	Number of lock suspensions
128	QTXATIM	☐	DB2TXATIM	DB2INT4	INT4	10	0	Number of timeouts
129	QTXALES	☐	DB2TXALES	DB2INT4	INT4	10	0	Number of lock escalations (shared)
130	QTXALEX	☐	DB2TXALEX	DB2INT4	INT4	10	0	Number of lock escalations (exclusive)
131	QTXAFLG1	☐	DB2BIT01	DB2CHAR01	CHAR	1	0	Field type char, length 1, bit field
132	QTXARES1	☐	DB2RES01	DB2CHAR01	CHAR	1	0	Field type char, length 1, reserved
133	QTXARLID	☐	DB2CHAR02	DB2CHAR02	CHAR	2	0	Field type char, length 2
134	QTXAPREC	☐	DB2TXAPREC	DB2INT4	INT4	10	0	Precedence How Limit determined
135	QTXASLMT	☐	DB2TXASLMT	DB2INT4	INT4	10	0	Limit in SU's - ASUTIME Column
136	QTXACLMT	☐	DB2TXACLMT	DB2INT4	INT4	10	0	Limit in CPU 16 microseconds
137	QTXACHUS	☐	DB2TXACHUS	DB2INT4	INT4	10	0	Highest amt CPU 16 microsec used in successful DB2 call
138	QTXASLAT	☐	DB2TXASLAT	DB2INT4	INT4	10	0	Number of latch suspensions
139	QTXASOTH	☐	DB2TXASOTH	DB2INT4	INT4	10	0	Number of other suspensions
140	QTXALOCK	☐	DB2TXALOCK	DB2INT4	INT4	10	0	Number of lock requests
141	QTXAUNLK	☐	DB2TXAUNLK	DB2INT4	INT4	10	0	Number of unlock requests
142	QTXAQRY	☐	DB2TXAQRY	DB2INT4	INT4	10	0	Number of query requests
143	QTXACHG	☐	DB2TXACHG	DB2INT4	INT4	10	0	Number of change requests
144	QTXAIRLM	☐	DB2TXAIRLM	DB2INT4	INT4	10	0	Number of other requests
145	QTXACLNO	☐	DB2TXACLNO	DB2INT4	INT4	10	0	Number of claim requests
146	QTXACLUN	☐	DB2TXACLUN	DB2INT4	INT4	10	0	Number of claim requests that were unsuccessful
147	QTXADRNO	☐	DB2TXADRNO	DB2INT4	INT4	10	0	Number of drain requests
148	QTXADRUN	☐	DB2TXADRUN	DB2INT4	INT4	10	0	Number of drain requests that were unsuccessful
149	.INCLUDE	☐				0	0	DB2/390: Data Sharing Locking for Given Thread
150	QTGALPLK	☐	DB2TGSLPLK	DB2DEC10V	DEC	10	0	Number of lock requests for P-locks
151	QTGAUPLK	☐	DB2TGSUPLK	DB2DEC10V	DEC	10	0	Number of unlock requests for P-locks
152	QTGACPLK	☐	DB2TGSCPLK	DB2DEC10V	DEC	10	0	Number of Change Requests for P-Locks
153	QTGALSLM	☐	DB2TGSLSLM	DB2DEC10V	DEC	10	0	Number of lock requests propagated to MVS XES synchronously
154	QTGACSLM	☐	DB2TGSCSLM	DB2DEC10V	DEC	10	0	No. of Change Requests Propagated to MVS XES Synchronously
155	QTGAUSLM	☐	DB2TGSUSLM	DB2DEC10V	DEC	10	0	Number of IRLM unlock requests propagated to MVS XES synch.
156	QTGAIGLO	☐	DB2TGSIGLO	DB2DEC10V	DEC	10	0	Number of suspends caused by IRLM global resource contention
157	QTGASGLO	☐	DB2TGSSGLO	DB2DEC10V	DEC	10	0	Suspends caused by MVS XES global resource contention
158	QTGAFLSE	☐	DB2TGSFLSE	DB2DEC10V	DEC	10	0	Number of suspends because of false contentions
159	QTGADRTA	☐	DB2TGSDRTA	DB2DEC10V	DEC	10	0	Incompatible retained lock
160	QTGANTFY	☐	DB2TGSNTFY	DB2DEC10V	DEC	10	0	Number of Notification Messages Sent to Other Members
161	GCONTRATE	☐	DB2TGCONRA	DB2CHAR10	CHAR	10	0	Global contention rate
162	FCONTRATE	☐	DB2TFCONRA	DB2CHAR10	CHAR	10	0	False contention rate
163	TLOPTRATE	☐	DB2TTLOPRA	DB2CHAR10	CHAR	10	0	Transaction locking optimization rate
164	.INCLUDE	☐				0	0	SQL Statement Data
165	STMTTYPE	☐	DB2STMTYPE	DB2CHAR22	CHAR	22	0	The current SQL statement type being executed by the thread
166	RDIPROGN	☐	DB2DIPROGN	DB2CHAR10	CHAR	10	0	The program name (package ID or DBRM name)
167	RDISTNUM	☐	DB2DISTNUM	DB2SINT	INT2	5	0	Precompiler statement number
168	DDISTNUM	☐			INT4	10	0
169	QW0124ST	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
170	QW01242L	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
171	QW01242	☐	DB2WQ0124	DB2C4000	LCHR	4000	0	SQL TEXT
172	QW0148CI	☐			CHAR	128	0
173	QW0148ST	☐	DB2W0148ST		CHAR	2	0	Indicates the status of the conversation or socket

History

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