Job Accessed by Another user

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Job Accessed by Another user

Post by ketfos »

Hi,
I am unable to open a datastage job. When I try to open it, it gives a message
"Job Accessed by another user"

When I go to Director and view the status , it shows "Running".
When I try to stop the job, I get a message "Stop Request has been sent to Server". It keeps on waiting.

When i view in Job Resources Screen in Director - Tools, and click Show ALL in bottom half of the screen it shows the following

PID/User # 9261
Lock Type Record
Item Id CustomerFix (Job Name)


How do I resolve this?

Ketfos
neena
Participant
Posts: 90
Joined: Mon Mar 31, 2003 4:32 pm

Post by neena »

Go to Unix box .. if you have permissions and Kill the PID 9261(if you are using UNX . Kill command )
If its windows it will take some time to kill the process.
Thanks
Neena
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi,
When I go to Unix and issue the command
kill 9261

I get a message " Specifed Process doesnot exist"

ketfos
bibhudc
Charter Member
Charter Member
Posts: 20
Joined: Thu Jun 19, 2003 12:26 pm

Post by bibhudc »

Try using DS.TOOLS from the Administrator client.

Bibhu
Bibhu
neena
Participant
Posts: 90
Joined: Mon Mar 31, 2003 4:32 pm

Post by neena »

If this is the message then your job is already released by Unix.
Try the job now.
If the problem still there then check the pid of it again and go to unix use kill -9 pid
HTH
Thanks
Neena
ketfos wrote:Hi,
When I go to Unix and issue the command
kill 9261

I get a message " Specifed Process doesnot exist"

ketfos
datastage
Participant
Posts: 229
Joined: Wed Oct 23, 2002 10:10 am
Location: Omaha

Re: Job Accessed by Another user

Post by datastage »

ketfos wrote:When I go to Director and view the status , it shows "Running".
Ketfos
Normally the above problem, when the job isn't actually running, is fixed in Directory by choosing Job...Clear Status File.

However there may be more since another user is attached. Try Neena's kill -9 pid recommendation. Also, within Director you need to search for any locks in the bottom portion of Cleanup Resources. There may be more than 1 pid. Then go to the top portion and try to logout that pid. Click show all for both processes (top) and locks (bottom)
Byron Paul
WARNING: DO NOT OPERATE DATASTAGE WITHOUT ADULT SUPERVISION.

"Strange things are afoot in the reject links" - from Bill & Ted's DataStage Adventure
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi,
Thanks, I was able to kill by cleaning resources and looking for pid# with locks.

Ketfos
Post Reply