Job is being accessed by another user

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
Karine
Participant
Posts: 37
Joined: Sun Feb 18, 2007 3:33 am

Job is being accessed by another user

Post by Karine »

When I tried to open an existing job, a message appeared with
"Job job_name is being accessed by another user"

1) How can I find out who is accessed this job?
2) If I want to force 'Unlock' this job - how can I do so?

I have been asking my co-workers and nobody own up accessing the job and I have waited for hours...
clj242021
Participant
Posts: 33
Joined: Mon Feb 12, 2007 2:54 am

Re: Job is being accessed by another user

Post by clj242021 »

Karine wrote:When I tried to open an existing job, a message appeared with
"Job job_name is being accessed by another user"

1) How can I find out who is accessed this job?
2) If I want to force 'Unlock' this job - how can I do so?

I have been asking my co-workers and nobody own up accessing the job and I have waited for hours...
you can via DS Director to find out who use the job
DS Director-->TOOL-->clearup resouces
#note if you use this function "enable job administration in director" must be check
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The "other user" can be you, in another window that you've minimized and forgotted about! Each connection to the server has a separate "agent process" to perform tasks.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ralleo
Premium Member
Premium Member
Posts: 21
Joined: Mon Dec 11, 2006 9:05 am
Location: London

Post by ralleo »

You can also run list_readu on the command line assuming you are using unix and the DataStage is set up correctly.

This generates a report to stdout and tells you the user for that job.
You can then unlock the userno number

Alternatively type who -R. This would tell you datastage users.

Ritchie

----------------------------------------------------------------
Always look for the light at the end of the tunnel
Post Reply