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. BMC AMI Log Master reports present only the data defined by your time frame and filter.

Related topic

 Reference-of-default-Log-Master-reports

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, non-compensated 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).

The following figure shows an example of a Data Capture Changes report:

 Date: 2022-01-18        BMC AMI Log Master for Db2 -  V13.01.00        Page: 1
 Time: 16.07.40         Copyright BMC Software, Inc. 1995-2023

                    Data Capture Analysis Report, By Table Name
 ----------------------------------------------------------------------------

 From: Date 2022-01-18 15.27.14.000000
   To: Date 2022-01-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:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*