Package accounting detail and summary tables (DMRAPxxx)
Performance Report Column Name | SMF Field Name | Used in Report | Field Type | Description |
|---|---|---|---|---|
DMRTABLEVERSION | Not applicable | NO | Char(8) | Version of Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | NO | Char(8) | Version of Performance Reporter that created or modified the row |
SYSTEMID | SM101SID | YES | Char(4) | SMF system ID |
SUBSYSTEM | SM101SSI | YES | Char(4) | Db2 subsystem ID |
QWHS - Standard Header | ||||
DB2VERSION | QWHSRN QWHSSUBV | NO | Char(6) | Version of Db2 that created the record |
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 |
TRACEMASK | QWHSMTN | NO | Integer | Active trace mask |
LOCATION | QWHSLOCN | YES | Char(16) | Local location name (Db2 subsystem ID if not defined) |
QWAC - Accounting Record Instrumentation | ||||
DATETIME | QWACESC | YES | Time stamp | Date and time the 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 |
CPUSUCONV | QWACSUCV | NO | Integer | CPU service unit conversion factor |
QWHA - Data Sharing | ||||
GROUPNAME | QWHADSGN | YES | Char(8) | Data sharing group name |
MEMBERNAME | QWHAMEMN | YES | Char(8) | Data sharing member name |
QMDA - z/OS Account Code and DDF | ||||
CLIENTPLATFORM | QMDAPLAT | NO | Char(18) | Platform issuing request, if request is issued by UNIX, Linux, Windows, or a JDBC driver Operating system issuing request, if request is issued by z/OS, z/VM, z/VSE, or iSeries |
QWHC - Correlation Header | ||||
PLANNAME | QWHCPLAN | YES | Char(8) | Plan name |
AUTHID | QWHCAID | YES | Char(8) | Primary authorization ID |
CONNECTION | QWHCCN | YES | Char(8) | Connection name |
CORRID | QWHCCV | YES | Char(12) | Correlation ID value |
CORRTOKN_L | QWHCCTKN_Var | NO | Varchar(128) | Correlation token |
ORIGPRIMID | QWHCOPID | YES | Char(8) | Original primary authorization ID |
CONNTYPE | QWHCATYP | YES | Char(8) | Connection type, based on the value in QWHCATYP For a list of connection types, see the description of CONNTYPE in Accounting-detail-and-summary-tables-DMRACxxx. |
ACCTTOKN | QWHCTOKN | NO | 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. |
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_L | QWHCTCXT | No | Varchar(128) | Long name version of the Trusted context name |
ROLENAME_L | QWHCROLE | No | Varchar(128) | Long name version of the Role name associated with authid |
ORIGAPPLUSER_L | QWHCOAUD | No | Varchar(128) | Long name version of the Original application userid |
ORIGPRIMID_L | QWHCOPID | No | Varchar(128) | Long name version of the Original primary authorization ID |
QWHD - Distributed Agent | ||||
REQLOCATION | QWHDRQNM | NO | Char(16) | Requestor location name for a distributed transaction |
REQPROD | QWHDPRID | NO | Char(8) | Distributed transaction requestor product ID |
REQPRODREL | QWHDPRID | NO | Char(8) | VvvRrrMm - version, release, modification level of the requestor for a distributed transaction |
NETWORKID | QWACNID | YES | Char(16) | Network ID |
INTERVAL | None | YES | Integer | Interval used only for the summary accounting package tables |
TRANSCNT | QWACPCNT for rollup records, otherwise, see description | YES | Integer | Transaction thread count for the summary accounting package tables For summary tables, this field contains the number of transactions that were used to calculate the column values. |
IFCIDSEQ# | QWHSISEQ | NO | Integer | IFCID sequence number |
QPAC - General Package Accounting | ||||
FIRSTPKG | QPACPKID | YES | Char(18) | First package or DBRM executed (planname if accounting class 7 not active) |
OCCURRENCES | None | YES | Smallint | Number of occurrences (useful in summary only) |
PKGFLAG | QPACFLGS | YES | Char(4) | PKG for a package DBRM for a DBRM PRUP for package data for a parallel rollup record If none of these flag values is found, the value of PKGFLAG is the hexadecimal representation of QPACFLGS. |
PKGTYPE | QPACFLGS | NO | Char(1) | P for a package (QPACPACK) D for a DBRM (QPACDBRM) Blank if neither value was found |
CURRENTFLAGCNT | QPACFLGS | NO | Integer | Number of times that this package is the current or most recently executed package (QPACCRNT) |
INSTOREDPROCCNT | QPACFLGS | NO | Integer | Number of times that this package was executed as part of a stored procedure (QPACINSP) |
AUTHNODB2CHKCNT | QPACFLGS | NO | Integer | Numbers of times that authorization was successful without having to check the Db2 catalog (QPACPAC) |
CLASS7CNT | QPACFLGS | YES | Integer | Count of transactions with Db2 SMF class 7 traces active (QPACCLS7) |
CLASS8CNT | QPACFLGS | YES | Integer | Count of transactions with Db2 SMF class 8 traces active (QPACCLS8) |
FLAGS | QPACFLGS | No | Smallint | Accounting package flags |
EXECLOCATION | QPACLOCN | YES | Char(16) | Remote location name where package was executed (blank if executed locally) |
COLLECTIONID | QPACCOLN | YES | Char(18) | Package collection ID |
PROGRAMNAME | QPACPKID | YES | Char(18) | Program name (package ID or DBRM) |
CONSISTOKEN | QPACCONT | YES | Char(16) | Consistency token (hexadecimal) converted to readable characters |
CONSISTOKENX | QPACCONT | YES | Char(8) | Consistency token (hexadecimal) in raw binary form |
SQLCOUNT | QPACSQLC | YES | Real | SQL requests count |
ELAPSEPKG | QPACSCT | YES | Decimal(15,6) | Total elapsed execution time for this package/DBRM When query parallelism is present this is an aggregated value of the parent and child QPACSCT |
QPACSCT | QPACSCT | NO | Decimal(15,6) | Total elapsed execution time for this package/DBRM. When query parallelism is present this is the value from the parent QPAC |
CPUTCBPKG | QPACTJST | YES | Decimal(15,6) | Total TCB CPU time for this package/DBRM (does not include zIIP CPU time) |
ENTEXEVENT | QPACARNA | YES | Real | Number of Db2 entry/exit events |
EVTSYNCIO | QPACARNE | YES | Real | Number of wait events for synchronous I/O |
ELAPSYNCIO | QPACAWTI | YES | Decimal(15,6) | Elapsed wait time for synchronous I/O |
ELAPLATCH | QPACAWLH | YES | Decimal(15,6) | Elapsed time for latch wait |
ELPLOCK | QPACAWTL | YES | Decimal(15,6) | Elapsed wait time for lock or latch |
ELPOTHREAD | QPACAWTR | YES | Decimal(15,6) | Elapsed wait time for other read I/O |
ELPOTHWRIT | QPACAWTW | YES | Decimal(15,6) | Elapsed wait time for other write I/O |
ELPUNITSW | QPACAWTE | YES | Decimal(15,6) | Elapsed wait time for unit switch |
ELPARCQIS | QPACALOG | YES | Decimal(15,6) | Elapsed wait time for archive log quiesce |
EVTLOCK | QPACARNL | YES | Real | Number of wait events for lock or latch |
EVTOTHREAD | QPACARNR | YES | Real | Number of wait events for other read I/O |
EVTOTHWAIT | QPACARNW | YES | Real | Number of wait events for other write I/O |
EVTUNITSW | QPACARNS | YES | Real | Number of waits for unit switch |
EVTARCQIS | QPACALCT | YES | Real | Number of waits for archive log quiesce |
EVTDRAIN | QPACARND | YES | Real | Number of waits for drain locks |
ELPDRAIN | QPACAWDR | YES | Decimal(15,6) | Elapsed wait time for a drain |
ELPCLAIM | QPACAWCL | YES | Decimal(15,6) | Elapsed wait time for claim release |
EVTCLAIM | QPACARNC | YES | Real | Number of wait events for claim release |
ELPARCREAD | QPACAWAR | YES | Decimal(15,6) | Elapsed wait time for an archive read from tape |
EVTARCREAD | QPACANAR | YES | Real | Number of wait trace events processed for archive read |
ELPPGLAT | QPACAWTP | YES | Decimal(15,6) | Elapsed wait time for page latch contention |
EVTPGLAT | QPACARNH | YES | Real | Number of wait events for page latch contention |
GBLMSGELAP | QPACAWTG | YES | Decimal(15,6) | Data sharing elapsed wait time sending messages |
GBLMSGEVNT | QPACARNG | YES | Real | Data sharing waits sending messages |
GBLLOKELAP | QPACAWTJ | YES | Decimal(15,6) | Data sharing elapsed wait time global lock contention |
GBLLOKEVNT | QPACARNJ | YES | Real | Data sharing waits for global lock contention |
SPROCCNT | QPACSPNS | NO | Real | Number of stored procedures executed This value is calculated only if accounting class 8 is active. |
FUNCCNT | QPACUDNU | NO | Real | Number of user-defined functions scheduled) This value is calculated only if accounting class 8 is active. |
NESTSCHEMA | QPACASCH | NO | Char(8) | Schema name under which nested activity (nesting of stored procedures, user-defined functions, or triggers) occurs |
NESTNAME | QPACAANM | NO | Char(18) | Name of nested activity |
NESTTYPE | QPACAAFG | NO | Char(5) | Type of nested activity:
|
WTELAWTK | QPACAWTK | NO | Decimal(15,6) | Wait time for global contention for child L-locks |
WTELAWTM | QPACAWTM | NO | Decimal(15,6) | Wait time for global contention for other L-locks |
WTELAWTN | QPACAWTN | NO | Decimal(15,6) | Wait time for global contention for pageset/partition P-locks |
WTELAWTO | QPACAWTO | NO | Decimal(15,6) | Wait time for global contention for page P-locks |
WTELAWTQ | QPACAWTQ | NO | Decimal(15,6) | Wait time for global contention for other P-locks |
WTEVARNK | QPACARNK | NO | Real | Number of events with global contention for child L-locks |
WTEVARNM | QPACARNM | NO | Real | Number of events with global contention for other L-locks |
WTEVARNN | QPACARNN | NO | Real | Number of events with global contention for pageset/partition P-locks |
WTEVARNO | QPACARNO | NO | Real | Number of events with global contention for page P-locks |
WTEVARNQ | QPACARNQ | NO | Real | Number of events with global contention for other P-locks |
PKGSWITCH | QPACSWITCH | NO | Real | # of times this package was switched to; for the first package run by an application, the initial call counts as a package switch |
CLASS7CPU_ZIIP | QPACCLS7_ZIIP | YES | Decimal(15,6) | Class 7 CPU time executed on a zIIP |
EVTLATCH | QPACANLH | No | Real | Number of wait trace events processed for waits on latches while executing this package |
EVTOTHWRIT | QPACARNW | Yes | Real | Number of wait trace events processed for waits for write I/O under another thread while executing this package |
PARSYNCCOUNT | QPAC_PQS_COUNT | No | Real | Number of times a parallel query processing suspended waiting for parent/child to synchronize |
PIPEWAITCOUNT | QPAC_PIPEWAIT_COUNT | No | Real | Number of wait trace events processed for waits for a pipe while executing this package |
ACCELWAITEVNTS | QPACAACC | No | Integer | Number of wait trace event processed for requests to an accelerator while executing this package |
PARSYNCWAIT | QPAC_PQS_WAIT | No | Decimal(15,6) | Accumulated time waiting for parallel query processing to synchronize between parent and child tasks |
PIPEWAIT | QPAC_PIPE_WAIT | No | Decimal(15,6) | Accumulated wait time for a pipe while executing this package |
ACCELWAITTIME | QPACAACW | No | Decimal(15,6) | Accumulated wait time for requests to an accelerator while executing this package |
QPACSCB | QPACSCB | No | Char(26) | Store clock value at entry to Db2 for most recent execution of this package This field is invalid if unique or summary rollup data is present. |
QPACSCE | QPACSCE | No | Char(26) | Store clock value at exit from Db2 after most recent execution of this package This field is invalid if unique or summary rollup data is present. |
QPACSCT | QPACSCT | No | Char(26) | The value represents total elapsed execution time for a package/DBRM. When parallelism is present this value represents the QPACSCT from the parent package. |
QBAC - Buffer Manager | ||||
BPGETPAGE | QBACGET | NO | Real | GETPAGEs |
BPPGUPDAT | QBACSWS | NO | Real | Pages updated |
BPSYNCRD | QBACRIO | NO | Real | Synchronous read I/O |
BPPREFET | QBACSEQ | NO | Real | Sequential prefetch |
BPSYNCWR | QBACIMW | NO | Real | Synchronous write I/O |
BPLISTPREF | QBACLPF | NO | Real | Number of list prefetch requests |
BPDPF | QBACDPF | NO | Real | Number of dynamic prefetch requests |
BPNGT | QBACNGT | NO | Real | Number of unsuccessful GETPAGE operations |
BPSIO | QBACSIO | NO | Real | Number of asynchronous pages read by prefetch under the control of the agent |
LOBWAITCNT | QPACALBC | NO | Real | Number of waits for LOB TCP/IP initialization events |
LOBWAITELAP | QPACALBW | NO | Decimal (15, 6) | Elapsed time waiting for LOB TCP/IP initialization |
ROLLTHDS | QPACRLNU | NO | Integer | Number of roll threads |
QTXA - Lock Data | ||||
DEADLOCKS | QTXADEA | NO | Real | Deadlocks |
SUSPENDS | QTXASLOC | NO | Real | Suspends |
TIMEOUTS | QTXATIM | NO | Real | Timeouts |
LOCKESHR | QTXALES | NO | Real | Lock escalations to shared |
LOCKEXCL | QTXALEX | NO | Real | Lock escalations to exclusive |
MAXPGLOCKS | QTXANPL | NO | Integer | Maximum page locks |
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 |
SUSPLATCH | QTXASLAT | NO | Real | Latch suspends |
SUSPOTHER | QTXASOTH | NO | Real | Other suspends |
LOCKREQS | QTXALOCK | NO | Real | Lock requests |
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 |
CLAIMREQ | QTXACLNO | NO | Real | Number of claim requests |
CLAIMREQUN | QTXACLUN | NO | Real | Number of unsuccessful claim requests |
DRAINREQ | QTXADRNO | NO | Real | Number of drain requests |
DRAINREQUN | QTXADRUN | NO | Real | Number of unsuccessful drain requests |
QX - SQL Statement | ||||
SELECTS | QPSELECT | NO | Real | Number of SELECT statements |
INSERTS | QPINSRT | NO | Real | Number of INSERT statements |
UPDATES | QPUPDTE | NO | Real | Number of UPDATE statements |
DELETES | QPDELET | NO | Real | Number of DELETE statements |
DESCRIBES | QPDESC | NO | Real | Number of DESCRIBE statements |
PREPARES | QPPREP | NO | Real | Number of PREPARE statements |
OPENS | QPOPEN | NO | Real | Number of OPEN statements |
FETCHES | QPFETCH | NO | Real | Number of FETCH statements |
CLOSES | QPCLOSE | NO | Real | Number of CLOSE statements |
LOCKTBL | QPLOCK | NO | Real | Number of LOCK TABLE statements |
SQLCALL | QPCALL | NO | Real | SQL call statements executed |
DMRACSHARE | None | NO | Integer | DMR column used only as a marker during configuration to delete data sharing columns, if requested |
DMRAUTOCUST | None | NO | Integer | DMR column used only as a marker during 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 configuration option |
DMRAUTOLONG | None | NO | Integer | DMR column used only as a marker during 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 configuration option |
AUTHID_L | QWHCAID | NO | Varchar(128) | Long name version of the authorization ID |
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 |
EXECLOCATION_L | QPACLOCN | NO | Varchar(128) | Long name version of the remote location where package was executed (blank if executed locally) |
COLLECTIONID_L | QPACCOLN | NO | Varchar(128) | Long name version of the package collection ID |
PROGRAMNAME_L | QPACPKID | NO | Varchar(128) | Long name version of the program name (package ID or DBRM) |
NESTSCHEMA_L | QPACASCH | NO | Varchar(128) | Long name version of the schema under which nested activity (nesting of stored procedures, user-defined functions, or triggers) occurs |
NESTNAME_L | QPACAANM | NO | Varchar(128) | Long name version of the nested activity |