Accounting Accelerator detail and summary tables (DMRAXxxx)
The following table describes the columns in the DMRAXDTL and DMRAXSUM tables.
Performance Report Column Name | SMF Field Name | Field Type | Description |
|---|---|---|---|
DMRTABLEVERSION | Not applicable | Char (8) | Version of Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | Char (8) | Version of Performance Reporter that created or modified the row |
SYSTEMID | SM101SID | Char (4) | System ID (SMF ID) |
SUBSYSTEM | SM101SSI | Char (4) | Subsystem ID (Db2 subsystem name) |
QWHC - Correlation Header | |||
PLAN | QWHCPLAN | Char (8) | Plan name |
AUTHID | QWHCAID | Char (8) | Authorization ID |
CONNECTION | QWHCCN | Char (8) | Connection name |
CORRID | QWHCCV | Char (12) | Correlation ID |
CORRTOKN_L | QWHCCTKN_Var | Varchar(128) | Correlation token |
ORIGPRIMID | QWHCOPID | Char (8) | Original primary authorization ID |
CONNTYPE | QWHCATYP | Char (8) | One of the following connection types, based on the value in QWHCATYP:
|
ACCTTOKN | QWHCTOKN | 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 | 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 suppl this information. |
ENDUSERID_L | QWHCEUID_Var | 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 | 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 suppl this information. |
ENDUSERTX_L | QWHCEUTX_Var | 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 | Char (18) | Optional end user's workstation name This field contains blanks if the client did not suppl this information. |
ENDUSERWN_L | QWHCEUWN_Var | 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 | Integer | Active trace mask |
PSTNUMBER | QWHCCV | Char (4) | PST number - IMS only |
PSBNAME | QWHCCV | Char (8) | PSB name - IMS only |
CICSTRAN | QWHCCV | Char (4) | Transaction code - CICS onl |
CORRNAME | QWHCCV | Char (8) | User ID, Jobname, CICS TRNID, or IMS PSBNAME |
CONTEXTNAME | QWHCTCXT | Varchar (128) | Trusted context name |
ROLENAME | QWHCROLE | Varchar (128) | Role name associated with authid |
ORIGAPPLAUTH | QWHCOAUD | Varchar (128) | Original application user ID |
QWHS - Standard Header | |||
DB2VERSION | QWHSRN QWHSSUBV | 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 | Char (8) | LUWID - Network ID |
LUWIDLUNM | QWHSLUNM | Char (8) | LUWID - Logical unit name |
LUWIDINST | QWHSLUUV | Char (6) | LUWID - Instance ID |
LUWIDCOMIT | QWHSLUCC | Real | LUWID - Commit count |
YEAR | QWHSSTCK | Char (4) | Year record was created |
LOCATION | QWHSLOCN | Char (16) | Local location name (Db2 subsystem ID if not defined) |
IFCIDSEQ# | QWHSISEQ | Integer | IFCID sequence number |
QWAC - Accounting Record Instrumentation | |||
DATETIME | QWACESC | Time stamp | Date and time record was created |
DATE | QWACESC | Date | Date record was created |
MONTH | QWACESC | Char (2) | Month record was created |
DAY | QWACESC | Char (2) | Day record was created |
TIME | QWACESC | Time | Time record was created |
HOUR | QWACESC | Char (2) | Hour record was created |
DAYOFWEEK# | QWACESC | Smallint | Relative da of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWACESC | Char (3) | MON, TUE, WED, THU, FRI, SAT, SUN |
WEEK# | QWACESC | Integer | Week number relative to the 1 January 1900 epoch |
NETWORKID | QWACNID | Char (16) | Network ID |
QWHA - Data Sharing | |||
GROUPNAME | QWHADSGN | Char (8) | Data sharing group name |
MEMBERNAME | QWHAMEMN | Char (8) | Data sharing member name |
QPAC - General Package Accounting | |||
FIRSTPKG | QPACPKID | Char (18) | First package or DBRM executed (planname if accounting class 7 not active) |
REQLOCATION_L | QWHDRQNM | Varchar (128) | Long name version of the distributed transaction requestor location |
Q8AC - Accounting Accelerator | |||
PRODUCTID | Q8ACPRID | Char (8) | Accelerator product ID |
CONNECTS | Q8ACCONN | BIGINT | Number of Accelerator connects |
REQUESTS | Q8ACREQ | BIGINT | Number of Accelerator requests |
REQUEST_TIMEOUTS | Q8ACTOUT | BIGINT | Number of Accelerator request timeouts |
FAILED_REQUESTS | Q8ACFAIL | BIGINT | Number of Accelerator failed requests |
BYTES_SENT | Q8ACBYTS | BIGINT | Number of bytes sent |
BYTES_RETURNED | Q8ACBYTR | BIGINT | Number of bytes returned |
MSGS_SENT | Q8ACMSGS | BIGINT | Number of messages sent |
MSGS_RETURNED | Q8ACMSGR | BIGINT | Number of messages returned |
BLOCKS_SENT | Q8ACBLKS | BIGINT | Number of blocks sent |
BLOCKS_RETURNED | Q8ACBLKR | BIGINT | Number of blocks returned |
ROWS_SENT | Q8ACROWS | BIGINT | Number of rows sent |
ROWS_RETURNED | Q8ACROWR | BIGINT | Number of rows returned |
CPU_TIME | Q8ACSCPU | Decimal (15,6) | Accelerator server's CPU time |
ELAPSED_TIME | Q8ACSELA | Decimal (15,6) | Accelerator server's elapsed time |
TCPIP_CPU_TIME | Q8ACTCPU | Decimal (15,6) | Accelerator server's TCP/IP CPU time |
TCPIP_ELAP_TIME | Q8ACTELA | Decimal (15,6) | Accelerator server's TCP/IP CPU elapsed time |
ACCUM_CPU_TIME | Q8ACACPU | Decimal (15,6) | Accelerator server's accumulated CPU time |
ACCUM_ELAP_TIME | Q8ACAELA | Decimal (15,6) | Accelerator server's accumulated elapsed time |
ACCUM_WAIT_TIME | Q8ACAWAT | Decimal (15,6) | Accumulated wait time |
NAME_L | Q8ACNAME | Varchar (128) | Accelerator server name |