One of the DS user's machine crashed while he was doing an export. Because of the crash, two of his DS Server Jobs became locked. The DS Admin tried to release the locks by using the 'release job' option in Manager. However, for both jobs the 'release job' option remained greyed out.
We were told by ASCL that when a job gets locked b/c of a client machine crash, the job cannot be released by the 'release job' option. The only way to release the job is by bouncing the server. I think that's pretty crummy. And I was wondering if releasing the lock on the Server with UV commands is still an option in this case.
Thanks,
BP
Use of the 'Release Job' option
Moderators: chulett, rschirm, roy
Re: Use of the 'Release Job' option
Buzzzzzzzzzzz. Have that support person be retrained. This is far too common for them NOT to know about DS.TOOLS.bigpoppa wrote:We were told by ASCL that when a job gets locked b/c of a client machine crash, the job cannot be released by the 'release job' option. The only way to release the job is by bouncing the server.
Search on this forum on how to telnet to the server's box and use DS.TOOLS. I'm experienced with UNIX so my answers would be slightly different for Windows. I believe there's a post by either Kim Duke or Ken Bland on that thread.
All you have to do is kill the connection that is locking that job, and in some cases, recompile the job and you're as good as new.
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
BP
This has been covered quite a bit. You can clear resources. You can UNLOCK READULOCK in the UV account. Sometimes even if you get the job unlocked you need to recompile it to clear it of all issues. Do a search there is more detail on this in past topics.
Most of the time you do not need to reboot. ASCL is saying that because it is the easiest decision to support. You have to become a Universe DBA to become good at these types of issues. Most customers do not want to create admin people for DataStage much less Universe. Trust me it helps to know Universe and how DataStage works at alow level to get the most out of DataStage. ASCL likes to sell DataStage as maintenence free and it is close.
Kim.
This has been covered quite a bit. You can clear resources. You can UNLOCK READULOCK in the UV account. Sometimes even if you get the job unlocked you need to recompile it to clear it of all issues. Do a search there is more detail on this in past topics.
Most of the time you do not need to reboot. ASCL is saying that because it is the easiest decision to support. You have to become a Universe DBA to become good at these types of issues. Most customers do not want to create admin people for DataStage much less Universe. Trust me it helps to know Universe and how DataStage works at alow level to get the most out of DataStage. ASCL likes to sell DataStage as maintenence free and it is close.
Kim.
Mamu Kim
OKAY.
Here's all you need to do for Windows based DataStage:
viewtopic.php?t=85570&start=0&postdays= ... highlight=
This ALWAYS works.
Here's all you need to do for Windows based DataStage:
viewtopic.php?t=85570&start=0&postdays= ... highlight=
This ALWAYS works.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
How's this for a rant topic:
Why, after 7 years, has job/routine/design object lock release management never been addressed via enhancement to DS Administrator???
hhhmmmm? Is this not the most frequently asked question, and the one with twenty different hack approaches that all have little gotchas?
Why, after 7 years, has job/routine/design object lock release management never been addressed via enhancement to DS Administrator???
hhhmmmm? Is this not the most frequently asked question, and the one with twenty different hack approaches that all have little gotchas?
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle