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