Audit report
The Audit report presents changes to critical data.
Log Master reports present only the data defined by your time frame and filter. The report is similar to the Detail report (Detail-report) with the following exceptions:
- Both the Audit and Detail reports show data from data manipulation language (DML) log records, including update log records. When the Audit report shows data from an update log record, it shows only the changed data. When the Detail report shows an update log record, it shows all data.
- The Audit report shows primary key information (for an example, see the IX Value field in Example Audit report by table name and URID). The Detail report does not show information about primary keys.
Use Audit reports to determine
- Who changed critical data
- When data was changed
- The volume of data changed
You can also use an Audit report to show information about changes to the Db2 catalog, including changes to Db2 security. For more information, see Auditing Db2 catalog activity.
When you use the Create Audit Report task dialog in the online interface, Log Master produces the Audit report by default. To request an Audit report, from any other task dialog (any option from 0 through 7 under the Actions category on the Main Menu), select the Define Report and File Outputs option, and then on the Output Options panel, select Audit.
By default, the Audit report includes only the data associated with noncompensated log records. To include compensated log records (and override the default), enter Y in the Include Rollback field of the Report Output panel. For more information, see Include Rollback in the online Help (F1).
By default, the Audit report includes log records that satisfy your time frame and filter. To override the default, enter Y in the Print REDO Information field of the Report Output panel. When you enter Y, Log Master selects log records as if it were generating REDO SQL statements. For more information about the log records that the produce selects, see Using-REDO-SQL.
The following figure shows a sample Audit report. The example shows the longer names supported by Db2 Version 8.1 and later, and column data that contains untranslatable Unicode characters. For more information, see Displaying long Db2 object names and Displaying-Unicode-characters.
Time: 16.42.50 Copyright BMC Software, Inc. 1995-2020
Audit Report, By Table Name, Urid
Compensated Log Records Included
--------------------------------------------------------------------------------
From: Date 2020-08-18 16.34.23.000000
To: Date 2020-08-18 16.34.49.000000
--------------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0014 Run Number: 2 Subsystem: DXW2
Description: DB2DBA GENERATE MONTHLY REPORTS
--------------------------------------------------------------------------------
Table Name: DB2DBADB.DB2DBA_YEAR_END_FINA
NCIAL_DATA_AND_QUARTERLY_ESTI
MATES_CONSOLIDATION_TABLE DBID.OBID: (363.3)
Tablespace Name: DB2DBADB.DB2DBAT1 DBID.PSID: (363.2)
URID LRSN: x'C328A04BCABB' Data Sharing Member: DXW2
URID : x'0010FFC0DA7E' Date : 2020-08-18 Conn Type: BA
Status : Committed Time : 16.34.23.877 Conn ID : BATCH
Plan Name: DSNTEP4 Auth ID: DB2DBA2 Corr ID : DB2DBAPR
---------------------------------------------------------------------------
Type: Insert At: x'C328A04BCAC8' Time: 2020-08-18 16.34.23.877
Report Index: DB2DBADB.DBAIX1 Type: Unique
RID : 00000016/01 Status: Committed
IX Value: TRANSACT_DATE : 2020-08-21
Field Data: TRANSACT_DATE UPDNUM DESCRIPTION**** SHORT_DEPT_NAME
New: 2020-08-21 000021 LOAD REC ACCTSPAYABLE
ACCT_REP_NAME*********** JOURNAL_CODE COMMENTS*************
New: EL-ASSAAD, IMAD 2104-- REVISE ACCT. BALANCE
*********************************** UPDNUM_CHGCOUNT ITEM_NO
New: FOR COMPENSATION. 0
Found untranslatable column data:
<description> : X'4C4F41442052454320E282AC202020'
---------------------------------------------------------------------------
Type: Update At: x'C328A04BCCDC' Time: 2020-08-18 16.34.23.885
Report Index: DB2DBADB.DBAIX1 Type: Unique
RID : 00000016/01 Status: Committed
IX Value: TRANSACT_DATE : 2020-08-21
Field Data: UPDNUM COMMENTS*********************************************
Old: 000021 REVISE ACCT. BALANCE FOR COMPENSATION.
New: UPD021 REVISE ACCT. BALANCE TO COMPENSATE FOR ORIGINAL ERROR
***
Old:
New: .
This section contains the following topics:
Related topic