How to unlock a job

skyboyfli · Post by **skyboyfli** » Mon Nov 15, 2010 3:35 am

How to Unlock a job...

When i am trying to open a job, i got a error message
"Unable to open"----------" locked by "------" user

i am using 8.1 version.

Thanks in advance

sultan@cts · Post by **sultan@cts** » Mon Nov 15, 2010 3:50 am

In version 8.x through webconsole,we can unlock the job.

skyboyfli · Post by **skyboyfli** » Mon Nov 15, 2010 4:02 am

sultan@cts wrote:In version 8.x through webconsole,we can unlock the job.

Is there any other way.... Web console is not there in my client machine.

Thanks,

sultan@cts · Post by **sultan@cts** » Mon Nov 15, 2010 5:28 am

If you have the access . follow the below steps from unix.
Step1:log to ds engine
/opt/Ascential/DataStage/DSEngine
Step2: Type the following three commands one after the other
$DSHOME
. ./dsenv
bin/dssh
step3:ogto ur project
Step4: In the command prompt, type the following command
LOGTO UV
Step5: Then type the command LIST.READU, to get list of all the unlocked objects
Step6: find the lock listed for your job number, and then look at the USERNO column
Step7: type the command UNLOCK USER userno ALL

other way is cleaning up the resource from director. i hope it doesnt work properly in version 8.x.

or else you can crate the copy of the locked job and work on it.

ArndW · Post by **ArndW** » Mon Nov 15, 2010 6:26 am

skyboyfli wrote:...Is there any other way.... Web console is not there in my client machine. Thanks,

Actually, it is an explorer-based application, you just need to connect to it with the correct URL, i.e. "http://my.server.machine:9080" and use your DataStage user login and can manage sessions (assuming that you have been assigned sufficient rights)

skyboyfli · Post by **skyboyfli** » Tue Nov 16, 2010 11:18 pm

ArndW wrote:
skyboyfli wrote:...Is there any other way.... Web console is not there in my client machine. Thanks,
Actually, it is an explorer-based application, you just need to connect to it with the ...

i am not a premium member iam not able to see ur answer can any one give me the answer plz

ray.wurlod · Post by **ray.wurlod** » Tue Nov 16, 2010 11:48 pm

Why not get a premium membership? Then you would be able to read the entirety of Arnd's and other premium posters' contributions.

Premium membership is not expensive, at less than 30c (Rs12) per day, and 100% of that revenue goes towards paying the hosting and bandwidth costs of DSXchange.