IFCID 003 - Initial Db2 Requester and MVS Correlation Data

This topic shows detailed information about Record Trace - IFCID 003 - Initial Db2 Requester and MVS Correlation Data.

Record trace - IFCID 003 - Initial Db2 Requester and MVS Correlation Data

The field labels shown in the following sample layout of Record Trace - IFCID 003 - Initial Db2 Requester and MVS Correlation Data are described in the following section. 


                             INITIAL DB2 REQUESTER AND MVS CORRELATION DATA                           
BYTES:   226                 PRODUCT ID: DB2                                        PRODUCT VERSION: V11R01M5
LOCATION: PMODB1H            NET ID    : DEIBMIPS          LU NAME : IPSAQB1H               CONNECT: DB2CALL 
CONNTYPE: BATCH              CORRNAME  : BBEEXC1           CORRNMBR: 'BLANK'                AUTHID : BBE     
PLANNAME: DB1HEXC1                                                                                          
MVS ACCOUNTING DATA: ACCOUNTING-ASTR0-1234567890ABCDEDGHIJKLMNOPQRSTUVWXYZACCOUNTING-ASTR1-1234567890ABCDEDGHIJKLMNOPQ
                     RSTUVWXYZACCOUNTING-ASTR2-1234567890ABCDEDGHI                                                    
*** Long name section:                                                                                                
LOCATION        : PMODB1H                                                                                             
*** End of long names
BYTES

The length of the product ID and accounting string.

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

Field Name: QMDAASLN

PRODUCT ID

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 IBM i.

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

LOCATION

The location name for the Db2 subsystem that created the QMDAINFO values.

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

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Field Name: QMDALOCN

NET ID

The NETID of the Db2 subsystem that created the QMDAINFO values.

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

Field Name: QMDANETN

LU NAME

The SNA LU name of the Db2 subsystem that created the QMDAINFO values.

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

Field Name: QMDALUNM

CONNECT

The connection name of the Db2 system that created the MVS and DDF accounting values.

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

Field Name: QMDACNAM

CONNTYPE

The type of subsystem connection at the Db2 system where the SQL application is running. Possible values and their descriptions are:

BATCH
TSO or call attach
SASS
CICS
MASS
IMS
DIST
Distributed

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

Field Name: QMDACTYP

CORRNAME

The first 8 bytes of the correlation ID at the Db2 system running the SQL.

The last 4 bytes of the correlation ID at the Db2 system running the SQL.

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

Field Name: QMDACORR

AUTHID

The Db2 authorization ID that the SQL application used before name translation and before driving the connection exit at the Db2 site where the SQL application is running.

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

Field Name: QMDAAUTH

PLANNAME

The Db2 plan used at the Db2 system running the SQL.

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

Field Name: QMDAPLAN

MVS ACCOUNTING DATA

The MVS accounting string associated with the MVS address space of the SQL application. It is filled if PROD_TYP=D; otherwise X'00' is used.

This information comes from the ACCT= parameter on the job statement. If the ACCT= parameter is blank, the information on the EXEC statement is used. TSO logon Accounting information is used only if there is a value in the account field on the TSO Logon panel. Do not confuse this field with the Accounting correlation token.

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

Field Name: QMDAACCT