Summary report

The Summary report provides summarized transaction count information such as the number of insert, update, and delete actions that are related to the log records that you select with your time frame and filter.

Use Summary reports to provide information about

  • Transaction volumes processed by various sort keys
  • The quantity of SQL generated for table space for UNDO and REDO operations

Related topic

Reference-of-default-Log-Master-reports

To request a Summary 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 Summary. BMC AMI Log Master includes the Summary report as a default form of output for several task dialogs.

This report has some similarities to the Object Activity Summary report, but do not confuse the two reports. For more information about the Object Activity Summary report, see Object-Activity-Summary-report.

Be aware that, by default, the Summary report includes the following information, which you can modify by using options on the Report Output panel. For more information about the fields on this panel, from panel, press F1 to access the online Help.

  • The Summary report includes only the data associated with non-compensated log records. To override the default to include compensated log records, enter Y in the Include Rollback field.
  • The Summary Report includes the log records that satisfy your filter. To override the default, enter Y in the Print REDO Information field. BMC AMI Log Master then selects log records as if it were generating REDO SQL statements. For more information about the log records that BMC AMI Log Master selects, see Using-REDO-SQL.
  • BMC AMI Log Master formats the Summary report for printed output. To override the default to include only data (no report headings, column headings, or blank lines), use the Format field, as follows:
    • To obtain data in the Comma Separated Value (CSV) format, enter C. Individual items of data are separated by commas. For an example, see the figure showing example Object Activity Summary report (CSV format) in Object-Activity-Summary-report.
    • To obtain data in the Standard Definition Format (SDF), enter S. Individual columns of data are filled so that each column has the same position and length on all lines of the output. For an example, see Example Summary report (SDF format).
  • The output does not include total lines. To include subtotal lines and report total lines in the output, enter Y in the Format CSV/SDF Include Total field.

Sample Summary reports

The following figure shows a sample Summary report. Example Summary report (SDF format) shows the same report produced as standard definition format (SDF) output, including report totals. For an example of Comma Separated Value (CSV) output, see the example Object Activity Summary report (CSV format) in Object-Activity-Summary-report.

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

                           Summary 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.$$WORKID0004         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)
   Ins   :             5  Del   :             3  Upd   :            47
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:            17
   Tot   :            72  Del/RI:             0  Upd/RI:             0

 Table Name: DB2DBADB.DB2DBAB2             DBID.OBID: (363.9)
 Tablespace Name: DB2DBADB.DB2DBAT2        DBID.PSID: (363.8)
   Ins   :             1  Del   :             1  Upd   :            15
   Exc   :             1
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :            18  Del/RI:             0  Upd/RI:             0

 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

Example Summary report (SDF format)

DB2DBADB<pad to 128 bytes>DB2DBAB1<pad to 128 bytes>5        3       47        0        0        0        0        0       17       72
DB2DBADB<pad to 128 bytes>DB2DBAB2<pad to 128 bytes>1        1       15        1        0        0        0        0        0       18
#RptTol#                  #RptTol#                  6        4       62        1        0        0        0        0       17       90

This section contains the following topics:

 

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