DDF accounting detail and summary tables (DMRADxxx)
DMRADxxx is an optional table for distributed processing accounting records.
Each row in the table represents information about one DDF location for one accounting record.
The following table describes the columns in the DMRADDTL and DMRADSUM tables.F
Performance Report Column Name | SMF Field Name | Used in Report | Field Type | Description |
|---|---|---|---|---|
DMRTABLEVERSION | Not applicable | NO | Char(8) | Version of MainView for DB2 Performance Reporter that created or modified the table definition |
DMRVERSION | Not applicable | NO | Char(8) | Version of MainView 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) |
FIRSTPKG | QPACPKID | YES | Char(18) | First package or DBRM executed (planname if accounting class 7 not active) |
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 |
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 |
QWHC - Correlation Header | ||||
AUTHID | QWHCAID | YES | Char(8) | 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. |
CONNECTION | QWHCCN | YES | Char(8) | Connection name |
CORRID | QWHCCV | YES | Char(12) | Correlation ID |
CORRTOKN_L (PTF BPD4910 applied) | QWHCCTKN_Var | NO | Varchar(128) | Correlation token |
ORIGPRIMID | QWHCOPID | YES | Char(8) | Original primary ID |
PLAN | QWHCPLAN | YES | Char(8) | Plan name |
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 (PTF BPD4910 applied) | 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 (PTF BPD4910 applied) | 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 (PTF BPD4910 applied) | 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 | NO | Char(4) | PST number - IMS only |
PSBNAME | QWHCCV | NO | Char(8) | PSB name - IMS only |
CICSTRAN | QWHCCV | NO | 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 |
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. |
LOCATION | QWHSLOCN | YES | Char(16) | Local location name (DB2 subsystem ID if not defined) |
LUWIDCOMIT | QWHSLUCC | YES | Real | LUWID - Commit count |
LUWIDLUNM | QWHSLUNM | YES | Char(8) | LUWID - Logical unit name |
LUWIDINST | QWHSLUUV | YES | Char(6) | LUWID - Instance ID |
LUWIDNID | QWHSNID | YES | Char(8) | LUWID - Network ID |
TRACEMASK | QWHSMTN | NO | Integer | Active trace mask |
YEAR | QWHSSTCK | YES | Char(4) | Year record was created |
QWHD - Distributed Agent | ||||
REQLOCATION | QWHDRQNM | NO | Char(8) | Requestor Location |
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 |
QLAC - Distributed Data Facility | ||||
REQSERV | QLACFLGS | NO | Char(9) | REQUESTOR or SERVER |
METHOD | QLACFLGS QWHCATYP | NO | Char(4) | APPL or SYST or BOTH |
NETWORKID | QWACNID | YES | Char(16) | Network ID |
INTERVAL | None | YES | Integer | Interval for the summary accounting table |
TRANSCNT | QWACPCNT for rollup records, otherwise, see description | YES | Integer | Transaction thread count for the summary accounting table 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 |
DDFLOCATION | QLACLOCN | YES | Char(16) | Location name of the remote site |
SQLSENT | QLACSQLS | YES | Real | SQL statements sent |
SQLRECV | QLACSQLR | YES | Real | SQL statements received |
ROWSENT | QLACROWS | YES | Real | Rows sent |
ROWRECV | QLACROWR | YES | Real | Rows received |
BYTESENT | QLACBYTS | YES | Real | Bytes sent |
BYTERECV | QLACBYTR | YES | Real | Bytes received |
CONVSENT | QLACCNVS | YES | Real | Conversations initiated from this site |
CONVRECV | QLACCNVR | YES | Real | Conversations initiated to this site |
MSGSSENT | QLACMSGS | YES | Real | Messages sent |
MSGSRECV | QLACMSGR | YES | Real | Messages received |
TRANSENT | QLACTRNS | YES | Real | Transactions migrated to remote |
TRANRECV | QLACTRNR | YES | Real | Transactions migrated from remote |
COMMITSENT | QLACCOMS | YES | Real | Commits sent |
COMMITRECV | QLACCOMR | YES | Real | Commits received |
ABORTSENT | QLACABRS | YES | Real | Rollback requests sent |
ABORTRECV | QLACABRR | YES | Real | Rollback requests received |
CONVQUED | QLACCNVQ | YES | Real | Conversation requests queued |
ELAPSWAIT | QLACCPUL | YES | Decimal(15,6) | Elapsed time remote wait |
ELAPSDATAW | QLACCPUR | YES | Decimal(15,6) | Elapsed wait for remote database |
CPUDATAR | QLACDBAT | YES | Decimal(15,6) | CPU time in remote database |
SWLIMBLK | QLACCBLB | NO | Real | Switch to limited block protocol |
SQLBOUND | QLACRBND | NO | Real | SQL bound for remote access |
ROWSBUFF | QLACBROW | NO | Real | Number of rows in buffer |
BLKSENT | QLACBTBF | YES | Real | Blocks sent using block fetch |
BLKRECV | QLACBRBF | YES | Real | Blocks received using block fetch |
CONVALLOCS | QLACCNVA | NO | Real | Successful conversation allocations |
CONVTERMS | QLACCNVT | NO | Real | Successful conversation terminations |
MAXCONV | QLACCIEL | NO | Integer | Maximum conversations open |
REQUSTPRSE | QLACPRSE | YES | Real | Number of PREPARE requests sent to participant |
REQUSTPRRC | QLACPRRC | YES | Real | Number of PREPARE requests received from coordinator |
REQUSTLASE | QLACLASE | YES | Real | Number of LAST AGENT requests sent to coordinator |
REQUSTLARC | QLACLARC | YES | Real | Number of LAST AGENT requests received from initiator |
REQUSTCRSE | QLACCRSE | YES | Real | Number of COMMIT requests sent to participant |
REQUSTCRRC | QLACCRRC | YES | Real | Number of COMMIT requests received from coordinator |
REQUSTBKSE | QLACBKSE | YES | Real | Number of BACKOUT requests sent to participant |
REQUSTBKRC | QLACBKRC | YES | Real | Number of BACKOUT requests received from coordinator |
RESPONRRSE | QLACRRSE | YES | Real | Number of FORGET responses sent to coordinator |
RESPONRRRC | QLACRRRC | YES | Real | Number of FORGET responses received from participant |
RESPONVYSE | QLACVYSE | YES | Real | Number of request COMMIT responses sent to coordinator |
RESPONVYRC | QLACVYRC | YES | Real | Number of request COMMIT responses received from participant |
RESPONVNSE | QLACVNSE | YES | Real | Number of BACKOUT responses sent to coordinator |
RESPONVNRC | QLACVNRC | YES | Real | Number of BACKOUT responses received from participant |
THDRMTINDT | QLACINDT | YES | Real | Number of threads indoubt with remote location as coordinator |
THDRMTCPTR | QLACCPTR | YES | Real | Number of COMMIT operations performed with remote location as coordinator |
THDRMTRBTR | QLACRBTR | YES | Real | Number of ROLLBACK operations performed with remote location as coordinator |
THDRMTPRID | QLACPRID | YES | Char(8) | Product ID of remote location |
ELAPSLOTWT | QLACMDWT | YES | Decimal(15,6) | Total elapsed time spent waiting for an available database access agent slot This wait occurs when DB2 reaches its maximum number of database access agents, and a DBAT must wait for another DBAT to relinquish its slot. |
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 |
DMRACSHARE | None | NO | Integer | DMR column used only as a marker during MainView customization to delete data sharing columns, if requested |
DMRAUTOCUST | None | NO | Integer | DMR column used only as a marker during MainView customization; 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 MainView customization option |
DMRAUTOLONG | None | NO | Integer | DMR column used only as a marker during MainView customization; 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 MainView customization 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 |
DDFLOCATION_L | QLSTLOCN | NO | Varchar(128) | Long name version of the remote location |
Related topic