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.

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