Default language.

DB2 Audit Detail report (AUDTL)

The DB2 Audit Detail report (AUDTL) provides an overview of all audited activity per user. The following figure shows a sample of the AUDTL report.

Related topic

Sample-audit-reports


Important

The report requires audit classes 1 through 8 (TYPE2=AUDSUM).

BMC SOFTWARE                                        DB2 AUDIT DETAIL REPORT                                             PAGE -     1
 REPORT: AUDTL                                                                                       REPORT DATE: 2000-05-25 19.25.28
                                                                                                                        SYSTEM - SYSB
                                                                                                                     SUBSYSTEM - DB2E

                                           AUDIT         AUDIT
  AUTHID    PLAN      DATE      TIME     CATEGORY        TYPE
 -------- -------- ---------- -------- ------------- ----------------
 ACCTDEP           2000-05-07 12.18.17 AUTH CHANGE   SIGNON
 ACCTDEP  TSMPL03  2000-05-09 07.14.10 AUTH CHANGE   SIGNON
 CJN1     DSNESPRR 2000-05-08 13.35.32 AUTH CNTL     GRANT
 CJN2     QMF311   2000-05-08 13.50.22 AUTH FAIL     SELECT
 CJN2     QMF311   2000-05-08 14.32.00 AUTH FAIL     INSERT
 CMR1              2000-05-07 17.20.00 AUTH CHANGE   SIGNON
 CMR1     TSMPL04  2000-05-07 11.34.00 AUTH CHANGE   SIGNON
 ELC2     MXZAPPL  2000-05-08 17.26.16 AUTH CNTL     REVOKE
 ELC2     MXZAPPL  2000-05-08 17.26.17 AUTH CNTL     GRANT
 ELC2     MXZAPPL  2000-05-08 17.26.34 AUTH CNTL     REVOKE
 ELC2     MXZAPPL  2000-05-08 17.26.42 AUTH CNTL     GRANT
 LAA1     RXSEL1M  2000-05-07 13.17.05 AUTH FAIL     EXECUTE
 MXW2     DSNUTIL  2000-05-07 12.33.47 UTILITY START LOAD
 MXW2     DSNUTIL  2000-05-08 07.09.20 DML WRITES    FIRST ACCESS
 MXW2     DSNUTIL  2000-05-08 07.10.05 UTILITY PHASE LOAD
 MXW2     DSNUTIL  2000-05-08 07.10.06 UTILITY TERM  LOAD
 MXW2     DSNUTIL  2000-05-08 08.37.04 UTILITY PHASE LOAD
 MXW2     DSNUTIL  2000-05-08 08.37.04 DML READS     FIRST ACCESS
 MXW2     MWSUMLD  2000-05-07 12.33.31 DML AT BIND   DELETE
 MXW2     MWSUMLD  2000-05-07 12.33.37 DML AT BIND   SEL QUERY
 MXW3     MWSUMLD  2000-05-08 11.30.01 DML READS     FIRST ACCESS
 PAYROLDP          2000-05-08 07.33.42 AUTH CHANGE   SIGNON
 PAYROLDP TSMPL02  2000-05-08 07.33.42 AUTH CHANGE   SIGNON
 SYSOPR            2000-05-07 11.06.09 AUTH CHANGE   END OF IDENTIFY
 SYSOPR            2000-05-09 11.01.24 AUTH FAIL     DISPLAY THD/DB
 SYSOPR            2000-05-09 11.24.15 AUTH CHANGE   END OF IDENTIFY
 SYSOPR            2000-05-09 11.25.18 AUTH FAIL     DISPLAY THD/DB
 SYSOPR            2000-05-09 11.25.43 AUTH CHANGE   END OF IDENTIFY
 TSM5              2000-05-07 15.56.03 AUTH CHANGE   SIGNON
 TSM5     TSMPL05  2000-05-07 15.56.03 AUTH CHANGE   SIGNON
 TSM6              2000-05-08 07.30.07 AUTH CHANGE   SIGNON
 TSM6     TSMPL06  2000-05-08 07.30.07 AUTH CHANGE   SIGNON
 TSM7              2000-05-07 16.48.38 AUTH CHANGE   SIGNON
 TSM7     TSMPL07  2000-05-07 16.48.39 AUTH CHANGE   SIGNON
 TSM8              2000-05-07 15.56.03 AUTH CHANGE   SIGNON
 TSM8     TSMPL08  2000-05-09 07.42.43 AUTH CHANGE   SIGNON

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 the audit record was completed

TIME

Time the audit record was completed

AUDIT CATEGORY

Description of audit category, such as AUTH FAIL, DML READ, and so on

AUDIT TYPE

Supplementary description of audited authorization

 

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