Unable to open job
Moderators: chulett, rschirm, roy
Unable to open job
Hi,
I cannot access my job as it says it's being accessed by another user. Any remedies for this ?
Thanks
I cannot access my job as it says it's being accessed by another user. Any remedies for this ?
Thanks
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
First check if that job is being accessed by another user. In that case you will have to ask that user to close the job for you to access. Else what you need to do is go to director and check if you have the rights to do a clean up (You get this feature only if this is checked in administrator). In case you have you can try this from 'job' tag. Well if you don't hvae that option you will have to do this from unix.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Re: Unable to open job
Hi I tried doing a clean up, but it doesnt take effect....Would you mind telling me the steps and also how i can do it unix.
Thanks
Thanks
cosec wrote:Hi,
I cannot access my job as it says it's being accessed by another user. Any remedies for this ?
Thanks
Did you not have any luck searching? It's all out there, having been discussed in detail many times before this. Why make someone type it all up again? ![Confused :?](./images/smilies/icon_confused.gif)
ps. For it to 'take effect' you need to be cleaning up either your own processes or doing it as dsadm. But then if you'd searched and done some self discovery you would have known that. :D
![Confused :?](./images/smilies/icon_confused.gif)
ps. For it to 'take effect' you need to be cleaning up either your own processes or doing it as dsadm. But then if you'd searched and done some self discovery you would have known that. :D
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The only way you can "do it unix" (sic) is to re-boot the server, which is overkill. You need, using DataStage tools, to identify the owner of the lock, determine whether the lock is validly held and - only if it is not validly held - unlock it. If it is validly held you should negotiate with the current owner.
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: 5
- Joined: Fri Dec 22, 2006 2:11 am
HI,
Follow these steps to release the lock:
In Directory->In Toolbar Select job->Select Job Resource->Select show all in both Processes and Locks->In locks option find out the PID with crosponding job name->then select the PID of the job in Processes option->finaly press logout tab, then alert tab will gets, just press ok and close![Laughing :lol:](./images/smilies/icon_lol.gif)
Follow these steps to release the lock:
In Directory->In Toolbar Select job->Select Job Resource->Select show all in both Processes and Locks->In locks option find out the PID with crosponding job name->then select the PID of the job in Processes option->finaly press logout tab, then alert tab will gets, just press ok and close
![Laughing :lol:](./images/smilies/icon_lol.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Your advice is poor. One first needs to establish that the lock is not validly held - for example someone else may be editing that job.
Arbitrarily releasing locks is "worst practice" and can lead to lost work.
Your advice is poor. One first needs to establish that the lock is not validly held - for example someone else may be editing that job.
Arbitrarily releasing locks is "worst practice" and can lead to lost work.
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.
If no one seems to have this job open, but still you get this error, you dont have to restart DS server, you can just RESET so these orphaned processes/locks get released.
Issue a "uvadmin -reset", when logged in as DS admin on UNIX
Asking rest of team members to save work and close application is not something you can do everytime such a thing happens.. with reset everyone can keep working..
Issue a "uvadmin -reset", when logged in as DS admin on UNIX
Asking rest of team members to save work and close application is not something you can do everytime such a thing happens.. with reset everyone can keep working..