Audit Trail Report

The audit trail report is divided into two sections: Formatted Audit Events Records (Audit trail report: Formatted Audit Event Records section) and Summary Statistics (Audit trail report: Summary Statistics section).
Figure 1. Audit trail report: Formatted Audit Event Records section
__________________________________________________________________________________________________________________
 IBM® File Manager for z/OS Db2 Component  Audit Trail Report                                       Page 1
                                              Formatted Audit Event Records                        Date: 2004-09-2
                                                                                                   Time: 11.14.39

Audit trail for EDIT function.
     Data set name: FMNUSER.FMN2AUD.DB26.D020918.T155156
 Audit description:
System Information:
     MVS System Id: FMD2
     Db2 Subsystem: DB26
     Current SQLID: FMNUSER
Db2 Object Information:
          Location:
             Owner: FMNUSER
              Name: EMP
Template Information:
     Data set name:
Audit event number: 1                   Data fetched on 02/09/18 at 15.52.00
     SQL statement:   SELECT "EMPNO", "FIRSTNME", "MIDINIT", "LASTNAME", "WORKDEPT", "PHONENO", "HIREDATE",
                       "JOB", "EDLEVEL", "SEX", "BIRTHDATE", "SALARY", "BONUS", "COMM" FROM "FMNUSER"."EMP"
__________________________________________________________________________________________________________________
The first part of the Formatted Event Records section shows:
  • The FM/Db2 function being audited (View, Edit, or Copy).
  • The name of the data set holding the audit log records.
  • The report description (if specified).
  • Location information for the Db2® object being manipulated.
The second part of the Formatted Event Records section shows information for each audit event (each SQL call is defined as a separate audit event):
  • The audit event number.
  • A date and timestamp.
  • The SQL statement.
  • The Db2® column name.
  • The type of key (if applicable).
  • The original value of the column (if the column has been changed or deleted).
  • The new value of the column (if the column has been changed or inserted).

If Print only changed fields was selected on the Print Audit Trail panel, only columns where the data has changed are shown.

Every FM/Db2 view, edit, or copy of a Db2® object is recorded as a separate session. If SMF recording is used, many sessions can be logged. Summary statistics are provided for each session, not the entire period being audited.
Figure 2. Audit trail report: Summary Statistics section
Summary Statistics
__________________________________________________________________________________________________________________
 IBM® File Manager for z/OS Db2 Component  Audit Trail Report                                       Page 2
                                              Summary Statistics                                   Date: 2004-09-2
                                                                                                   Time: 11.14.39

                        Data base opened on 2004-09-18 at 15.52.00 by userid: FMNUSER
                        Data base closed on 2004-09-18 at 15.55.47
   Total SQL statements: 1
          Rows inserted: 0
           Rows deleted: 0
          Rows replaced: 0
TOTAL Data base changes: 0
       Records bypassed: 0
Audit Trail Report Options
                Maximum Print Lines per Page: 60
      Print Only Changed Fields on an Update: NO
__________________________________________________________________________________________________________________
The Summary Statistics section shows:
  • The times the database was opened and closed.
  • The user ID.
  • Counts of the number of SQL calls, inserts, deletes, and row replacements for the FM/Db2 session.
  • The total number of update events.

Related tasks

Related references