DSODB purging

[skathaitrooney]

Hello Experts,

I need to purge DSODB tables sustaining the records for the last 3 months or so.

I am following the below technote by IBM

http://www-01.ibm.com/support/docview.w ... wg21659783

My question was that has anybody purged their logs before using this method or by any method other than this(for eg. by preparing DML's themselves)

I have a DB2 database.

Please share your experience if anyone has done this before.

[felixyong]

Hi

This link provide you the instruction - http://www-01.ibm.com/support/knowledge ... inodb.html

I hit problem using the stool so I just use the SQL option to delete it directly.

[skathaitrooney]

Thanks Felix. I manually ran the sql's as mentioned by you.. did not face any issues. Thanks a lot, your post really helped. Cheers!

[rkashyap]

Please note that SQLs on Deleting data by using SQL Queries do not purge DSODB.DataLocator.

We were advised to run following SQL also.

Code: Select all

DELETE FROM DSODB.DataLocator L  WHERE NOT EXISTS (SELECT 1 FROM DSODB.JobRunLink J WHERE J.LocatorId = L.LocatorId);

In addition to indexes mentioned in patch_JR46761_index_server_all_[version], an additional index was created to support above SQL.

Code: Select all

CREATE INDEX DSODB.JobRunLinkLocatorId ON DSODB.JobRunLink(LocatorID);