Page 1 of 1

How to clear the Locks in DS?

Posted: Thu Nov 27, 2003 11:28 pm
by asvictor
Hi

One of my Job is locked. I have been trying to clear the lock by cleaning up the resources. even then I can't clear the lock. Is there any any or any special command to clear them in the OS itself?

Cheers

Posted: Thu Nov 27, 2003 11:30 pm
by kcbland
Amazingly, there is a post exactly for that:

viewtopic.php?t=85570

Posted: Fri Nov 28, 2003 6:53 am
by Teej
No! Really?

-T.J.

Posted: Sun Nov 30, 2003 8:11 am
by ray.wurlod
You just did that for the points, yeah? :lol:

Posted: Mon Dec 01, 2003 6:04 am
by anupam
Hi

go to ur project directory
execute these commands
1) . `cat /.dshome`/dsenv
2) `cat /.dshome`/bin/uv
then
DataStage Command Language 6.0
(c) Copyright 2002 Ascential Software, Inc. - All Rights Reserved
DSEngine logged on: Mon Dec 1 16:19:10 2003
will come
3) DS.TOOLS
Then choose option 5 another screen will come
choose option 4 to see the locks
and then note ur PID and
choose option 7 and give the pid to release the locks.
------------------------------------------------------------------------------
2nd options is go to Datastage administrator and execute command DS.TOOLS and then get the PID of the locked job and choose option 7 to release ur job.

By the way Ray has also done this for points :P
I hope this will resolve ur problem.