IFCID142: Audit DDL Create/Alter/Drop

The IFCID142 DD contains the extracted IFCID 142 (Audit DDL Create/Alter/Drop) records, which contain the record of CREATE, ALTER, and DROP statements against tables that are audited or that have multilevel security defined at the row level.

Fields

Begin program-specific programming interface information.

The IFCID142 DD has the following fields:

AUDIT DDL

ALTER, CREATE, or DROP.

Field Name: QW0142AC

TABLE NAME

The table name that is being created, altered, or dropped.

Field Name: QW0142TN

TABLE OWNER

The table owner (same as table qualifier).

Field Name: QW0142OW

TABLE OWNER TYPE

The table owner type. TABLE OWNER TYPE can have the following values:

PRIMARY OR SECONDARY AUTH ID
ROLE

Field Name: QW0142OR

TABLE CREATOR

The table creator.

Field Name: QW0142CR

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. See the OPTIONS field of IFCID140: Audit Authorization Failures for a full description of the bits of this field.

Field Name: QW0142HO

DATABASE

The database ID.

Field Name: QW0142DB

TABLE OBID

The object ID.

Field Name: QW0142OB

SECLABEL OF MLS TABLE

The security label of the Multilevel Security (MLS) table.

Field Name: QW0142SL

MULTILEVEL SECURITY

Shows the multilevel security (MLS) status as follows:

Y (on CREATE or DROP of an MLS Table, or ALTER to add a SECLABEL column)
N (on ALTER of an MLS table)
NON-MLS
N/A

Field Name: QW0142ML

ROW/COLUMN ACCESS CONTROL

Shows the row and column access control status. The field can have one of the following values:

ACTIVATE ROW ACCESS CONTROL
ACTIVATE COLUMN ACCESS CONTROL
ACTIVATE ROW AND COLUMN ACCESS CONTROL
NO ACCESS CONTROL
N/A

Field Name: QW0142RC

SQL STMT

The SQL statement text. Long SQL text can be truncated.

Field Name: QW0142TX

Example

AUDIT DDL                                                                                        
ALTER         TABLE NAME   : TBCCDB2A                                                            
              TABLE OWNER  : SCCCDB2A                                                            
              TABLE OWNER TYPE: N/A                                                              
              TABLE CREATOR: USRT001                                                             
              OPTIONS      : X'0400000000000000'                                                 
              DATABASE     : 00269                                                               
              TABLE OBID   : 00003                                                               
              SECLABEL OF MLS TABLE: L3C234                                                      
              MULTILEVEL SECURITY  : N (on ALTER of an MLS table)                                
              ROW/COLUMN ACCESS CONTROL: NO ACCESS CONTROL                                       
              SQL STMT: ALTER TABLE SCCCDB2A.TBCCDB2A ALTER COLUMN NAME SET DATA TYPE VARCHAR(10)

End program-specific programming interface information.