How to purge job logs through command line.

pradeepleon · Post by **pradeepleon** » Wed Feb 18, 2009 1:39 pm

Does anyone know how can we purge Job logs through Unix command line ?

Appreciate your response,
thanks,
Pradeep.

chulett · Post by **chulett** » Wed Feb 18, 2009 1:48 pm

There really isn't a way. You can perhaps 'truncate' them using CLEAR.FILE in a dssh session, but you'd need to know the job number and restore the auto-purge settings afterwards as they would be removed as well.

dspxguy · Post by **dspxguy** » Wed Feb 18, 2009 1:53 pm

Logs are tables stored in Universe so you need to log in to TCL and execute CLEAR.FILE RT_LOGxxx command.

pradeepleon · Post by **pradeepleon** » Wed Feb 18, 2009 3:01 pm

Thank you Craig and Billie(dspxguy) for your response.

Pradeep.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 18, 2009 3:06 pm

CLEAR.FILE is NOT the same as a log purge.

CLEAR.FILE destroys control records, forcing DataStage to re-create those next time the job runs.

And CLEAR.FILE certainly does not provide partial purge (number of days old or number of job runs to keep).

There is absolutely no command line interface supplied for these.

chulett · Post by **chulett** » Wed Feb 18, 2009 3:08 pm

Which is why I noted it was akin to a truncate.