Hello all
I am desperate about a job that I cant update from development, as it is locked in Production server
When trying to delete it, I am getting the typical error message: Cannot get exclusive access
I went to the DS dssh in Unix, and I tried all these things
1. Executed DS.TOOLS, option 4, and tried to logout the process, and all locks in the process
Got this error message: Cannot find any process numbers for stages in job
2. Close all sessions, and execute DS.REINDEX ALL and DS.CHECKER. The checker found the job and just returned message "Job processed". Nothing else
3. Followed steps in this post, and it even returned this:
>UNLOCK NODE 94151 USER 50551 ALL
Clearing Record locks.
Clearing GROUP locks.
Clearing FILE locks.
But nothing worked. I dont know what else to do. I would stop and restart the server, but......there is one inconvenient: this is production, so.....not a good idea
Can you give me any guidance on how to get this fixed? Any help will be really appreciated!
Job locked and cannot reimport, delete or unlock it
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 291
- Joined: Wed Sep 26, 2007 11:23 am
- Location: Madrid, Spain
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Re: Job locked and cannot reimport, delete or unlock it
Try this, this one always works for me.
list.readu
then make note of the user number,
unlock user <specify userno> unlock all
this will unlock all jobs for any particular user.
list.readu
then make note of the user number,
unlock user <specify userno> unlock all
this will unlock all jobs for any particular user.
Thanks
Karthick
Karthick
-
- Premium Member
- Posts: 291
- Joined: Wed Sep 26, 2007 11:23 am
- Location: Madrid, Spain
Re: Job locked and cannot reimport, delete or unlock it
Man, you save my life!!dsuser_cai wrote:Try this, this one always works for me.
list.readu
then make note of the user number,
unlock user <specify userno> unlock all
this will unlock all jobs for any particular user.
By the way, in the command you gave me, the second unlock should be removed
Thanks very much!!!!