Deleting logs of multiple jobs simultaneously
Moderators: chulett, rschirm, roy
Deleting logs of multiple jobs simultaneously
How do I do it?
Whenever you get the time Kim, please elaborate on the cons of this practice.
Is it because it loops through all the jobs. If thats the case then a person can tweak it to clear logs of only a subset of jobs by changing the source to a sequential file which has the job ids of only the a few jobs.
Is it because it loops through all the jobs. If thats the case then a person can tweak it to clear logs of only a subset of jobs by changing the source to a sequential file which has the job ids of only the a few jobs.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
There are people who do this but if a job is running and you clear the log file it is just not smart. The phantom process is updating this table and rows disappear. If everyone is off the system and you do this then it is probably safe. The RT_LOGnnn files have surrogate keys. The next available key is one of the records you delete when you clear this file. DataStage seems to recover from clearing these log files but still it is better to autopurge.
If you really need this code then someone could just post it. It is a batch job, so it is all code.
If you really need this code then someone could just post it. It is a batch job, so it is all code.
Mamu Kim
O yes. I have been using it uptill now at times when we run out of space. But even when i go for it, i make sure i do it when there is no one logged on or no DS jobs are running in that environment. I just wanted to make sure there are no other cons with it that might prove dangerous to the project even after taking the precautionary measures.
Thanks Kim.
Thanks Kim.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.