SMF DB2 fields of IFCID 140

QW0140AT

(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

QW0140ATD

(Mapped Integer)

AuthIDType

cs2

Authorization ID type, expressed as AuthID or Role

QW0140HO

Options

Host options for SQL statements as 8 bytes of hexadecimal (zeroes for non-SQL statements)

QW0140HO1B

(Mapped Integer)

Lang1

Host options language field one: Assembler, COBOL, FORTRAN, Dynamic, FORTRAN, IBM COBOL, or See Lang3

QW0140HO3

(Mapped Integer)

Lang3

Host options language field three: Assembler, COBOL, PL/I, FORTRAN, COBOL2, IBM COBOL, C++, or C

QW0140LL

(Integer)

Len

Length of failing SQL statement + 4 (zero when no SQL statement exists)

QW0140OB

(EGNX)

ObjType

fileType

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

QW0140OBD

(Mapped Integer)

ObjType

fileType

Object type, expressed as a textual description such as Bufferpool or Collection

QW0140PR

(Integer)

Priv

Privilege being checked, expressed as an integer

QW0140PRD

(Mapped Integer)

Priv

Privilege being checked, expressed as a textual description

QW0140RC

(Integer)

ExitRet

outcome

Return code from access control authorization exit routine: -1 – exit was not called; 4 – perform db2 authorization check; 8 – not authorized; 12 – unable to service request, do not call again

QW0140RS

(Integer)

ExitRsn

reason

User defined reason code from the access control authorization exit routine

QW0140SC

(EGNX)

SrcQual

Source Object Owner. Two cases:

1) If object type not equal User Auth – Qualifier of the object against which authorization was checked. Valid for qualifiable objects.

2) If object type equals User Auth – Qualifier of ALIAS being created. Valid for CREATE ALIAS privilege.

QW0140SN

(EGNX)

Src

Source Object Name: Two cases:

1) If object type not equal User Auth – Name of the object against which authorization was checked.

2) If object type equals User Auth – Name of the object being created. Valid when privilege is CREATE ALIAS, CREATEDBA, CREATEDBC, or CREATE STOGROUP.

QW0140TC

(EGNX)

TargQual

filePath

Target Object Owner: Qualifier of the object being defined

This field is valid for the CREATE INDEX and CREATE TABLE privileges. It is also valid for the CREATE VIEW authorization check that is a set of checks against the following privileges: CREATE VIEW (when creating view for another), SELECT, INSERT, DELETE and UPDATE.

QW0140TN

(EGNX)

Targ

fname

Target object name: Name of the object being defined

This field is valid only in the same cases for which QW0140TC is valid.

QW0140TX

(EGNX)

Sql

request

SQL text, truncated to 4000 bytes

QW0140TX_1023

(EGNX)

Sql

cs1

SQL text, truncated to 1023 bytes

QW0140TX_1500

(EGNX)

Sql

SQL text, truncated to 1500 bytes

QW0140TX_2500

(EGNX)

Sql

SQL text, truncated to 2500 bytes

QW0140UR

(EGNX)

AuthIDChk

Authorization ID being checked

QW0140UT

Utok

ACEE Utoken if available, formatted as a diagnostic dump

If not accessible 1st word 0 – Not able to get UTOKEN; -1 – Abend on accessing ACEE.

QW0140UT_POE

(EGNX)

POE

ACEE Utoken Port of entry (CONS ID,TERM ID-first half of IP value for SERVAUTH)

QW0140UT_SGRP

(EGNX)

Group

spriv

ACEE Utoken submitting GROUPNAME

QW0140UT_SGRP_L

(EGNX)

groupID

ACEE Utoken submitting GROUPNAME

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

QW0140UT_XNOD

(EGNX)

Node

ACEE Utoken execution node