Initial Db2 Requester Correlation

This topic shows detailed information about Accounting - Initial Db2 Requester Correlation.

This block shows the accounting trace for the initial Db2 requester correlation.

---- INITIAL DB2 REQUESTER CORRELATION ---------------------------------------------------------------------------------------------
PRODUCT ID     : DB2
PRODUCT VERSION: CCCCCCCC
LOCATION NAME  : CCCCCCCCCCCCCCCC
NET ID         : CCCCCCCC
LU NAME        : CCCCCCCC
AUTHID         : CCCCCCCC
CONNTYPE       : CCCCCCCC
CORRNAME       : CCCCCCCC
CORRNMBR       : CCCCCCCC

PRODUCT ID

Shows the product identifier (ID) of the requester. For the Db2 UDB for z/OS requester, this field has a value of DB2.

Field Name: QMDAPRID

PRODUCT VERSION

The version, release, and modification level of the product, which generated the accounting information. It has the following format: vv rr m, where:

vv

Version level

rr

Release level

m

Modification level

N/P is shown if the record was written at the application requester location.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup.

Field Name: QMDB2PRDV

LOCATION NAME

The location name for the Db2 subsystem that created the QMDAINFO values.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Field Name: QMDALOCN

NET ID

The NETID of the Db2 subsystem that created the QMDAINFO values.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup.

Field Name: QMDANETN

LU NAME

The SNA LU name of the Db2 subsystem that created the QMDAINFO values.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup.

Field Name: QMDALUNM

AUTHID

The Db2 authorization ID that the SQL application used before name translation and before driving the connection exit at the Db2 site where the SQL application is running.

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup.

Field Name: QMDAAUTH

CONNTYPE

The type of subsystem connection at the Db2 system where the SQL application is running. Possible values and their descriptions are:

BATCH

TSO or call attach

SASS

CICS

MASS

IMS

DIST

Distributed

For DDF/RRSAF rollup records, the field will contain a value derived from the last thread to rollup.

Field Name: QMDACTYP

CORRNAME

The translated correlation name derived from the correlation ID. The translation depends on the connection ID.

Field Name: ADRQCRNM

CORRNMBR

The translated correlation number derived from the correlation ID. The translation depends on the connection ID.

Field Name: ADRQCRNB