Audit report
- 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 updated log record, it shows only the changed data. When the Detail report shows an updated log record, it shows all data.
- The Audit report shows primary key information (for 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, BMC AMI 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 non-compensated 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, BMC AMI 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 a long table name 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-2023
Audit Report, By Table Name, Urid
Compensated Log Records Included
--------------------------------------------------------------------------------
From: Date 2022-01-18 16.34.23.000000
To: Date 2022-01-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 : 2022-01-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: 2022-01-18 16.34.23.877
Report Index: DB2DBADB.DBAIX1 Type: Unique
RID : 00000016/01 Status: Committed
IX Value: TRANSACT_DATE : 2022-01-21
Field Data: TRANSACT_DATE UPDNUM DESCRIPTION**** SHORT_DEPT_NAME
New: 2022-01-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: 2022-01-18 16.34.23.885
Report Index: DB2DBADB.DBAIX1 Type: Unique
RID : 00000016/01 Status: Committed
IX Value: TRANSACT_DATE : 2022-01-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: