Locked jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Thu May 20, 2004 1:10 am
Locked jobs
What needs to be done if a job gets locked ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please be more specific. Do you mean that the job design gets locked (this job is in use by another process)? Or do you mean locked in that it appears to be running but not processing any rows? Or something else again?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
All responders (except me) have assumed what the OP meant by "locked".
Beware of assumptions. As you may already be aware, or soon enough will become aware, they are highly dangerous things in an ETL environment!
Let me also make the point that killing a process will rarely release some kinds of lock but, instead, leave the locks in a state called "held by a defunct process", which are even harder to clean up because defunct processes are not displayed in the Cleanup Resources window.
The correct mechanism for addressing the situation "job is locked" (whatever that means) is going to depend on what the OP means by "locked", which is why I asked the question and why I await the OP's response before posting again.
Beware of assumptions. As you may already be aware, or soon enough will become aware, they are highly dangerous things in an ETL environment!
Let me also make the point that killing a process will rarely release some kinds of lock but, instead, leave the locks in a state called "held by a defunct process", which are even harder to clean up because defunct processes are not displayed in the Cleanup Resources window.
The correct mechanism for addressing the situation "job is locked" (whatever that means) is going to depend on what the OP means by "locked", which is why I asked the question and why I await the OP's response before posting again.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.