Skip to Content

Default language.

Information
Space announcement The Using section of the MainView for DB2 documentation is now available in Japanese. The displayed language is dependent on your browser language. You can switch languages from the Language menu.

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
Warning

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*

MainView for DB2 6.1