DSXchange

Hi All,

I was editing a job and suddenly the connection got
broken. Now I am not able to access the job in
designer - it gives the message "Job XXX is being
accessed by another user."

How do I reset this status. For info, I am am running
DS 4.2 on Win 2000.

Thanks in advance.

Regards,

YN


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com

Thats happened with me as well. What we do is stop and start the server again (UNIX). Im not sure of the commands for 2000, but the manuals should have it.

Regards
Denzil

-----Original Message-----
From: YN [mailto:yn_ds@yahoo.com]
Sent: Monday, February 18, 2002 12:13 PM
To: datastage-users@oliver.com
Subject: Job Locked... How to Reset??


Hi All,

I was editing a job and suddenly the connection got
broken. Now I am not able to access the job in
designer - it gives the message "Job XXX is being
accessed by another user."

How do I reset this status. For info, I am am running
DS 4.2 on Win 2000.

Thanks in advance.

Regards,

YN


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com

Hi
If You Know Job No (Internally, DataStage job has unique job no)

First Check Process with Job no.

You can see datastage directory menu ( Job --> Cleanup Resource) If this menus disable (check admin menu in ds administrator)

And
Second Check Lock or Process and release all Lock or Process related this job.


Then You can modify this job.

Or
If you possible to shutdown datastage server,
then just stop the service and restart, than automatically release lock


Have a nice day.
----- Original Message -----
From: "YN"
To:
Sent: Monday, February 18, 2002 7:12 PM
Subject: Job Locked... How to Reset??


> Hi All,
>
> I was editing a job and suddenly the connection got
> broken. Now I am not able to access the job in
> designer - it gives the message "Job XXX is being
> accessed by another user."
>
> How do I reset this status. For info, I am am running
> DS 4.2 on Win 2000.
>
> Thanks in advance.
>
> Regards,
>
> YN
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com

Hi,

This is for Windows. Not sure abt any other OS.
1. Login as the Administrator into the DataStage Director.
2. Go to Job --> Cleanup Resources (this will take a few mins). 3. You should see a window which has two frames in it -
a. Click on the radio button - Show All in the top frame.
b. Look for your UserName.
c. Click on the PID#
d. Click on the radio button - Show by Process in the bottom frame. 4. Continue Step 3 until u see the job which got locked. This will be displayed in the bottom frame. 5. Click on the PID# and then click Release All

This should release your lock.

Regards,
A.


-----Original Message-----
From: YN
Sent: Mon 2/18/2002 3:42 PM
To: datastage-users@oliver.com
Cc:
Subject: Job Locked... How to Reset??

Hi All,

I was editing a job and suddenly the connection got
broken. Now I am not able to access the job in
designer - it gives the message "Job XXX is being
accessed by another user."

How do I reset this status. For info, I am am running
DS 4.2 on Win 2000.

Thanks in advance.

Regards,

YN


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com

Hi Kim,

Thanks.. it worked. Now I do not need to restart the
DS Server!!

YN

--- DaeHwan Kim wrote:
> Hi
> If You Know Job No (Internally, DataStage job has
> unique job no)
>
> First Check Process with Job no.
>
> You can see datastage directory menu ( Job -->
> Cleanup Resource)
> If this menus disable (check admin menu in ds
> administrator)
>
> And
> Second Check Lock or Process and release all Lock or
> Process related this job.
>
>
> Then You can modify this job.
>
> Or
> If you possible to shutdown datastage server,
> then just stop the service and restart, than
> automatically release lock
>
>
> Have a nice day.
> ----- Original Message -----
> From: "YN"
> To:
> Sent: Monday, February 18, 2002 7:12 PM
> Subject: Job Locked... How to Reset??
>
>
> > Hi All,
> >
> > I was editing a job and suddenly the connection
> got
> > broken. Now I am not able to access the job in
> > designer - it gives the message "Job XXX is being
> > accessed by another user."
> >
> > How do I reset this status. For info, I am am
> running
> > DS 4.2 on Win 2000.
> >
> > Thanks in advance.
> >
> > Regards,
> >
> > YN
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Sports - Coverage of the 2002 Olympic Games
> > http://sports.yahoo.com
>


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com

