SMF DB2 fields of IFCID 361

QW0361AT
 (EGNX)

AuthType
 dpriv

Authority type, represented as a one-character code such as B or C

QW0361ATD
 (Mapped Integer)

AuthType
 dpriv

Authority type, represented as a textual description such as System DBADM, DBCTRL

QW0361ID
 (EGNX)

Authority

Authorization ID or role that has the authority

QW0361IT
 (EGNX)

AuthIDType
 cs2

Authorization ID type, expressed as a one-byte code of blank for primary or secondary authorization ID, and L for a role

QW0361ITD
 (Mapped Integer)

AuthIDType
 cs2

Authorization ID type, expressed as AuthID or Role

QW0140LL
 (Integer)

Len

Length of SQL statement

QW0361ON
 (EGNX)

Other

Other object name

QW0361OT
 (EGNX)

ObjType
 fileType

Object type, expressed as a one-byte code such as B or C

QW0361OTD
 (Mapped Integer)

ObjType
 fileType

Object type, expressed as a name such as Bufferpool or Collection

QW0361PR
 (Integer)

Priv
 spriv

Privilege checked, expressed as an integer

QW0361PRD
 (Mapped Integer)

Priv

spriv

Privilege checked, expressed as a textual description such as Display profile or Start profile

QW0361SC
 (EGNX)

SrcQual

Source object qualifier and owner

QW0361SN

Src

Source object name

QW0361TC
 (EGNX)

TargQual
 filePath

Target object qualifier and owner

QW0361TN
 (EGNX)

Targ
 fname

Target object name

QW0361TX
 (EGNX)

Cmd

SQL statement or command, truncated at 4000 bytes if required

QW0361TX_1023
 (EGNX)

Cmd
 cs1

SQL statement or command, truncated at 1023 bytes if required

QW0361TX_1500
 (EGNX)

Cmd

SQL statement or command, truncated at 1500 bytes if required

QW0361TX_2500
 (EGNX)

Cmd

SQL statement or command, truncated at 2500 bytes if required