Detail report
Log Master reports present only the data defined by your time frame and filter. This report is similar to the Audit report, with the following exceptions. For more information about the Audit report, see Audit report.
The Detail and Audit reports show data from data management log records. However, when the Detail report shows data from an update log record, it shows all data, whereas the Audit report shows only the changed data.
The Detail report does not show primary key information; however, the Audit report does.
Use the Detail report to
Display log information to help determine application problems
Show information from the log as an audit trail for applications
Show information about changes to the Db2 catalog, including changes to Db2 security
For more information, see Auditing Db2 catalog activity.
To request a Detail report, from any 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 Detail.
By default, the Detail report includes only the data associated with noncompensated log records. You can include compensated log records (and override the default) by entering 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 Detail report includes the log records that satisfy your filter and time frame. You can override the default by entering 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 Log Master selects, see Using REDO SQL.
Sample Detail report
The following figure shows an example of a Detail 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 Defining a default report.
Date: 2020-08-18 BMC AMI Log Master for Db2 - V12.01.00 Page: 1
Time: 16.43.58 Copyright BMC Software, Inc. 1995-2020
Detail Report, By Table Name, Urid
-----------------------------------------------------------------------------
From: Date 2020-08-18 16.34.23.000000
To: Date 2020-08-18 16.34.49.000000
-----------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0015 Run Number: 2 Subsystem: DXW2
Description: DB2DBA GENERATE MONTHLY REPORTS
-----------------------------------------------------------------------------
Table Name: DB2DBADB.DB2DBA_YEAR_END_FINA
NCIAL_DATA_AND_QUARTERLY_ESTI
ATES_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
Status: Committed
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
Status: Committed
Field Data: TRANSACT_DATE UPDNUM DESCRIPTION** SHORT_DEPT_NAME
Old: 2020-08-21 000021 LOAD REC ACCTSPAYABLE
New: 2020-08-21 UPD021 LOAD REC ACCTSPAYABLE
ACCT_REP_NAME*********** JOURNAL_CODE COMMENTS*************
Old: EL-ASSAAD, IMAD 2104-- REVISE ACCT. BALANCE
New: EL-ASSAAD, IMAD 2104-- REVISE ACCT. BALANCE
*********************************** UPDNUM_CHGCOUNT ITEM_NO
Old: FOR COMPENSATION. 0
New: TO COMPENSATE FOR ORIGINAL ERROR. 0
Found untranslatable column data from new row:
<description> : X'4C4F41442052454320E282AC202020'
Found untranslatable column data from old row:
<description> : X'4C4F41442052454320E282AC202020'
Sample Detail report, wide format
The following figure shows an example of a Detail report, and uses the report’s wide format, which can be more convenient for tables with many columns.
Date: 2020-08-18 BMC AMI Log Master for Db2 - V12.01.00 Page: 1
Time: 16.17.50 Copyright BMC Software, Inc. 1995-2020
Detail Report, By Table Name, Urid
------------------------------------------------------------------------------------------------------------------------------------
From: Date 2020-08-18 15:27:14.000000
To: Date 2020-08-18 15:27:40.000000
------------------------------------------------------------------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0016 Run Number: 1 Subsystem: DXW2
Description: DB2DBA GENERATE MONTHLY REPORTS
------------------------------------------------------------------------------------------------------------------------------------
Table Name: DB2DBADB.DB2DBAB1 DBID.OBID: (363.3)
Tablespace Name: DB2DBADB.DB2DBAT1 DBID.PSID: (363.2)
URID LRSN: x'C3289149BAF6' Data Sharing Member: DXW2
URID : x'0010FEE9BA7E' Date : 2020-08-18 Conn Type: BA
Status : Committed Time : 15.27.15.183 Conn ID : BATCH
Plan Name: DSNTEP4 Auth ID: DB2DBA2 Corr ID : DB2DBAPR
-------------------------------------------------------------------------------------------------------------------------------
Type: Insert At: x'C3289149BAFC' Time: 2020-08-18 15.27.15.183
Status: Committed
Field Data: TRANSACT_DATE UPDNUM DESCRIPTION**** SHORT_DEPT_NAME ACCT_REP_NAME*********** JOURNAL_CODE COMMENTS********
New: 2020-08-21 000021 LOAD REC #21 ACCTSPAYABLE EL-ASSAAD, IMAD 2104-- REVISE ACCT. BAL
**************************************** UPDNUM_CHGCOUNT ITEM_NO
New: ANCE FOR COMPENSATION. 0
-------------------------------------------------------------------------------------------------------------------------------
Type: Update At: x'C3289149BE8A' Time: 2020-08-18 15.27.15.198
Status: Committed
Field Data: TRANSACT_DATE UPDNUM DESCRIPTION**** SHORT_DEPT_NAME ACCT_REP_NAME*********** JOURNAL_CODE COMMENTS********
Old: 2020-08-20 000021 LOAD REC #21 ACCTSPAYABLE EL-ASSAAD, IMAD 2104-- REVISE ACCT. BAL
New: 2020-08-21 UPD021 LOAD REC #21 ACCTSPAYABLE EL-ASSAAD, IMAD 2104-- REVISE ACCT. BAL
**************************************** UPDNUM_CHGCOUNT ITEM_NO
Old: ANCE FOR COMPENSATION. 0
New: ANCE TO COMPENSATE FOR ORIGINAL ERROR. 0
-------------------------------------------------------------------------------------------------------------------------------
Type: Update At: x'C3289149DE3C' Time: 2020-08-18 15.27.15.328
Status: Committed
Field Data: TRANSACT_DATE UPDNUM DESCRIPTION**** SHORT_DEPT_NAME ACCT_REP_NAME*********** JOURNAL_CODE COMMENTS********
Old: 2020-08-20 UPD021 LOAD REC #21 ACCTSPAYABLE EL-ASSAAD, IMAD 2104-- REVISE ACCT. BAL
New: 2020-08-21 UPD021 LOAD REC #21 ACCTSPAYABLE EL-ASSAAD, IMAD 2104-- REVISE ACCT. BAL
**************************************** UPDNUM_CHGCOUNT ITEM_NO
Old: ANCE TO COMPENSATE FOR ORIGINAL ERROR. 0
New: ANCE TO COMPENSATE FOR ORIGINAL ERROR. 1
This section contains the following topics:
Comments
Log in or register to comment.