SAP ABAP Table DB2QSYSW1 (Table holding different DB2 IFI statistics values)

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	DB2QSYSW1	Table Relationship Diagram
Short Description	Table holding different DB2 IFI statistics values

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	instrumentation header mapping
3	QWHSLEN	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
4	QWHSTYP	☐	DB2RAW01	DB2RAW01	RAW	1	0	Field type raw, length 2, 1 byte
5	QWHSRMID	☐	DB2RAW01	DB2RAW01	RAW	1	0	Field type raw, length 2, 1 byte
6	QWHSIID	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
7	QWHSNSDA	☐	DB2RAW01	DB2RAW01	RAW	1	0	Field type raw, length 2, 1 byte
8	QWHSRN	☐	DB2RAW01	DB2RAW01	RAW	1	0	Field type raw, length 2, 1 byte
9	QWHSACE	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
10	QWHSSSID	☐	DB2CHAR04	DB2CHAR04	CHAR	4	0	Field type char, length 4
11	QWHSSC1	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
12	QWHSSC2	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
13	QWHSISEQ	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
14	QWHSWSEQ	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
15	QWHSMTN	☐	DB2BIT04	DB2CHAR04	CHAR	4	0	Field type char, length 4, bit field
16	QWHSLOCN	☐			CHAR	128	0
17	QWHSNID	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
18	QWHSLUNM	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
19	QWHSLUUV	☐	DB2BIT06	DB2CHAR06	CHAR	6	0	Field type char, length 6, bit field
20	QWHSLUCC	☐	DB2INT2AA	DB2SINT	INT2	5	0	Small integer
21	.INCLUDE	☐				0	0	accumulated statistics for SSSS and SSAM resource manager
22	Q3STIDEN	☐	DB23STIDEN	DB2INT4U	INT4	10	0	Successful connections to DB2 from an allied address space
23	Q3STSIGN	☐	DB23STSIGN	DB2INT4U	INT4	10	0	Successful signon requests to identify a new user for CICS
24	Q3STCTHD	☐	DB23STCTHD	DB2INT4U	INT4	10	0	Number of successful create thread requests
25	Q3STTERM	☐	DB23STTERM	DB2INT4U	INT4	10	0	Number of times threads were terminated successfully
26	Q3STRIUR	☐	DB23STRIUR	DB2INT4U	INT4	10	0	Number of indoubts unit of recovery successfully resolved
27	Q3STPREP	☐	DB23STPREP	DB2INT4U	INT4	10	0	Commit phase 1 requests in a two-phase environment
28	Q3STCOMM	☐	DB23STCOMM	DB2INT4U	INT4	10	0	Commit phase 2 requests in a two-phase commit environment
29	Q3STABRT	☐	DB23STABRT	DB2INT4U	INT4	10	0	Units of recovery were backed out successfully
30	Q3STSYNC	☐	DB23STSYNC	DB2INT4U	INT4	10	0	Number of commits in a single-phase environment
31	Q3STEXIT	☐	DB2INT4U	DB2INT4U	INT4	10	0	Field Type INT, Length 4
32	Q3STINDT	☐	DB23STINDT	DB2INT4U	INT4	10	0	Number of indoubts units of recovery
33	Q3STMEOT	☐	DB23STMEOT	DB2INT4U	INT4	10	0	Number of times non-DB2 tasks abended while connected to DB2
34	Q3STMEOM	☐	DB23STMEOM	DB2INT4U	INT4	10	0	Non-DB2 address space deleted by MVS while connected to DB2
35	Q3STSSSI	☐	DB2INT4U	DB2INT4U	INT4	10	0	Field Type INT, Length 4
36	Q3STCTHW	☐	DB23STCTHW	DB2INT4U	INT4	10	0	Number of create thread requests queued
37	Q3STRDON	☐	DB23STRDON	DB2INT4U	INT4	10	0	Number of read-only commits
38	.INCLUDE	☐				0	0	command statistical counters
39	Q9STCTR0	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
40	Q9STCTR1	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
41	Q9STCTR2	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
42	Q9STCTR3	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
43	Q9STCTR4	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
44	Q9STCTR5	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
45	Q9STCTR6	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
46	Q9STCTR7	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
47	Q9STCTR8	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
48	Q9STCTR9	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
49	Q9STCTRA	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
50	Q9STCTRB	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
51	Q9STCTRC	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
52	Q9STCTRD	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
53	Q9STEROR	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
54	Q9STCTRE	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
55	Q9STCTRF	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
56	Q9STCTRG	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
57	Q9STCTRH	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
58	Q9STCTRI	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
59	Q9STCTRJ	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
60	Q9STCTRK	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
61	Q9STCTRL	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
62	Q9STCTRM	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
63	Q9STCTRN	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
64	Q9STCTRO	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
65	Q9STCTRP	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
66	Q9STCTRQ	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
67	Q9STCTRR	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
68	Q9STCTRS	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
69	Q9STCTRT	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
70	Q9STCTRU	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
71	Q9STCTRV	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
72	Q9STCTRW	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
73	Q9STCTRX	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
74	Q9STCTRY	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
75	Q9STCTRZ	☐	DB29STCTRZ	DEC_10	DEC	10	0	Number of -DISPLAY FUNCTION commands
76	Q9STCTX0	☐	DB29STCTX0	DEC_10	DEC	10	0	Number of -START FUNCTION commands
77	Q9STCTX1	☐	DB29STCTX1	DEC_10	DEC	10	0	Number of -STOP FUNCTION commands
78	Q9STCTX2	☐	DB29STCTX2	DEC_10	DEC	10	0	Number of -SET LOG commands
79	Q9STCTX3	☐	DB29STCTX3	DEC_10	DEC	10	0	Number of -DISPLAY LOG commands
80	Q9STIX01	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
81	Q9STIX02	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
82	Q9STIX03	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
83	Q9STIX04	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
84	Q9STIX05	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
85	Q9STIX06	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
86	Q9STIX07	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
87	Q9STIX08	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
88	Q9STIX09	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
89	Q9STIX10	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
90	Q9STIX11	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
91	Q9STIX12	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
92	Q9STIX13	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
93	Q9STIX14	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
94	Q9STIX15	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
95	Q9STIX16	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
96	Q9STIX17	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
97	Q9STIX18	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
98	Q9STIX19	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
99	Q9STIX20	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
100	Q9STIX21	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
101	Q9STIX22	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
102	Q9STIX23	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
103	Q9STIX24	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
104	Q9STIX25	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
105	Q9STIX26	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
106	Q9STIX27	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
107	Q9STIX28	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
108	Q9STIX29	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
109	Q9STIX30	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
110	Q9STIX31	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
111	Q9STIX32	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
112	Q9STIX33	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
113	Q9STIX34	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
114	Q9STIX35	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
115	Q9STIX36	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
116	.INCLUDE	☐				0	0	instrumentation mapping for statistics information
117	QWSDCKPT	☐	DB2WSDCKPT	DB2INT4	INT4	10	0	Number of checkpoints DB2 has taken since startup
118	QWSDRINV	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
119	QWSDLR	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
120	QWSDSCA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
121	QWSDSCU	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
122	QWSDSCCO	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
123	QWSDSCRA	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
124	QWSDSCRS	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
125	QWSDSCWR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
126	QWSDCDLC	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
127	QWSDCDLR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
128	QWSDCDRR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
129	QWSDCDDR	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
130	QWSDCDDD	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
131	QWSDCDMB	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
132	QWSDCDTB	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
133	QWSDARTH	☐			DEC	16	0
134	QWSDARSG	☐			DEC	16	0
135	QWSDARST	☐			DEC	16	0
136	QWSDARIR	☐			DEC	16	0
137	.INCLUDE	☐				0	0	log manager statitics block
138	QJSTID	☐	DB2CHAR02	DB2CHAR02	CHAR	2	0	Field type char, length 2
139	QJSTLL	☐	DB2SINT	DB2INT2V	INT2	5	0	Small integer (2 bytes)
140	QJSTEID	☐	DB2CHAR04	DB2CHAR04	CHAR	4	0	Field type char, length 4
141	QJSTWRW	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
142	QJSTWRNW	☐	DB2JSTWRNW	DB2INT4	INT4	10	0	Number of Write-No-Wait Requests
143	QJSTWRNWD	☐	DB2JSTWRNWD	DB2DEC10V	DEC	10	0	Number of Write-No-Wait Requests
144	QJSTWRF	☐	DB2INT4	DB2INT4	INT4	10	0	Field Type INT, Length 4
145	QJSTWTB	☐	DB2JSTWTB	DB2INT4	INT4	10	0	Unavailable output log buffers
146	QJSTRBUF	☐	DB2JSTRBUF	DB2INT4	INT4	10	0	Number of Log Reads Satisfied from Output Buffer
147	QJSTRACT	☐	DB2JSTRACT	DB2INT4	INT4	10	0	Number of Log Reads Satisfied from Active Log Data Set
148	QJSTRARH	☐	DB2JSTRARH	DB2INT4	INT4	10	0	Number of Log Reads Satisfied from Archive Log Data Set
149	QJSTTVC	☐	DB2JSTTVC	DB2INT4	INT4	10	0	Read accesses delayed due to tape volume contention
150	QJSTBSDS	☐	DB2JSTBSDS	DB2INT4	INT4	10	0	Number of BSDS Access Requests
151	QJSTBFFL	☐	DB2JSTBFFL	DB2INT4	INT4	10	0	Number of Active Log Output Control Intervals Created
152	QJSTBFWR	☐	DB2JSTBFWR	DB2INT4	INT4	10	0	Number of calls to the log write routine
153	QJSTALR	☐	DB2JSTALR	DB2INT4	INT4	10	0	Number of archive log read allocations
154	QJSTALW	☐	DB2JSTALW	DB2INT4	INT4	10	0	Number of archive log write allocations
155	QJSTCIOF	☐	DB2JSTCIOF	DB2INT4	INT4	10	0	Count of Control Intervals Offloaded
156	QJSTWUR	☐	DB2JSTWUR	DB2INT4	INT4	10	0	Read accesses delayed due to unavailable resource
157	QJSTLAMA	☐	DB2JSTLAMA	DB2INT4	INT4	10	0	Check Tape Mounts Attempted
158	QJSTLAMS	☐	DB2JSTLAMS	DB2INT4	INT4	10	0	Successful "look ahead" (tape volume) mounts attempted
159	.INCLUDE	☐				0	0	DB2/390: Statistics Global Locking
160	QTGSLPLK	☐	DB2TGSLPLK	DB2DEC10V	DEC	10	0	Number of lock requests for P-locks
161	QTGSUPLK	☐	DB2TGSUPLK	DB2DEC10V	DEC	10	0	Number of unlock requests for P-locks
162	QTGSCPLK	☐	DB2TGSCPLK	DB2DEC10V	DEC	10	0	Number of Change Requests for P-Locks
163	QTGSLSLM	☐	DB2TGSLSLM	DB2DEC10V	DEC	10	0	Number of lock requests propagated to MVS XES synchronously
164	QTGSUSLM	☐	DB2TGSUSLM	DB2DEC10V	DEC	10	0	Number of IRLM unlock requests propagated to MVS XES synch.
165	QTGSIGLO	☐	DB2TGSIGLO	DB2DEC10V	DEC	10	0	Number of suspends caused by IRLM global resource contention
166	QTGSSGLO	☐	DB2TGSSGLO	DB2DEC10V	DEC	10	0	Suspends caused by MVS XES global resource contention
167	QTGSFLSE	☐	DB2TGSFLSE	DB2DEC10V	DEC	10	0	Number of suspends because of false contentions
168	QTGSDRTA	☐	DB2TGSDRTA	DB2DEC10V	DEC	10	0	Incompatible retained lock
169	QTGSNTFY	☐	DB2TGSNTFY	DB2DEC10V	DEC	10	0	Number of Notification Messages Sent to Other Members
170	QTGSNTFR	☐	DB2TGSNTFR	DB2DEC10V	DEC	10	0	Number of Notification Messages Received from Other Members
171	QTGSKIDS	☐	DB2TGSKIDS	DB2DEC10V	DEC	10	0	Number of resources propagated by IRLM to MVS XES async.
172	QTGSPPPE	☐	DB2TGSPPPE	DB2DEC10V	DEC	10	0	Page Set/Partition P-Lock Negotiation
173	QTGSPGPE	☐	DB2TGSPGPE	DB2DEC10V	DEC	10	0	Page P-Lock Negotiation
174	QTGSOTPE	☐	DB2TGSOTPE	DB2DEC10V	DEC	10	0	Other P-Lock Negotiation
175	QTGSCHNP	☐	DB2TGSCHNP	DB2DEC10V	DEC	10	0	P-Lock Change Request During P-Lock Negotiation
176	QTGSPEMX	☐	DB2TGSPEMX	DB2DEC10V	DEC	10	0	Maximum Engines for P-Lock/Notify Exits
177	QTGSPEQW	☐	DB2TGSPEQW	DB2DEC10V	DEC	10	0	Engines Unavailable for P-Lock/Notify Exits
178	QTGSCSLM	☐	DB2TGSCSLM	DB2DEC10V	DEC	10	0	No. of Change Requests Propagated to MVS XES Synchronously
179	QTGSFLMG	☐	DB2TGSFLMG	DB2DEC10V	DEC	10	0	False contention on z/OS image

History

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