Initial Other Requester Correlation

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

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

Accounting - Initial Other Requester Correlation

The field labels shown in the following sample layout of Accounting - Initial Other Requester Correlation are described in the following section.

---- INITIAL OTHER REQUESTER CORRELATION -------------------------------------------------------------------------------------------
PRODUCT ID     : SQL/DS
PRODUCT VERSION: CCCCCCCC
STRING         : CCCCCCCC
PRODUCT ID
Shows the product identifier (ID) of the requester. It can have the following values:
SQL/DS
For DB2® UDB for VSE and VM.
DB2/400
For DB2 UDB for IBM i.
LOG READER
For Asynchronous Log Reader Task.

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: QMDAPRIDV

STRING
The accounting string:
  • For local DB2 threads, the format of the accounting string is shown in QMDAINFO.
  • For database access threads, the accounting string contains the accounting string sent by the requester.
  • The QMDAPRID value identifies which product generated the accounting string.
    • If the requester is DB2, the accounting string is defined in QMDAINFO.
    • If QMDAPTYP is DSN, QMDAINFO defines the format.
    • If QMDAPTYP is SQL or JCC, QMDASQLI defines the format.
    • Otherwise, the format is undefined.

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

Field Name: QMDAASTR