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 Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Data summary and purge process (DPRSUM)

This section describes the DPRSUM batch job.

The purpose of this procedure is to:

  • Summarize rows in the Db2 detail accounting table or package accounting table into a summary table to save space and reduce processing costs
  • Summarize rows in a summary accounting table into a table that is summarized over a longer interval
  • Purge outdated data from the performance data tables

Note

Multiple summarize and purge processes can be specified in one run.

The summarization process accesses a detail accounting table and produces a new or updated summary accounting table. The purge process accesses any performance data table and deletes rows with a DATETIME earlier than the specified purge date or retention period.

This section contains the following topics:

 

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