Job history
You can purge your historical job information that is scheduled in Product Master to improve performance to restore free disk space and speed up database utilities.
Maintaining job history
The IBM® Job Data Maintenance Report is available to delete job data based on the options provided in a lookup table. This report is created using the Product Master scripts and can be scheduled to run on an appropriate maintenance window using the Product Master scheduler.Job
Data Maintenance Report has the following dependent Product Master objects:
| Product Master object name | Product Master object type | Usage |
|---|---|---|
| IBM Job Data Maintenance script | Script file, /scripts/reports/ in the docstore directory. | Script file that is used by IBM Job Data Maintenance Report |
| DB Queries | Script file, /scripts/IBM_MDMDocStore_Maintenance/ in the docstore directory. | Script included in the file that is used by IBM Job Data Maintenance Report |
| Product Master Data Maintenance Lookup | Lookup Table | Input parameters that are used by IBM Job Data Maintenance Report |
| Product Master Data Maintenance Spec | Lookup Table Spec | Lookup Table Spec for Product Master Data Maintenance Lookup table |
Important: The default value of the Days_to_keep attribute
in the Product Master Data
Maintenance lookup table is
30. Therefore, the default
action for the Job Data Maintenance Report is to delete all of the
job schedule information older than 30 days. Ensure that you modify
the lookup table values per your requirement before running the Job
Data Maintenance Report.Sample IBM Job Data Maintenance Report output
Job data maintenance for company: ibm
Job run date: 2013-01-01 16:57:14
Deleting completed job schedules older than date: 2013-01-01 16:57:14
Total job schedules deleted : 54
Job data maintenance completed