Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Log Master for Db2 13.1.

Commit report contents

The information presented in the Commit report depends on the report ordering fields that you request. If the unit of recovery identifier (URID) is the last report ordering field, or if you sort the report by Activity (Descending), the report presents full unit of recovery information.

That information includes:

  • URID
  • Status (always COMMITTED in this report)
  • Plan name
  • Date and time that the unit of recovery started
  • Authorization ID
  • Connection type (for example, Batch, CICS, IMS)
  • Connection ID
  • Correlation ID
  • Number of log records by update type (insert, update, delete, or exchange)
  • Number of delete and update actions due to referential integrity (RI)
  • Number of insert, delete, and update actions due to trigger activity
  • Total number of log records encountered

If you sort the report in a different order or use a different field as the last report ordering field, the Commit report includes the following summary information:

  • Unique value of the report ordering field
  • Number of URIDs encountered matching the report ordering field
  • Total number of data management log records, along with the total activity for the report ordering field
  • Average number of data management log records, along with the total activity for the report ordering field
  • Largest number of DML log records, along with the total activity for a URID within the report ordering field

Related topic

 Commit-report

 

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