DSXchange

I needed to close Datastage Designer as it hung up.
I went to server and unlocked all the jobs using dsadm account. when I again tried to open the jobs , it is again showing warning that job is locked by user ( which is me). I am the only user. I don't know whats going on. It is happenign for last 3-4 days. However when I try to open the same job after 4-5 hourrs after unlocking it, it successfully opens.

Please help me with this issue.
following is current status but I still can't open the jobs.

[dsadm@lxdscon Server]$ cd DSEngine
[dsadm@lxdscon DSEngine]$ . ./dsenv
[dsadm@lxdscon DSEngine]$ bin/dssh
DataStage Command Language 8.0 Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 1997, 2006 All Rights Reserved.
DSEngine logged on: Thursday, February 28, 2008 17:43

>LOGTO uv
>LIST.READU EVERY

No locks or semaphores active.

Thanks for all your help!

just4geeks wrote:I needed to close Datastage Designer as it hung up.
I went to server and unlocked all the jobs using dsadm account. when I again tried to open the jobs , it is again showing warning that job is locked by user ( which is me). I am the only user. I don't know whats going on. It is happenign for last 3-4 days. However when I try to open the same job after 4-5 hourrs after unlocking it, it successfully opens.

Please help me with this issue.
following is current status but I still can't open the jobs.

[dsadm@lxdscon Server]$ cd DSEngine
[dsadm@lxdscon DSEngine]$ . ./dsenv
[dsadm@lxdscon DSEngine]$ bin/dssh
DataStage Command Language 8.0 Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 1997, 2006 All Rights Reserved.
DSEngine logged on: Thursday, February 28, 2008 17:43

>LOGTO uv
>LIST.READU EVERY

No locks or semaphores active.

Thanks for all your help!

Hi ,

you open the director and goto job option and click on cleanup resources .so your job lock will be released.

Thanx

Thanks for replying.

I already tried that.
I did clean up resources from director. also I did unlock jobs from administrator. but result is still the same.

Thanks,

This is Version 8, so you need to do this from the Websphere Information Server side as well.

ArndW wrote:This is Version 8, so you need to do this from the Websphere Information Server side as well.

Can you please tell me what do you mean by 'Websphere information Server side'. I am already doing it by going to DSEngine Directory and invoking 'dssh' and unlocking it from there. Please read my first post.
Is there any other way?

Thanks a lot!

Just4geeks - I did read your first post and replied. At version 8 the locking mechanism is no longer exclusively controlled within the DataStage server engine as it was in the past, there are now other components involved on the IBM Information Server side.

Open up and connect to "http://{servername}:9080" in a browser, login with "isadmin", click on the "administration" tab, select "Session Management" then "active sessions", locate the offending session and click on "disconnect".

ArndW wrote:Open up and connect to "http://{servername}:9080" in a browser, login with "isadmin", click on the "administration" tab, select "Session Management" then "active sessions", locate the offending session and click on "disconnect".

Thanks a lot ArndW! it worked. By any means I was not trying to offend you. its just that I thought 'Information server side' means server on unix.

easy way to unlock job is,make dsx from manager to desktop and make read only 1 to read only 0,do this option by find and replace.
and import that job again from manager and c,it works

That does not unlock the job in 8.0, see the method above instead.
(and there is no Manager!!"