Data Capture Changes report
The Data Capture Changes report enables you to analyze the impact of creating or altering your Db2 tables that are defined with Data Capture Changes.
The report expresses the impact on the log as the number of bytes logged for updates, because insert and delete actions are always logged in their entirety. Log Master reports present only the data defined by your time frame and filter.
To request a Data Capture Changes 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 Data Capture Analysis.
The Data Capture Changes report can include compensated log records, noncompensated log records, or both, depending on the value of the Include Rollback field of the Report Output panel. For more information, see Include Rollback in the online Help (F1).
Following figure shows an example of a Data Capture Changes report:
Time: 16.07.40 Copyright BMC Software, Inc. 1995-2020
Data Capture Analysis Report, By Table Name
----------------------------------------------------------------------------
From: Date 2020-08-18 15.27.14.000000
To: Date 2020-08-18 15.27.40.000000
----------------------------------------------------------------------------
Report Information:
Work ID : DB2DBA.$$WORKID0008 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)
------ DATA CAPTURE NONE (DCN) ----- ----- DATA CAPTURE CHANGES (DCC) ---
Rcds Bytes Alter Rcd% /
Found Found DCN Byte% (No Update Activity to Report)
Ins 5 1003 1003 6 / 9
Del 3 597 597 4 / 5
Upd 0 0 0 0 / 0
Upd DCN 64 9440 13K 88 /85
Exc 0 0 0 0 / 0
----- ----- -----
Tot 72 11K 14K
DCC Would Use 0.00% More Bytes
Table Name: DB2DBADB.DB2DBAB2 DBID.OBID: (363.9)
Tablespace Name: DB2DBADB.DB2DBAT2 DBID.PSID: (363.8)
------ DATA CAPTURE NONE (DCN) ----- ----- DATA CAPTURE CHANGES (DCC) ---
Rcds Bytes Alter Rcd% / Rcds Bytes Alter Rcd% /
Found Found DCN Byte% Found Found DCN Byte%
Ins 0 0 0 0 / 0 Ins 1 193 193 5 / 5
Del 0 0 0 0 / 0 Del 1 193 193 5 / 5
Upd 0 0 0 0 / 0 Upd 0 0 0 0 / 0
Upd DCN 0 0 0 0 / 0 Upd DCC 15 3397 3013 83 / 89
Exc 0 0 0 0 / 0 Exc 1 0 0 5 / 0
----- ----- ----- ----- ----- -----
Tot 0 0 0 Tot 18 3783 3399
DCC Would Use 0.00% More Bytes DCN Would Use 10.15% Fewer Bytes
Report Totals:
Ins : 6 Del : 4 Upd : 62
Exc : 1
Ins/Tr: 0 Del/Tr: 0 Upd/Tr: 17
Tot : 90 Del/RI: 0 Upd/RI: 0
This section contains the following topics:
Related topic