Db2 IFCID common SMF fields, SMF 100-102

QWHCAID

(EGNX)

AuthID

duid

Correlation authorization ID

QWHCATYP

(Mapped Integer)

ConnType

Connecting system type, one of TSO, CALL, BATCH, CICS, BMP, MPP, PRIV, DRDA, CTL, TRAN, UTIL or RRSAF

QWHCCN

(EGNX)

Conn

Correlation connection name

QWHCCV

(EGNX)

CorrID

cs6

Correlation ID

QWHCEUID

(EGNX)

UserID

suid

The end user’s user ID at the user’s workstation

QWHCEUID_L

(EGNX)

usrName

The end user’s user ID at the user’s workstation

This field’s formatting is conditioned on the software switch LEEF.

QWHCEUIDX

(EGNX)

EndUID

The end user’s user ID at the user’s workstation

QWHCEUTX

(EGNX)

Trans

The end user’s transaction name

QWHCEUWN

(EGNX)

WrkSta

shost

The end user’s workstation name

QWHCOPID

(EGNX)

OpID

Original operator ID

QWHCPLAN

(EGNX)

Plan

sproc

Plan name

QWHDPRID

(EGNX)

ProdID

PRDID parameter of DRDA ACCRDB command

Product ID of application requester. For private protocols this field sets to an appropriate product ID value. N/A if header is written at application requester site.

QWHDRQNM

(EGNX)

ReqLoc

Requester location name – blank if header Is written at application requester site

The name by which Db2 knows the application requester.

QWHDRQNM_L

(EGNX)

src

Requester location name – blank if header is written at application requester site

The name by which Db2 knows the application requester. This field’s formatting is conditioned on the software switch LEEF.

QWHDSVNM

(EGNX)

ReqNm

SRVNAM parameter of DRDA EXCSAT command

What a DRDA requester calls itself. For private protocols same as QWHDRQNM. N/A if header is written at application requester site.

QWHSACE

Ace

Address of the Dispatch Unit ACE

QWHSIID

(Integer)

IFCID

IFCID (Db2 instrumentation facility component identifier) number

QWHSIID_D

(Mapped Integer)

IFCID_D

IFCID (Db2 instrumentation facility component identifier) number expressed as text

QWHSLOCN

(EGNX)

Loc

cs4

Local location name

QWHSLUCC

(Integer)

Commits

Commit count

QWHSLUNM

(EGNX)

LU

LU name

QWHSLUUV

Unique

Uniqueness value

Uniquely identifies a distributed thread.

QWHSLWID

LUWID

cs3

Logical unit of work ID, in the format Network.LU.Uniqueness.Commits

QWHSNID

(EGNX)

NetID

cs5

Network ID

QWHSNSDA

(Integer)

NSDA

Number of self-defining sections

This field is intended primarily for diagnostic use.

QWHSRMID

(Integer)

RMID

RMID (Db2 Resource Manager Identifier)

QWHSRN

Rel

Db2 version and release number, for instance, 10.1

Integer

CPUTime

CPU time of TCB or SRB

SM100SSI

(EGNX)

Subsys

dproc

Db2 Subsystem ID

SMFDB2CAT

(EGNX)

Cat

cat

Constant Db2