Pruning report

The IBM® Db2® Data Management Console scans the report data periodically in the background and prunes report data history using the pruning algorithm.

About this task

The pruning function provides four types of configuration for pruning the report history data. You can enable the pruning setting for the report history data at the same time. The console scans the data in the background by order and does pruning.
Note: Db2 Data Management Console administrator can view and set data pruning but a database administrator can only view and cannot set data pruning.

This topic explains how to prune report data.

Procedure

  1. Click Administration and select Reports.
  2. Click the gear icon to open the Report execution record pruning window. The default pruning selection is Prune by status.
  3. Select Prune by status, if you want to prune data based on execution status.
    • Keep succeed report records can keep 7 days of succeeded report records by default.
    • Keep failed report records can keep 30 days of failed report records by default.
    Note:
    • The data pruning success reports include the reports with Success, Stopping, or Warning status.
    • The data pruning failed reports include the reports with Error status.
    • All other reports cannot be pruned. For example, reports with Running status.
  4. Select Prune by schedule if you want to prune job data based on job schedule type.
    • Keep hourly records can keep 30 days for report records for scheduled by hourly by default.
    • Keep daily records can keep 90 days for report records for scheduled by daily by default.
    • Keep weekly records can keep 180 days for report reports for scheduled by weekly by default.
    • Keep monthly records can keep 360 days for job records for scheduled by monthly by default.
    • Keep annually records can keep 720 days for report records for scheduled by annually by default.
    • Keep on demand records can keep 30 days for job records for on demand by default.
  5. Select Prune by the number of records, if you want to prune report data based on report record number and run number for each report.
    • Keep record for can keep 30 days for all records by default.
    • Keep run records for each report can keep last 12 run records for each report by default.
    Note: The job data is pruned only if both rules are satisfied.
  6. Select Disable pruning, if you want to disable report data pruning.
    Note: Disabling pruning keeps all the records indefinitely. This increases the overhead and impacts storage capacity and performance.
  7. After setting the prune rules, click Save. The console scans the report data periodically in the background and prunes report data history. The default scan time is in 24:00:00 for console server time.

    The console pruning scan time can be modified in the configuration file as follows:

    1. Go to the folder <dmc_install_directory>/Config/dswebserver_override.properties
    2. Add or modify the following parameter 
      'pruning_start_time = {HH}:{MM}:{SS}'
      where, {HH}:{MM}:{SS} is the console server time, for example:
      'pruning_start_time = 14:13:30'
    3. Restart the console server.