How can I unlock a job after it has been killed?

DWH-M · Post by **DWH-M** » Wed Feb 04, 2009 12:59 am

HI

my job got locked, I tried using datastage admin command to kill the process id,
after killing the process id also job is still showing , job is still accessed by another.
I tried in Datastage director also to clean up the resource.
can anybody help out in this

Thanks in advance

**Note: subject / content edited to be more descriptive - Content Editor **

ray.wurlod · Post by **ray.wurlod** » Wed Feb 04, 2009 3:26 am

Tell the DS Admin that you NEVER kill processes associated with DataStage jobs. There are proper ways to stop jobs and remove their processes; kill -9 is not among them.

So, the job is locked, and the lock is owned by a process that no longer exists (a "defunct" process). Your DS Admin is going to need to identify the particular lock, using LIST.READU or similar command, identify the process associated with that lock, and issue an appropriate UNLOCK command. Or this can also be done from the DS.TOOLS menu.

uegodawa · Post by **uegodawa** » Wed Feb 04, 2009 3:08 pm

DS Admin can unlock jobs using following commands.
#cd $DSHOME

#/app/ascential/Ascential/DataStage/DSEngine>bin/uv

>LIST.READU

this will display all the locks, check for that particular job and clear the lock as follows

>UNLOCK USER <USER_NO> ALL

e.g
Device.... Inode.... Netnode Userno Lmode Pid Login Id Item-ID.............
75551473 154909 0 50647 12 RU 14889 dsadm SeqFXAllsitesales

in this case Userno is 50647

so command would be:
>UNLOCK USER 50467 ALL

once it clears the lock issue Q to quit.
>Q

Then you should be able to open the job.