Page 1 of 1

Job locked and cannot reimport, delete or unlock it

Posted: Thu Apr 16, 2009 11:21 am
by manuel.gomez
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!

Re: Job locked and cannot reimport, delete or unlock it

Posted: Thu Apr 16, 2009 11:27 am
by dsuser_cai
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.

Re: Job locked and cannot reimport, delete or unlock it

Posted: Thu Apr 16, 2009 11:35 am
by manuel.gomez
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.
Man, you save my life!!

By the way, in the command you gave me, the second unlock should be removed

Thanks very much!!!!