AutoPurge of Log Entries

MukundShastri · Post by **MukundShastri** » Thu Nov 18, 2004 4:13 am

I have enabled 'Auto-purge of job log' (upto previous 1 job runs) in dastage administrator. But it is not Autopurging log entries in the already existing jobs. When I checked in 'Ascential Datastage Administrator's Guide' ,it's saying that log entries can be Autopurged using settings in Datastage administrator only for the jobs which are created after the settings are done.

If I have already existing jobs, how do I Autopurge them using datastage administrator settings ??

Thanks
mukund

chulett · Post by **chulett** » Thu Nov 18, 2004 8:18 am

You would need to write a routine that takes those settings and applies them to the exisiting jobs. Needless to say, that would require knowledge of the underlying Universe/DataStage Engine metadata and some decent coding skills. Haven't checked in awhile, perhaps some kind soul has uploaded one over on ADN?

I believe you could export the entire project and then reimport it and they would then take on the current autopurge settings. Not 100% sure on that, though...

Worst case is someone sits down in front of Director and manually updates all of your existing jobs.

kduke · Post by **kduke** » Thu Nov 18, 2004 10:07 am

Craig

Ken Bland posted one somewhere.

kduke · Post by **kduke** » Thu Nov 18, 2004 10:08 am

Here it is viewtopic.php?t=87241

chulett · Post by **chulett** » Thu Nov 18, 2004 10:12 am

Excellent... forgot about that being here.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 18, 2004 2:57 pm

There is also a known bug in 5.1 (possibly 5.2) where Auto Purge settings are not even propagated into new job designs. I believe it was fixed in 6.0.
For RIL I created a routine to add the //PURGE.SETTINGS entry in all job log files, which they run periodically. I believe they're now in the process of updating to 7.x, so won't need it for much longer!