Object Activity Summary report

This report presents a raw count of all data management (DM) log records in the Db2 log that relate to the objects that you specify.

Use this report to obtain a summary of all of the data management activity related to a given set of Db2 objects, including the following:

• Log records from committed transactions, records from aborted transactions, and any compensation records regardless of transaction status

• Log records regardless of whether the Db2 objects are defined in the Db2 catalog at the time when the report is created

• Log records from transactions that are not complete within your specified time frame (transactions that are not yet committed or aborted)

To request an Object Activity 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 Object Activity Summary.

Be aware of the following points as you define an Object Activity Summary report:

• You cannot generate an Object Activity Summary report if your filter selects log records based on a column’s value (for example, WHERE TABLE01.QUANTITY > 500).

• You cannot generate this report if Log Master is reading log records from a logical log file previously created by Log Master or an application program.

• To help you detect URIDs containing an extremely large number of uncommitted transactions, Log Master does not honor the value of the URIDTHR installation option when it generates an Object Activity Summary report. For more information about the URIDTHR option, see the section about operational considerations and installation in URIDTHR.

• By default, Log Master formats the Object Activity Summary report for printed output. You can override the default to include only data (no report headings, column headings, or blank lines) by using the Format field on the Report Output panel. Log Master provides two formats, both of which use character representation to make data easier to move to other platforms.

  • Enter C in the Format field to obtain data in the Comma Separated Value (CSV) format available in some database software. Individual items of data are separated by commas. For an example, see figure (Example Object Activity Summary report (CSV format).

  • Enter S in the Format field to obtain data in the Standard Definition Format (SDF) available in some database software. 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 the Example Summary report (SDF format) in Summary report.

  • Enter Y in the Format CSV/SDF Include Total field on the Report Output panel to include subtotal lines and report total lines in the output. By default, the output does not include total lines.

The following figure (Example Object Activity Summary report) shows an example of an Object Activity Summary report. The following figure (Example Object Activity Summary report (CSV format)) shows the same report produced with the CSV format, without subtotals or report totals. For an example of the SDF report output, see Summary report.

 Date: 2013-01-18          BMC AMI Log Master for Db2 -  V12.01.00      Page: 1
 Time: 16.05.25         Copyright BMC Software, Inc. 1995-2020

                   Object Activity 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.$$WORKID0006         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   :             8  Del   :             4  Upd   :            59
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:            20
   Tot   :            91  Del/RI:             0  Upd/RI:             0
   Compensation Records:
   Ins   :             1  Del   :             3  Upd   :            12
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             3
   Tot   :            19  Del/RI:             0  Upd/RI:             0

 Table Name: DB2DBADB.DB2DBAB2             DBID.OBID: (363.9)
 Tablespace Name: DB2DBADB.DB2DBAT2        DBID.PSID: (363.8)
   Ins   :             3  Del   :             1  Upd   :            22
   Exc   :             1
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :            27  Del/RI:             0  Upd/RI:             0
   Compensation Records:
   Ins   :             0  Del   :             2  Upd   :             7
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :             9  Del/RI:             0  Upd/RI:             0

 Report Totals:
   Ins   :            11  Del   :             5  Upd   :            81
   Exc   :             1
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:            20
   Tot   :           118  Del/RI:             0  Upd/RI:             0
   Compensation Records:
   Ins   :             1  Del   :             5  Upd   :            19
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             3
   Tot   :            28  Del/RI:             0  Upd/RI:             0

'DB2DBADB','DB2DBAB1',8,4,59,0,0,0,0,0,20,91,1,3,12,0,0,0,0,0,3,19
'DB2DBADB','DB2DBAB2',3,1,22,1,0,0,0,0,0,27,0,2,7,0,0,0,0,0,0,9

This section contains the following topics: