Data Element list used by SAP ABAP Table DB2QSYSW2 (DB2 statistics (part 2))
SAP ABAP Table 
DB2QSYSW2 (DB2 statistics (part 2)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2BIT01 | Field type char, length 1, bit field | |
| 2 | Data Element |
DB2CHAR02 | Field type char, length 2 | |
| 3 | Data Element |
DB2CHAR04 | Field type char, length 4 | |
| 4 | Data Element |
DB2DEC10 | Field Type DEC, Length 10 | |
| 5 | Data Element |
DB2DEC10 | Field Type DEC, Length 10 | |
| 6 | Data Element |
DB2DEC10 | Field Type DEC, Length 10 | |
| 7 | Data Element |
DB2DEC10 | Field Type DEC, Length 10 | |
| 8 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 9 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 10 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 11 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 12 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 13 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 14 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 15 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 16 | Data Element |
DB2DEC10V | Field Type DEC, Length 10 | |
| 17 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 18 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 19 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 20 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 21 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 22 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 23 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 24 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 25 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 26 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 27 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 28 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 29 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 30 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 31 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 32 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 33 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 34 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 35 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 36 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 37 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 38 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 39 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 40 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 41 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 42 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 43 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 44 | Data Element |
DB2FULLP | Total number of prepares: full prepares + short prepares | |
| 45 | Data Element |
DB2GHITRAT | Dynamic Statement Cache Global Hit Ratio | |
| 46 | Data Element |
DB2INT2AA | Small integer | |
| 47 | Data Element |
DB2INT2AA | Small integer | |
| 48 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 49 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 50 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 51 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 52 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 53 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 54 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 55 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 56 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 57 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 58 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 59 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 60 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 61 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 62 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 63 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 64 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 65 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 66 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 67 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 68 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 69 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 70 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 71 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 72 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 73 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 74 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 75 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 76 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 77 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 78 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 79 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 80 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 81 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 82 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 83 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 84 | Data Element |
DB2INT4 | Field Type INT, Length 4 | |
| 85 | Data Element |
DB2ISECFRE | Number of free pages in EDM statement pool | |
| 86 | Data Element |
DB2ISECPGE | Number of pages in EDM statement pool | |
| 87 | Data Element |
DB2ISECT | Current number of pages in EDM pool used for cursor tables | |
| 88 | Data Element |
DB2ISECTG | Number of requests for cursor table sections | |
| 89 | Data Element |
DB2ISECTL | Number of CT sections not found in EDM pool | |
| 90 | Data Element |
DB2ISEDBD | Current number of pages in EDM pool used for DB descriptor | |
| 91 | Data Element |
DB2ISEDBDG | Number of requests for database descriptor | |
| 92 | Data Element |
DB2ISEDBDL | Number of DB descriptors not found in EDM pool | |
| 93 | Data Element |
DB2ISEDFAL | Number of failures because the data space is full | |
| 94 | Data Element |
DB2ISEDFRE | Number of free pages in the data space free chain | |
| 95 | Data Element |
DB2ISEDPGE | Number of pages in the data space used by the EDM pool | |
| 96 | Data Element |
DB2ISEDSC | Number of pages used for DSC | |
| 97 | Data Element |
DB2ISEDSG | Number of requests for DSC sections | |
| 98 | Data Element |
DB2ISEDSI | Number of inserts into EDM pool for dynamic statement cache | |
| 99 | Data Element |
DB2ISEFREE | Current number of free pages in the free chain | |
| 100 | Data Element |
DB2ISEKT | Current number of pages in EDM pool used for package tables | |
| 101 | Data Element |
DB2ISEKTG | Number of requests for package table sections | |
| 102 | Data Element |
DB2ISEKTL | Number of times a PT section was not found in EDM pool | |
| 103 | Data Element |
DB2ISEPAGE | Current number of pages in the EDM pool | |
| 104 | Data Element |
DB2ISESKCT | Current number of pages in EDM pool used for skeleton CT | |
| 105 | Data Element |
DB2ISESKPT | Current number of pages in EDM pool used for skeleton PT | |
| 106 | Data Element |
DB2ISESTMT | Number of statements in EDM pool for dynamic statement cache | |
| 107 | Data Element |
DB2ISTRCUR | RID block allocated - current | |
| 108 | Data Element |
DB2ISTRHIG | RID blocks allocated - maximum | |
| 109 | Data Element |
DB2ISTRLLM | RDS limit exceeded | |
| 110 | Data Element |
DB2ISTRMAX | Process limit exceeded | |
| 111 | Data Element |
DB2ISTRPLM | Physical limit reached | |
| 112 | Data Element |
DB2ISTRSTG | RID list processing exhausted virtual storage | |
| 113 | Data Element |
DB2LHITRAT | Dynamic Statement Cache Local Hit Ratio | |
| 114 | Data Element |
DB2MEMN | DB2 member name in data sharing environment | |
| 115 | Data Element |
DB2NUMC10 | Field type numc, length 10, integer | |
| 116 | Data Element |
DB2PREPR | Number of Prepare Requests | |
| 117 | Data Element |
DB2RACNAC | Number of failures in adding an entry to authorization cache | |
| 118 | Data Element |
DB2RACOW1 | Number of authorization ID overrides in authorization cache | |
| 119 | Data Element |
DB2RACOW2 | Number of routine entry overrides in authorization cache | |
| 120 | Data Element |
DB2RACPUB | Number of successful public authorization checks | |
| 121 | Data Element |
DB2RANOT | Number of authorization checks without authorization cache | |
| 122 | Data Element |
DB2RES01 | Field type char, length 1, reserved | |
| 123 | Data Element |
DB2RES03 | Field type char, length 3, reserved | |
| 124 | Data Element |
DB2RES04 | Field type char, length 4, reserved | |
| 125 | Data Element |
DB2RPRERAT | Reprepare Ratio | |
| 126 | Data Element |
DB2SHPREP | Number of Short Prepares | |
| 127 | Data Element |
DB2TDSDRN | Number of datasets that were closed via the DRAIN process | |
| 128 | Data Element |
DB2TDSOPN | Number of datasets open concurrently | |
| 129 | Data Element |
DB2TMAXDS | Max. no. of datasets open concurrently | |
| 130 | Data Element |
DB2TMAXPB | Page sets available to drain since last statistics interval | |
| 131 | Data Element |
DB2TPCCT | No. of infrequently updated datasets conv. from R/W to R/O | |
| 132 | Data Element |
DB2TRACAUT | Number of successful authorization checks | |
| 133 | Data Element |
DB2TREOPN | Number of times a previously unused dataset was used | |
| 134 | Data Element |
DB2TSLWDD | Datasets not used, but not closed due to deferred close | |
| 135 | Data Element |
DB2TXACHG | Number of change requests | |
| 136 | Data Element |
DB2TXACHUS | Highest amt CPU 16 microsec used in successful DB2 call | |
| 137 | Data Element |
DB2TXACLMT | Limit in CPU 16 microseconds | |
| 138 | Data Element |
DB2TXACLNO | Number of claim requests | |
| 139 | Data Element |
DB2TXACLUN | Number of claim requests that were unsuccessful | |
| 140 | Data Element |
DB2TXADEA | Number of deadlocks | |
| 141 | Data Element |
DB2TXADRNO | Number of drain requests | |
| 142 | Data Element |
DB2TXADRUN | Number of drain requests that were unsuccessful | |
| 143 | Data Element |
DB2TXAIRLM | Number of other requests | |
| 144 | Data Element |
DB2TXALES | Number of lock escalations (shared) | |
| 145 | Data Element |
DB2TXALEX | Number of lock escalations (exclusive) | |
| 146 | Data Element |
DB2TXALOCK | Number of lock requests | |
| 147 | Data Element |
DB2TXALOCKD | Number of lock requests | |
| 148 | Data Element |
DB2TXANLP | Maximum page or row locks held | |
| 149 | Data Element |
DB2TXAPREC | Precedence How Limit determined | |
| 150 | Data Element |
DB2TXAQRY | Number of query requests | |
| 151 | Data Element |
DB2TXASLAT | Number of latch suspensions | |
| 152 | Data Element |
DB2TXASLMT | Limit in SU's - ASUTIME Column | |
| 153 | Data Element |
DB2TXASLOC | Number of lock suspensions | |
| 154 | Data Element |
DB2TXASOTH | Number of other suspensions | |
| 155 | Data Element |
DB2TXATIM | Number of timeouts | |
| 156 | Data Element |
DB2TXAUNLK | Number of unlock requests | |
| 157 | Data Element |
DB2TXAUNLKD | Number of unlock requests | |
| 158 | Data Element |
DB2XALDAB | Number of ALTER DATABASE statements executed | |
| 159 | Data Element |
DB2XALOCC | # of ALLOCATE CURSOR statements executed | |
| 160 | Data Element |
DB2XALOCL | # of ASSOCIATE LOCATOR statements executed | |
| 161 | Data Element |
DB2XALPRO | Number of ALTER PROCEDURE statements | |
| 162 | Data Element |
DB2XALTCTX | alter trusted context | |
| 163 | Data Element |
DB2XALTIX | Number of ALTER INDEX statements executed | |
| 164 | Data Element |
DB2XALTJR | alter jar | |
| 165 | Data Element |
DB2XALTST | Number of ALTER STORAGE GROUP statements executed | |
| 166 | Data Element |
DB2XALTTA | Number of ALTER TABLE statements executed | |
| 167 | Data Element |
DB2XALTTS | Number of ALTER TABLE SPACE statements executed | |
| 168 | Data Element |
DB2XALUDF | Number of ALTER FUNCTION statements | |
| 169 | Data Element |
DB2XCALL | Number of SQL CALL statements executed | |
| 170 | Data Element |
DB2XCALLAB | # of times a stored procedure ABENDed | |
| 171 | Data Element |
DB2XCALLRJ | # of times an SQL CALL statement was rejected | |
| 172 | Data Element |
DB2XCALLTO | # of times an SQL CALL stmt timedout waiting to be scheduled | |
| 173 | Data Element |
DB2XCASCDP | Maximum level of nested SQL cascading | |
| 174 | Data Element |
DB2XCAUD | Number of user-defined functions executed | |
| 175 | Data Element |
DB2XCAUDAB | Number of times a user-defined function abended | |
| 176 | Data Element |
DB2XCAUDRJ | Number of times a user-defined function was rejected | |
| 177 | Data Element |
DB2XCAUDTO | No. of times a user-defined funct. timed out before sched. | |
| 178 | Data Element |
DB2XCDIST | Number of CREATE DISTINCT TYPE statements | |
| 179 | Data Element |
DB2XCLOSE | Number of CLOSE CURSOR statements executed | |
| 180 | Data Element |
DB2XCMTON | Number of COMMENT ON statements executed | |
| 181 | Data Element |
DB2XCON1 | Number of CONNECT TYPE 1 statements executed | |
| 182 | Data Element |
DB2XCON2 | Number of CONNECT TYPE 2 statements executed | |
| 183 | Data Element |
DB2XCOORNO | COORDINATOR setting mismatch | |
| 184 | Data Element |
DB2XCRALS | Number of CREATE ALIAS statements executed | |
| 185 | Data Element |
DB2XCRATB | Number of CREATE AUXILIARY TABLE statements | |
| 186 | Data Element |
DB2XCRCTX | create trusted context | |
| 187 | Data Element |
DB2XCRDAB | Number of CREATE DATABASE statements executed | |
| 188 | Data Element |
DB2XCRGTT | # OF CREATE GLBL TEMP TABLE | |
| 189 | Data Element |
DB2XCRINX | Number of CREATE INDEX statements executed | |
| 190 | Data Element |
DB2XCRPRO | Number of CREATE PROCEDURE statements | |
| 191 | Data Element |
DB2XCRROL | create role | |
| 192 | Data Element |
DB2XCRSTG | Number of CREATE STORAGE GROUP statements executed | |
| 193 | Data Element |
DB2XCRSYN | Number of CREATE SYNONYM statements executed | |
| 194 | Data Element |
DB2XCRTAB | Number of CREATE TABLE statements executed | |
| 195 | Data Element |
DB2XCRUDF | Number of CREATE FUNCTION statements | |
| 196 | Data Element |
DB2XCTABS | Number of CREATE TABLE SPACE statements executed | |
| 197 | Data Element |
DB2XCTRIG | Number of SQL CREATE TRIGGER statements | |
| 198 | Data Element |
DB2XDDIST | Number of DROP DISTINCT TYPE statements | |
| 199 | Data Element |
DB2XDEFVU | Number of CREATE VIEW statements executed | |
| 200 | Data Element |
DB2XDEGBUF | Parallel groups fell to sequential due to storage shortage | |
| 201 | Data Element |
DB2XDEGCUR | Parallel groups fell to sequential due to updatable cursor | |
| 202 | Data Element |
DB2XDEGENC | Par.groups fell to sequ. due to unavailable enclave services | |
| 203 | Data Element |
DB2XDEGESA | Par. groups fell to sequ. due to lack of ESA sort support | |
| 204 | Data Element |
DB2XDELET | Number of DELETE statements executed | |
| 205 | Data Element |
DB2XDESC | Number of DESCRIBE statements executed | |
| 206 | Data Element |
DB2XDRPAL | Number of DROP ALIAS statements executed | |
| 207 | Data Element |
DB2XDRPCTX | drop trusted context | |
| 208 | Data Element |
DB2XDRPDB | Number of DROP DATABASE statements executed | |
| 209 | Data Element |
DB2XDRPFN | Number of DROP UDF statements | |
| 210 | Data Element |
DB2XDRPIX | Number of DROP INDEX statements executed | |
| 211 | Data Element |
DB2XDRPPKG | Number of DROP PACKAGE statements executed | |
| 212 | Data Element |
DB2XDRPPR | Number of DROP PROCEDURE statements | |
| 213 | Data Element |
DB2XDRPROL | drop role | |
| 214 | Data Element |
DB2XDRPST | Number of DROP STORAGE GROUP statements executed | |
| 215 | Data Element |
DB2XDRPSY | Number of DROP SYNONYM statements executed | |
| 216 | Data Element |
DB2XDRPTA | Number of DROP TABLE statements executed | |
| 217 | Data Element |
DB2XDRPTR | Number of SQL DROP TRIGGER statements | |
| 218 | Data Element |
DB2XDRPTS | Number of DROP TABLE SPACE statements executed | |
| 219 | Data Element |
DB2XDRPVU | Number of DROP VIEW statements executed | |
| 220 | Data Element |
DB2XDSCRTB | Number of DESCRIBE TABLE statements executed | |
| 221 | Data Element |
DB2XFETCH | Number of FETCH statements executed | |
| 222 | Data Element |
DB2XFREEL | Number of FREE LOCATOR statements | |
| 223 | Data Element |
DB2XGRANT | Number of GRANT statements executed | |
| 224 | Data Element |
DB2XHOLDL | Number of HOLD LOCATOR statements | |
| 225 | Data Element |
DB2XINCRB | Number of INCREMENTAL BINDs executed | |
| 226 | Data Element |
DB2XINSRT | Number of INSERT statements executed | |
| 227 | Data Element |
DB2XISORR | Isolation level RR or RS | |
| 228 | Data Element |
DB2XLABON | Number of LABEL ON statements executed | |
| 229 | Data Element |
DB2XLOCK | Number of LOCK TABLE statements executed | |
| 230 | Data Element |
DB2XMAXDEG | Maximum parallelism degree | |
| 231 | Data Element |
DB2XMERGE | # of times merge sql statement was executed | |
| 232 | Data Element |
DB2XMIAP | Number of times RID list processing is used | |
| 233 | Data Element |
DB2XMRMIAP | RID list processing failed - limit exeeded | |
| 234 | Data Element |
DB2XNORGRP | Parallel groups: executed as planned | |
| 235 | Data Element |
DB2XNSMIAP | RID list processing failed - no storage | |
| 236 | Data Element |
DB2XOPEN | Number of OPEN CURSOR statements executed | |
| 237 | Data Element |
DB2XPREP | Number of PREPARE statements executed | |
| 238 | Data Element |
DB2XREDGRP | Parallel groups: executed with reduced degree | |
| 239 | Data Element |
DB2XREL | Number of RELEASE statements executed | |
| 240 | Data Element |
DB2XREOP | Total Number of Times Reoptimization Occurs | |
| 241 | Data Element |
DB2XREPOP1 | Parallel groups with reformulated access path (Sysplex conf) | |
| 242 | Data Element |
DB2XREPOP2 | Parallel groups with reformulated access path (buffer pool) | |
| 243 | Data Element |
DB2XREVOK | Number of REVOKE statements executed | |
| 244 | Data Element |
DB2XRNIX | rename index | |
| 245 | Data Element |
DB2XRNTAB | RENAME TABLE | |
| 246 | Data Element |
DB2XROIIDX | Direct row access attempted, but reverted to using index | |
| 247 | Data Element |
DB2XROIMAT | Number of times DB2 used dir. row access to locate a record | |
| 248 | Data Element |
DB2XROITS | Direct row access attempted, reverted to tablespace scan | |
| 249 | Data Element |
DB2XROWTRG | Number of times a row trigger is activated | |
| 250 | Data Element |
DB2XSELECT | Number of SELECT statements executed | |
| 251 | Data Element |
DB2XSETCDG | Number of SET CURRENT DEGREE statements executed | |
| 252 | Data Element |
DB2XSETCON | Number of SET CONNECTION statements executed | |
| 253 | Data Element |
DB2XSETCRL | Number of SET CURRENT RULES statements executed | |
| 254 | Data Element |
DB2XSETHV | Number of SET HOST VARIABLE statements executed | |
| 255 | Data Element |
DB2XSETPTH | Number of SQL SET CURRENT PATH statements | |
| 256 | Data Element |
DB2XSETSQL | Number of SET CURRENT SQLID statements executed | |
| 257 | Data Element |
DB2XSTDEXP | MAXKEEPD parameter exceeded | |
| 258 | Data Element |
DB2XSTFND | Number of Times that DB2 Found the Statement in the Cache | |
| 259 | Data Element |
DB2XSTINV | Statement invalidated | |
| 260 | Data Element |
DB2XSTIRP | Number of implicit prepares | |
| 261 | Data Element |
DB2XSTLOBV | Maximum storage used for LOB values (MB) | |
| 262 | Data Element |
DB2XSTNFND | Number of times statement could not be found in cache | |
| 263 | Data Element |
DB2XSTNPRP | Number of avoided prepares | |
| 264 | Data Element |
DB2XSTTRG | Number of times a statement trigger is activated | |
| 265 | Data Element |
DB2XTOTGRP | Parallel groups: total executed | |
| 266 | Data Element |
DB2XTRGERR | No. of times an SQL error occurred during a triggered action | |
| 267 | Data Element |
DB2XTRTBL | # of times truncate table stmt was exec. | |
| 268 | Data Element |
DB2XUPDTE | Number of UPDATE statements executed | |
| 269 | Data Element |
DB2XXCBPNX | Parallel groups: intended to run across data sharing group | |
| 270 | Data Element |
DB2XXCSKIP | Member bypasses due to storage shortage |
