Cannot get exlusive access to ex..job may be being monitored

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
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

Cannot get exlusive access to ex..job may be being monitored

Post by Alethesnake »

Hi all,
I've a problem with a sequence.
Yesterday I runned a sequence that remained running for almost 1 hour by doing nothing (it seems a dead-lock), it simply keept still before the attaching of a job.
I tried to stop it from the director several times without success, so I decided to kill its respective pid (I get it from the unix shell with ps -emo THREAD and I killed it with kill -9 <pid>).
The job finally stopped, but now I'm not able to recompile it. I can reset it, I can run it (successfully) but everytime I try to compile it I get the message:

Cannot get exclusive access to executable file for job XXX job may be being monitored.

Is there a way to "unlock" this job?
...
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

look for locks from iis administration
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

look for locks from iis administration
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi,

Check if the job is being monitored in the Director. Just change the view in Director from log view to status view.

Let us know what happens.

There are also other options in Director like Clean up resources and Clear status file which can be used to release the locks if any.

HTH
--Rich
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

Post by Alethesnake »

looking at the unix console no lock seems to be active on the job.
Note, I can run, reset, edit and save the job. I 'only' cannot compile it.
...
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

Post by Alethesnake »

richdhan wrote:Hi,

Check if the job is being monitored in the Director. Just change the view in Director from log view to status view.

Let us know what happens.

There are also other options in Director like Clean up resources and Clear status file which can be used to release the locks if any.

HTH
--Rich
I also tried to close the director, but the problem remains.
...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Could anyone else in the organization be monitoring the job or have it open ? Just because you close the Director does not preclude that possibility. The locks are on the server.

If this is a parallel job with a Transformer stage, try a Force Compile.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

Post by Alethesnake »

Actually I'm the one with access permission to the project, and from the consolle no other connections seems active to the server.
The problem rose when the Sequence remained running before the attachment of a job by doing nothing and I killed its pid from the unix shell.
It seems like the executable of the sequence has remained read-only (it's only an hypotesis). Is it possible to manually delete/chmod the executables? Which is their path?
Thanks a lot.
...
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do not, ever, use kill -9 on DataStage processes.

You will only deepen the hole you have already dug.

Use the DS.TOOLS menu or Cleanup Resources in Director.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Alethesnake
Participant
Posts: 56
Joined: Mon Mar 26, 2007 8:48 am
Location: Blue Bay (La Spezia)

Post by Alethesnake »

ray.wurlod wrote:Do not, ever, use kill -9 on DataStage processes.

You will only deepen the hole you have already dug.

Use the DS.TOOLS menu or Cleanup Resources in Director. ...
I understand, I will never again use the kill -9 on datastage processes.
I finally unlock my sequence by cleaning up all resources in the director, I initially had some problems to catch the right process to release.

Thanks a lot to all for your suggestions.

Bye,

Ale.
...
Post Reply