| 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 |
|