IFCID 147 - Thread Correlation Data

This topic shows detailed information about Record Trace - IFCID 147 - Thread Correlation Data.

Record trace - IFCID 147 - Thread Correlation Data

The field labels shown in the following sample layout of Record Trace - IFCID 147 - Thread Correlation Data are described in the following section. 


!                                                 THREAD CORRELATION DATA                                                  
!*** Long name section:                                                                                                    
!ORIGINAL AUTHID : EDVA                                                                                                    
!PRIMARY AUTHID  : EDVA                                                                                                    
!END USER ID     : EDVA                                                                                                    
!*** End of long names                                                                                                     
!                                                                                                                          
!AUTHORIZATION ID: EDVA          CONNECTION NAME : DB2CALL      CORRELATION VALUE: EDVA                                    
!PLAN NAME       : DSNREXX       ORIGINAL AUTH ID: EDVA         CONNECTION TYPE  : DB2 CALL ATTACH                         
!ACCOUNTING TOKEN: N/A                                                                                                     
!END USER ID     : EDVA          TRANSACTION     : EDVA         JOBSTEP NAME     :      N/A                                
!END USER WST    : DB2CALL                                                                                                 
!                                                                                                                          
!*** Service Area:                                                                                                         
!DB2 Version      :        161   Record subversion:          3  QWHC Length      : X'00A4'
ORIGINAL AUTHID
The original authorization ID. Possible values are:
  • For TSO: the logon ID
  • For batch: the user ID on the job statement
  • For IMS (message-driven regions): the signon ID, LTERM, ASXBUSR, or PSB name
  • For IMS (control regions): the user ID on the job statement, or the RACF® started procedure entry if RACF is used
  • For CICS: the user ID, TERM ID, TRAN ID, or as specified in the resource control table
  • For MVS operator commands and Db2 system internal agents: SYSOPR
  • For a distributed application server (AS):
    • If the application requester (AR) is a Db2 system, then this is the same value that was assigned at the AR.
    • If the application requester is not a Db2 system, then this is the user ID used to make the initial connection with the application server.

Field Name: QWHCOPID

PRIMARY AUTHID

The primary authorization ID from a connection or signon. The connection authorization exit and the signon authorization exit can change the primary authorization ID so that it differs from the original primary authorization ID (ORIGAUTH). Distributed authorization ID translation can also change the primary authorization ID.

Field Name: QWHCAID

END USER ID

The user ID of the workstation end user. This user ID can be different from the authorization ID used to connect to Db2. This field contains blanks if the client does not supply this information.

Field Name: QWHCEUID

AUTHORIZATION ID

The primary authorization ID from a connection or signon. The connection authorization exit and the signon authorization exit can change the primary authorization ID so that it differs from the original primary authorization ID (ORIGAUTH). Distributed authorization ID translation can also change the primary authorization ID.

Field Name: QWHCAID

CONNECTION NAME
The connection name. Possible values are:
  • For batch: BATCH
  • For TSO: TSO
  • For QMF: DB2CALL
  • For utilities: UTILITY
  • For Db2 private protocol this is the Db2 subsystem ID
  • For IMS: the IMS ID
  • For CICS, this is the CICS ID
  • For DRDA connections from non-Db2 requesters: SERVER

Field Name: QWHCCN

This is an exception field.

CORRELATION VALUE
Correlation ID value:
FOR BATCH
Job name
FOR TSO
Logon ID
FOR IMS/VS
PST#.PSBNAME
FOR CICS
CONNECTION_TYPE.THREAD_TYPE.THREAD_#.TRAN-ID
FOR RRSAF
CORRELATION-ID VALUE FROM SIGNON FUNCTION
For threads using the Db2 private protocol or DRDA from a Db2 requester
This field contains the correlation-id name of the thread at the requesting location.
For threads using DRDA from a non-Db2 requester
This field contains the first 12 characters in the DDM external name (EXTNAM) parameter of the DDM EXCSAT command received as part of the SQL connect.

Field Name: QWHCCV

PLAN NAME
The plan name. It is blank for a Db2 command thread; otherwise:
DSNESPRR
For SPUFI with repeatable read.
DSNESPCS
For SPUFI with cursor stability.
DSNUTIL
For utilities.
DSNTEP2
For DSNTEP2.
DSNBIND
For binding.
The application plan name
For IMS.
The application plan name
For CICS®.
A blank plan name
For IMS and CICS commands.
DSQPLAN
For QMF.
The first 8 bytes of the application name
For DRDA connections to the common servers.

Field Name: QWHCPLAN

This is an exception field.

ORIGINAL AUTH ID
The original authorization ID. Possible values are:
  • For TSO: the logon ID
  • For batch: the user ID on the job statement
  • For IMS (message-driven regions): the signon ID, LTERM, ASXBUSR, or PSB name
  • For IMS (control regions): the user ID on the job statement, or the RACF started procedure entry if RACF is used
  • For CICS: the user ID, TERM ID, TRAN ID, or as specified in the resource control table
  • For MVS operator commands and Db2 system internal agents: SYSOPR
  • For a distributed application server (AS):
    • If the application requester (AR) is a Db2 system, then this is the same value that was assigned at the AR.
    • If the application requester is not a Db2 system, then this is the user ID used to make the initial connection with the application server.

Field Name: QWHCOPID

CONNECTION TYPE

The connecting system type code (in hexadecimal). This field can have a null value. Utilities, for example, do not have a connecting system type.

Field Name: QWHCATYP

ACCOUNTING TOKEN

Accounting correlation token.

This field applies only if CONNECTION TYPE equals CICS ATTACH or RRSAF ATTACH, otherwise N/A is shown.

If connection type is CICS ATTACH, the first eight bytes identify the network name (right padded with blanks), the second eight bytes identify the LU name (right padded with blanks), the final six bytes are the uniqueness value.

If the connection type is RRSAF ATTACH, the field is the value of the parameter accounting token in the RRSAF signon function.

This field is shown as both a character and a hexadecimal string.

Field Name: QWHCTOKN

TOKEN IN HEX

Accounting correlation token.

This field applies only if CONNECTION TYPE equals CICS ATTACH or RRSAF ATTACH, otherwise N/A is shown.

If connection type is CICS ATTACH, the first eight bytes identify the network name (right padded with blanks), the second eight bytes identify the LU name (right padded with blanks), the final six bytes are the uniqueness value.

If the connection type is RRSAF ATTACH, the field is the value of the parameter accounting token in the RRSAF signon function.

This field is shown as both a character and a hexadecimal string.

Field Name: QWHCTOKN

END USER ID

The user ID of the workstation end user. This user ID can be different from the authorization ID used to connect to Db2. This field contains blanks if the client does not supply this information.

Field Name: QWHCEUID

TRANSACTION

The transaction or application name that is run.

Field Name: QWHCEUTX

JOBSTEP NAME

If the thread that is currently running is a TCB, this value is the step name in the JCL that is running the batch job.

Field Name: QWHCJOBSTEP

END USER WST

The end user's workstation name.

Field Name: QWHCEUWN