DSXchange

Posted: **Mon May 18, 2015 10:00 am**

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.

Posted: **Wed May 20, 2015 10:45 pm**

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.

Posted: **Mon Jun 01, 2015 4:09 am**

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!

Posted: **Fri Jul 03, 2015 12:16 pm**

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);

DSXchange

DSODB purging

DSODB purging

Re: DSODB purging