Thanks Aedla for elaborating the steps...

Regards,

YN

--- Phaneender Aedla
wrote:
> Hi,
>
> This is for Windows. Not sure abt any other OS.
> 1. Login as the Administrator into the DataStage
> Director.
> 2. Go to Job --> Cleanup Resources (this will take a
> few mins).
> 3. You should see a window which has two frames in
> it -
> a. Click on the radio button - Show All in
> the top frame.
> b. Look for your UserName.
> c. Click on the PID#
> d. Click on the radio button - Show by
> Process in the bottom frame.
> 4. Continue Step 3 until u see the job which got
> locked. This will be
> displayed in the bottom frame.
> 5. Click on the PID# and then click Release All
>
> This should release your lock.
>
> Regards,
> A.
>
>
> -----Original Message-----
> From: YN
> Sent: Mon 2/18/2002 3:42 PM
> To: datastage-users@oliver.com
> Cc:
> Subject: Job Locked... How to Reset??
>
> Hi All,
>
> I was editing a job and suddenly the connection got
> broken. Now I am not able to access the job in
> designer - it gives the message "Job XXX is being
> accessed by another user."
>
> How do I reset this status. For info, I am am
> running
> DS 4.2 on Win 2000.
>
> Thanks in advance.
>
> Regards,
>
> YN
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com
>
>
>
>


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com

also within administrator there is a section that allows you to run universe commands. in there, you can type in: UNLOCK ALL
this will unlock the file / record locks datastage created within universe.

-----Original Message-----
From: DaeHwan Kim [mailto:whatcanido@lexken.co.kr]
Sent: Monday, February 18, 2002 5:21 AM
To: datastage-users@oliver.com
Subject: Re: Job Locked... How to Reset??


Hi
If You Know Job No (Internally, DataStage job has unique job no)

First Check Process with Job no.

You can see datastage directory menu ( Job --> Cleanup Resource) If this menus disable (check admin menu in ds administrator)

And
Second Check Lock or Process and release all Lock or Process related this job.


Then You can modify this job.

Or
If you possible to shutdown datastage server,
then just stop the service and restart, than automatically release lock


Have a nice day.
----- Original Message -----
From: "YN"
To:
Sent: Monday, February 18, 2002 7:12 PM
Subject: Job Locked... How to Reset??


> Hi All,
>
> I was editing a job and suddenly the connection got
> broken. Now I am not able to access the job in
> designer - it gives the message "Job XXX is being
> accessed by another user."
>
> How do I reset this status. For info, I am am running
> DS 4.2 on Win 2000.
>
> Thanks in advance.
>
> Regards,
>
> YN
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - Coverage of the 2002 Olympic Games
> http://sports.yahoo.com

Under DataStage Director, on the menu, select jobs->cleanup resources, this will allow to view/release/logout process and locks for all jobs and users. In order to access this menu, you must enable "job administration in director" for projects within DataStage Administrator.

-----Original Message-----
From: Denzil Sander [mailto:DenzilS@mxgroup.co.za]
Sent: Monday, February 18, 2002 5:17 AM
To: datastage-users@oliver.com
Subject: RE: Job Locked... How to Reset??


Thats happened with me as well. What we do is stop and start the server again (UNIX). Im not sure of the commands for 2000, but the manuals should have it.

Regards
Denzil

-----Original Message-----
From: YN [mailto:yn_ds@yahoo.com]
Sent: Monday, February 18, 2002 12:13 PM
To: datastage-users@oliver.com
Subject: Job Locked... How to Reset??


Hi All,

I was editing a job and suddenly the connection got
broken. Now I am not able to access the job in
designer - it gives the message "Job XXX is being
accessed by another user."

How do I reset this status. For info, I am am running
DS 4.2 on Win 2000.

Thanks in advance.

Regards,

YN


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com