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
- Click Administration and select
.
- Click the gear icon to open the Report execution record pruning
window. The default pruning selection is Prune by status.
- 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.
- 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.
- 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.
- 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.
- 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:
- Go to the folder
<dmc_install_directory>/Config/dswebserver_override.properties
- 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'
- Restart the console server.