Page 1 of 1
How to purge job logs through command line.
Posted: Wed Feb 18, 2009 1:39 pm
by pradeepleon
Does anyone know how can we purge Job logs through Unix command line ?
Appreciate your response,
thanks,
Pradeep.
Posted: Wed Feb 18, 2009 1:48 pm
by chulett
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.
Posted: Wed Feb 18, 2009 1:53 pm
by dspxguy
Logs are tables stored in Universe so you need to log in to TCL and execute CLEAR.FILE RT_LOGxxx command.
Posted: Wed Feb 18, 2009 3:01 pm
by pradeepleon
Thank you Craig and Billie(dspxguy) for your response.
Pradeep.
Posted: Wed Feb 18, 2009 3:06 pm
by ray.wurlod
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.
Posted: Wed Feb 18, 2009 3:08 pm
by chulett
Which is why I noted it was akin to a truncate.