Table/Structure Field list used by SAP ABAP Program RSDB3002 (Summary for System-Wide data)
SAP ABAP Program RSDB3002 (Summary for System-Wide data) is using
# Object Type Object Name Object Description Note
     
1 Table/Structure Field  DB2Q3ST - Q3STABRT Units of recovery were backed out successfully
2 Table/Structure Field  DB2Q3ST - Q3STCOMM Commit phase 2 requests in a two-phase commit environment
3 Table/Structure Field  DB2Q3ST - Q3STCTHD Number of successful create thread requests
4 Table/Structure Field  DB2Q3ST - Q3STCTHW Number of create thread requests queued
5 Table/Structure Field  DB2Q3ST - Q3STIDEN Successful connections to DB2 from an allied address space
6 Table/Structure Field  DB2Q3ST - Q3STINDT Number of indoubts units of recovery
7 Table/Structure Field  DB2Q3ST - Q3STMEOM Non-DB2 address space deleted by MVS while connected to DB2
8 Table/Structure Field  DB2Q3ST - Q3STMEOT Number of times non-DB2 tasks abended while connected to DB2
9 Table/Structure Field  DB2Q3ST - Q3STPREP Commit phase 1 requests in a two-phase environment
10 Table/Structure Field  DB2Q3ST - Q3STRDON Number of read-only commits
11 Table/Structure Field  DB2Q3ST - Q3STRIUR Number of indoubts unit of recovery successfully resolved
12 Table/Structure Field  DB2Q3ST - Q3STSIGN Successful signon requests to identify a new user for CICS
13 Table/Structure Field  DB2Q3ST - Q3STSYNC Number of commits in a single-phase environment
14 Table/Structure Field  DB2Q3ST - Q3STTERM Number of times threads were terminated successfully
15 Table/Structure Field  DB2Q9ST - Q9STCTR6 Field Type DEC, Length 10
16 Table/Structure Field  DB2Q9ST - Q9STCTRN Field Type DEC, Length 10
17 Table/Structure Field  DB2Q9ST - Q9STCTRS Field Type DEC, Length 10
18 Table/Structure Field  DB2QBST - QBSTBPNM DB2 buffer pool name
19 Table/Structure Field  DB2QBST - QBSTCBA Number of currently active (non-stealable) buffers
20 Table/Structure Field  DB2QBST - QBSTDIO Number of dynamic prefetch reads
21 Table/Structure Field  DB2QBST - QBSTDMC Number of times the data manager threshold was reached
22 Table/Structure Field  DB2QBST - QBSTDPF Number of dynamic prefetch requests
23 Table/Structure Field  DB2QBST - QBSTDPP Number of pages read via dynamic prefetch read I/O
24 Table/Structure Field  DB2QBST - QBSTDSO Number of datasets successfully opened physically
25 Table/Structure Field  DB2QBST - QBSTDWT Number of times the deferred write threshold was reached
26 Table/Structure Field  DB2QBST - QBSTDWV Number of times vertical deferred write threshold is reached
27 Table/Structure Field  DB2QBST - QBSTGET Number of get page requests (conditional and unconditional)
28 Table/Structure Field  DB2QBST - QBSTHITR Buffer hit ratio
29 Table/Structure Field  DB2QBST - QBSTIMW Number of immediate writes
30 Table/Structure Field  DB2QBST - QBSTJIS Total number of denied concurrent prefetch I/O streams
31 Table/Structure Field  DB2QBST - QBSTLIO Number of list prefetch reads
32 Table/Structure Field  DB2QBST - QBSTLPF Number of list prefetch requests
33 Table/Structure Field  DB2QBST - QBSTLPP Number of pages read via list prefetch
34 Table/Structure Field  DB2QBST - QBSTMAX Number of times a work file could not be opened
35 Table/Structure Field  DB2QBST - QBSTMIG Number of times migrated datasets were encountered
36 Table/Structure Field  DB2QBST - QBSTPIO Number of sequential prefetch reads
37 Table/Structure Field  DB2QBST - QBSTPL1 Prefetch quantity is reduced from normal to 50%
38 Table/Structure Field  DB2QBST - QBSTPL2 Number of occurrences of prefetch quantity reduced 1/4
39 Table/Structure Field  DB2QBST - QBSTPQF The parallel query went into reduced or degenerated mode
40 Table/Structure Field  DB2QBST - QBSTPQO Total no. of requests for parallel query support
41 Table/Structure Field  DB2QBST - QBSTPWS Number of pages written
42 Table/Structure Field  DB2QBST - QBSTREE Sequential prefetch disabled - unavailable read engine
43 Table/Structure Field  DB2QBST - QBSTRIO Number of synchronous read I/O operations
44 Table/Structure Field  DB2QBST - QBSTRPI Number of page inserts required for read I/O
45 Table/Structure Field  DB2QBST - QBSTRTO Number of recall timeouts
46 Table/Structure Field  DB2QBST - QBSTSEQ Number of sequential prefetch requests
47 Table/Structure Field  DB2QBST - QBSTSGT Number of get page requests issued by sequential access req.
48 Table/Structure Field  DB2QBST - QBSTSIO Synchronous read requests issued by sequential access req.
49 Table/Structure Field  DB2QBST - QBSTSPD Sequential prefetch disabled - no buffers available
50 Table/Structure Field  DB2QBST - QBSTSPP Number of pages read because of normal sequential prefetch
51 Table/Structure Field  DB2QBST - QBSTSWS Update intents against pages in the buffer pool
52 Table/Structure Field  DB2QBST - QBSTVPA Number of successful virtual buffer pool expans./contract.
53 Table/Structure Field  DB2QBST - QBSTVPL Number of buffers allocated for virtual buffer pool
54 Table/Structure Field  DB2QBST - QBSTWBVQ Number of Pages Removed from the DWQ for Destructive Read
55 Table/Structure Field  DB2QBST - QBSTWDRP Number of pages for which destructive read was requested
56 Table/Structure Field  DB2QBST - QBSTWEE A write engine is unavailable for asynchronous write I/O
57 Table/Structure Field  DB2QBST - QBSTWFD Work file requests were rejected due to buffer pool shortage
58 Table/Structure Field  DB2QBST - QBSTWFF Number of times a merge pass could not be performed
59 Table/Structure Field  DB2QBST - QBSTWFM Maximum number of work files concurrently used
60 Table/Structure Field  DB2QBST - QBSTWFR Number of merge passes requested for DB2 sort activities
61 Table/Structure Field  DB2QBST - QBSTWFT Number of merge passes requested for DB2 sort activities
62 Table/Structure Field  DB2QBST - QBSTWIO Number of asynchronous writes
63 Table/Structure Field  DB2QBST - QBSTWKPD Number of work prefetches not scheduled due to zero prefetch
64 Table/Structure Field  DB2QBST - QBSTWPI Number of page inserts required for write I/O
65 Table/Structure Field  DB2QBST - QBSTXFL Number of times the virtual buffer pool was full
66 Table/Structure Field  DB2QBST - QBSTXFV Total number of virtual buffer pool or hiperpool failures
67 Table/Structure Field  DB2QBST - QBSTXIS Highest number of concurrent prefetch I/O streams
68 Table/Structure Field  DB2QISE - QISECT Current number of pages in EDM pool used for cursor tables
69 Table/Structure Field  DB2QISE - QISECTG Number of requests for cursor table sections
70 Table/Structure Field  DB2QISE - QISECTL Number of CT sections not found in EDM pool
71 Table/Structure Field  DB2QISE - QISEDBD Current number of pages in EDM pool used for DB descriptor
72 Table/Structure Field  DB2QISE - QISEDBDG Number of requests for database descriptor
73 Table/Structure Field  DB2QISE - QISEDBDL Number of DB descriptors not found in EDM pool
74 Table/Structure Field  DB2QISE - QISEDSC Number of pages used for DSC
75 Table/Structure Field  DB2QISE - QISEFAIL Field type numc, length 10, integer
76 Table/Structure Field  DB2QISE - QISEFREE Current number of free pages in the free chain
77 Table/Structure Field  DB2QISE - QISEKT Current number of pages in EDM pool used for package tables
78 Table/Structure Field  DB2QISE - QISEKTG Number of requests for package table sections
79 Table/Structure Field  DB2QISE - QISEKTL Number of times a PT section was not found in EDM pool
80 Table/Structure Field  DB2QISE - QISEPAGE Current number of pages in the EDM pool
81 Table/Structure Field  DB2QISE - QISESKCT Current number of pages in EDM pool used for skeleton CT
82 Table/Structure Field  DB2QISE - QISESKPT Current number of pages in EDM pool used for skeleton PT
83 Table/Structure Field  DB2QIST - QISTRLLM RDS limit exceeded
84 Table/Structure Field  DB2QIST - QISTRMAX Process limit exceeded
85 Table/Structure Field  DB2QIST - QISTRPLM Physical limit reached
86 Table/Structure Field  DB2QIST - QISTRSTG RID list processing exhausted virtual storage
87 Table/Structure Field  DB2QJST - QJSTALR Number of archive log read allocations
88 Table/Structure Field  DB2QJST - QJSTBFFL Number of Active Log Output Control Intervals Created
89 Table/Structure Field  DB2QJST - QJSTBFWR Number of calls to the log write routine
90 Table/Structure Field  DB2QJST - QJSTBSDS Number of BSDS Access Requests
91 Table/Structure Field  DB2QJST - QJSTCIOF Count of Control Intervals Offloaded
92 Table/Structure Field  DB2QJST - QJSTLAMA Check Tape Mounts Attempted
93 Table/Structure Field  DB2QJST - QJSTLAMS Successful "look ahead" (tape volume) mounts attempted
94 Table/Structure Field  DB2QJST - QJSTRACT Number of Log Reads Satisfied from Active Log Data Set
95 Table/Structure Field  DB2QJST - QJSTRARH Number of Log Reads Satisfied from Archive Log Data Set
96 Table/Structure Field  DB2QJST - QJSTRBUF Number of Log Reads Satisfied from Output Buffer
97 Table/Structure Field  DB2QJST - QJSTTVC Read accesses delayed due to tape volume contention
98 Table/Structure Field  DB2QJST - QJSTWRNWD Number of Write-No-Wait Requests
99 Table/Structure Field  DB2QJST - QJSTWTB Unavailable output log buffers
100 Table/Structure Field  DB2QJST - QJSTWUR Read accesses delayed due to unavailable resource
101 Table/Structure Field  DB2QTST - QTDSDRN Number of datasets that were closed via the DRAIN process
102 Table/Structure Field  DB2QTST - QTDSOPN Number of datasets open concurrently
103 Table/Structure Field  DB2QTST - QTMAXDS Max. no. of datasets open concurrently
104 Table/Structure Field  DB2QTST - QTMAXPB Page sets available to drain since last statistics interval
105 Table/Structure Field  DB2QTST - QTPCCT No. of infrequently updated datasets conv. from R/W to R/O
106 Table/Structure Field  DB2QTST - QTSLWDD Datasets not used, but not closed due to deferred close
107 Table/Structure Field  DB2QTXA - QTXACHG Number of change requests
108 Table/Structure Field  DB2QTXA - QTXACLNO Number of claim requests
109 Table/Structure Field  DB2QTXA - QTXACLUN Number of claim requests that were unsuccessful
110 Table/Structure Field  DB2QTXA - QTXADEA Number of deadlocks
111 Table/Structure Field  DB2QTXA - QTXADRNO Number of drain requests
112 Table/Structure Field  DB2QTXA - QTXADRUN Number of drain requests that were unsuccessful
113 Table/Structure Field  DB2QTXA - QTXAIRLM Number of other requests
114 Table/Structure Field  DB2QTXA - QTXALES Number of lock escalations (shared)
115 Table/Structure Field  DB2QTXA - QTXALEX Number of lock escalations (exclusive)
116 Table/Structure Field  DB2QTXA - QTXALOCK Number of lock requests
117 Table/Structure Field  DB2QTXA - QTXAQRY Number of query requests
118 Table/Structure Field  DB2QTXA - QTXASLAT Number of latch suspensions
119 Table/Structure Field  DB2QTXA - QTXASLOC Number of lock suspensions
120 Table/Structure Field  DB2QTXA - QTXASOTH Number of other suspensions
121 Table/Structure Field  DB2QTXA - QTXATIM Number of timeouts
122 Table/Structure Field  DB2QTXA - QTXAUNLK Number of unlock requests
123 Table/Structure Field  DB2QWHS - QWHSSSID Field type char, length 4
124 Table/Structure Field  DB2QWP4 - QWP4DSMX Field Type INT, Length 4
125 Table/Structure Field  DB2QXST - GHITRATIO Dynamic Statement Cache Global Hit Ratio
126 Table/Structure Field  DB2QXST - LHITRATIO Dynamic Statement Cache Local Hit Ratio
127 Table/Structure Field  DB2QXST - QXALDAB Number of ALTER DATABASE statements executed
128 Table/Structure Field  DB2QXST - QXALTIX Number of ALTER INDEX statements executed
129 Table/Structure Field  DB2QXST - QXALTST Number of ALTER STORAGE GROUP statements executed
130 Table/Structure Field  DB2QXST - QXALTTA Number of ALTER TABLE statements executed
131 Table/Structure Field  DB2QXST - QXALTTS Number of ALTER TABLE SPACE statements executed
132 Table/Structure Field  DB2QXST - QXCALL Number of SQL CALL statements executed
133 Table/Structure Field  DB2QXST - QXCLOSE Number of CLOSE CURSOR statements executed
134 Table/Structure Field  DB2QXST - QXCMTON Number of COMMENT ON statements executed
135 Table/Structure Field  DB2QXST - QXCON1 Number of CONNECT TYPE 1 statements executed
136 Table/Structure Field  DB2QXST - QXCON2 Number of CONNECT TYPE 2 statements executed
137 Table/Structure Field  DB2QXST - QXCRALS Number of CREATE ALIAS statements executed
138 Table/Structure Field  DB2QXST - QXCRDAB Number of CREATE DATABASE statements executed
139 Table/Structure Field  DB2QXST - QXCRINX Number of CREATE INDEX statements executed
140 Table/Structure Field  DB2QXST - QXCRSTG Number of CREATE STORAGE GROUP statements executed
141 Table/Structure Field  DB2QXST - QXCRSYN Number of CREATE SYNONYM statements executed
142 Table/Structure Field  DB2QXST - QXCRTAB Number of CREATE TABLE statements executed
143 Table/Structure Field  DB2QXST - QXCTABS Number of CREATE TABLE SPACE statements executed
144 Table/Structure Field  DB2QXST - QXDEFVU Number of CREATE VIEW statements executed
145 Table/Structure Field  DB2QXST - QXDEGBUF Parallel groups fell to sequential due to storage shortage
146 Table/Structure Field  DB2QXST - QXDEGCUR Parallel groups fell to sequential due to updatable cursor
147 Table/Structure Field  DB2QXST - QXDEGENC Par.groups fell to sequ. due to unavailable enclave services
148 Table/Structure Field  DB2QXST - QXDEGESA Par. groups fell to sequ. due to lack of ESA sort support
149 Table/Structure Field  DB2QXST - QXDELET Number of DELETE statements executed
150 Table/Structure Field  DB2QXST - QXDESC Number of DESCRIBE statements executed
151 Table/Structure Field  DB2QXST - QXDRPAL Number of DROP ALIAS statements executed
152 Table/Structure Field  DB2QXST - QXDRPDB Number of DROP DATABASE statements executed
153 Table/Structure Field  DB2QXST - QXDRPIX Number of DROP INDEX statements executed
154 Table/Structure Field  DB2QXST - QXDRPPKG Number of DROP PACKAGE statements executed
155 Table/Structure Field  DB2QXST - QXDRPST Number of DROP STORAGE GROUP statements executed
156 Table/Structure Field  DB2QXST - QXDRPSY Number of DROP SYNONYM statements executed
157 Table/Structure Field  DB2QXST - QXDRPTA Number of DROP TABLE statements executed
158 Table/Structure Field  DB2QXST - QXDRPTS Number of DROP TABLE SPACE statements executed
159 Table/Structure Field  DB2QXST - QXDRPVU Number of DROP VIEW statements executed
160 Table/Structure Field  DB2QXST - QXDSCRTB Number of DESCRIBE TABLE statements executed
161 Table/Structure Field  DB2QXST - QXFETCH Number of FETCH statements executed
162 Table/Structure Field  DB2QXST - QXGRANT Number of GRANT statements executed
163 Table/Structure Field  DB2QXST - QXINCRB Number of INCREMENTAL BINDs executed
164 Table/Structure Field  DB2QXST - QXINSRT Number of INSERT statements executed
165 Table/Structure Field  DB2QXST - QXLABON Number of LABEL ON statements executed
166 Table/Structure Field  DB2QXST - QXLOCK Number of LOCK TABLE statements executed
167 Table/Structure Field  DB2QXST - QXOPEN Number of OPEN CURSOR statements executed
168 Table/Structure Field  DB2QXST - QXPREP Number of PREPARE statements executed
169 Table/Structure Field  DB2QXST - QXREDGRP Parallel groups: executed with reduced degree
170 Table/Structure Field  DB2QXST - QXREL Number of RELEASE statements executed
171 Table/Structure Field  DB2QXST - QXREVOK Number of REVOKE statements executed
172 Table/Structure Field  DB2QXST - QXSELECT Number of SELECT statements executed
173 Table/Structure Field  DB2QXST - QXSETCDG Number of SET CURRENT DEGREE statements executed
174 Table/Structure Field  DB2QXST - QXSETCON Number of SET CONNECTION statements executed
175 Table/Structure Field  DB2QXST - QXSETCRL Number of SET CURRENT RULES statements executed
176 Table/Structure Field  DB2QXST - QXSETHV Number of SET HOST VARIABLE statements executed
177 Table/Structure Field  DB2QXST - QXSETSQL Number of SET CURRENT SQLID statements executed
178 Table/Structure Field  DB2QXST - QXSTDEXP MAXKEEPD parameter exceeded
179 Table/Structure Field  DB2QXST - QXSTDINV Statement invalidated
180 Table/Structure Field  DB2QXST - QXSTFND Number of Times that DB2 Found the Statement in the Cache
181 Table/Structure Field  DB2QXST - QXSTIPRP Number of implicit prepares
182 Table/Structure Field  DB2QXST - QXSTNFND Number of times statement could not be found in cache
183 Table/Structure Field  DB2QXST - QXSTNPRP Number of avoided prepares
184 Table/Structure Field  DB2QXST - QXUPDTE Number of UPDATE statements executed
185 Table/Structure Field  DB2SUSCRN - RESTIME Time of last reset
186 Table/Structure Field  DB2SUSCRN - SAMPDATE Date when sampling is taken
187 Table/Structure Field  DB2SUSCRN - SAMPMODUS DB2 sample mode
188 Table/Structure Field  DB2SUSCRN - SAMPTIME Time when sampling is taken
189 Table/Structure Field  DB2SWPARM - BPACTPG Maximum active pages across all the active buffer pools
190 Table/Structure Field  DB2SWPARM - BPACTPGNM Buffer pool with maximum active pages
191 Table/Structure Field  DB2SWPARM - BPHITRAT Random hit ratio
192 Table/Structure Field  DB2SWPARM - BPHITRATNM Buffer pool which has the minimum hit ratio
193 Table/Structure Field  DB2SWPARM - BPHPCONC Hiper pool concerns for any of the active buffer pools
194 Table/Structure Field  DB2SWPARM - BPSHORT Buffer pool shortage in any of the active buffer pools
195 Table/Structure Field  DB2SWPARM - BPSHORTNM Buffer pool which has a buffer pool shortage
196 Table/Structure Field  DB2SWPARM - EPCTREQ (CT requests - CT not in EDM pool) / CT requests
197 Table/Structure Field  DB2SWPARM - EPDBDREQ (DBD requests - DBD not in EDM pool) / DBD requests
198 Table/Structure Field  DB2SWPARM - EPFULL Total number of failures due to EDM pool being full
199 Table/Structure Field  DB2SWPARM - EPPGINUSE Percentage of EDM pool pages currently in use
200 Table/Structure Field  DB2SWPARM - EPPTREQ (PT requests - PT not in EDM pool) / PT requests
201 Table/Structure Field  DB2SWPARM - HDSUBSYSID DB2 subsystem ID
202 Table/Structure Field  DB2SWPARM - LGBUFWRACT Output log buffer writes per active log control interval
203 Table/Structure Field  DB2SWPARM - LGLOGWRAT Number of bytes in KB written for active log per sec
204 Table/Structure Field  DB2SWPARM - MCALTERCMD Alter Bufferpool/Alter Group Bufferpool commands are issued
205 Table/Structure Field  DB2SWPARM - MCPARALRED Degree of parallelism lower than planned
206 Table/Structure Field  DB2SWPARM - MCRIDLIST Any of the RID list limits is reached
207 Table/Structure Field  DB2SWPARM - MCSTARTTRC Start Trace command was issued
208 Table/Structure Field  DB2SWPARM - OCCUROPEDS Percentage of currently open datasets
209 Table/Structure Field  DB2SWPARM - OCDEFCLOSE Datasets closed because deferred close threshold is reached
210 Table/Structure Field  DB2SWPARM - OCDSINUSE Number of datasets currently in use
211 Table/Structure Field  DB2SWPARM - SSCHECKPNT No. of checkpoints
212 Table/Structure Field  SYST - UCOMM ABAP System Field: PAI-Triggering Function Code
213 Table/Structure Field  SYST - VLINE ABAP System Field: Vertical Line for List