Open Transaction report

The Open Transaction report lists the transactions (units of recovery) on the Db2 subsystem that are not committed or aborted at the end point of your log scan, including any transactions that begin before the start point of your log scan.

Use an Open Transaction report to identify the work that might not be represented on other reports.

Related topic

Reference-of-default-Log-Master-reports

To request an Open Transaction 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 Open Transaction.

Be aware of the following points as you define an Open Transaction report:

  • BMC AMI Log Master reads Db2 checkpoint records before the start point of your log scan to obtain information about any transactions that were open when the checkpoint record was created.
  • The report can include open transactions that do not affect the Db2 objects selected (directly or indirectly) by your filter. BMC AMI Log Master includes these transactions because an open transaction might include activity affecting your selected objects past the end point of your log scan.
  • The transactions included in the report can vary depending on whether your filter selects log records based on criteria that relate to the unit of recovery (for example, by plan name or authorization ID).
    • If your filter selects based on only criteria that relate to the unit of recovery, the report includes only the open transactions selected by your filter.
    • If your filter includes at least one criteria that does not relate to the unit of recovery (such as table name or column name), the report includes all open transactions on the current Db2 subsystem.
  • The activity counts in the report are based on the log records selected by your filter and the range of your log scan. Treat the counts as estimates of the activity associated with open transactions; do not use them as definitive data.

The following figure shows an example of an Open Transaction report.

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

                    Open Transaction Report, By Correlation ID
 ----------------------------------------------------------------------------

 From: Mark DB2DBA.START.RBA(0) (x'C32EE60188A4')
   To: Current x'C32EE606BFBF'

 ----------------------------------------------------------------------------
 Report Information:

 Work ID    : DB2DBA.$$WORKID0012         Run Number:    2  Subsystem: DXW2
 Description:   DB2DBA GENERATE MONTHLY REPORTS
 ----------------------------------------------------------------------------

 URID LRSN: x'C32EE603D105' Data Sharing Member: DXW2

 URID     : x'001125202C60' Date   : 2022-01-18   Conn Type: BATCH
 Status   : Open            Time   : 16.18.15.747 Conn ID  : DB2CALL
 Plan Name: DB2SQLG8        Auth ID: DB2DBA2      Corr ID  : DB2DBAO0
   Ins   :            25  Del   :             4  Upd   :            16
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :            45  Del/RI:             0  Upd/RI:             0

 URID LRSN: x'C32EE6034EE8' Data Sharing Member: DXW2

 URID     : x'001125200616' Date   : 2022-01-18   Conn Type: BATCH
 Status   : Open            Time   : 16.18.15.214 Conn ID  : DB2CALL
 Plan Name: DB2SQLG8        Auth ID: DB2DBA2      Corr ID  : DB2DBAO1
   Ins   :             1  Del   :             0  Upd   :             0
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :             1  Del/RI:             0  Upd/RI:             0

 URID LRSN: x'C32EE6034DD3' Data Sharing Member: DXW2

 URID     : x'001125200000' Date   : 2022-01-18   Conn Type: BATCH
 Status   : Open            Time   : 16.18.15.210 Conn ID  : DB2CALL
 Plan Name: DB2SQLG8        Auth ID: DB2DBA2      Corr ID  : DB2DBAO2
   Ins   :            25  Del   :             2  Upd   :             6
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :            33  Del/RI:             0  Upd/RI:             0

 URID LRSN: x'C32EE603D0DD' Data Sharing Member: DXW2

 URID     : x'001125202997' Date   : 2022-01-18   Conn Type: BATCH
 Status   : Open            Time   : 16.18.15.747 Conn ID  : DB2CALL
 Plan Name: DB2SQLG8        Auth ID: DB2DBA2      Corr ID  : DB2DBAO4
   Ins   :           105  Del   :            43  Upd   :            69
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :           217  Del/RI:             0  Upd/RI:             0

 URID LRSN: x'C32EE6046917' Data Sharing Member: DXW2

 URID     : x'00112521954D' Date   : 2022-01-18   Conn Type: BATCH
 Status   : Open            Time   : 16.18.16.370 Conn ID  : DB2CALL
 Plan Name: DB2SQLG8        Auth ID: DB2DBA2      Corr ID  : DB2DBAO5
   Ins   :            99  Del   :            37  Upd   :            66
   Exc   :             0
   Ins/Tr:             0  Del/Tr:             0  Upd/Tr:             0
   Tot   :           202  Del/RI:             0  Upd/RI:             0

   Total URID's Encountered:     5

This section contains the following topics:

 

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