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 |