Default language.

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*