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

QW0361LL

(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

QW0140LL

(Integer)

Len

Length of SQL statement