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

The product identifier of the requester:

DB2

DB2 UDB for z/OS

SQL/DS

DB2 UDB for VSE and VM

COMMON SERV

DB2 UDB for Linux, UNIX, and Windows

DB2/400

DB2 UDB for iSeries

N/P

If the record was written at the application requester location

Otherwise, it shows the first 3 characters of the product ID.

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

Field Name: QMDAPRIDP

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