DS auto purge not working

htrisakti3 · Post by **htrisakti3** » Thu Dec 08, 2005 6:04 pm

We have datastage log auto-purge set at project level from dsadmin. It is set to purge in 5 days.. But when I look at log it contains everything from day-1, so I suspect this auto-purge does not work..
If anyone could give me some pointer where to look to fix this..

tcj · Post by **tcj** » Thu Dec 08, 2005 6:09 pm

Off the top of my head I believe that the change you made will only affect new jobs created in that project.

The old jobs in your project would not have had their auto-purge changed.

Tim

kcbland · Post by **kcbland** » Thu Dec 08, 2005 6:15 pm

Only when a job runs does the log get purged. If you only run a job once a month, but its purge is daily, it will only purge when the job runs. There's no "purge" daemon to clean up logs daily - it's the responsibility of the job to maintain its own log.

Setting the project purge setting means that any newly created, copied, or imported jobs will have that setting.

chulett · Post by **chulett** » Thu Dec 08, 2005 6:21 pm

And it isn't really set to purge "in 5 days". It's set to keep at most five days in the log, and as Ken notes, will purge anything over 5 days old only after the job runs successfully. That's key to note as well, if a job completes with Warnings or Aborts the auto-purge will not be triggered.

htrisakti3 · Post by **htrisakti3** » Thu Dec 08, 2005 7:38 pm

from archive/prev posting, I saw how to programmatically set the auto-purge property on each jobs.

Would the script work in read-only env?
In our prod env, the DS projects are protected & all objects are read-only.

chulett · Post by **chulett** » Thu Dec 08, 2005 7:44 pm

I believe so... couldn't hurt to try. It will either work or not work. At worst case, unprotect the project, make the change and then protect it again.