Running the delete_old_versions.sh script with the current timestamp used for the --end_date option does not delete all old version rows

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

The number of old version rows increases over time despite running the delete_old_versions.sh script at regular intervals.


Cause

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Master Data Management Server for Product Information Management
System Administration

Software version:

6.0

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1625360

Modified date:

2013-02-14

Translate my page

Machine Translation

Content navigation