Unlocking a job

boris · Post by **boris** » Wed Jul 07, 2004 1:13 pm

Hi all,
Some of the jobs are getting locked due to temporary network disconnection.How to unlock these jobs? Any clues would be appriciated.
Thanks

kcbland · Post by **kcbland** » Wed Jul 07, 2004 1:20 pm

Search the forum, this has been covered lots of times.

ketfos · Post by **ketfos** » Wed Jul 07, 2004 5:13 pm

Hi,
Go to DataStage Director and choose CleanUp resources.

Select the PID# and Release it.

Ketfos

Bhusan · Post by **Bhusan** » Wed Jul 07, 2004 5:19 pm

If Datastage director cleanup does not release the job, then do a grep on dsapi_slave and find the pid of the process and kill that.

rasi · Post by **rasi** » Wed Jul 07, 2004 6:11 pm

goto uv and type DS.TOOLS. A menu will appear and choose 5 from that option which gives you all information about locks.

Rasi

boris · Post by **boris** » Thu Jul 08, 2004 8:05 am

Thanks guys,
It worked.

chucksmith · Post by **chucksmith** » Thu Jul 08, 2004 10:23 am

Be aware that the DataStage pid only report 6 digit PIDs. On some Unix boxes, I have found 7 digit PIDs. Be sure to use the correct PID. You may want to verify it with a ps -ef.