Db2 transaction groupings values

The standard fields are:

• CORR—The correlation ID is a one- to twelve-character identifier passed to Db2 that identifies the task requesting Db2 services. The value in this field depends on the connection type. Hexadecimal values are converted to #. The correlation ID values for each connection type appear in the following table:

  Connection type	Contents of correlation ID
  CICS	Transaction name (bytes 5 - 8)
  DLIBATCH	PSBname (bytes 5 - 12)
  IMSBMP	PSBname (bytes 5 - 12)
  IMSCNTL	PSBname (bytes 5 - 12)
  IMSMPP	PSBname (bytes 5 - 12)
  TSO	Userid
  TSOBATCH	Jobname
  DB2CALL	Eight-character value passed from the requestor
  System Directed Access	Eight-character value passed from the requestor
  Appl. Directed Access	Eight-character value passed from the requestor
  RRSAF	Eight-character value passed from the requestor
  Db2 Utilities	Eight-character value passed from the requestor

• CORRASIS—The correlation value as it appears in the data.
• SAPUID—From the correlation header, this field is the end user’s user ID at the user’s workstation.
• EUID—From the correlation header, this field is the end user’s user ID at the user’s workstation.
• SAPTRAN—From the correlation header, this field is defined as the end user’s transaction name.
• EUTRAN—From the correlation header, this field is defined as the end user’s transaction name.
• SAPWPTYP—From the correlation header, this field is the first byte of the field defined as the end user’s workstation name. For SAP, this is the work process type.
• SAPWPNUM—From the correlation header, this field is the third through seventh bytes of the field defined as the end user’s workstation name. For SAP, this is the work process number.
• SAPWPID—From the correlation header, this field is the ninth through eighteenth bytes of the field defined as the end user’s workstation name. For SAP, this is the work process identifier.
• SAPWP—From the correlation header, this is the SAP work process information (SAPWPTYP & SAPWPNUM & SAPWPID).
• EUWS—From the correlation header, this field is defined as the end user’s workstation name.
• PLAN—A Db2 plan name is the one- to eight-character value that identifies to Db2 the collection of SQL requests associated with a load module.
• PACKAGE—A Db2 package name is the one- to eight-character value that identifies to Db2 the collection of SQL requests associated with a load program.
• AUTH—A Db2 authorization ID is the one- to eight-character value that identifies the user ID requesting Db2 services. The authorization ID is different from the original operator ID, if secondary authorization IDs are used during Db2 sign-on.
• OPER—Db2 operator ID is the one- to eight-character value that identifies the original operator ID of the Db2 user.
• TRAN—The transaction name for a CICS connection. This is also the PSBname for an IMS connection and the Db2 plan name for all other connection types.
• LOCATION—The location value for a DDF connection type (system-directed access or application-directed access).
• PSB—The PSBname for an IMS connection type.
• JOB—The jobname for batch connection types.
• TYPEv—The connection type keyword, such as CICS, IMSMPP, TSO, and so on.
• NONE—Indicates that nothing is required in this field.

The following additional Db2 fields can be specified:

• QWHSLOCN—Local location name
• QWHSLWID—Logical unit of work ID
• QWHSNIDv—Network ID
• QWHSLUNM—Network name
• QWHCAIDv—Primary authorization ID from connection or signon
• QWHCCVv—Raw correlation ID
• QWHCCNv—Connection name
• QWHCPLANv—Plan name
• QWHCOPIDv—Original primary authorization ID
• QWHCTOKNv—Accounting correlation token
• QWHCEUID—End user’s work station user ID
• QWHCEUTX—Transaction or application that the end user is running
• QWHCEUWN—End user’s work station name
• QWHDRQNM—Requestor location name
• QWHDTSTP—Timestamp for DBAT trace records
• QWHDSVNM—EXSCAT SRVNAM parameter
• QWHDPRID—ACCRDB PRDID parameter
• QWHAMEMN—Db2 data sharing group member name
• QWHADSGN—Db2 data sharing group name
• QWACNID—Network ID value passed from CICS, IMS or RRS
• QWACWLME—MVS Workload Manager Service Class name
• QLACLOCN—Location name of the remote location
• QLACPRID—Product ID of the remote location
• QMDAAINF—Account information
• QMDAPRID—Accounting string product ID
• QMDAPTYP—Accounting string product name
• QMDAPVER—Accounting string product version
• QMDAPREL—Accounting string product release
• QMDAPMOD—Accounting string product modification level
• QMDAASTR—Accounting string for the agent
• QMDAINFO—Entire accounting string
• QMDALOCN—Location name that created the QMDAINFO values
• QMDANETN—NETID that created the QMDAINFO values
• QMDALUNM—LU name that created the QMDAINFO values
• QMDACNAM—Db2 connection name at the Db2 system where the SQL application is running
• QMDACTYP—Db2 connection type at the Db2 system where the SQL application is running
• QMDACORR—Db2 correlation ID at the Db2 system where the SQL application is running
• QMDAAUTH—Db2 authorization ID that the SQL application used
• QMDAPLAN—Db2 plan that the SQL application used
• QMDAPLAT—Client platform
• QMDAAPPL—Client application name
• QMDAATID—Client authorization ID
• QPACPKNM—Package name
• QPACLOCN—Location name
• QPACCOLN—Package collection ID
• QPACPKID—Program name
• QPACCONT—Consistency token
• QPACASCH—Schema data
• QPACAANM—Trigger, stored procedure or user-defined function name
• QWDAXCQO—Correlating value for parallel task
• QWHCTCXT—Trusted context name
• QWHCROLE—Authorization ID role name
• QWHCOAUD—Original application user ID
• QMDAACCT—MVS accounting string for Db2 SQL application
• QMDASQLI—Accounting string from Db2 client
• QMDASUFX—DDCS account suffix