Summary report

Use Summary reports to provide information about

• Transaction volumes processed by various sort keys

• The quantity of SQL generated for a table space for UNDO and REDO operations

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. 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 the panel, press F1 to access the online Help.

• The Summary report includes only the data associated with noncompensated 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. Log Master then 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.

• 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: 2020-08-18         BMC AMI Log Master for Db2 -  V12.01.00        Page: 1
 Time: 16.02.23         Copyright BMC Software, Inc. 1995-2020

                           Summary 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.$$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

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: