Clearing Logs

roy · Post by **roy** » Thu Aug 25, 2005 1:22 am

Hi,
I think nothing will do it unless your going to try hack the files and delete the entries directly.
Unless you can make the instances reoccur along time there for not making to much of a mess along time.
Or delete them manually.

I know it's not much help

kduke · Post by **kduke** » Thu Aug 25, 2005 7:36 am

The instance ids are stored in 2 places in RT_LOGnnn and RT_STATUSnnn. You could hack these and delete these directly as Roy stated but I would not recommend that rither. You can setup autopurge and delete anything over 2 days old. I think autopurge with reusing the same instance ids is the best idea like Roy.

kool_cons · Post by **kool_cons** » Thu Aug 25, 2005 9:56 pm

I already enabled the option in adminstrator by project level for auto purging over last 2 job runs. seems it is not working.still i was able to see all past entries. But if you try in director,set the option as job wise, it works. but it is messy process to change the option for all job(morethan 500 jobs). I would like set this options as project level.Is there any way.
Thanks In advance

chulett · Post by **chulett** » Thu Aug 25, 2005 10:11 pm

The setting at the Project level only applies to new jobs created after the change was put into place.

You have a couple of options. You can create a routine to take a value and update all existing jobs with that value - but that implies a good knowledge of the inner workings of things DataStage.

Something else you can try. Export all of your jobs. Reimport all of the jobs. They should now have the new defaults. I think.

(try it with one first)

kduke · Post by **kduke** » Thu Aug 25, 2005 10:27 pm

Ken Bland posted a routine to update all jobs with purge settings. Do a search. Works great.

rleishman · Post by **rleishman** » Sun Nov 20, 2005 8:18 pm

Sorry to reopen an old thread, but there was an unanswered thought that was useful to me, and possibly will be to others.

chulett wrote:Something else you can try. Export all of your jobs. Reimport all of the jobs. They should now have the new defaults. I think.

(try it with one first)

Tried it (with one first

). It worked. Thanks Craig.

kcbland · Post by **kcbland** » Sun Nov 20, 2005 8:37 pm

Reimporting all jobs can be excessive for so simple of a problem.

The log settings are a single row in each and every log file for a job. Change a couple of attributes (columns) in that row and viola! Purge settings are updated.

It's a shame that release 7.5 still doesn't have a feature in DS Manager to mass update a selection set of jobs log settings. I didn't see anything in the 8.0 release notes at the Smokeout in Las Vegas about helping you out there. When 8.0 comes out, give us about 2 weeks to retrofit our utilities for the enhancements due to the repository migration.