Job is unlocked but still not opening in designer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
just4geeks
Premium Member
Premium Member
Posts: 644
Joined: Sat Aug 26, 2006 3:59 pm
Location: Mclean, VA

Job is unlocked but still not opening in designer

Post by just4geeks »

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!
Attitude is everything....
sri.cbv
Participant
Posts: 6
Joined: Tue Nov 06, 2007 3:01 am
Location: chennai

Re: Job is unlocked but still not opening in designer

Post by sri.cbv »

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
SRINIVAS
just4geeks
Premium Member
Premium Member
Posts: 644
Joined: Sat Aug 26, 2006 3:59 pm
Location: Mclean, VA

Post by just4geeks »

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,
Attitude is everything....
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

This is Version 8, so you need to do this from the Websphere Information Server side as well.
Last edited by ArndW on Fri Feb 29, 2008 3:48 am, edited 1 time in total.
just4geeks
Premium Member
Premium Member
Posts: 644
Joined: Sat Aug 26, 2006 3:59 pm
Location: Mclean, VA

Post by just4geeks »

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!
Attitude is everything....
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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".
just4geeks
Premium Member
Premium Member
Posts: 644
Joined: Sat Aug 26, 2006 3:59 pm
Location: Mclean, VA

Post by just4geeks »

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.
Attitude is everything....
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

Post by just4u_sharath »

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
deanwalker
Participant
Posts: 82
Joined: Tue Jan 22, 2008 10:37 am
Location: UK

Post by deanwalker »

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