dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table DB2QTHDDTL

DB2MONI: thread details

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table DB2QTHDDTL (DB2MONI: thread details) is a standard table in SAP ERP. It belongs to the package STU3.

Technical Information

Table DB2QTHDDTL
Short Text DB2MONI: thread details
Package STU3
Table Type Transparent Table

Fields for Table DB2QTHDDTL

Field Name Key Description Data Element Type Length Check Table
MEMBNM ✔ DB2 member name in data sharing environment DB2MEMN CHAR 8
ACE ✔ Field type raw, length 8, 4 bytes DB2RAW04 INT4 10
QXSELECT Number of SELECT statements executed DB2XSELECT DEC 19
QXINSRT Number of INSERT statements executed DB2XINSRT DEC 19
QXUPDTE Number of UPDATE statements executed DB2XUPDTE DEC 19
QXDELET Number of DELETE statements executed DB2XDELET DEC 19
QXDESC Number of DESCRIBE statements executed DB2XDESC DEC 19
QXPREP Number of PREPARE statements executed DB2XPREP DEC 19
QXOPEN Number of OPEN CURSOR statements executed DB2XOPEN DEC 19
QXCLOSE Number of CLOSE CURSOR statements executed DB2XCLOSE DEC 19
QXCRTAB Number of CREATE TABLE statements executed DB2XCRTAB DEC 19
QXCRINX Number of CREATE INDEX statements executed DB2XCRINX DEC 19
QXCTABS Number of CREATE TABLE SPACE statements executed DB2XCTABS DEC 19
QXCRSYN Number of CREATE SYNONYM statements executed DB2XCRSYN DEC 19
QXCRDAB Number of CREATE DATABASE statements executed DB2XCRDAB DEC 19
QXCRSTG Number of CREATE STORAGE GROUP statements executed DB2XCRSTG DEC 19
QXDEFVU Number of CREATE VIEW statements executed DB2XDEFVU DEC 19
QXDRPIX Number of DROP INDEX statements executed DB2XDRPIX DEC 19
QXDRPTA Number of DROP TABLE statements executed DB2XDRPTA DEC 19
QXDRPTS Number of DROP TABLE SPACE statements executed DB2XDRPTS DEC 19
QXDRPDB Number of DROP DATABASE statements executed DB2XDRPDB DEC 19
QXDRPSY Number of DROP SYNONYM statements executed DB2XDRPSY DEC 19
QXDRPST Number of DROP STORAGE GROUP statements executed DB2XDRPST DEC 19
QXDRPVU Number of DROP VIEW statements executed DB2XDRPVU DEC 19
QXALTST Number of ALTER STORAGE GROUP statements executed DB2XALTST DEC 19
QXFETCH Number of FETCH statements executed DB2XFETCH DEC 19
QXALTTS Number of ALTER TABLE SPACE statements executed DB2XALTTS DEC 19
QXALTTA Number of ALTER TABLE statements executed DB2XALTTA DEC 19
QXALTIX Number of ALTER INDEX statements executed DB2XALTIX DEC 19
QXCMTON Number of COMMENT ON statements executed DB2XCMTON DEC 19
QXLOCK Number of LOCK TABLE statements executed DB2XLOCK DEC 19
QXGRANT Number of GRANT statements executed DB2XGRANT DEC 19
QXREVOK Number of REVOKE statements executed DB2XREVOK DEC 19
QXINCRB Number of INCREMENTAL BINDs executed DB2XINCRB DEC 19
QXLABON Number of LABEL ON statements executed DB2XLABON DEC 19
QXSETSQL Number of SET CURRENT SQLID statements executed DB2XSETSQL DEC 19
QXCRALS Number of CREATE ALIAS statements executed DB2XCRALS DEC 19
QXDRPAL Number of DROP ALIAS statements executed DB2XDRPAL DEC 19
QXMIAP Number of times RID list processing is used DB2XMIAP DEC 19
QXNSMIAP RID list processing failed - no storage DB2XNSMIAP DEC 19
QXMRMIAP RID list processing failed - limit exeeded DB2XMRMIAP DEC 19
QXSETHV Number of SET HOST VARIABLE statements executed DB2XSETHV DEC 19
QXALDAB Number of ALTER DATABASE statements executed DB2XALDAB DEC 19
QXDRPPKG Number of DROP PACKAGE statements executed DB2XDRPPKG DEC 19
QXDSCRTB Number of DESCRIBE TABLE statements executed DB2XDSCRTB DEC 19
QXMAXDEG Maximum parallelism degree DB2XMAXDEG DEC 19
QXTOTGRP Parallel groups: total executed DB2XTOTGRP DEC 19
QXDEGCUR Parallel groups fell to sequential due to updatable cursor DB2XDEGCUR DEC 19
QXDEGESA Par. groups fell to sequ. due to lack of ESA sort support DB2XDEGESA DEC 19
QXDEGBUF Parallel groups fell to sequential due to storage shortage DB2XDEGBUF DEC 19
QXREDGRP Parallel groups: executed with reduced degree DB2XREDGRP DEC 19
QXNORGRP Parallel groups: executed as planned DB2XNORGRP DEC 19
QXCON1 Number of CONNECT TYPE 1 statements executed DB2XCON1 DEC 19
QXCON2 Number of CONNECT TYPE 2 statements executed DB2XCON2 DEC 19
QXREL Number of RELEASE statements executed DB2XREL DEC 19
QXSETCON Number of SET CONNECTION statements executed DB2XSETCON DEC 19
QXSETCDG Number of SET CURRENT DEGREE statements executed DB2XSETCDG DEC 19
QXSETCRL Number of SET CURRENT RULES statements executed DB2XSETCRL DEC 19
QXCALL Number of SQL CALL statements executed DB2XCALL DEC 19
QXCALLAB # of times a stored procedure ABENDed DB2XCALLAB DEC 19
QXCALLTO # of times an SQL CALL stmt timedout waiting to be scheduled DB2XCALLTO DEC 19
QXCALLRJ # of times an SQL CALL statement was rejected DB2XCALLRJ DEC 19
QXDEGENC Par.groups fell to sequ. due to unavailable enclave services DB2XDEGENC DEC 19
QXRLFDPA CHAR 1
QXSTRES1 Field type char, length 3, reserved DB2RES03 CHAR 3
QXCOORNO COORDINATOR setting mismatch DB2XCOORNO DEC 19
QXISORR Isolation level RR or RS DB2XISORR DEC 19
QXCRGTT # OF CREATE GLBL TEMP TABLE DB2XCRGTT DEC 19
QXSTREOP Total Number of Times Reoptimization Occurs DB2XREOP DEC 19
QXXCBPNX Parallel groups: intended to run across data sharing group DB2XXCBPNX DEC 19
QXXCSKIP Member bypasses due to storage shortage DB2XXCSKIP DEC 19
QXALOCL # of ASSOCIATE LOCATOR statements executed DB2XALOCL DEC 19
QXALOCC # of ALLOCATE CURSOR statements executed DB2XALOCC DEC 19
QXSTFND Number of Times that DB2 Found the Statement in the Cache DB2XSTFND DEC 19
QXSTNFND Number of times statement could not be found in cache DB2XSTNFND DEC 19
QXSTIPRP Number of implicit prepares DB2XSTIRP DEC 19
QXSTNPRP Number of avoided prepares DB2XSTNPRP DEC 19
QXSTDEXP MAXKEEPD parameter exceeded DB2XSTDEXP DEC 19
QXSTDINV Statement invalidated DB2XSTINV DEC 19
QXRNTAB RENAME TABLE DB2XRNTAB DEC 19
QXFULLP Total number of prepares: full prepares + short prepares DB2FULLP DEC 19
QXCTRIG Number of SQL CREATE TRIGGER statements DB2XCTRIG DEC 19
QXDRPTR Number of SQL DROP TRIGGER statements DB2XDRPTR DEC 19
QXSETPTH Number of SQL SET CURRENT PATH statements DB2XSETPTH DEC 19
QXDRPFN Number of DROP UDF statements DB2XDRPFN DEC 19
QXDRPPR Number of DROP PROCEDURE statements DB2XDRPPR DEC 19
QXCDIST Number of CREATE DISTINCT TYPE statements DB2XCDIST DEC 19
QXDDIST Number of DROP DISTINCT TYPE statements DB2XDDIST DEC 19
QXCRUDF Number of CREATE FUNCTION statements DB2XCRUDF DEC 19
QXCRPRO Number of CREATE PROCEDURE statements DB2XCRPRO DEC 19
QXHOLDL Number of HOLD LOCATOR statements DB2XHOLDL DEC 19
QXFREEL Number of FREE LOCATOR statements DB2XFREEL DEC 19
QXREPOP1 Parallel groups with reformulated access path (Sysplex conf) DB2XREPOP1 DEC 19
QXREPOP2 Parallel groups with reformulated access path (buffer pool) DB2XREPOP2 DEC 19
QXCRATB Number of CREATE AUXILIARY TABLE statements DB2XCRATB DEC 19
QXSTLOBV Maximum storage used for LOB values (MB) DB2XSTLOBV DEC 19
QXALUDF Number of ALTER FUNCTION statements DB2XALUDF DEC 19
QXALPRO Number of ALTER PROCEDURE statements DB2XALPRO DEC 19
QXROIMAT Number of times DB2 used dir. row access to locate a record DB2XROIMAT DEC 19
QXROIIDX Direct row access attempted, but reverted to using index DB2XROIIDX DEC 19
QXROITS Direct row access attempted, reverted to tablespace scan DB2XROITS DEC 19
QXSTTRG Number of times a statement trigger is activated DB2XSTTRG DEC 19
QXROWTRG Number of times a row trigger is activated DB2XROWTRG DEC 19
QXTRGERR No. of times an SQL error occurred during a triggered action DB2XTRGERR DEC 19
QXCASCDP Maximum level of nested SQL cascading DB2XCASCDP DEC 19
QXCAUD Number of user-defined functions executed DB2XCAUD DEC 19
QXCAUDAB Number of times a user-defined function abended DB2XCAUDAB DEC 19
QXCAUDTO No. of times a user-defined funct. timed out before sched. DB2XCAUDTO DEC 19
QXCAUDRJ Number of times a user-defined function was rejected DB2XCAUDRJ DEC 19
GHITRATIO Dynamic Statement Cache Global Hit Ratio DB2GHITRAT CHAR 7
LHITRATIO Dynamic Statement Cache Local Hit Ratio DB2LHITRAT CHAR 7
REPREPRAT Reprepare Ratio DB2RPRERAT CHAR 7
PREPREQ Number of Prepare Requests DB2PREPR DEC 19
SHORTPREP Number of Short Prepares DB2SHPREP DEC 19
QXALTJR alter jar DB2XALTJR DEC 19
QXMERGE # of times merge sql statement was executed DB2XMERGE DEC 19
QXTRTBL # of times truncate table stmt was exec. DB2XTRTBL DEC 19
QXCRROL create role DB2XCRROL DEC 19
QXDRPROL drop role DB2XDRPROL DEC 19
QXCRCTX create trusted context DB2XCRCTX DEC 19
QXALTCTX alter trusted context DB2XALTCTX DEC 19
QXDRPCTX drop trusted context DB2XDRPCTX DEC 19
QXRNIX rename index DB2XRNIX DEC 19
QTXADEA Number of deadlocks DB2TXADEA INT4 10
QTXASLOC Number of lock suspensions DB2TXASLOC INT4 10
QTXATIM Number of timeouts DB2TXATIM INT4 10
QTXALES Number of lock escalations (shared) DB2TXALES INT4 10
QTXALEX Number of lock escalations (exclusive) DB2TXALEX INT4 10
QTXAFLG1 Field type char, length 1, bit field DB2BIT01 CHAR 1
QTXARES1 Field type char, length 1, reserved DB2RES01 CHAR 1
QTXARLID Field type char, length 2 DB2CHAR02 CHAR 2
QTXAPREC Precedence How Limit determined DB2TXAPREC INT4 10
QTXASLMT Limit in SU's - ASUTIME Column DB2TXASLMT INT4 10
QTXACLMT Limit in CPU 16 microseconds DB2TXACLMT INT4 10
QTXACHUS Highest amt CPU 16 microsec used in successful DB2 call DB2TXACHUS INT4 10
QTXASLAT Number of latch suspensions DB2TXASLAT INT4 10
QTXASOTH Number of other suspensions DB2TXASOTH INT4 10
QTXALOCK Number of lock requests DB2TXALOCK INT4 10
QTXAUNLK Number of unlock requests DB2TXAUNLK INT4 10
QTXAQRY Number of query requests DB2TXAQRY INT4 10
QTXACHG Number of change requests DB2TXACHG INT4 10
QTXAIRLM Number of other requests DB2TXAIRLM INT4 10
QTXACLNO Number of claim requests DB2TXACLNO INT4 10
QTXACLUN Number of claim requests that were unsuccessful DB2TXACLUN INT4 10
QTXADRNO Number of drain requests DB2TXADRNO INT4 10
QTXADRUN Number of drain requests that were unsuccessful DB2TXADRUN INT4 10
QTGALPLK Number of lock requests for P-locks DB2TGSLPLK INT4 10
QTGAUPLK Number of unlock requests for P-locks DB2TGSUPLK INT4 10
QTGACPLK Number of Change Requests for P-Locks DB2TGSCPLK INT4 10
QTGALSLM Number of lock requests propagated to MVS XES synchronously DB2TGSLSLM INT4 10
QTGACSLM No. of Change Requests Propagated to MVS XES Synchronously DB2TGSCSLM INT4 10
QTGAUSLM Number of IRLM unlock requests propagated to MVS XES synch. DB2TGSUSLM INT4 10
QTGAIGLO Number of suspends caused by IRLM global resource contention DB2TGSIGLO INT4 10
QTGASGLO Suspends caused by MVS XES global resource contention DB2TGSSGLO INT4 10
QTGAFLSE Number of suspends because of false contentions DB2TGSFLSE INT4 10
QTGADRTA Incompatible retained lock DB2TGSDRTA INT4 10
QTGANTFY Number of Notification Messages Sent to Other Members DB2TGSNTFY INT4 10
GCONTRATE Global contention rate DB2TGCONRA CHAR 10
FCONTRATE False contention rate DB2TFCONRA CHAR 10
TLOPTRATE Transaction locking optimization rate DB2TTLOPRA CHAR 10
STMTTYPE The current SQL statement type being executed by the thread DB2STMTYPE CHAR 22
RDIPROGN The program name (package ID or DBRM name) DB2DIPROGN CHAR 10
RDISTNUM Precompiler statement number DB2DISTNUM INT2 5
DDISTNUM Precompiler statement number INT4 10
QW0124ST Statement ID DB2QSTTOKN INT4 10
QW01242L Small integer DB2INT2AA INT2 5
QW01242 SQL TEXT DB2WQ0124 LCHR 4000
QW0148CI DB2 collection ID CHAR 128
QW0148ST Indicates the status of the conversation or socket DB2W0148ST CHAR 2