__________________________________________________________________________________________________________________
HCLZ Data Tools 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: HFMUSER.HFM2AUD.DB26.D020918.T155156
Audit description:
System Information:
MVS System Id: FMD2
Db2 Subsystem: DB26
Current SQLID: HFMUSER
Db2 Object Information:
Location:
Owner: HFMUSER
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 "HFMUSER"."EMP"
__________________________________________________________________________________________________________________
The first part of the Formatted Event Records section shows:
The ZDT/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 ZDT/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
__________________________________________________________________________________________________________________
HCLZ Data Tools 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: HFMUSER
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 ZDT/Db2 session.