In our shop, Dastage is installed in two-server, active-passive topology.
Late last night, the primary server failed and (as anticipated) all the running jobs failed, subsequently DataStage came up on the secondary server. Operators were able to restart all the failed jobs, but for one which was stuck in "running" status (as per DataStage Director). In order to restart this job, the "status" file had to be cleared off manually.
I thought that the resources (log/status etc) will free up during start of DataStage on a new server, but apparently not!
Can you please share your thoughts on how to automate clearing of resources during failover.
11.5.0.1: Active/Passive failover issue.
Moderators: chulett, rschirm, roy