Job Locked... How to Reset??

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Job Locked... How to Reset??

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

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
Locked