Can someone share a Job Unlock UV script which has automated the process of releasing job locks. That is a script which accepts just the project and job name and release all the locks associated with that job, the list.readu and "unlock user <userno> all " commands in a interactive script to make the lock administration and housekeeping tasks simpler.
I tried searching the forum a lot for this kind of script but could not locate one. It would be great if someone has already done this.
Regards,
Nirav
UV Script to release Job Locks from Unix
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Thu Dec 13, 2007 2:57 am
UV Script to release Job Locks from Unix
Thanks & Regards
Nirav
Nirav
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The unlock scripts for UV locks are already in place, in the DS.TOOLS menu. However, job locks are not necessarily held in the "UniVerse" (DataStage) database any more. The correct mechanism is to disconnect the owning session, which automatically releases the job locks.
Don't forget that having the DataStage deadlock daemon running will automatically release locks not held by valid processes periodically.
Don't forget that having the DataStage deadlock daemon running will automatically release locks not held by valid processes periodically.
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.
-
- Participant
- Posts: 14
- Joined: Thu Dec 13, 2007 2:57 am
Thanks for all your responses gentlemen. Ray I am aware of the DS.TOOLS menu, it is just that I was trying to create a script which would abstract the UV commands, I do not want lot of people fiddling with UV commands as that can mess up things. So I wanted to create a script which would take the job name and project name as input and will release universe locks if any held by that particular job.
We have had issues with jobs hanging intermittently, where they do not process anything after the jobs are started and then we need to stop it and release all the UV locks along with the fifo files in order to rerun it, on rerun that same job completes successfully. We have a admin team who handle this cases and this team is a multi product admin team and we the datastage guys do not want to expose all the UV commands, so that someone does not mess up things by mistake. Meanwhile we are trying to find out the cause of the locks with the service provider.
We have had issues with jobs hanging intermittently, where they do not process anything after the jobs are started and then we need to stop it and release all the UV locks along with the fifo files in order to rerun it, on rerun that same job completes successfully. We have a admin team who handle this cases and this team is a multi product admin team and we the datastage guys do not want to expose all the UV commands, so that someone does not mess up things by mistake. Meanwhile we are trying to find out the cause of the locks with the service provider.
Thanks & Regards
Nirav
Nirav