Default language.

DB2 Audited DDL Access report (AUDDL)

The DB2 Audited DDL Access report (AUDDL) provides DDL data for each authorization ID and plan. The report identifies DDL status changes (CREATE, DROP, ALTER) on audited tables. The following figure shows a sample of the AUDDL report.

Related topic

Sample-audit-reports


Important

It requires audit class 3 (TYPE2=AUDDDL).

BMC SOFTWARE                                        DB2 AUDITED DDL ACCESS REPORT                                       PAGE -     1
 REPORT: AUDDL                                                                                       REPORT DATE: 2000-05-25 16.53.08
                                                                                                                        SYSTEM - SYSB
                                                                                                                     SUBSYSTEM - DB2E
                                                                    TABLE     TABLE  TABLE
  AUTHID    PLAN     DATE       TIME     TYPE      TABLE NAME       OWNER    CREATOR OBID  DATABASE SQL TEXT
 -------- -------- ---------- -------- -------- ------------------ -------- -------- ----- -------- -------------------------------
 MXW3    DSNESPCS 2000-05-07 22.08.32 DROP     DMRAUSUM          MXW2     MXW2         96              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.09.06 DROP     DMRAUSUM          MXW2     MXW2         96              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.09.22 CREATE   DMRAUSUM          MXW2     MXW3         96
 MXW3    DSNESPCS 2000-05-07 22.30.48 DROP     DMRAUSUM          MXW2     MXW3         96              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.31.02 CREATE   DMRAUSUM          MXW2     MXW3         96
 MXW3    DSNESPCS 2000-05-07 22.48.41 DROP     DMRAUDMB          MXW2     MXW2         71              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.41 DROP     DMRAUCHG          MXW2     MXW2          3              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.41 DROP     DMRAUDDL          MXW2     MXW2         76              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.42 DROP     DMRAUDML          MXW2     MXW2         81              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.42 DROP     DMRAUGRV          MXW2     MXW2         91              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.42 DROP     DMRAUFAL          MXW2     MXW2         86              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.42 DROP     DMRAUUTL          MXW2     MXW2        101              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.48.42 DROP     DMRAUSUM          MXW2     MXW3         96              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-07 22.49.30 CREATE   DMRAUCHG          MXW2     MXW3          3
 MXW3    DSNESPCS 2000-05-07 22.49.34 CREATE   DMRAUDMB          MXW2     MXW3         71
 MXW3    DSNESPCS 2000-05-07 22.49.41 CREATE   DMRAUDDL          MXW2     MXW3         76
 MXW3    DSNESPCS 2000-05-07 22.50.11 CREATE   DMRAUCHG          MXW2     MXW3          3
 MXW3    DSNESPCS 2000-05-07 22.50.15 CREATE   DMRAUDMB          MXW2     MXW3         71
 MXW3    DSNESPCS 2000-05-07 22.50.21 CREATE   DMRAUDDL          MXW2     MXW3         76
 MXW3    DSNESPCS 2000-05-07 22.51.33 CREATE   DMRAUCHG          MXW2     MXW3          3
 MXW3    DSNESPCS 2000-05-07 22.51.37 CREATE   DMRAUDMB          MXW2     MXW3         71
 MXW3    DSNESPCS 2000-05-07 22.51.41 CREATE   DMRAUDDL          MXW2     MXW3         76
 MXW3    DSNESPCS 2000-05-07 22.51.46 CREATE   DMRAUDML          MXW2     MXW3         81
 MXW3    DSNESPCS 2000-05-07 22.51.51 CREATE   DMRAUFAL          MXW2     MXW3         86              CREATE TABLE MXW2.DMRAUFAL
 MXW3    DSNESPCS 2000-05-07 22.51.56 CREATE   DMRAUGRV          MXW2     MXW3         91
 MXW3    DSNESPCS 2000-05-07 22.52.01 CREATE   DMRAUSUM          MXW2     MXW3         96
 MXW3    DSNESPCS 2000-05-07 22.52.07 CREATE   DMRAUUTL          MXW2     MXW3        101
 MXW3    DSNESPCS 2000-05-08 14.12.28 DROP     DMRAUDDL          MXW2     MXW3         76              DROP TABLESPACE MWDMRDB1
 MXW3    DSNESPCS 2000-05-08 14.13.12 CREATE   DMRAUDDL          MXW2     MXW3         76

The report data is sorted by both AUTHID and PLAN (default). The following table describes the columns on the report.

Column

Description

AUTHID

Authorization ID of the user accessing this Db2 system

PLAN

Plan name of the application program, transaction, or utility executed

DATE

Date of the audited DDL access

TIME

Time of the audited DDL access

TYPE

Type of access performed on the audited Db2 table, such as CREATE, ALTER, or DROP

TABLE NAME

Name of the accessed audited Db2 table

TABLE OWNER

User ID of the owner of the audited Db2 table accessed

TABLE CREATOR

Authorization ID of the creator of the Db2 table associated with the DDL access

TABLE OBID

Internal Db2 identification (OBID) of the table associated with the access

DATABASE

Name of the database (or DBID) containing the audited Db2 table

SQL TEXT

Beginning of the text of the SQL statement accessing the audited Db2 table

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*