Job locked and cannot reimport, delete or unlock it

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
manuel.gomez
Premium Member
Premium Member
Posts: 291
Joined: Wed Sep 26, 2007 11:23 am
Location: Madrid, Spain

Job locked and cannot reimport, delete or unlock it

Post 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!
dsuser_cai
Premium Member
Premium Member
Posts: 151
Joined: Fri Feb 13, 2009 4:19 pm

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

Post 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.
Thanks
Karthick
manuel.gomez
Premium Member
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

Post 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!!!!
Post Reply