Multi Instance jobs - clear logs

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
anu123
Premium Member
Premium Member
Posts: 143
Joined: Sun Feb 05, 2006 1:05 pm
Location: Columbus, OH, USA

Multi Instance jobs - clear logs

Post by anu123 »

We have many multi instance jobs and each time we run each job will use unique invocation id and we do not have a mechanism to clean up all these instances. With all these instances, we are able to open director.

Is there any way to clean up all older instances?

Thanks in advance.
Thank you,
Anu
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

From what I recall, if you recompile the job or do a 'Reset Status File' on the job it will clear all instances from the Director view.
-craig

"You can never have too many knives" -- Logan Nine Fingers
anu123
Premium Member
Premium Member
Posts: 143
Joined: Sun Feb 05, 2006 1:05 pm
Location: Columbus, OH, USA

Post by anu123 »

Thank you Craig.
That is what I have been doing (re compiling ) but would like to know if we have any alternatives to keep most recent instance and purge rest.

Thanks.
Thank you,
Anu
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes there are, they involve deleting instance records from RT_STATUSxxx, but I don't have the details readily to hand.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply