.
Accounting detail and summary tables (DMRACxxx)
One accounting record is created from each SMF 101 record that is received.
Each row in the DMRACDTL table represents one transaction or thread within Db2, or the number of DDF/RRSAF threads represented by one rollup accounting record.
Each row in a DMRACSUM or DMRACSM2 table represents the aggregate number of the threads summarized according to the defined summary keys for the defined summary interval. For the DMRACSUM or DMRACSM2 tables, nonsummary key IDs are set to the last value processed, counts are totals, and any snapshot values are set to maximums.
The number of threads in either type of table is in the column TRANSCNT. The interval for a summary table is in column INTERVAL.
The following table describes the columns in the DMRACSUM and DMRACSM2 tables.
Performance Report Column Name | SMF Field Name | Used in Report | Field Type | Description |
|---|---|---|---|---|
DMRTABLEVERSION | Not applicable | NO | Char(8) | Version of BMC AMI Ops Monitor for Db2 Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | NO | Char(8) | Version of BMC AMI OpsM for Db2 Performance Reporter that created or modified the row |
SYSTEMID | SM101SID | YES | Char(4) | System ID (SMF ID) |
SUBSYSTEM | SM101SSI | YES | Char(4) | Subsystem ID (Db2 subsystem name) |
CLASS2CNT | None | YES | Integer | Count of transactions with Db2 SMF CLASS2 traces active |
CLASS3CNT | None | YES | Integer | Count of transactions with Db2 SMF CLASS3 traces active |
QWHC - Correlation Header | ||||
PLANNAME | QWHCPLAN | YES | Char(8) | Plan name |
AUTHID | QWHCAID | YES | Char(8) | Authorization ID |
AUTHID_L | QWHCAID | NO | Varchar(128) | Long name version of the authorization ID |
CONNECTION | QWHCCN | YES | Char(8) | Connection name |
CORRID | QWHCCV | YES | Char(12) | Correlation ID |
CORRTOKN_L | QWHCCTKN_Var | NO | Varchar(128) | Correlation token |
ORIGPRIMID | QWHCOPID | YES | Char(8) | Original primary authorization ID |
CONNTYPE | QWHCATYP | YES | Char(8) | One of the following connection types, based on the value in QWHCATYP:
|
ALLIEDCNT | QWHCATYP | NO | Integer | 1 if not DBAT; includes ALLIEDDISTCNT |
ALLIEDDISTCNT | QWHCATYP | NO | Integer | 1 if not DBAT but QLAC data present |
DBATCNT | QWHCATYP | NO | Integer | 1 if DBAT and single QLAC; includes DBATDISTCNT |
DBATDISTCNT | QWHCATYP | NO | Integer | 1 if DBAT and > 1 QLAC |
ACCTTOKN | QWHCTOKN | YES | Char(22) | Accounting token for CICS This field applies to the CICS Attachment Facility, RRSAF, and database access threads. For database access threads, this is the value that is received from the requester system. If the connection to the requester system is through Db2 private protocols, this accounting value is identical to the accounting value used at the requester system. If the connection to the requester system is through DRDA protocols, this accounting value is determined from the first 22 bytes of the correlation token (CRRTKN) value of the access relational database (ACCRDB) command received from the requester system during connect processing. |
ENDUSERID | QWHCEUID | NO | Char(16) | Optional work station end user ID This ID can be different from the authorization ID used to connect to Db2. This field contains blanks if the client did not supply this information. |
ENDUSERID_L | QWHCEUID_Var | NO | Varchar(128) | Longname version of optional work station end user ID This ID can be different from the authorization ID used to connect to Db2. This field contains blanks if the client did not supply this information. |
ENDUSERTX | QWHCEUTX | NO | Char(32) | Optional end user's transaction or application name that identifies the application that is currently running, not the product that is used to run the application This field contains blanks if the client did not supply this information. |
ENDUSERTX_L | QWHCEUTX_Var | NO | Varchar(255) | Longname version of optional end user's transaction or application name that identifies the application that is currently running, not the product that is used to run the application This field contains blanks if the client did not supply this information. |
ENDUSERWN | QWHCEUWN | NO | Char(18) | Optional end user's workstation name This field contains blanks if the client did not supply this information. |
ENDUSERWN_L | QWHCEUWN_Var | NO | Varchar(255) | Longname version of optional end user's workstation name This field contains blanks if the client did not supply this information. |
TRACEMASK | QWHSMTN | NO | Integer | Active trace mask |
PSTNUMBER | QWHCCV | YES | Char(4) | PST number - IMS only |
PSBNAME | QWHCCV | YES | Char(8) | PSB name - IMS only |
CICSTRAN | QWHCCV | YES | Char(4) | Transaction code - CICS only |
CORRNAME | QWHCCV | YES | Char(8) | User ID, Jobname, CICS TRNID, or IMS PSBNAME |
CONTEXTNAME | QWHCTCXT | NO | Varchar(128) | Trusted context name |
ROLENAME | QWHCROLE | NO | Varchar(128) | Role name associated with authid |
ORIGAPPLAUTH | QWHCOAUD | NO | Varchar(128) | Original application user ID |
ORIGAPPLUSER_L | QWHCOAUD | NO | Varchar(128) | Original application USERID |
ORIGPRIMID_L | QWHCOPID | NO | Varchar(128) | Original operator ID |
QWHS - Standard Header | ||||
DB2VERSION | QWHSRN QWHSSUBV | NO | Char(6) | Version of Db2 that created the record For versions of Db2 before 8.1, a value of 0000 is used for QWHSSUBV because the field was not defined. |
LUWIDNID | QWHSNID | YES | Char(8) | LUWID - Network ID |
LUWIDLUNM | QWHSLUNM | YES | Char(8) | LUWID - Logical unit name |
LUWIDINST | QWHSLUUV | YES | Char(6) | LUWID - Instance ID |
LUWIDCOMIT | QWHSLUCC | YES | Real | LUWID - Commit count |
YEAR | QWHSSTCK | YES | Char(4) | Year record was created |
LOCATION | QWHSLOCN | YES | Char(16) | Local location name (Db2 subsystem ID if not defined) |
IFCIDSEQ# | QWHSISEQ | NO | Integer | IFCID sequence number |
ACEADDR | QWHSACE | NO | Integer | ACE address – Dispatch unit address |
QWAC - Accounting Record Instrumentation | ||||
DATETIME | QWACESC | YES | Time stamp | Date and time record was created |
DATE | QWACESC | YES | Date | Date record was created |
MONTH | QWACESC | YES | Char(2) | Month record was created |
DAY | QWACESC | YES | Char(2) | Day record was created |
TIME | QWACESC | YES | Time | Time record was created |
HOUR | QWACESC | YES | Char(2) | Hour record was created |
DAYOFWEEK# | QWACESC | NO | Smallint | Relative day of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWACESC | NO | Char(3) | MON, TUE, WED, THU, FRI, SAT, SUN |
WEEK# | QWACESC | NO | Integer | Week number relative to the 1 January 1900 epoch |
ROLLUPTERMCNT | QWACPCNT | NO | Integer | Number of parallel tasks or utility subtasks created for the originating task or main utility task (for DDF/RRSAF rollup transactions) For parallel tasks or utility subtasks, this value is zero. |
NETWORKID | QWACNID | YES | Char(16) | Network ID |
LATCHCNTWTP | QWACAWTP | YES | Decimal(15,6) | Accumulated wait time because of page latch contention (accounting or monitor class 3) |
LATCHCNTRNH | QWACARNH | YES | Real | Number of wait trace events processed for page latch contention (accounting or monitor class 3) |
GBLMSGELAP | QWACAWTG | YES | Decimal(15,6) | Data sharing elapsed wait time sending messages |
GBLMSGEVNT | QWACARNG | YES | Real | Data sharing waits sending messages |
GBLLOKELAP | QWACAWTJ | YES | Decimal(15,6) | Data sharing elapsed wait time global lock contention |
GBLLOKEVNT | QWACARNJ | YES | Real | Data sharing waits for global lock contention |
SPTCB | QWACSPCP | YES | Decimal(15,6) | TCB time processing SQL calls in a WLM address space |
SPTCBINDB2 | QWACSPTT | YES | Decimal(15,6) | Stored procedure TCB time in Db2 (accounting class 2) |
SPEVNT | QWACSPNE | YES | Real | Stored procedure SQL entry or exit events |
SPWAITELAP | QWACCAST | YES | Decimal(15,6) | Stored procedure elapsed time waiting for TCB |
SPWAITCNT | QWACCANM | YES | Real | Stored procedure waits for a TCB |
PARATASKS | QWACPCNT | YES | Real | Parallel tasks or utility subtasks created for an originating parallel task or utility main task |
PARALLTASKS | QWACPCNT | NO | Integer | 1 if CPU or I/O parallelism used; otherwise 0 |
PACEADDR | QWACPACE | NO | Integer | For non-rollup parent record = 0 For non-rollup child agent record = QWHSACE of parent record For parallel query rollup record = QWHSACE of parent record For autonomous procedures rollup record = QWHS of parent record For DDF/RRSAF rollup record = No meaning |
CPUSUCONV | QWACSUCV | NO | Integer | CPU service unit conversion factor |
LOGWRTEVNT | QWACARLG | NO | Real | Number of wait trace events processed for waits for log write I/O |
LOGWRTELAP | QWACAWLG | NO | Decimal(15,6) | Accumulated wait time for log write I/O |
WLMSVCCLASS | QWACWLME | NO | Char(8) | MVS workload manager service class name This field is used only for database access threads on MVS 5.2 or later. In all other cases, this field contains binary zeroes. The WLM service class determines the MVS WLM priority of the work performed by the database access thread. |
LOGRECORDS | QWACLRN | NO | Real | Number of log records written The amount of logging for a thread can exceed the amount of logging for units of recovery because the logging for a thread includes logging of actions performed by Db2 on behalf of the thread. |
LOGBYTES | QWACRAB | NO | Real | Total number of bytes of log records written |
FUNCTCB | QWACUDCP | NO | Decimal(15,6) | Accumulated TCB time used to satisfy user-defined function requests processed in a Db2 stored procedures address space or WLM established address space |
FUNCSQLTCB | QWACUDTT | NO | Decimal(15,6) | Accumulated TCB time in Db2 for processing SQL statements issued by user-defined functionsThis time is not included in QWACUDCP. |
FUNCSQLEVNT | QWACUDNE | NO | Real | Number of SQL entry/exit events performed by user-defined functions |
FUNCWAIT | QWACUDST | NO | Decimal(15,6) | Total elapsed time spent waiting for an available TCB before the user-defined function could be scheduled |
FUNCELAP | QWACUDEA | NO | Decimal(15,6) | Total elapsed time spent in user-defined functions, including time spent executing SQL |
FUNCSQLELAP | QWACUDEB | NO | Decimal(15,6) | Total elapsed time spent for user-defined functions to execute SQL |
TRIGGERTCB | QWACTRTT | NO | Decimal(15,6) | Accumulated TCB time used while executing under the control of triggers (does not include zIIP CPU time) |
TRIGGERELAP | QWACTRET | NO | Decimal(15,6) | Accumulated elapsed time used while executing under the control of triggers |
PREENCTCB | QWACPECT | NO | Decimal(15,6) | Accumulated TCB time used before the enclave is created |
PREENCSQLTCB | QWACPECD | NO | Decimal(15,6) | Accumulated CPU time used for Db2 to process SQL statements before the enclave is created |
SPROCELAP | QWACSPEA | NO | Decimal(15,6) | Total elapsed time spent in stored procedures, including time spent executing SQL |
SPROCSQLELAP | QWACSPEB | NO | Decimal(15,6) | Total elapsed time spent executing SQL in stored procedures |
ENCTRIGGERTCB | QWACTRTE | NO | Decimal(15,6) | Trigger under enclave TCB time |
ENCTRIGGERELAP | QWACTREE | NO | Decimal(15,6) | Trigger under enclave elapsed time |
NORMTERMCNT | QWACRINV | NO | Integer | Normal termination - 1 if QWACRINV = 4-16 |
ABNORMTERMCNT | QWACRINV | NO | Integer | Abnormal termination - 1 if QWACRINV > 16 |
SVPOINTREQ | QWACSVPT | NO | Real | Savepoint requests |
SVPOINTREL | QWACRLSV | NO | Real | Release savepoint requests |
SVPOROLLBK | QWACRBSV | NO | Real | Rollback savepoint requests |
WTELAWTK | QWACAWTK | NO | Decimal(15,6) | Wait time for global contention for child L-locks |
WTELAWTM | QWACAWTM | NO | Decimal(15,6) | Wait time for global contention for other L-locks |
WTELAWTN | QWACAWTN | NO | Decimal(15,6) | Wait time for global contention for pageset/partition P-locks |
WTELAWTO | QWACAWTO | NO | Decimal(15,6) | Wait time for global contention for page P-locks |
WTELAWTQ | QWACAWTQ | NO | Decimal(15,6) | Wait time for global contention for other P-locks |
WTEVARNK | QWACARNK | NO | Real | Number of events with global contention for child L-locks |
WTEVARNM | QWACARNM | NO | Real | Number of events with global contention for other L-locks |
WTEVARNN | QWACARNN | NO | Real | Number of events with global contention for pageset/partition P-locks |
WTEVARNO | QWACARNO | NO | Real | Number of events with global contention for page P-locks |
WTEVARNQ | QWACARNQ | NO | Real | Number of events with global contention for other P-locks |
THDSTART | QWACBSC | YES | Time stamp | Beginning store-clock time |
ELAPSETOD | QWACBSC QWACESC | YES | Decimal(15,6) | Elapsed time |
ELAPSETCB | QWACBJST QWACEJST QWACSPCP QWACUDCP QWACTRTT QWACTRTE | YES | Decimal(15,6) | TCB CPU time, including stored procedures, triggers, and user-defined functions (does not include zIIP CPU time) |
ELAPSESRB | QWACBSRB QWACESRB | YES | Decimal(15,6) | SRB CPU time |
REASON | QWACRINV | YES | Integer | Reason accounting invoked |
P2COMMITS | QWACCOMM | YES | Real | Phase 2 or single-phase commits (sync) |
ABORTS | QWACABRT | YES | Real | Aborts |
EDB2TOD | QWACASC, QWACSPEB, QWACUDEB, QWACTREE, QWACTRET | YES | Decimal(15,6) | Elapsed Db2 time, including stored procedures, triggers, and user-defined functions |
EDB2TCB | QWACAJSTQWACSPTT QWACUDTT QWACTRTT QWACTRTE | YES | Decimal(15,6) | TCB CPU in Db2, including stored procedures, triggers, and user-defined functions (does not include zIIP CPU time) |
EDB2SRB | QWACASRB | YES | Decimal(15,6) | SRB CPU in Db2 (not used in Db2 6.1 and later) |
EWAITIO | QWACAWTI | YES | Decimal(15,6) | Elapsed wait for synchronous I/O Log waits are not included in this field. |
EWAITLAL | QWACAWTL | YES | Decimal(15,6) | Elapsed wait for lock or latch |
ENTEXEVNT | QWACARNA | YES | Real | Number of Db2 exit/entry events |
WAITEVNT | QWACARNE | YES | Real | Wait events for synchronous I/O Log waits are not included in this field. |
WAITREADIO | QWACAWTR | YES | Decimal(15,6) | Elapsed wait for other read I/O |
WAITWRITEIO | QWACAWTW | YES | Decimal(15,6) | Elapsed wait for other write I/O |
WAITSYNCEVENT | QWACAWTE | YES | Decimal(15,6) | Elapsed wait for unit switch Data set waits are not included in this field. |
WEVLOCK | QWACARNL | YES | Real | Wait events for lock/latch |
WEVREAD | QWACARNR | YES | Real | Wait events for other read |
WEVWRITE | QWACARNW | YES | Real | Wait events for other write |
WEVSYNCH | QWACARNS | YES | Real | Wait events for unit switch Data set waits are not included in this field. |
LOBWAITCNT | QWACALBC | NO | Real | Number of waits for LOB TCP/IP initialization events |
LOBWAITELAP | QWACALBW | NO | Decimal (15, 6) | Elapsed time waiting for LOB TCP/IP initialization |
ACCELWAITEVENTS | QWACAACC | NO | Real | Number of wait trace event processed for requests to an accelerator |
ACCELWAITTIME | QWACAACW | NO | Decimal(15,6) | Accumulated wait time for requests to an accelerator |
AUTOPROCCNT | QWAC_AT_COUNT | NO | Real | For non-rollup records = the number of autonomous procedures executed For autonomous procedure rollup records = 0 For a DDF/RRSAF rollup records = the number of autonomous procedures executed. These procedures are NOT counted in QWACPCNT |
AUTOPROCWAIT | QWAC_AT_WAIT | NO | DECIMAL(15,6) | Accumulated time waiting for autonomous procedures to complete |
CLASS1CPU_SE_SP | QWACSP_CLS1se | NO | DECIMAL(15,6) | The accumulated CPU time used to satisfy stored procedure requests processed in a DB2 stored procedure or WLM address space while executing on an IBM specialty engine. |
CLASS1CPU_SE_UDF | QWACUDF_CLS1se | NO | DECIMAL(15,6) | The accumulated CPU time used to satisfy UDF requests processed in a DB2 stored procedure or WLM address space while executing on an IBM specialty engine. |
CLASS2CPU_SE_SP | QWACSP_CLS2se | NO | DECIMAL(15,6) | The accumulated CPU time consumed in DB2 processing SQL statements issued by stored procedures processed in a DB2 stored procedure or WLM address space while executing on an IBM specialty engine. |
CLASS2CPU_SE_UDF | QWACUDF_CLS2se | NO | DECIMAL(15,6) | The accumulated CPU time consumed in DB2 processing SQL statements issued by UDFs processed in a DB2 stored procedure or WLM address space while executing on an IBM specialty engine. |
CURWORKFILEBLKS | QWAC_WORKFILE_CURR | NO | BIGINT | Current number of work file blocks being used by this agent (traditional work file use, DGTT and DGTT indexes) |
ELIGDB2ACCELCPU | QWAC_ACCEL_ELIG_CP | NO | DECIMAL(15,6) | The accumulated CPU time spent processing SQL in DB2 that may be eligible for execution on an accelerator this value does not include time spent processing on an IBM specialty engine |
ELIGDB2ACCELELAP | QWAC_ACCEL_ELIG_ELA | NO | DECIMAL(15,6) | The accumulated elapsed time spent processing SQL in DB2 that may be eligible for execution on an accelerator |
ELIGDB2ACCELSE | QWAC_ACCEL_ELIG_SE | NO | DECIMAL(15,6) | The accumulated CPU time consumed on an IBM specialty engine processing SQL in DB2 that may be eligible for execution on an accelerator |
LATCHWAITCNT | QWACARLH | NO | Real | Number of wait trace events processed for waits for latch contention |
LATCHWAITCONT | QWACAWLH | NO | DECIMAL(15,6) | Accumulated wait time due to latch contention |
LOGBYTESWRITTEN | QWACLRAB | NO | BIGINT | Bytes logged |
LOGBYTEX | QWACLRAB | NO | CHAR(6) | Log bytes written (HEX) |
MAXWORKFILEBLKS | QWAC_WORKFILE_MAX | NO | BIGINT | Maximum number of work file blocks being used by this agent at any given point in time (traditional work file use, DGTT and DGTT indexes) |
PARSYNCCOUNT | QWAC_PQS_COUNT | NO | Real | Number of times a parallel query processing had to suspend waiting for parent/child to synchronize |
PARSYNCWAIT | QWAC_PQS_WAIT | NO | DECIMAL(15, 6) | Accumulated time waiting for parallel queries to synchronize between parent and child tasks |
PROGRAMS | QWACPKGN | NO | SMALLINT | Number of packages for which the appropriate traces were active and therefore, package level accounting was performed. |
ROLLUPCOUNT | QWAC_PT_COUNT | NO | Real | 1. For all non-rollup records = 0 |
SPNFCPU | QWACSPNF_CP | NO | DECIMAL(15, 6) | Accumulated CPU time consumed executing stored procedure requests on the main application execution unit. This time does not include CPU consumed on an IBM specialty engine. |
SPNFCPUZIIP | QWACSPNF_ZIIP | NO | DECIMAL(15, 6) | Accumulated CPU time consumed executing stored procedure requests on the main application execution unit on an IBM specialty engine |
SPNFELAP | QWACSPNF_ELAP | NO | DECIMAL(15, 6) | Accumulated elapsed time consumed executing stored procedure requests on the main application execution unit. |
TRTE_CPU_SE | QWACTRTE_se | NO | DECIMAL(15, 6) | The accumulated CPU time consumed on an IBM specialty engine while executing triggers on a nested task |
UDFNFCPU | QWACUDFNF_CP | NO | DECIMAL(15, 6) | Accumulated CPU time consumed executing user defined functions on the main application execution unit on an IBM specialty engine. |
UDFNFCPUZIIP | QWACUDFNF_ZIIP | NO | DECIMAL(15, 6) | Accumulated CPU time consumed executing user defined functions on the main application execution unit on an IBM specialty engine. |
UDFNFELAP | QWACUDFNF_ELAP | NO | DECIMAL(15, 6) | Accumulated elapsed time consumed executing user defined functions on the main application execution unit. |
QWAX - Accounting Class 3 | ||||
ARCLOG | QWAXALCT | YES | Real | Wait events for archive log quiesce |
DRAINLKRND | QWAXARND | YES | Real | Wait events for drain locks (accounting or monitor class 3) |
DRAINLKWDR | QWAXAWDR | YES | Decimal(15,6) | Elapsed wait time for a drain lock (accounting or monitor class 3) |
CLAIMRLWCL | QWAXAWCL | YES | Decimal(15,6) | Elapsed wait time for a drain when waiting for claims to be released (accounting or monitor class 3) |
CLAIMRLRNC | QWAXARNC | YES | Real | Wait events processed for waits for claims to be released (accounting or monitor class 3) |
ARCHREADWAR | QWAXAWAR | YES | Decimal(15,6) | Elapsed wait for an archive read from tape (accounting or monitor class 3) |
ARCHREADNAR | QWAXANAR | YES | Real | Wait events processed for archive read (accounting or monitor class 3) |
OPENCLSELAP | QWAXOCSE | NO | Decimal(15,6) | Accumulated wait time for a synchronous execution unit switch to the Db2 OPEN/CLOSE data set service or the HSM recall service |
SYSLGRNGELAP | QWAXSLSE | NO | Decimal(15,6) | Accumulated wait time for a synchronous execution unit switch to the Db2 SYSLGRNG recording service This service is also sometimes used for level ID checking for down-level detection. |
DATASETELAP | QWAXDSSE | NO | Decimal(15,6) | Accumulated wait time for a synchronous execution unit switch to the Db2 data space manager services, which include define data set, extend data set, delete data set, reset data set, and VSAM catalog access |
OTHERSWELAP | QWAXOTSE | NO | Decimal(15,6) | Accumulated wait time for a synchronous execution unit switch to other Db2 service tasks |
OPENCLSEVNT | QWAXOCNS | NO | Real | Number of wait trace events processed for waits for synchronous execution unit switching to the OPEN/CLOSE service |
SYSLGRNGEVNT | QWAXSLNS | NO | Real | Number of wait trace events processed for waits for synchronous execution unit switching to the SYSLGRNG recording service |
DATASETEVNT | QWAXDSNS | NO | Real | Number of wait trace events processed for waits for synchronous execution unit switching to the data space manager service tasks |
OTHERSWEVNT | QWAXOTNS | NO | Real | Number of wait trace events processed for waits for synchronous execution unit switching to other service tasks |
WTELAWFC | QWAXAWFC | NO | Decimal(15,6) | Wait time for force-at-commit |
WTEVFCCT | QWAXFCCT | NO | Real | Number of events with force-at-commit |
WTELIXLT | QWAXIXLT | NO | Decimal(15,6) | Wait time for asynchronous group buffer pool requests (IXLCACHE + IXLFCOMP) |
WTEVIXLE | QWAXIXLE | NO | Real | Number of events with asynchronous group buffer pool requests (IXLCACHE + IXLFCOMP) |
LOBCOMPWAITCNT | QWAX_LOBCOMP_COUNT | NO | Real | Number of wait trace events processed for LOB compression |
LOBCOMPWAITTIM | QWAX_LOBCOMP_WAIT | NO | DECIMAL(15, 6) | Accumulated wait time for LOB compression |
PIPEWAITCNT | QWAX_PIPEWAIT_COUNT | NO | Real | Number of wait trace events processed for |
PIPEWAITTIM | QWAX_PIPE_WAIT | NO | DECIMAL(15, 6) | Accumulated wait time for pipe wait |
QX - SQL Statement | ||||
SETCURPREC | QXSETCPR | NO | Real | SET CURRENT PRECISION statements |
DCLGLOBALTT | QXDCLGTT | NO | Real | DECLARE GLOBAL TEMPORARY TABLE statements |
PARAGLOBALTT | QXDEGDTT | NO | Real | Parallel groups using DECLARE TEMPORARY TABLE |
SELECTS | QXSELECT | YES | Real | Number of SELECT statements |
INSERTS | QXINSRT | YES | Real | Number of INSERT statements |
UPDATES | QXUPDTE | YES | Real | Number of UPDATE statements |
DELETES | QXDELET | YES | Real | Number of DELETE statements |
DESCRIBES | QXDESC | YES | Real | Number of DESCRIBE statements |
PREPARES | QXPREP | YES | Real | Number of PREPARE statements |
OPENS | QXOPEN | YES | Real | Number of OPEN statements |
FETCHES | QXFETCH | YES | Real | Number of FETCH statements |
CLOSES | QXCLOSE | YES | Real | Number of CLOSE statements |
CREATETBL | QXCRTAB | YES | Real | Number of CREATE TABLE statements |
CREATEINDX | QXCRINX | YES | Real | Number of CREATE INDEX statements |
CREATETSP | QXCTABS | YES | Real | Number of CREATE TABLESPACE statements |
CREATESYN | QXCRSYN | YES | Real | Number of CREATE SYNONYM statements |
CREATEDB | QXCRDAB | YES | Real | Number of CREATE DATABASE statements |
CREATESG | QXCRSTG | YES | Real | Number of CREATE STORAGE GROUP statements |
CREATEVU | QXDEFVU | YES | Real | Number of CREATE VIEW statements |
DROPINDX | QXDRPIX | YES | Real | Number of DROP INDEX statements |
DROPTBL | QXDRPTA | YES | Real | Number of DROP TABLE statements |
DROPTSP | QXDRPTS | YES | Real | Number of DROP TABLESPACE statements |
DROPDB | QXDRPDB | YES | Real | Number of DROP DATABASE statements |
DROPSYN | QXDRPSY | YES | Real | Number of DROP SYNONYM statements |
DROPSG | QXDRPST | YES | Real | Number of DROP STORAGE GROUP statements |
DROPVU | QXDRPVU | YES | Real | Number of DROP VIEW statements |
ALTERSG | QXALTST | YES | Real | Number of ALTER STORAGE GROUP statements |
ALTERTSP | QXALTTS | YES | Real | Number of ALTER TABLESPACE statements |
ALTERTBL | QXALTTA | YES | Real | Number of ALTER TABLE statements |
ALTERINDX | QXALTIX | YES | Real | Number of ALTER INDEX statements |
COMMENTON | QXCMTON | YES | Real | Number of COMMENT ON statements |
LOCKTBL | QXLOCK | YES | Real | Number of LOCK TABLE statements |
GRANTS | QXGRANT | YES | Real | Number of GRANT statements |
REVOKES | QXREVOK | YES | Real | Number of REVOKE statements |
INCRBINDS | QXINCRB | YES | Real | Number of incremental BIND statements |
LABELON | QXLABON | YES | Real | Number of LABEL ON statements |
SETSQLID | QXSETSQL | YES | Real | Number of SET SQLID statements |
CREATEALIAS | QXCRALS | YES | Real | Number of CREATE ALIAS statements |
DROPALIAS | QXDRPAL | YES | Real | Number of DROP ALIAS statements |
MULTINDEXYES | QXMIAP | YES | Real | Number of multi-index paths |
MULTINDEXNOS | QXNSMIAP | YES | Real | Number of multi-index no storage |
MULTINDEXNOM | QXMRMIAP | YES | Real | Number of multi-index over maximum |
SETHOSTV | QXSETHV | YES | Real | Number of SET host variable statements |
ALTERDB | QXALDAB | YES | Real | Number of ALTER DATABASE statements |
DROPPKG | QXDRPPKG | YES | Real | Number of DROP PACKAGE statements |
DESCRBTABL | QXDSCRTB | YES | Real | Number of DESCRIBE TABLE statements |
PARAMAXDEG | QXMAXDEG | YES | Integer | Maximum degree of parallel I/O processing executed among parallel groups |
PARATOTGRP | QXTOTGRP | YES | Real | Number of parallel groups executed |
PARADEGCUR | QXDEGCUR | YES | Real | Number of parallel groups that fell back to sequential operation because of a cursor that can be used for UPDATE or DELETE |
PARADEGESA | QXDEGESA | YES | Real | Number of parallel groups that fell back to sequential operation because of a lack of ESA sort support |
PARADEGBUF | QXDEGBUF | YES | Real | Number of parallel groups that fell back to sequential operation because of storage shortage or contention on the buffer pool |
PARAREDGRP | QXREDGRP | YES | Real | Number of parallel groups processed to a parallel degree less than planned because of a storage shortage or contention on the buffer pool |
PARANORGRP | QXNORGRP | YES | Real | Number of parallel groups executed to the planned parallel degree |
PARACON1NO | QXCON1 | YES | Real | Number of CONNECT TYPE 1 statements executed |
PARACON2NO | QXCON2 | YES | Real | Number of CONNECT TYPE 2 statements executed |
PARARELNO | QXREL | YES | Real | Number of RELEASE statements executed |
PARASETCON | QXSETCON | YES | Real | Number of SET CONNECTION statements executed |
PARASETCDG | QXSETCDG | YES | Real | Number of SET CURRENT DEGREE statements executed |
PARADEGENC | QXDEGENC | YES | Real | Fallback to sequential because MVS/ESA enclave services not available |
PARARLFDISABLE | QXRLFDPA | YES | Real | query parallelism disabled by RLF |
SETCURRULES | QXSETCRL | YES | Real | Set current rules statements executed |
SQLCALL | QXCALL | YES | Real | SQL call statements executed |
SQLCALLAB | QXCALLAB | YES | Real | Stored procedure abnormal executions |
SQLCALLTO | QXCALLTO | YES | Real | Stored procedure time outs |
SQLCALLRJ | QXCALLRJ | YES | Real | SQL call statements rejected |
PARACOORNO | QXCOORNO | NO | Real | Total number of parallel groups executed on a single Db2 due to one of the following reasons: When the plan or package was bound, the coordinator subsystem parameter was set to YES, but the parameter is set to NO when the program runs The plan or package was bound on a Db2 with the coordinator subsystem parameter set to YES, but the program is being run on a different Db2 that has the coordinator value set to NO |
PARAISORR | QXISORR | NO | Real | Total number of parallel groups executed on a single Db2 because the plan or package was bound with an isolation value of repeatable read |
SQLCRGTT | QXCRGTT | NO | Real | Number of CREATE GLOBAL TEMPORARY TABLE statements |
REOPTIMIZE | QXSTREOP | NO | Real | Number of times reoptimization occurred |
PARAXDSGRP | QXXCBPNX | NO | Real | Number of parallel groups Db2 intended to run across the data sharing group |
PARACSKIP | QXXCSKIP | NO | Real | Number of times the parallelism coordinator had to bypass a Db2 when distributing tasks because there was not enough buffer pool storage on one or more Db2 members |
ASSOCLOCR | QXALOCL | NO | Real | Number of associate locator statements executed |
ALLOCCUR | QXALOCC | NO | Real | Number of allocate cursor statements executed |
PREPFND | QXSTFND | NO | Real | Number of times Db2 satisfied a PREPARE request by making a copy of a statement in the prepared statement cache |
PREPNOTFND | QXSTNFND | NO | Real | Number of times Db2 searched the prepared statement cache but could not find a suitable prepared statement |
PREPIMPLICIT | QXSTIPRP | NO | Real | Number of times Db2 did an implicit PREPARE for a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache did not contain a valid copy of the prepared statement |
PREPNOIMPLICIT | QXSTNPRP | NO | Real | Number of times Db2 did not PREPARE a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache contained a valid copy of the prepared statement |
PREPDISCMAX | QXSTDEXP | NO | Real | Number of times Db2 discarded a prepared statement from the prepared statement cache because the number of prepared statements in the cache exceeded the value of subsystem parameter MAXKEEPD |
PREPDISCPROG | QXSTDINV | NO | Real | Number of times Db2 discarded a prepared statement from the prepared statement cache because a program executed a DROP, ALTER, or REVOKE statement against a dependent object |
RENAMETBL | QXRNTAB | NO | Real | Number of RENAME TABLE statements |
CREATETRIGGER | QXCTRIG | NO | Real | Number of SQL CREATE TRIGGER statements |
DROPTRIGGER | QXDRPTR | NO | Real | Number of SQL DROP TRIGGER statements |
SETCURRPATH | QXSETPTH | NO | Real | Number of SQL SET CURRENT PATH statements |
DROPUDF | QXDRPFN | NO | Real | Number of DROP UDF statements |
DROPPROC | QXDRPPR | NO | Real | Number of DROP PROCEDURE statements |
CREATEDISTINCT | QXCDIST | NO | Real | Number of CREATE DISTINCT TYPE statements |
DROPDISTINCT | QXDDIST | NO | Real | Number of DROP DISTINCT TYPE statements |
CREATEFUNC | QXCRUDF | NO | Real | Number of CREATE FUNCTION statements |
CREATEPROC | QXCRPRO | NO | Real | Number of CREATE PROCEDURE statements |
HOLDLOCATOR | QXHOLDL | NO | Real | Number of HOLD LOCATOR statements |
FREELOCATOR | QXFREEL | NO | Real | Number of FREE LOCATOR statements |
PARACONFIG | QXREPOP1 | YES | Real | Number of parallel groups for which Db2 reformulated the parallel portion of the access path because the SYSPLEX configuration at run time was different from the SYSPLEX configuration at bind time. This counter is incremented only by the parallelism coordinator at run time |
PARANOBP | QXREPOP2 | YES | Real | Number of parallel groups for which Db2 reformulated the parallel portion of the access path because there was not enough buffer pool resource. This counter is incremented only by the parallelism coordinator at run time |
CREATEAUXTBL | QXCRATB | NO | Real | Number of CREATE AUXILIARY TABLE statements |
MAXLOBSTG | QXSTLOBV | NO | Real | Maximum storage used for LOB values, in megabytes |
ALTERFUNC | QXALUDF | NO | Real | Number of ALTER FUNCTION statements |
ALTERPROC | QXALPRO | NO | Real | Number of ALTER PROCEDURE statements |
DIRECTROW | QXROIMAT | NO | Real | Number of times that Db2 used direct row access to locate a record |
DIRECTROWIX | QXROIIDX | NO | Real | Number of times that Db2 attempted to use direct row access but reverted to using an index to locate a record |
DIRECTROWTS | QXROITS | NO | Real | Number of times that Db2 attempted to use direct row access but reverted to using a table space scan to locate a record |
STMTTRIGGER | QXSTTRG | NO | Real | Number of times a statement trigger is activated |
ROWTRIGGER | QXROWTRG | NO | Real | Number of times a row trigger is activated |
SQLERRTRIGGER | QXTRGERR | NO | Real | Number of times an SQL error occurred during the execution of a triggered action |
MAXSQLCASCADE | QXCASCDP | NO | Real | Maximum level of nested SQL cascading due to triggers, user-defined functions, and stored procedures |
FUNC | QXCAUD | NO | Real | Number of user-defined functions executed |
FUNCAB | QXCAUDAB | NO | Real | Number of times a user-defined function abended |
FUNCTO | QXCAUDTO | NO | Real | Number of times a user-defined function timed out waiting to be scheduled |
FUNCRJ | QXCAUDRJ | NO | Real | Number of times a user-defined function was rejected |
CREATESEQ | QXCRESEQ | NO | Real | Number of CREATE SEQUENCE statements |
ALTERSEQ | QXALTSEQ | NO | Real | Number of ALTER SEQUENCE statements |
DROPSEQ | QXDROSEQ | NO | Real | Number of DROP SEQUENCE statements |
PREPRESTRIX | QXPRRESI | NO | Real | Number of PREPARE statements for which the use of indexes was restricted because the indexes were in a pending state |
ALTERVIEW | QXALTVW | NO | Real | Number of ALTER VIEW statements |
CLASS1CPU_ZIIP | QWACCLS1_ZIIP | NO | Decimal(15,6) | Class 1 CPU time executed on a zIIP |
CLASS2CPU_ZIIP | QWACCLS2_ZIIP | YES | Decimal(15,6) | Class 2 CPU time executed on a zIIP |
TRIGGERCPU_ZIIP | QWACTRTT_ZIIP | YES | Decimal(15,6) | Trigger CPU time executed on a zIIP |
CPUZIIPELIGIBLE | QWACZIIP_ELIGIBLE | YES | Decimal(15,6) | CPU time that was eligible to execute on a zIIP |
ALTERVIEW | QXALTVW | YES | Real | Number of ALTER VIEW |
ALTERJAR | QXALTJR | YES | Real | Number of ALTER JAR |
MERGE | QXMERGE | YES | Real | Number of MERGE |
TRUNCATETABLE | QXTRTBL | YES | Real | Number of TRUNCATE TABLE |
CREATEROLE | QXCRROL | YES | Real | Number of CREATE ROLE |
DROPROLE | QXDRPROL | YES | Real | Number of DROP ROLE |
CREATETRUST | QXCRCTX | YES | Real | Number of CREATE TRUSTED CONTEXT |
ALTERTRUST | QXALTCTX | YES | Real | Number of ALTER TRUSTED CONTEXT |
CREATETRUST | QXDRPCTX | YES | Real | Number of DROP TRUSTED CONTEXT |
RENAMEINDX | QXRNIX | YES | Real | Number of RENAME INDEX |
ROWSFETCHD | QXRWSFETCHD | NO | bigint | Number of rows fetched |
ROWSINSRTD | QXRWSINSRTD | NO | bigint | Number of rows inserted |
ROWSUPDTD | QXRWSUPDTD | NO | bigint | Number of rows updated |
ROWSDELETD | QXRWSDELETD | NO | bigint | Number of rows deleted |
QBAC - Buffer Manager | ||||
BPGETPAGE | QBACGET | YES | Real | GETPAGEs |
BPPGUPDAT | QBACSWS | YES | Real | Pages updated |
BPSYNCRD | QBACRIO | YES | Real | Synchronous read I/O |
BPPREFET | QBACSEQ | YES | Real | Sequential prefetch |
BPSYNCWR | QBACIMW | YES | Real | Synchronous write I/O |
BPLISTPREF | QBACLPF | YES | Real | Number of list prefetch requests |
BPDPF | QBACDPF | YES | Real | Number of dynamic prefetch requests |
BPNGT | QBACNGT | YES | Real | Number of unsuccessful GETPAGE operations |
BPSIO | QBACSIO | YES | Real | Number of asynchronous pages read by prefetch under the control of the agent |
QT - Bind Data | ||||
DEADLOCKS | QTXADEA | YES | Real | Deadlocks |
SUSPENDS | QTXASLOC | YES | Real | Suspends |
TIMEOUTS | QTXATIM | YES | Real | Timeouts |
LOCKESHR | QTXALES | YES | Real | Lock escalations to shared |
LOCKEXCL | QTXALEX | YES | Real | Lock escalations to exclusive |
MAXPGLOCKS | QTXANPL | YES | Integer | Maximum page locks |
SUSPLATCH | QTXASLAT | YES | Real | Latch suspends |
SUSPOTHER | QTXASOTH | YES | Real | Other suspends |
LOCKREQS | QTXALOCK | YES | Real | Lock requests |
CLAIMREQ | QTXACLNO | YES | Real | Number of claim requests |
CLAIMREQUN | QTXACLUN | YES | Real | Number of unsuccessful claim requests |
DRAINREQ | QTXADRNO | YES | Real | Number of drain requests |
DRAINREQUN | QTXADRUN | YES | Real | Number of unsuccessful drain requests |
RLFTABLEID | QTXARLID | NO | Char(2) | Resource limit table ID |
RLFLIMDET | QTXAPREC | NO | Integer | Resource limit determination |
RLFSULIMIT | QTXASLMT | NO | Integer | Limit in SUs |
RLFCPULIMIT | QTXACLMT | NO | Integer | RLF limit in CPU milliseconds |
RLFCPULIMITU | QTXACLMT | NO | Decimal(15,6) | RLF limit in CPU seconds |
RLFCPUUSED | QTXACHUS | NO | Integer | Highest CPU milliseconds used |
RLFCPUUSEDU | QTXACHUS | NO | Decimal(15,6) | Highest CPU seconds used |
UNLOCKREQS | QTXAUNLK | NO | Real | Unlock requests |
QUERYREQS | QTXAQRY | NO | Real | Lock query requests |
CHNGREQS | QTXACHG | NO | Real | Lock change requests |
IRLMREQS | QTXAIRLM | NO | Real | Other IRLM requests |
QMDA - z/OS Account Code and DDF | ||||
CLIENTPLATFORM | QMDAPLAT | NO | Char(18) | Platform issuing request, if request is issued by UNIX, Linux, Microsoft Windows (Windows), or a JDBC driver Operating system issuing request, if request is issued by z/OS, z/VM, z/VSE, or iSeries |
ACCTSTRING | QMDAASTR | NO | CHAR(247) | The accounting string for the agent. |
QWDA - Data Sharing | ||||
DB2MBRMAX | QWDAXCLM | NO | Integer | Largest number of Db2 members that participated in processing a query |
MBRCORR1-8 | QWDAXCQO | NO | Char(8) | For a parallel task, this is a correlating value that indicates the member name of the parallelism coordinator |
DMRACSHARE | None | NO | Integer | DMR column used only as a marker during BMC AMI Ops configuration to delete data sharing columns, if requested |
QBGA - Buffer Manager | ||||
GBPREADINVBD | QBGAXD | NO | Real | Synchronous coupling facility reads caused by invalid buffer and with data returned |
GBPREADINVBR | QBGAXR | NO | Real | Synchronous coupling facility reads caused by invalid buffer with no data returned and a directory entry created |
GBPREADNOPGD | QBGAMD | NO | Real | Synchronous coupling facility reads caused by page not in buffer pool and with data returned |
GBPREADNOPGR | QBGAMR | NO | Real | Synchronous coupling facility reads caused by page not in buffer pool with no data returned and a directory entry created |
GBPREADNOPGN | QBGAMN | NO | Real | Synchronous coupling facility reads caused by page not in buffer pool with no data returned and no directory entry created |
GBPWRITCHG | QBGASW | NO | Real | Changed pages written synchronously to group buffer pool |
GBPWRITCLEAN | QBGAWC | NO | Real | Clean pages written synchronously to group buffer pool |
GBPUNREGPG | QBGADG | NO | Real | Number of coupling facility requests to unregister a page |
GBPEXPLICITXI | QBGAEX | YES | Real | Number of explicit cross-invalidations |
GBPWRITCHK2 | QBGA2S | NO | Real | Number of completion checks for writes to the secondary GBP that were suspended because the write had not yet completed processing |
GBPASYNPRIM | QBGAHS | NO | Real | Asynchronous requests for primary GBP |
GBPASYNSEC | QBGA2H | NO | Real | Asynchronous requests for secondary GBP |
GBPDEPGETPG | QBGAGG | NO | Real | Getpages for GBP-dependent pages |
GBPPLKSPMAP | QBGAP1 | NO | Real | Page P-lock requests for space map pages |
GBPPLKDATA | QBGAP2 | NO | Real | Page P-lock requests for data pages |
GBPPLKIDX | QBGAP3 | NO | Real | Page P-lock requests for index leaf pages |
GBPPLKUNLK | QBGAU1 | NO | Real | Page P-lock unlock requests |
GBPPSUSSPMAP | QBGAS1 | NO | Real | Page P-lock suspensions for space map pages |
GBPPSUSDATA | QBGAS2 | NO | Real | Page P-lock suspensions for data pages |
GBPPSUSIDX | QBGAS3 | NO | Real | Page P-lock suspensions for index leaf pages |
GBPWARMULTI | QBGAWM | NO | Real | Number of Write and Register Multiple (WARM) requests |
GBPWAR | QBGAWS | NO | Real | Number of Write and Register (WAR) requests |
QTGA - Global Locking | ||||
GLPLOCKLK | QTGALPLK | NO | Real | Lock requests for P-locks |
GLPLOCKCHG | QTGACPLK | NO | Real | Change requests for P-locks |
GLPLOCKUNLK | QTGAUPLK | NO | Real | Unlock requests for P-locks |
GLXESSYNCLK | QTGALSLM | NO | Real | Lock requests propagated to MVS XES synchronously |
GLXESSYNCCHG | QTGACSLM | NO | Real | Change requests propagated to MVS XES synchronously |
GLXESSYNCUNLK | QTGAUSLM | NO | Real | Unlock requests propagated to MVS XES synchronously |
GLSUSPIRLM | QTGAIGLO | NO | Real | Suspends caused by IRLM global resource contention |
GLSUSPXES | QTGASGLO | NO | Real | Suspends caused by MVS XES global resource contention |
GLSUSPFALSE | QTGAFLSE | NO | Real | Suspends caused by false contentions |
GLINCOMPAT | QTGADRTA | NO | Real | Global lock or change requests denied for incompatible retained lock |
GLNOTFYSENT | QTGANTFY | NO | Real | Notify messages sent |
DMRAUTOCUST | None | NO | Integer | DMR column used only as a marker during BMC AMI Ops configuration; all columns following this one (up to DMRAUTOLONG) in the create table member are not used in the reports (NO in Used in Report column) and can be deleted as a group as a BMC AMI Ops configuration option |
GLFALSECONT | QTGAFCNT | NO | Integer | Number of false contention lock and unlock requests |
QIFA - IFI Accounting Information | ||||
IFIELAPSED | QIFAAIET | NO | Decimal(15,6) | Accumulated elapsed time spent processing IFI calls |
IFITCBCPU | QIFAAITT | NO | Decimal(15,6) | Accumulated TCB CPU time spent processing IFI calls |
IFIELAPDTC | QIFAAMBT | NO | Decimal(15,6) | Accumulated elapsed time spent processing data capture describes |
IFIELAPEXT | QIFAAMLT | NO | Decimal(15,6) | Accumulated elapsed time spent extracting log records for tables defined with data capture changes |
IFIENTRIES | QIFAANIF | NO | Real | Number of entries to and exits from IFI events |
IFILOGREAD | QIFAANLR | NO | Real | Number of log reads performed for processing IFI read requests for IFCID 0185 |
IFILOGREC | QIFAANRC | NO | Real | Number of log records written for tables defined with data capture changes |
IFILOGRTN | QIFAANRR | NO | Real | Number of log records returned to caller of IFI reads call for IFCID 0185 |
IFIDATAROW | QIFAANDR | NO | Real | Number of data rows returned in IFCID 0185 |
IFIDATADSC | QIFAANDD | NO | Real | Number of data descriptions returned in IFCID 0185 |
IFIDATACAP | QIFAANMB | NO | Real | Number of data capture describes for processing read requests for IFCID 0185 data |
IFITABLRTN | QIFAANTB | NO | Real | Number of tables returned to caller of IFI reads call for IFCID 0185 |
DMRAUTOLONG | None | NO | Integer | DMR column used only as a marker during BMC AMI Ops configuration; all columns following this one in the create table member are long name versions of the corresponding fields and can be deleted as a group as a BMC AMI Ops configuration option |
LOCATION_L | QWHSLOCN | NO | Varchar(128) | Long name version of the local location (Db2 subsystem ID if not defined) |
REQLOCATION_L | QWHDRQNM | NO | Varchar(128) | Long name version of the distributed transaction requestor location |
Related topic