SMF DB2 fields

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 ID) number

QWHSIID_D
 (Mapped Integer)

IFCID 

IFCID (DB2 Instrumentation Facility Component ID) 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

SM100SSI
 (EGNX)

Subsys
dproc

DB2 Subsystem ID

SMFDB2CAT
 (EGNX)

Cat
 cat

Constant DB2