IFCID 145 - Audit DML Statement

This topic shows detailed information about Record Trace - IFCID 145 - Audit DML Statement.

Record trace - IFCID 145 - Audit DML Statement

The field labels shown in the following sample layout of Record Trace - IFCID 145 - Audit DML Statement are described in the following section. 


-------------------------------------------------------------------------------------------------------------------------
*** AUDIT LOG RECORD ***

-------------------------------------------------------------------------------------------------------------------------
SECTION 1 - AUDIT INFORMATION:

LOCATION NAME: DB0B                        PKG COLLCT ID: DSNTEP2                     PROGRAM NAME : DSNTEP2
STMT TIME    : X'18CABFE7169A11C0'         TYPE         : SELECT - QUERY              ISOLATION    : CS
HOST OPTIONS : X'0400000000000000'         SQL CODE     :          0                  STMT #       :       1829
STMT ID      :                    50       DBID/OBID #  :          1                  MASK/PERM #  :          2

LOCATION NAME (LONG):   DB0B
PKG COLLCT ID (LONG):   DSNTEP2
PROGRAM NAME (LONG) :   DSNTEP2
-------------------------------------------------------------------------------------------------------------------------
SECTION 2 - AUDIT OBJECTS:

DATABASE: 353                              TABLE OBID:          3
-------------------------------------------------------------------------------------------------------------------------
SECTION 3 - ROW/COLUMN ACCESS CTRL OBJECTS:

SCHEMA NAME: DB0BSECA
OBJECT NAME: INCOME_BRANCH

SCHEMA NAME: DB0BSECA
OBJECT NAME: RA01_CUSTOMERS

-------------------------------------------------------------------------------------------------------------------------
SECTION 4 - SQL STATEMENT TEXT:

SELECT * FROM DB2R5.CUSTOMER
-------------------------------------------------------------------------------------------------------------------------
LOCATION NAME

The location name.

Field Name: QW0145LN

PKG COLLCT ID

The package collection identifier.

Field Name: QW0145PC

PROGRAM NAME

The program name.

Field Name: QW0145PN

STMT TIME

The hexadecimal value of the precompiler timestamp.

Field Name: QW0145TS

TYPE

The SQL statement type.

Field Name: QW0145ST

ISOLATION
The isolation level of the DML statement:
RR
Repeatable read
CS
Cursor stability
RS
Read stability
UR
Uncommitted read
XR
Repeatable read with X lock
XS
Read stability with X lock

Field Name: QW0145IS

HOST OPTIONS
The options used in the host to check the SQL statement. The bits of this field are used as indicators. If all bits are 0, the statement is not an SQL statement. The values are:
Bit 1
Host language character string delimiter
0
Apostrophe
1
Quote
Bit 2
Decimal point symbol
0
Period
1
Comma
Bit 3
SQL character string delimiter
0
Apostrophe
1
Quote
Bit 4
Mixed character string indicator
0
No
1
Yes
Bit 5
Host language options indicator
0
Do not use host language options
1
Use host language options
Bits 6 to 8
Host language indicator
001
Assembler
010
Cobol
011
PL/I
100
None - Dynamic SQL
101
Fortran
110
Cobol2
111
Null - See bits 17 to 24 for the language
Bits 9 to 16
Character set being used
00000000
Alphanumeric
00000001
Katakana
Bits 17 to 24
Alternate host language field
B
Assembler
C
Cobol
P
PL/I
F
Fortran
2
Cobol2
D
C
Bits 25 to 28
Time Option
0000
None
1000
Local
0100
JIS
0010
ISO/EUR
0001
USA
Bits 29 to 32
Date Option
0000
None
1000
Local
0100
EUR
0010
ISO/JIS
0001
USA
Bit 33
Decimal
0
No
1
Yes
Bits 34 to 40
Unused
Bits 41 to 48
Remote option
00000001
SQL(ALL)
00000010
SQL(DB2)
Bits 49 to 56
SQL flag option
00000000
No SQLFLAG option
00000001
SQLFLAG(SAA)

Field Name: QW0145HO

SQL CODE

The SQLCODE of the SQL statement.

Field Name: QW0145SC

STMT #

The precompiler statement number.

Field Name: QW0145SN

STMT ID

The SQL unique statement ID.

Field Name: QW0145SI

DBID/OBID #

The number of unique non-zero DBID and OBID in the audited statement.

Field Name: QW0145OB_NUM

MASK/PERM #

The number of masks or permissions enforced in the audited statement.

Field Name: QW0145AC_NUM

LOCATION NAME (LONG)

The location name.

Field Name: QW0145LN

PKG COLLCT ID (LONG)

The package collection identifier.

Field Name: QW0145PC

PROGRAM NAME (LONG)

The program name.

Field Name: QW0145PN

DATABASE

The audit log table DBID in hexadecimal.

Field Name: QW0145DB

TABLE OBID

The audit log table OBID in hexadecimal.

Field Name: QW0145OB

SCHEMA NAME

The name of the access control schema.

Field Name: QW0145AS

OBJECT NAME

The name of the access control object.

Field Name: QW0145AO

SECTION 4 - SQL STATEMENT TEXT (NO LABEL)

The SQL statement text associated with the BIND. If SQL text is not present, N/P is printed. Long SQL text can be truncated.

Field Name: QW0145RT