Initial DB2 Common Server or Universal JDBC Driver Correlation

This topic shows detailed information about "Accounting - Initial DB2 Common Server or Universal JDBC Driver Correlation".

This block shows the accounting trace for the initial DB2 common server or universal JDBC driver correlation.

---- INITIAL DB2 COMMON SERVER OR UNIVERSAL JDBC DRIVER CORRELATION ----------------------------------------------------------------
 PRODUCT ID     : JDBC DRIVER
 PRODUCT VERSION: V3 R66M0
 CLIENT PLATFORM: IS-255-01234567890
 CLIENT APPLNAME: IS-255-0123456789012
 CLIENT AUTHID  : IS-128--
 DDCS ACC.SUFFIX: IS-255-01234567890123456789012#1

PRODUCT TYP

Shows the product identifier (ID) of the requester. It can have the following values:

DB2

For DB2 UDB for z/OS®

SQL/DS

For DB2® UDB for VSE and VM

JDBC DRIVER

For Universal JDBC driver

COMMON SERV

For DB2 UDB for Linux, UNIX, Windows

DB2/400

For DB2 UDB for iSeries

Otherwise, it shows the first 3 characters of the product ID, or N/P 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: 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

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