Data Element list used by SAP ABAP Table DB2QTHDDTL (DB2MONI: thread details)
SAP ABAP Table 
DB2QTHDDTL (DB2MONI: thread details) 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 |
DB2DIPROGN | The program name (package ID or DBRM name) | |
| 4 | Data Element |
DB2DISTNUM | Precompiler statement number | |
| 5 | Data Element |
DB2FULLP | Total number of prepares: full prepares + short prepares | |
| 6 | Data Element |
DB2GHITRAT | Dynamic Statement Cache Global Hit Ratio | |
| 7 | Data Element |
DB2INT2AA | Small integer | |
| 8 | Data Element |
DB2LHITRAT | Dynamic Statement Cache Local Hit Ratio | |
| 9 | Data Element |
DB2MEMN | DB2 member name in data sharing environment | |
| 10 | Data Element |
DB2PREPR | Number of Prepare Requests | |
| 11 | Data Element |
DB2QSTTOKN | Statement ID | |
| 12 | Data Element |
DB2RAW04 | Field type raw, length 8, 4 bytes | |
| 13 | Data Element |
DB2RES01 | Field type char, length 1, reserved | |
| 14 | Data Element |
DB2RES03 | Field type char, length 3, reserved | |
| 15 | Data Element |
DB2RPRERAT | Reprepare Ratio | |
| 16 | Data Element |
DB2SHPREP | Number of Short Prepares | |
| 17 | Data Element |
DB2STMTYPE | The current SQL statement type being executed by the thread | |
| 18 | Data Element |
DB2TFCONRA | False contention rate | |
| 19 | Data Element |
DB2TGCONRA | Global contention rate | |
| 20 | Data Element |
DB2TGSCPLK | Number of Change Requests for P-Locks | |
| 21 | Data Element |
DB2TGSCSLM | No. of Change Requests Propagated to MVS XES Synchronously | |
| 22 | Data Element |
DB2TGSDRTA | Incompatible retained lock | |
| 23 | Data Element |
DB2TGSFLSE | Number of suspends because of false contentions | |
| 24 | Data Element |
DB2TGSIGLO | Number of suspends caused by IRLM global resource contention | |
| 25 | Data Element |
DB2TGSLPLK | Number of lock requests for P-locks | |
| 26 | Data Element |
DB2TGSLSLM | Number of lock requests propagated to MVS XES synchronously | |
| 27 | Data Element |
DB2TGSNTFY | Number of Notification Messages Sent to Other Members | |
| 28 | Data Element |
DB2TGSSGLO | Suspends caused by MVS XES global resource contention | |
| 29 | Data Element |
DB2TGSUPLK | Number of unlock requests for P-locks | |
| 30 | Data Element |
DB2TGSUSLM | Number of IRLM unlock requests propagated to MVS XES synch. | |
| 31 | Data Element |
DB2TTLOPRA | Transaction locking optimization rate | |
| 32 | Data Element |
DB2TXACHG | Number of change requests | |
| 33 | Data Element |
DB2TXACHUS | Highest amt CPU 16 microsec used in successful DB2 call | |
| 34 | Data Element |
DB2TXACLMT | Limit in CPU 16 microseconds | |
| 35 | Data Element |
DB2TXACLNO | Number of claim requests | |
| 36 | Data Element |
DB2TXACLUN | Number of claim requests that were unsuccessful | |
| 37 | Data Element |
DB2TXADEA | Number of deadlocks | |
| 38 | Data Element |
DB2TXADRNO | Number of drain requests | |
| 39 | Data Element |
DB2TXADRUN | Number of drain requests that were unsuccessful | |
| 40 | Data Element |
DB2TXAIRLM | Number of other requests | |
| 41 | Data Element |
DB2TXALES | Number of lock escalations (shared) | |
| 42 | Data Element |
DB2TXALEX | Number of lock escalations (exclusive) | |
| 43 | Data Element |
DB2TXALOCK | Number of lock requests | |
| 44 | Data Element |
DB2TXAPREC | Precedence How Limit determined | |
| 45 | Data Element |
DB2TXAQRY | Number of query requests | |
| 46 | Data Element |
DB2TXASLAT | Number of latch suspensions | |
| 47 | Data Element |
DB2TXASLMT | Limit in SU's - ASUTIME Column | |
| 48 | Data Element |
DB2TXASLOC | Number of lock suspensions | |
| 49 | Data Element |
DB2TXASOTH | Number of other suspensions | |
| 50 | Data Element |
DB2TXATIM | Number of timeouts | |
| 51 | Data Element |
DB2TXAUNLK | Number of unlock requests | |
| 52 | Data Element |
DB2USERID | DB2USERID- | |
| 53 | Data Element |
DB2W0148ST | Indicates the status of the conversation or socket | |
| 54 | Data Element |
DB2WQ0124 | SQL TEXT | |
| 55 | Data Element |
DB2XALDAB | Number of ALTER DATABASE statements executed | |
| 56 | Data Element |
DB2XALOCC | # of ALLOCATE CURSOR statements executed | |
| 57 | Data Element |
DB2XALOCL | # of ASSOCIATE LOCATOR statements executed | |
| 58 | Data Element |
DB2XALPRO | Number of ALTER PROCEDURE statements | |
| 59 | Data Element |
DB2XALTCTX | alter trusted context | |
| 60 | Data Element |
DB2XALTIX | Number of ALTER INDEX statements executed | |
| 61 | Data Element |
DB2XALTJR | alter jar | |
| 62 | Data Element |
DB2XALTST | Number of ALTER STORAGE GROUP statements executed | |
| 63 | Data Element |
DB2XALTTA | Number of ALTER TABLE statements executed | |
| 64 | Data Element |
DB2XALTTS | Number of ALTER TABLE SPACE statements executed | |
| 65 | Data Element |
DB2XALUDF | Number of ALTER FUNCTION statements | |
| 66 | Data Element |
DB2XCALL | Number of SQL CALL statements executed | |
| 67 | Data Element |
DB2XCALLAB | # of times a stored procedure ABENDed | |
| 68 | Data Element |
DB2XCALLRJ | # of times an SQL CALL statement was rejected | |
| 69 | Data Element |
DB2XCALLTO | # of times an SQL CALL stmt timedout waiting to be scheduled | |
| 70 | Data Element |
DB2XCASCDP | Maximum level of nested SQL cascading | |
| 71 | Data Element |
DB2XCAUD | Number of user-defined functions executed | |
| 72 | Data Element |
DB2XCAUDAB | Number of times a user-defined function abended | |
| 73 | Data Element |
DB2XCAUDRJ | Number of times a user-defined function was rejected | |
| 74 | Data Element |
DB2XCAUDTO | No. of times a user-defined funct. timed out before sched. | |
| 75 | Data Element |
DB2XCDIST | Number of CREATE DISTINCT TYPE statements | |
| 76 | Data Element |
DB2XCLOSE | Number of CLOSE CURSOR statements executed | |
| 77 | Data Element |
DB2XCMTON | Number of COMMENT ON statements executed | |
| 78 | Data Element |
DB2XCON1 | Number of CONNECT TYPE 1 statements executed | |
| 79 | Data Element |
DB2XCON2 | Number of CONNECT TYPE 2 statements executed | |
| 80 | Data Element |
DB2XCOORNO | COORDINATOR setting mismatch | |
| 81 | Data Element |
DB2XCRALS | Number of CREATE ALIAS statements executed | |
| 82 | Data Element |
DB2XCRATB | Number of CREATE AUXILIARY TABLE statements | |
| 83 | Data Element |
DB2XCRCTX | create trusted context | |
| 84 | Data Element |
DB2XCRDAB | Number of CREATE DATABASE statements executed | |
| 85 | Data Element |
DB2XCRGTT | # OF CREATE GLBL TEMP TABLE | |
| 86 | Data Element |
DB2XCRINX | Number of CREATE INDEX statements executed | |
| 87 | Data Element |
DB2XCRPRO | Number of CREATE PROCEDURE statements | |
| 88 | Data Element |
DB2XCRROL | create role | |
| 89 | Data Element |
DB2XCRSTG | Number of CREATE STORAGE GROUP statements executed | |
| 90 | Data Element |
DB2XCRSYN | Number of CREATE SYNONYM statements executed | |
| 91 | Data Element |
DB2XCRTAB | Number of CREATE TABLE statements executed | |
| 92 | Data Element |
DB2XCRUDF | Number of CREATE FUNCTION statements | |
| 93 | Data Element |
DB2XCTABS | Number of CREATE TABLE SPACE statements executed | |
| 94 | Data Element |
DB2XCTRIG | Number of SQL CREATE TRIGGER statements | |
| 95 | Data Element |
DB2XDDIST | Number of DROP DISTINCT TYPE statements | |
| 96 | Data Element |
DB2XDEFVU | Number of CREATE VIEW statements executed | |
| 97 | Data Element |
DB2XDEGBUF | Parallel groups fell to sequential due to storage shortage | |
| 98 | Data Element |
DB2XDEGCUR | Parallel groups fell to sequential due to updatable cursor | |
| 99 | Data Element |
DB2XDEGENC | Par.groups fell to sequ. due to unavailable enclave services | |
| 100 | Data Element |
DB2XDEGESA | Par. groups fell to sequ. due to lack of ESA sort support | |
| 101 | Data Element |
DB2XDELET | Number of DELETE statements executed | |
| 102 | Data Element |
DB2XDESC | Number of DESCRIBE statements executed | |
| 103 | Data Element |
DB2XDRPAL | Number of DROP ALIAS statements executed | |
| 104 | Data Element |
DB2XDRPCTX | drop trusted context | |
| 105 | Data Element |
DB2XDRPDB | Number of DROP DATABASE statements executed | |
| 106 | Data Element |
DB2XDRPFN | Number of DROP UDF statements | |
| 107 | Data Element |
DB2XDRPIX | Number of DROP INDEX statements executed | |
| 108 | Data Element |
DB2XDRPPKG | Number of DROP PACKAGE statements executed | |
| 109 | Data Element |
DB2XDRPPR | Number of DROP PROCEDURE statements | |
| 110 | Data Element |
DB2XDRPROL | drop role | |
| 111 | Data Element |
DB2XDRPST | Number of DROP STORAGE GROUP statements executed | |
| 112 | Data Element |
DB2XDRPSY | Number of DROP SYNONYM statements executed | |
| 113 | Data Element |
DB2XDRPTA | Number of DROP TABLE statements executed | |
| 114 | Data Element |
DB2XDRPTR | Number of SQL DROP TRIGGER statements | |
| 115 | Data Element |
DB2XDRPTS | Number of DROP TABLE SPACE statements executed | |
| 116 | Data Element |
DB2XDRPVU | Number of DROP VIEW statements executed | |
| 117 | Data Element |
DB2XDSCRTB | Number of DESCRIBE TABLE statements executed | |
| 118 | Data Element |
DB2XFETCH | Number of FETCH statements executed | |
| 119 | Data Element |
DB2XFREEL | Number of FREE LOCATOR statements | |
| 120 | Data Element |
DB2XGRANT | Number of GRANT statements executed | |
| 121 | Data Element |
DB2XHOLDL | Number of HOLD LOCATOR statements | |
| 122 | Data Element |
DB2XINCRB | Number of INCREMENTAL BINDs executed | |
| 123 | Data Element |
DB2XINSRT | Number of INSERT statements executed | |
| 124 | Data Element |
DB2XISORR | Isolation level RR or RS | |
| 125 | Data Element |
DB2XLABON | Number of LABEL ON statements executed | |
| 126 | Data Element |
DB2XLOCK | Number of LOCK TABLE statements executed | |
| 127 | Data Element |
DB2XMAXDEG | Maximum parallelism degree | |
| 128 | Data Element |
DB2XMERGE | # of times merge sql statement was executed | |
| 129 | Data Element |
DB2XMIAP | Number of times RID list processing is used | |
| 130 | Data Element |
DB2XMRMIAP | RID list processing failed - limit exeeded | |
| 131 | Data Element |
DB2XNORGRP | Parallel groups: executed as planned | |
| 132 | Data Element |
DB2XNSMIAP | RID list processing failed - no storage | |
| 133 | Data Element |
DB2XOPEN | Number of OPEN CURSOR statements executed | |
| 134 | Data Element |
DB2XPREP | Number of PREPARE statements executed | |
| 135 | Data Element |
DB2XREDGRP | Parallel groups: executed with reduced degree | |
| 136 | Data Element |
DB2XREL | Number of RELEASE statements executed | |
| 137 | Data Element |
DB2XREOP | Total Number of Times Reoptimization Occurs | |
| 138 | Data Element |
DB2XREPOP1 | Parallel groups with reformulated access path (Sysplex conf) | |
| 139 | Data Element |
DB2XREPOP2 | Parallel groups with reformulated access path (buffer pool) | |
| 140 | Data Element |
DB2XREVOK | Number of REVOKE statements executed | |
| 141 | Data Element |
DB2XRNIX | rename index | |
| 142 | Data Element |
DB2XRNTAB | RENAME TABLE | |
| 143 | Data Element |
DB2XROIIDX | Direct row access attempted, but reverted to using index | |
| 144 | Data Element |
DB2XROIMAT | Number of times DB2 used dir. row access to locate a record | |
| 145 | Data Element |
DB2XROITS | Direct row access attempted, reverted to tablespace scan | |
| 146 | Data Element |
DB2XROWTRG | Number of times a row trigger is activated | |
| 147 | Data Element |
DB2XSELECT | Number of SELECT statements executed | |
| 148 | Data Element |
DB2XSETCDG | Number of SET CURRENT DEGREE statements executed | |
| 149 | Data Element |
DB2XSETCON | Number of SET CONNECTION statements executed | |
| 150 | Data Element |
DB2XSETCRL | Number of SET CURRENT RULES statements executed | |
| 151 | Data Element |
DB2XSETHV | Number of SET HOST VARIABLE statements executed | |
| 152 | Data Element |
DB2XSETPTH | Number of SQL SET CURRENT PATH statements | |
| 153 | Data Element |
DB2XSETSQL | Number of SET CURRENT SQLID statements executed | |
| 154 | Data Element |
DB2XSTDEXP | MAXKEEPD parameter exceeded | |
| 155 | Data Element |
DB2XSTFND | Number of Times that DB2 Found the Statement in the Cache | |
| 156 | Data Element |
DB2XSTINV | Statement invalidated | |
| 157 | Data Element |
DB2XSTIRP | Number of implicit prepares | |
| 158 | Data Element |
DB2XSTLOBV | Maximum storage used for LOB values (MB) | |
| 159 | Data Element |
DB2XSTNFND | Number of times statement could not be found in cache | |
| 160 | Data Element |
DB2XSTNPRP | Number of avoided prepares | |
| 161 | Data Element |
DB2XSTTRG | Number of times a statement trigger is activated | |
| 162 | Data Element |
DB2XTOTGRP | Parallel groups: total executed | |
| 163 | Data Element |
DB2XTRGERR | No. of times an SQL error occurred during a triggered action | |
| 164 | Data Element |
DB2XTRTBL | # of times truncate table stmt was exec. | |
| 165 | Data Element |
DB2XUPDTE | Number of UPDATE statements executed | |
| 166 | Data Element |
DB2XXCBPNX | Parallel groups: intended to run across data sharing group | |
| 167 | Data Element |
DB2XXCSKIP | Member bypasses due to storage shortage |
