Initial DB2 Common Server Correlation

This topic shows detailed information about "Accounting - Initial DB2 Common Server Correlation".

This block shows the Accounting trace for the initial DB2 common server correlation.

---- INITIAL DB2 COMMON SERVER CORRELATION -----------------------------------------------------------------------------------------
PRODUCT ID     : COMMON SERV
PRODUCT VERSION: V9 R1 M1
CLIENT PLATFORM: AIX 64BIT
CLIENT APPLNAME: PRCCHNG
CLIENT AUTHID  : USRT001
DDCS ACC.SUFFIX: "BLANK"

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

CLIENT PLATFORM

The client platform, such as AIX®. This is a 1 to 18 character field padded with blanks.

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

Field Name: QMDAPLAT

CLIENT APPLNAME

The name of the client application. This is a 1 to 20 character field padded with blanks. An example is "PAYROLL".

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

Field Name: QMDAAPPL

CLIENT AUTHID

The client authorization ID of an application process. This is a 1 to 8 character field padded with blanks. An example is "SMITH".

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

Field Name: QMDAATID

DDCS ACC.SUFFIX

The account suffix. The maximum length of this field is 200 bytes. This field is the user-supplied portion (suffix) of the accounting string. An example is "DEFAULT_DRDA". A value of zero in QMDASFLN Indicates there is no account suffix.

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

Field Name: QMDASUFX