The delete_old_versions.sh script that is provided with IBM InfoSphere Master Data Management Server for Product Information Management Version 6.0.0 up to Fix Pack 13 might not delete all old version rows as expected. Over time the number of old version rows might accumulate and impact overall performance.
The number of old version rows increases over time despite running the delete_old_versions.sh script at regular intervals.
The delete_old_versions.sh script does not use the correct "START VERSION ID" to delete old version rows.
Diagnosing the problem
Run the estimate_old_versions.sh script to monitor the number of old object version rows in various InfoSphere MDM Server for PIM database tables immediately after running the delete_old_versions.sh script. Both scripts must have exactly the same options.
For example when you run:
./delete_old_versions.sh --code=trigo --end_date=2013-02-13.13:35:00
run this script immediately:
./estimate_old_versions.sh --code=trigo --end_date=2013-02-13.13:35:00
The generated file "estimate_old_verions.out" should show 0 or a small number of old version rows depending on the ongoing activities in the system. This number should not increase over time when you run the delete_old_versions.sh script regularly.
Resolving the problem
Replace the existing delete_old_versions_localized.sh script with the attached script and continue to use the delete_old_versions.sh script in the usual manner. The delete_old_versions_localized.sh script is located in the $TOP/src/maintenance directory.