IFCID 142 - Audit DDL Create/Alter/Drop
This topic shows detailed information about Record Trace - IFCID 142 - Audit DDL Create/Alter/Drop
.
Audit DDL reports on SQL CREATE, ALTER, and DROP statements executed against an auditable object.
The SQL statement types are AUDIT DDL CREATE, AUDIT DDL ALTER, or AUDIT DDL DROP. These statements are all reported in the same format.
Record trace - IFCID 142 - Audit DDL Create/Alter/Drop
The field labels shown in the following sample layout of Record Trace - IFCID 142 - Audit DDL Create/Alter/Drop
are described in the following section.
AUDIT DDL NETWORKID: DEIBMIPS LUNAME: IPSAU851 LUWSEQ: 1
UNKNOWN TABLE NAME : AUDTB1
TABLE OWNER : PRL
TABLE CREATOR: PRL
TABLE OWNER TYPE:N/A
OPTIONS : X'0400000000000000'
DATABASE : 264
TABLE OBID : 3
SECLABEL OF MLS TABLE: N/P
MULTILEVEL SECURITY : N/P
ROW/CLMN ACCESS CTRL : B
SQL STMT:
CREATE TABLE PRL.AUDTB1 (IDCOLUMN INTEGER
GENERATED ALWAYS AS IDENTITY, NNAME VARCHAR
(50) NOT NULL, VNAME CHAR(10) NOT NULL,
ANZAHL INTEGER NOT NULL) AUDIT ALL IN
- TABLE NAME
-
The table name being created, altered, or dropped.
Field Name: QW0142TN
- TABLE OWNER
-
The table owner (same as table qualifier).
Field Name: QW0142OW
- TABLE CREATOR
-
The table creator.
Field Name: QW0142CR
- TABLE OWNER TYPE
-
The type of the table owner (grantor or revoker). Possible values are:
- L
- A ROLE is used.
- blank
- The user ID of the primary or the secondary authorization ID is used.
- N/P
- A blank is shown in the performance database.
- N/A
- A blank is shown in the performance database.
Field Name: QW0142OR
- 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: QW0142HO
-
- DATABASE
-
The database ID. Deduced from the Db2 fields QW0142DB, QW0105DN or QW0107DN.
When present, the database name is shown, otherwise the decimal identifier from QW0142DB is shown, or N/A when this value is 0.
Field Name: RT0142DB
- TABLE OBID
-
The object ID. Deduced from the Db2 fields QW0142OB, QW0105TN or QW0107TN.
When present, the name of the object is shown, otherwise the decimal identifier from QW0142OB is shown, or N/A when this value is 0.
Field Name: RT0142OB
- SECLABEL OF MLS TABLE
-
The security label that is used when the table is defined.
Field Name: QW0142SL
- MULTILEVEL SECURITY
-
The Multilevel Security (MLS) table can contain the following values:
- YES
- For a Create or Drop operation of a table that has multilevel security, or for an Alter operation of a table to add a security label column.
- NO
- For an Alter operation of a table that has multilevel security.
- NON MLS TABLE
- The table does not have multilevel security.
- N/P
- Not present. A blank is shown in the performance database.
- N/A
- A blank is shown in the performance database.
Field Name: QW0142ML
- ROW/CLMN ACCESS CTRL
-
The access control field contains data about ROW-LEVEL and COLUMN-LEVEL (R/C) ACCESS CONTROL in DDL. It can have the following values:
- 'R' (ROW)
- Activates row-level access control.
- 'C' (COLUMN)
- Activates column-level access control.
- 'B' (BOTH)
- Activates row-level and column-level access control.
- ' ' (NONE)
- Activates no access control.
Field Name: QW0142RC
- SQL STMT
-
The SQL statement text. Long SQL text can be truncated.
Field Name: QW0142TX