How to clear the Locks in DS?

asvictor · Post by **asvictor** » Thu Nov 27, 2003 11:28 pm

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

kcbland · Post by **kcbland** » Thu Nov 27, 2003 11:30 pm

Amazingly, there is a post exactly for that:

viewtopic.php?t=85570

Teej · Post by **Teej** » Fri Nov 28, 2003 6:53 am

No! Really?

-T.J.

ray.wurlod · Post by **ray.wurlod** » Sun Nov 30, 2003 8:11 am

You just did that for the points, yeah?

anupam · Post by **anupam** » Mon Dec 01, 2003 6:04 am

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

I hope this will resolve ur problem.