Statistics table (DMRSTATB): sections QSST through QXST
The following table describes the columns in the DMRSTATB and DMRSTBSM tables.
Performance report column name | SMF field name | Data type | Used in report | Description |
|---|---|---|---|---|
DMRTABLEVERSION |
| CHAR(8) | NO | Version of DMR that created this table |
DMRVERSION |
| CHAR(8) | NO | Version of DMR that created this record |
SYSTEMID | SM100SID | CHAR(4) | NO | SMF system ID |
SUBSYSTEM | SM100SSI | CHAR(4) | NO | Db2 subsystem ID |
QWHS - Standard Header | ||||
DB2VERSION | QWHSRN | CHAR(6) | NO | Version of Db2 that generated this data |
INTERVAL | INTEGER | NO | Interval - only for summary | |
TRANSCNT | INTEGER | NO | Trans count - used for summary | |
IFCIDSEQ# | IFCIDSEQ# | INTEGER | NO | IFCID sequence number |
LOCATION | LOCATION | CHAR(16) | NO | Local location name |
GROUPNAME | GROUPNAME | CHAR(8) | NO | Data sharing group name |
MEMBERNAME | MEMBERNAME | CHAR(8) | NO | Data sharing member name |
TRACEMASK | TRACEMASK | INTEGER | NO | Active trace number mask |
DMRACSHARE | INTEGER | NO | DMR column used as marker during AUTOCUST | |
DMRAUTOCUST | INTEGER | NO | DMR AUTOCUST marker for column only | |
DMRAUTOLONG | INTEGER | NO | DMR AUTOCUST marker for column only | |
DATETIME | QWHSSTCK | TIMESTAMP | NO | Date and time statistics written |
DATE | QWHSSTCK | DATE | NO | Date record was created |
YEAR | QWHSSTCK | CHAR(4) | NO | Year record was created |
MONTH | QWHSSTCK | CHAR(2) | NO | Month record was created |
DAY | QWHSSTCK | CHAR(2) | NO | Day record was created |
TIME | QWHSSTCK | TIME | NO | Time record was created |
HOUR | QWHSSTCK | CHAR(2) | NO | Hour record was created |
DAYOFWEEK# | QWHSSTCK | SMALLINT | NO | Relative day of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWHSSTCK | CHAR(3) | NO | Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday |
WEEK# | QWHSSTCK | INTEGER | NO | Week number relative to the 1 January 1900 epoch |
QSST - Storage Manager | ||||
QSSTABND | QSSTABND | INTEGER | NO | Abends issue due to SOS |
QSSTCONT | QSSTCONT | INTEGER | NO | SOS storage contractions |
QSSTCRIT | QSSTCRIT | INTEGER | NO | SOS detected |
QT - Bind Data | ||||
QTABIND | QTABIND | INTEGER | NO | Successful automatic binds |
QTABINDA | QTABINDA | INTEGER | NO | Automatic bind attempts |
QTALLOC | QTALLOC | INTEGER | NO | Successful plan allocations |
QTALLOCA | QTALLOCA | INTEGER | NO | Plan allocation attempts |
QTAUCCH | QTAUCCH | INTEGER | NO | Successful authorization checks with cache |
QTAUCHK | QTAUCHK | INTEGER | NO | Authorization check attempts |
QTAUCNOT | QTAUCNOT | INTEGER | NO | Number of plan authorization check not use plan authorization cache |
QTAUCOW1 | QTAUCOW1 | INTEGER | NO | Number of times Db2 overwrote AUTHID in plan authorization cache |
QTAUPUB | QTAUPUB | INTEGER | NO | Successful authorization checks with public |
QTAUSUC | QTAUSUC | INTEGER | NO | Successful authorization checks |
QTAUTOBA | QTAUTOBA | INTEGER | NO | AUTOBIND package attempts |
QTBINDA | QTBINDA | INTEGER | NO | Bind add subcommands |
QTBINDPA | QTBINDPA | INTEGER | NO | Bind add package |
QTBINDPR | QTBINDPR | INTEGER | NO | Bind replace package |
QTBINDR | QTBINDR | INTEGER | NO | Bind replace subcommands |
QTDSDRN | QTDSDRN | INTEGER | NO | Number of datasets closed by drain |
QTDSOPN | QTDSOPN | INTEGER | NO | Number of datasets currently open |
QTFREE | QTFREE | INTEGER | NO | Free subcommands |
QTFREEA | QTFREEA | INTEGER | NO | Attempts to free a plan |
QTFREEAP | QTFREEAP | INTEGER | NO | Free package attempts |
QTFREEP | QTFREEP | INTEGER | NO | Free package commands |
QTINVRID | QTINVRID | INTEGER | NO | Automatic bind-invalid Resource-IDS |
QTMAXDS | QTMAXDS | INTEGER | NO | Maximum number of datasets open |
QTMAXPB | QTMAXPB | INTEGER | NO | Maximum page set blocks |
QTPACAUT | QTPACAUT | INTEGER | NO | Number of successful package authorization cache checks |
QTPACNOT | QTPACNOT | INTEGER | NO | Number of failed package executed checks-not in cache |
QTPACOW1 | QTPACOW1 | INTEGER | NO | Number of AUTHID replace in cache |
QTPACOW2 | QTPACOW2 | INTEGER | NO | Number of PKG/COLLECTION replace in cache |
QTPACPUB | QTPACPUB | INTEGER | NO | Number of successful package executed checks-public |
QTPCCT | QTPCCT | INTEGER | NO | Number of infrequently updated datasets converted from R/W to R/O |
QTPCGBP | QTPCGBP | INTEGER | NO | Number of infrequently accessed dataset physically closed |
QTPCUT | QTPCUT | INTEGER | NO | Number of utility access dataset physically closed reserve |
QTPKABND | QTPKABND | INTEGER | NO | Autobind package successful |
QTPKALL | QTPKALL | INTEGER | NO | Allocate package successful |
QTPKALLA | QTPKALLA | INTEGER | NO | Allocate package attempts |
QTPKGBD | QTPKGBD | INTEGER | NO | Packages bound |
QTPKGFRD | QTPKGFRD | INTEGER | NO | Free package successful |
QTPKGRBD | QTPKGRBD | INTEGER | NO | Package successful |
QTPLNBD | QTPLNBD | INTEGER | NO | Plans successfully bound |
QTPLNFRD | QTPLNFRD | INTEGER | NO | Plans successfully freed |
QTPLNRBD | QTPLNRBD | INTEGER | NO | Plans successfully rebound |
QTRACAUT | QTRACAUT | INTEGER | NO | Successful authorization checks |
QTRACNAC | QTRACNAC | INTEGER | NO | Auth ID cache-entry not added |
QTRACNOT | QTRACNOT | INTEGER | NO | Authorization checks-not use cache |
QTRACOW1 | QTRACOW1 | INTEGER | NO | Auth ID cache wrote over ID |
QTRACOW2 | QTRACOW2 | INTEGER | NO | Auth ID cache wrote over routine |
QTRACPUB | QTRACPUB | INTEGER | NO | Successful auth checks-public |
QTRBINDA | QTRBINDA | INTEGER | NO | Attempts to rebind |
QTRBINDP | QTRBINDP | INTEGER | NO | Rebind package |
QTRBNDPA | QTRBNDPA | INTEGER | NO | Rebind package attempts |
QTREBIND | QTREBIND | INTEGER | NO | Rebind subcommands |
QTREBIND | QTREBIND | NO | QTREBIND package successful | |
QTREOPN | QTREOPN | INTEGER | NO | Number of times not IN-USE open datasets became IN-USE |
QTSLWDD | QTSLWDD | INTEGER | NO | Number of datasets not IN-USE but not closed |
QTTESTB | QTTESTB | INTEGER | NO | Test binds (no Plan-ID) |
QTGS - Global Locking | ||||
QTGSCHNP | QTGSCHNP | INTEGER | NO | P-lock change requests during P-lock negotiation |
QTGSCNOTY | QTGSCNOTY | INTEGER | NO | Notify exit counter |
QTGSCPLK | QTGSCPLK | INTEGER | NO | Change requests for P-locks |
QTGSCPLOK | QTGSCPLOK | INTEGER | NO | P-lock exit counter |
QTGSCREJ | QTGSCREJ | INTEGER | NO | Conditional rejections XES |
QTGSCSLM | QTGSCSLM | INTEGER | NO | Change requests propagated to XES synchronously |
QTGSDGBL | QTGSDGBL | INTEGER | NO | Number of total global deadlocks |
QTGSDRTA | QTGSDRTA | INTEGER | NO | Global requests denied-incompatible retained lock |
QTGSFCONT | QTGSFCONT | INTEGER | NO | False contention |
QTGSFLGS | QTGSFLGS | BINARY(4) | NO | QTGS section counter flags |
QTGSFLMG | QTGSFLMG | INTEGER | NO | False contentions for Lock/Unlock requests |
QTGSFLSE | QTGSFLSE | INTEGER | NO | Suspends - Sync/Async heuristic conversions for lock request in XES |
QTGSGCONT | QTGSGCONT | INTEGER | NO | Contention exit-IRLM granted ok |
QTGSGICNT | QTGSGICNT | INTEGER | NO | Global resource contention |
QTGSIGLO | QTGSIGLO | INTEGER | NO | SUSPENDS - IRLM Global resource contention |
QTGSKIDS | QTGSKIDS | INTEGER | NO | Resources propagated by IRLM to MVS XES async |
QTGSLCAIC | QTGSLCAIC | INTEGER | NO | Active IRLM CB latch contention counter |
QTGSLICNT | QTGSLICNT | INTEGER | NO | Local resource contention |
QTGSLPLK | QTGSLPLK | INTEGER | NO | Lock requests for P-locks |
QTGSLSLM | QTGSLSLM | INTEGER | NO | Lock requests propagated to XES synchronously |
QTGSNTFR | QTGSNTFR | INTEGER | NO | Notify messages received |
QTGSNTFY | QTGSNTFY | INTEGER | NO | Notify messages sent |
QTGSOTPE | QTGSOTPE | INTEGER | NO | Negotiate another P-lock type |
QTGSPEMX | QTGSPEMX | INTEGER | NO | Maximum engines avail - P-Lock/Notify exit requests |
QTGSPEQW | QTGSPEQW | INTEGER | NO | Engine not avail- P-Lock/Notify exit requests |
QTGSPGPE | QTGSPGPE | INTEGER | NO | Negotiate page P-lock - Inter-Db2 contention |
QTGSPPPE | QTGSPPPE | INTEGER | NO | Negotiate PGSET/PART - Change Inter-Db2 interest levels |
QTGSSGLO | QTGSSGLO | INTEGER | NO | Suspends - MVS XES global resource contention |
QTGSUPLK | QTGSUPLK | INTEGER | NO | Unlock requests for P-Locks |
QTGSUSLM | QTGSUSLM | INTEGER | NO | Unlock requests propagated to XES synchronously |
QTXA - Lock Usage | ||||
QTXACGEN | QTXACGEN | INTEGER | NO | Generic latch contentions |
QTXACHG | QTXACHG | INTEGER | NO | Change request count |
QTXACHUS | QTXACHUS | INTEGER | NO | Highest CPU 16 microsecs used |
QTXACLMT | QTXACLMT | INTEGER | NO | Limit in CPU 16 microseconds |
QTXACLNO | QTXACLNO | INTEGER | NO | Number of claim requests |
QTXACLUN | QTXACLUN | INTEGER | NO | Number of unsuccessful claim requests |
QTXACNNT | QTXACNNT | INTEGER | NO | Notify control block latch contention- NOTIFY |
QTXACRAL | QTXACRAL | INTEGER | NO | Resource hash tb latch contention- ASYNC LOCK |
QTXACRCH | QTXACRCH | INTEGER | NO | Resource hash table latch contention- CHANGE |
QTXACRCP | QTXACRCP | INTEGER | NO | Resource hash table latch contention- COMPAT |
QTXACRLK | QTXACRLK | INTEGER | NO | Resource hash table latch contention- LOCK |
QTXACRNT | QTXACRNT | INTEGER | NO | Resource hash table latch contention- NOTIFY |
QTXACRQF | QTXACRQF | INTEGER | NO | Resource hash table latch contention- QUERY FAST |
QTXACRUK | QTXACRUK | INTEGER | NO | Resource hash table latch contention- UNLOCK |
QTXACWAL | QTXACWAL | INTEGER | NO | Workunit hash table latch contention- ASYNC LOCK |
QTXACWCH | QTXACWCH | INTEGER | NO | Workunit hash table latch contention- CHANGE |
QTXACWCP | QTXACWCP | INTEGER | NO | Workunit hash table latch contention- COMPAT |
QTXACWLK | QTXACWLK | INTEGER | NO | Workunit hash table latch contention- LOCK |
QTXACWQF | QTXACWQF | INTEGER | NO | Workunit hash table latch- QUERY FAST |
QTXACWSY | QTXACWSY | INTEGER | NO | Workunit hash table latch contention- SYNC |
QTXACWUK | QTXACWUK | INTEGER | NO | Workunit hash table latch contention- UNLOCK |
QTXADEA | QTXADEA | INTEGER | NO | Deadlock count |
QTXADEAD | QTXADEAD | INTEGER | NO | Deadlock exit counter |
QTXADLCL | QTXADLCL | INTEGER | NO | Total number of local deadlocks |
QTXADRNO | QTXADRNO | INTEGER | NO | Number of drain requests |
QTXADRUN | QTXADRUN | INTEGER | NO | Number of unsuccessful drain requests |
QTXAFLG1 | QTXAFLG1 | BINARY(1) | NO | QTXA flag |
QTXAIRLM | QTXAIRLM | INTEGER | NO | Other IRLM request count |
QTXALCCP | QTXALCCP | INTEGER | NO | Number of Compat queue generated |
QTXALCMM | QTXALCMM | INTEGER | NO | Main latch contention due to main latch held |
QTXALCMU | QTXALCMU | INTEGER | NO | Main latch contention due to use count not 0 |
QTXALCSM | QTXALCSM | INTEGER | NO | Secondary latch contention main latch held |
QTXALES | QTXALES | INTEGER | NO | Lock escalation count - shared |
QTXALEX | QTXALEX | INTEGER | NO | Lock escalation count - exclusive |
QTXALOCK | QTXALOCK | INTEGER | NO | Lock request count |
QTXANRTY | QTXANRTY | INTEGER | NO | Non re-tryable ABENDS |
QTXAPREC | QTXAPREC | INTEGER | NO | How limit was determined |
QTXAQRY | QTXAQRY | INTEGER | NO | Query request count |
QTXARLID | QTXARLID | CHAR(2) | NO | Resource limit table ID |
QTXARSUM | QTXARSUM | INTEGER | NO | Resume exit counter |
QTXARTRY | QTXARTRY | INTEGER | NO | Re-tryable abends |
QTXASLAT | QTXASLAT | INTEGER | NO | Suspend count-latch conflicts |
QTXASLMT | QTXASLMT | INTEGER | NO | Limit in SU's - ASUTIME |
QTXASLOC | QTXASLOC | INTEGER | NO | Lock suspend count |
QTXASOTH | QTXASOTH | INTEGER | NO | Suspend count-other conflicts |
QTXASRCL | QTXASRCL | INTEGER | NO | Resource latch contention counter |
QTXASTAT | QTXASTAT | INTEGER | NO | Status exit counter |
QTXASUSP | QTXASUSP | INTEGER | NO | Suspend exit counter |
QTXATIM | QTXATIM | INTEGER | NO | Lock timeout count |
QTXATIME | QTXATIME | INTEGER | NO | Timeout exit counter |
QTXATOUT | QTXATOUT | INTEGER | NO | Timeout RLBS purged |
QTXAUCNT | QTXAUCNT | INTEGER | NO | Count counter Compat QEs in IRLM |
QTXAUNLK | QTXAUNLK | INTEGER | NO | Unlock request count |
QVAS - Agent Services | ||||
QVASADDL | QVASADDL | INTEGER | NO | Allocate failure, deadlock |
QVASADIR | QVASADIR | INTEGER | NO | Allocate failure, invalid resource |
QVASADUR | QVASADUR | INTEGER | NO | Allocate failure, unavailable resource |
QVASSUSP | QVASSUSP | INTEGER | NO | Count of physical suspends |
QVLS - Latch Manager | ||||
QVLSLC01 | QVLSLC01 | INTEGER | NO | Infrequently used |
QVLSLC02 | QVLSLC02 | INTEGER | NO | Global authorization cache |
QVLSLC03 | QVLSLC03 | INTEGER | NO | DDF disconnect |
QVLSLC04 | QVLSLC04 | INTEGER | NO | SYSSTRING cache |
QVLSLC05 | QVLSLC05 | INTEGER | NO | IRLM data sharing exits |
QVLSLC06 | QVLSLC06 | INTEGER | NO | Data sharing index split |
QVLSLC07 | QVLSLC07 | INTEGER | NO | Index lotch and OBD |
QVLSLC08 | QVLSLC08 | INTEGER | NO | Query parallelism |
QVLSLC09 | QVLSLC09 | INTEGER | NO | Utilities or stored |
QVLSLC10 | QVLSLC10 | INTEGER | NO | Allied agent chain or sequence descriptors |
QVLSLC11 | QVLSLC11 | INTEGER | NO | DGTT allocation |
QVLSLC12 | QVLSLC12 | INTEGER | NO | Global transaction ID table |
QVLSLC13 | QVLSLC13 | INTEGER | NO | Pageset operations |
QVLSLC14 | QVLSLC14 | INTEGER | NO | Bufferpool LRU |
QVLSLC15 | QVLSLC15 | INTEGER | NO | ARCHIVE LOG MODE(QUIESCE) |
QVLSLC16 | QVLSLC16 | INTEGER | NO | UR chain |
QVLSLC17 | QVLSLC17 | INTEGER | NO | RURE chain |
QVLSLC18 | QVLSLC18 | INTEGER | NO | DDF resynch list |
QVLSLC19 | QVLSLC19 | INTEGER | NO | Log write |
QVLSLC20 | QVLSLC20 | INTEGER | NO | System checkpoint |
QVLSLC21 | QVLSLC21 | INTEGER | NO | Accounting rollup |
QVLSLC22 | QVLSLC22 | INTEGER | NO | Internal checkpoint |
QVLSLC23 | QVLSLC23 | INTEGER | NO | Buffer manager |
QVLSLC24 | QVLSLC24 | INTEGER | NO | EDM pool or prefetch |
QVLSLC25 | QVLSLC25 | INTEGER | NO | Workfile allocation |
QVLSLC26 | QVLSLC26 | INTEGER | NO | Dynamic statement cache |
QVLSLC27 | QVLSLC27 | INTEGER | NO | Stored procedures or authorization cache |
QVLSLC28 | QVLSLC28 | INTEGER | NO | Stored procedures or authorization cache |
QVLSLC29 | QVLSLC29 | INTEGER | NO | Field procs and DDF transaction manager |
QVLSLC30 | QVLSLC30 | INTEGER | NO | Agent services |
QVLSLC31 | QVLSLC31 | INTEGER | NO | Package authorization cache or DPS common |
QVLSLC32 | QVLSLC32 | INTEGER | NO | TCPACE serialization |
QVLSLC254 | QVLSLC254 | INTEGER | NO | Index latch |
QWSA - Address Space | ||||
QWSAEJST_DBM | QWSAEJST | DECIMAL(15, 6) | NO | Database - TCB CPU |
QWSAEJST_DIST | QWSAEJST | DECIMAL(15, 6) | NO | Job step TCB CPU for DIST address space |
QWSAEJST_IRLM | QWSAEJST | DECIMAL(15, 6) | NO | IRLM - TCB CPU |
QWSAEJST_MSTR | QWSAEJST | DECIMAL(15, 6) | NO | SSAS - TCB CPU |
QWSAEJST_SPAS | QWSAEJST | DECIMAL(15, 6) | NO | Job step TCB CPU for SPAS address space |
QWSAIIPT_DBM | QWSAIIPT | DECIMAL(15, 6) | NO | CPU time for I/O interrupt processing for DBM1 |
QWSAIIPT_DIST | QWSAIIPT | DECIMAL(15, 6) | NO | CPU time for I/O interrupt processing DIST address space |
QWSAIIPT_IRLM | QWSAIIPT | DECIMAL(15, 6) | NO | CPU time for I/O interrupt processing for IRLM |
QWSAIIPT_MSTR | QWSAIIPT | DECIMAL(15, 6) | NO | CPU time for I/O interrupt processing for MSTR |
QWSAIIPT_SPAS | QWSAIIPT | DECIMAL(15, 6) | NO | CPU time for I/O interrupt processing SPAS address space |
QWSAPSRB_DBM | QWSAPSRB | DECIMAL(15, 6) | NO | Preemptable SRB CPU for DBM1 |
QWSAPSRB_DIST | QWSAPSRB | DECIMAL(15, 6) | NO | Preemptable SRB CPU for DIST |
QWSAPSRB_IRLM | QWSAPSRB | DECIMAL(15, 6) | NO | Preemptable SRB CPU for IRLM |
QWSAPSRB_MSTR | QWSAPSRB | DECIMAL(15, 6) | NO | Preemptable SRB CPU for MSTR |
QWSAPSRB_SPAS | QWSAPSRB | DECIMAL(15, 6) | NO | Preemptable SRB CPU for SPAS |
QWSAPSRB_ZP_DBM | QWSAPSRB_ZIIP | DECIMAL(15, 6) | NO | Preemptable SRB ZIIP CPU for DBM1 |
QWSAPSRB_ZP_DIS | QWSAPSRB_ZIIP | DECIMAL(15, 6) | NO | Preemptable SRB ZIIP CPU for DIST |
QWSAPSRB_ZP_IRL | QWSAPSRB_ZIIP | DECIMAL(15, 6) | NO | Preemptable SRB ZIIP CPU for IRLM |
QWSAPSRB_ZP_MST | QWSAPSRB_ZIIP | DECIMAL(15, 6) | NO | Preemptable SRB ZIIP CPU for MSTR |
QWSAPSRB_ZP_SPA | QWSAPSRB_ZIIP | DECIMAL(15, 6) | NO | Preemptable SRB ZIIP CPU for SPAS |
QWSASRBT_DBM | QWSASRBT | DECIMAL(15, 6) | NO | Database - SRB CPU |
QWSASRBT_DIST | QWSASRBT | DECIMAL(15, 6) | NO | SRB CPU for DIST address space |
QWSASRBT_IRLM | QWSASRBT | DECIMAL(15, 6) | NO | IRLM - SRB CPU |
QWSASRBT_MSTR | QWSASRBT | DECIMAL(15, 6) | NO | SSAS - SRB CPU |
QWSASRBT_SPAS | QWSASRBT | DECIMAL(15, 6) | NO | SRB CPU for SPAS address space |
QWSB - Instrumentation Destination Data | ||||
QWSBSACT | QWSBSACT | SMALLINT | NO | SMF not active errors |
QWSBSBUF | QWSBSBUF | SMALLINT | NO | SMF buffer overrun errors |
QWSBSRNA | QWSBSRNA | SMALLINT | NO | SMF records not accepted |
QWSBSRNW | QWSBSRNW | INTEGER | NO | SMF records not written |
QWSBSRSW_SMF | QWSBSRSW | INTEGER | NO | SMF records written successfully |
QWSBSRSW_GTF | QWSBSRSW | INTEGER | NO | GTF records written successfully |
QWSBSRSW_OTH | QWSBSRSW | INTEGER | NO | Other records written successfully |
QWSBSWF | QWSBSWF | SMALLINT | NO | SMF write failures |
QWSC - Instrumentation Data | ||||
QWSCSRNW_IFC12 | QWSCSRNW | INTEGER | NO | Count IFCID 1/2 records not written |
QWSCSRNW_IFC3 | QWSCSRNW | INTEGER | NO | Count IFCID 3 records not written |
QWSCSRNW_OTH | QWSCSRNW | INTEGER | NO | Count other IFCID records not written |
QWSCSRSW_IFC12 | QWSCSRSW | INTEGER | NO | Count IFCID 1/2 records written |
QWSCSRSW_IFC3 | QWSCSRSW | INTEGER | NO | Count IFCID 3 records written |
QWSCSRSW_OTH | QWSCSRSW | INTEGER | NO | Count other IFCID records written |
QWSD - IFC Checkpoint | ||||
QWSDARIR | QWSDARIR | INTEGER | NO | Rollup accounting records failed to qualify |
QWSDARSG | QWSDARSG | INTEGER | NO | Rollup accounting records storage threshold exceeded |
QWSDARST | QWSDARST | INTEGER | NO | Rollup accounting records staleness threshold exceeded |
QWSDARTH | QWSDARTH | INTEGER | NO | Rollup accounting records threshold exceeded |
QWSDCDDD | QWSDCDDD | INTEGER | NO | Number of data capture data descriptions returned |
QWSDCDDR | QWSDCDDR | INTEGER | NO | Data capture data rows returned |
QWSDCDLC | QWSDCDLC | INTEGER | NO | Number of data capture log records retrieved |
QWSDCDLR | QWSDCDLR | INTEGER | NO | Number of data capture log reads |
QWSDCDMB | QWSDCDMB | INTEGER | NO | Number of data capture describes performed |
QWSDCDRR | QWSDCDRR | INTEGER | NO | Data capture log records returned |
QWSDCDTB | QWSDCDTB | INTEGER | NO | Number of data capture tables returned to caller |
QWSDCKPT | QWSDCKPT | INTEGER | NO | Number of checkpoints since Db2 start |
QWSDLRG | QWSDLRG | CHAR(10) | NO | High used RBA address of log |
QWSDRINV | QWSDRINV | INTEGER | NO | Reason statistics invoked |
QWSDSCA | QWSDSCA | INTEGER | NO | Count of IFI abends |
QWSDSCCO | QWSDSCCO | INTEGER | NO | Count of IFI command requests |
QWSDSCRA | QWSDSCRA | INTEGER | NO | Count of IFI READA requests |
QWSDSCRS | QWSDSCRS | INTEGER | NO | Count of IFI READS requests |
QWSDSCU | QWSDSCU | INTEGER | NO | Count of IFI unrecognized function |
QWSDSCWR | QWSDSCWR | INTEGER | NO | Count of IFI write requests |
QX - SQL Statement | ||||
QXALDAB | QXALDAB | BIGINT | NO | Number of Alter database |
QXALOCC | QXALOCC | BIGINT | NO | Number of allocate cursor statements executed |
QXALOCL | QXALOCL | BIGINT | NO | Number of associate locator statements executed |
QXALPRO | QXALPRO | BIGINT | NO | Alter procedure statements |
QXALTCTX | QXALTCTX | BIGINT | NO | Number of Alter trusted context statements executed |
QXALTIX | QXALTIX | BIGINT | NO | Number of SQL Alter index statements |
QXALTJR | QXALTJR | BIGINT | NO | Number of Alter jar statements executed |
QXALTMP | QXALTMP | BIGINT | NO | Alter mask or permission statements |
QXALTSEQ | QXALTSEQ | BIGINT | NO | Number of Alter sequences |
QXALTST | QXALTST | BIGINT | NO | Number of SQL Alter storage group statements |
QXALTTA | QXALTTA | BIGINT | NO | Number of SQL Alter Table statement |
QXALTTS | QXALTTS | BIGINT | NO | Number of SQL Alter Tablespace statements |
QXALTVW | QXALTVW | BIGINT | NO | Number of SQL Alter view statements |
QXALUDF | QXALUDF | BIGINT | NO | Alter function statements |
QXCALL | QXCALL | BIGINT | NO | SQL call statements executed |
QXCALLAB | QXCALLAB | BIGINT | NO | Stored procedure abnormal executions |
QXCALLRJ | QXCALLRJ | BIGINT | NO | SQL call statements rejected |
QXCALLTO | QXCALLTO | BIGINT | NO | Stored procedure time outs |
QXCASCDP | QXCASCDP | BIGINT | NO | Maximum nested SQL cascading |
QXCAUD | QXCAUD | BIGINT | NO | Number of user-defined functions executed |
QXCAUDAB | QXCAUDAB | BIGINT | NO | Number of user-defined function abends |
QXCAUDRJ | QXCAUDRJ | BIGINT | NO | Number of user-defined function rejects |
QXCAUDTO | QXCAUDTO | BIGINT | NO | Number of user-defined function timeouts |
QXCDIST | QXCDIST | BIGINT | NO | Create distinct type statements |
QXCLOSE | QXCLOSE | BIGINT | NO | Number of SQL close statements |
QXCMTON | QXCMTON | BIGINT | NO | Number of SQL comment on statements |
QXCON1 | QXCON1 | BIGINT | NO | Number of connect type 1 statements executed |
QXCON2 | QXCON2 | BIGINT | NO | Number of connect type 2 statements executed |
QXCOORNO | QXCOORNO | BIGINT | NO | Number of parallel groups executed on single Db2-coordinator NO |
QXCRALS | QXCRALS | BIGINT | NO | Number of create Alias statements |
QXCRATB | QXCRATB | BIGINT | NO | Create auxiliary Table statements |
QXCRCTX | QXCRCTX | BIGINT | NO | Number of create trusted context statements executed |
QXCRDAB | QXCRDAB | BIGINT | NO | Number of SQL create Db statements |
QXCREMP | QXCREMP | BIGINT | NO | Create mask or permission statements |
QXCRESEQ | QXCRESEQ | BIGINT | NO | Number of create sequences |
QXCRGTT | QXCRGTT | BIGINT | NO | Number of create global temporary table statements |
QXCRINX | QXCRINX | BIGINT | NO | Number of SQL create Index statements |
QXCRPRO | QXCRPRO | BIGINT | NO | Create procedure statements |
QXCRROL | QXCRROL | BIGINT | NO | Number of create Role statements executed |
QXCRSTG | QXCRSTG | BIGINT | NO | Number of SQL create Storage group statements |
QXCRSYN | QXCRSYN | BIGINT | NO | Number of SQL create Synonym statements |
QXCRTAB | QXCRTAB | BIGINT | NO | Number of SQL create Table statements |
QXCRTSV | QXCRTSV | BIGINT | NO | Create variable statements |
QXCRUDF | QXCRUDF | BIGINT | NO | Create function statements-SQL |
QXCTABS | QXCTABS | BIGINT | NO | Number of SQL create Tablespace statements |
QXCTRIG | QXCTRIG | BIGINT | NO | SQL create trigger statements |
QXDCLGTT | QXDCLGTT | BIGINT | NO | Number of declare global temporary table statements |
QXDDIST | QXDDIST | BIGINT | NO | Drop distinct type statements |
QXDEFVU | QXDEFVU | BIGINT | NO | Number of SQL create view statements |
QXDEGAT | QXDEGAT | BIGINT | NO | Parallel groups that fell to sequential mode |
QXDEGBUF | QXDEGBUF | BIGINT | NO | Total groups fall back due to storage/buffer pool contention |
QXDEGCUR | QXDEGCUR | BIGINT | NO | Total groups fall back due to cursor for update/delete |
QXDEGDTT | QXDEGDTT | BIGINT | NO | Number of parallel group query block using a UDF |
QXDEGENC | QXDEGENC | BIGINT | NO | Total groups fall back due to no enclave services |
QXDEGESA | QXDEGESA | BIGINT | NO | Total groups fall back due to lack ESA sort |
QXDELET | QXDELET | BIGINT | NO | Number of SQL delete statements |
QXDESC | QXDESC | BIGINT | NO | Number of SQL describe statements |
QXDROSEQ | QXDROSEQ | BIGINT | NO | Number of drop sequences |
QXDRPAL | QXDRPAL | BIGINT | NO | Number of drop alias statements |
QXDRPCTX | QXDRPCTX | BIGINT | NO | Number of drop trusted statements executed |
QXDRPDB | QXDRPDB | BIGINT | NO | Number of SQL drop database statements |
QXDRPFN | QXDRPFN | BIGINT | NO | Drop UDF statements |
QXDRPIX | QXDRPIX | BIGINT | NO | Number of SQL drop index statements |
QXDRPMP | QXDRPMP | BIGINT | NO | Create mask or permission statements |
QXDRPPKG | QXDRPPKG | BIGINT | NO | Number of drop package |
QXDRPPR | QXDRPPR | BIGINT | NO | Drop procedure statements |
QXDRPROL | QXDRPROL | BIGINT | NO | Number of drop role statements executed |
QXDRPST | QXDRPST | BIGINT | NO | Number of SQL drop storage group statements |
QXDRPSV | QXDRPSV | BIGINT | NO | Drop variable statements |
QXDRPSY | QXDRPSY | BIGINT | NO | Number of SQL drop synonym statements |
QXDRPTA | QXDRPTA | BIGINT | NO | Number of SQL drop table statements |
QXDRPTR | QXDRPTR | BIGINT | NO | SQL drop trigger statements |
QXDRPTS | QXDRPTS | BIGINT | NO | Number of SQL drop Tablespace statements |
QXDRPVU | QXDRPVU | BIGINT | NO | Number of SQL drop view statements |
QXDSCRTB | QXDSCRTB | BIGINT | NO | Number of describe table |
QXFETCH | QXFETCH | BIGINT | NO | Number of SQL fetch statements |
QXFREEL | QXFREEL | BIGINT | NO | Free locator statements |
QXGRANT | QXGRANT | BIGINT | NO | Number of SQL grant statements |
QXHJINCS | QXHJINCS | BIGINT | NO | RID append interrupted for Hybrid Join - no storage |
QXHJINCT | QXHJINCT | BIGINT | NO | RID append interrupted for Hybrid Join - internal limits |
QXHOLDL | QXHOLDL | BIGINT | NO | Hold locator statements |
QXINCRB | QXINCRB | BIGINT | NO | Number of incremental binds |
QXINSRT | QXINSRT | BIGINT | NO | Number of SQL insert statements |
QXISORR | QXISORR | BIGINT | NO | Number of parallel groups executed on single Db2-bind repeatable-read |
QXLABON | QXLABON | BIGINT | NO | Number of SQL label on statements |
QXLOCK | QXLOCK | BIGINT | NO | Number of SQL lock table statements |
QXMAXDEG | QXMAXDEG | BIGINT | NO | Maximum parallelism among groups |
QXMAXESTIDG | QXMAXESTIDG | BIGINT | NO | Estimated maximum degree for a parallel group |
QXMAXPLANDG | QXMAXPLANDG | BIGINT | NO | Planned maximum degree for a parallel group |
QXMERGE | QXMERGE | BIGINT | NO | Number of merge statements executed |
QXMIAP | QXMIAP | BIGINT | NO | Count multi index path used |
QXMRMIAP | QXMRMIAP | BIGINT | NO | Count number multi index-over max |
QXN1093A | QXN1093A | BIGINT | NO | (*) serviceability |
QXN1093B | QXN1093B | BIGINT | NO | (*) serviceability |
QXNORGRP | QXNORGRP | BIGINT | NO | Total groups executed to planned parallel degree |
QXNSMIAP | QXNSMIAP | BIGINT | NO | Count number multi index-no storage |
QXOPEN | QXOPEN | BIGINT | NO | Number of SQL open statements |
QXPAROPT | QXPAROPT | BIGINT | NO | (*) serviceability |
QXPFMAXU | QXPFMAXU | BIGINT | NO | (*) serviceability |
QXPFMAXUG | QXPFMAXUG | BIGINT | NO | (*) serviceability |
QXPFSENUM | QXPFSENUM | BIGINT | NO | (*) serviceability |
QXPFSENUMG | QXPFSENUMG | BIGINT | NO | (*) serviceability |
QXPFSLNUM | QXPFSLNUM | BIGINT | NO | (*) serviceability |
QXPREP | QXPREP | BIGINT | NO | Number of SQL prepare statements |
QXPRRESI | QXPRRESI | BIGINT | NO | Number of prepares restricted index in pending state |
QXR1BOAD | QXR1BOAD | BIGINT | NO | Times fetched 1 block |
QXREDGRP | QXREDGRP | BIGINT | NO | Total groups processed less than planned |
QXREFTBL | QXREFTBL | BIGINT | NO | Number of times table refreshed |
QXREL | QXREL | BIGINT | NO | Number of release statements executed |
QXREPOP1 | QXREPOP1 | BIGINT | NO | Parallel portion of access path reformulated-sysplex configuration |
QXREPOP2 | QXREPOP2 | BIGINT | NO | Parallel portion of access path reformulated-buffer pool |
QXREVOK | QXREVOK | BIGINT | NO | Number of SQL revoke statements |
QXRFMIAP | QXRFMIAP | BIGINT | NO | Number of times RID list processing not used |
QXRNIX | QXRNIX | BIGINT | NO | Number of rename index statements executed |
QXRNTAB | QXRNTAB | BIGINT | NO | Number of rename table statements |
QXROIIDX | QXROIIDX | BIGINT | NO | Number of direct row access used index |
QXROIMAT | QXROIMAT | BIGINT | NO | Number of direct row access to locate record |
QXROITS | QXROITS | BIGINT | NO | Number of direct row access used Tablespace scan |
QXROWTRG | QXROWTRG | BIGINT | NO | Number of row trigger activations |
QXRSDMAD | QXRSDMAD | BIGINT | NO | Number of times DM was not called for RID list retrieval |
QXRSMIAP | QXRSMIAP | BIGINT | NO | RID multiple index access skipped because not necessary |
QXRWSDELETD | QXRWSDELETD | BIGINT | NO | Total rows deleted |
QXRWSFETCHD | QXRWSFETCHD | BIGINT | NO | Total rows fetched |
QXRWSINSRTD | QXRWSINSRTD | BIGINT | NO | Total rows inserted |
QXRWSINSRTDALG1 | QXRWSINSRTDALG1 | BIGINT | NO | Insert algorithm type 1 |
QXRWSINSRTDALG2 | QXRWSINSRTDALG2 | BIGINT | NO | Insert algorithm type 2 |
QXRWSUPDTD | QXRWSUPDTD | BIGINT | NO | Total rows updated |
QXSELECT | QXSELECT | BIGINT | NO | Number of SQL select statements |
QXSETCDG | QXSETCDG | BIGINT | NO | Number of set current degree statements executed |
QXSETCON | QXSETCON | BIGINT | NO | Number of set connection statements executed |
QXSETCPR | QXSETCPR | BIGINT | NO | Number of set current precision statements executed |
QXSETCRL | QXSETCRL | BIGINT | NO | Number of set current rules statements executed |
QXSETHV | QXSETHV | BIGINT | NO | Number of set host variable |
QXSETPTH | QXSETPTH | BIGINT | NO | Number of SQL set current path statements |
QXSETSQL | QXSETSQL | BIGINT | NO | Number of set current SQLID statements |
QXSISTOR | QXSISTOR | BIGINT | NO | Times sparse index disabled |
QXSIWF | QXSIWF | BIGINT | NO | Times sparse index built workflow for probing |
QXSTARRAY_EXP | QXSTARRAY_EXPANSION | BIGINT | NO | Array variables expanded greater than 32k |
QXSTCWLD | QXSTCWLD | BIGINT | NO | Number of times duplicate dynamic statements created |
QXSTCWLM | QXSTCWLM | BIGINT | NO | Number of times matching reusable statements found |
QXSTCWLP | QXSTCWLP | BIGINT | NO | Number of statements parsed due to concentrate |
QXSTCWLR | QXSTCWLR | BIGINT | NO | Number of times dynamic statements replaced |
QXSTDEXP | QXSTDEXP | BIGINT | NO | Number of discarded prepares - MAXKEEPD |
QXSTDINV | QXSTDINV | BIGINT | NO | Number of discarded prepares - DROP/ALTER/REVOKE |
QXSTEHLST | QXSTEHLST | BIGINT | NO | Number of execution history lost |
QXSTFND | QXSTFND | BIGINT | NO | Number of satisfied prepare request - made cache copy |
QXSTHVLST | QXSTHVLST | BIGINT | NO | Number of HV recording lost in execution history |
QXSTIPRP | QXSTIPRP | BIGINT | NO | Number of KEEPDYNAMIC(YES) implicit prepares |
QXSTLOBV | QXSTLOBV | BIGINT | NO | Maximum MB storage for LOB values |
QXSTMLSFND | QXSTMLSFND | BIGINT | NO | Number of times Db2zai stabilized prepare |
QXSTMLSRT | QXSTMLSRT | BIGINT | NO | Number of times Db2zai sort feedback used |
QXSTNFND | QXSTNFND | BIGINT | NO | Number of failed searches prepare cache |
QXSTNPRP | QXSTNPRP | BIGINT | NO | Number of KEEPDYNAMIC(YES) cache copy found |
QXSTODGNGRP | QXSTODGNGRP | BIGINT | NO | Parallel groups degenerated to sequential |
QXSTOREDGRP | QXSTOREDGRP | BIGINT | NO | Parallel group degree reduced |
QXSTSFND | QXSTSFND | BIGINT | NO | Prepares satisfied from SYSDYNQRY |
QXSTSRT | QXSTSRT | BIGINT | NO | Number of RDS sort performed |
QXSTSRTL | QXSTSRTL | BIGINT | NO | Number of RDS sort used IBM integrated accelerator |
QXSTTIMEOUTAPPL | QXSTTIMEOUTFROMAPPL | BIGINT | NO | Number of set current lock timeout SQL executed |
QXSTTIMEOUTPROF | QXSTTIMEOUTFROMPROF | BIGINT | NO | Number of set current lock timeout SQL executed DSN_PROFILE_TABLE |
QXSTTRG | QXSTTRG | BIGINT | NO | Number of statement trigger activations |
QXSTXMLV | QXSTXMLV | BIGINT | NO | Number of maximum storage used for XML values |
QXTOTGRP | QXTOTGRP | BIGINT | NO | Total parallel groups executed |
QXTRGERR | QXTRGERR | BIGINT | NO | Number of row trigger SQL errors |
QXTRNOWN | QXTRNOWN | BIGINT | NO | Number of transfer ownership |
QXTRTBL | QXTRTBL | BIGINT | NO | Number of truncate table statements executed |
QXUPDTE | QXUPDTE | BIGINT | NO | Number of SQL update statements |
QXWFRIDS | QXWFRIDS | BIGINT | NO | RIDs overflown to work flow - no storage |
QXWFRIDT | QXWFRIDT | BIGINT | NO | RIDs overflown to work flow - internal limits |
QXXCBPNX | QXXCBPNX | BIGINT | NO | Number of parallel groups intended across data share group |
QXXCSKIP | QXXCSKIP | BIGINT | NO | Number of parallel coordinator bypass Db2 - buffer pool storage |
LOCATION_L | QWHSLOCN_VAR | VARCHAR(128) | NO | Local location name |