"Cannot get exclusive access to executable file for job

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
cbres00
Participant
Posts: 34
Joined: Tue Sep 21, 2004 9:20 am

"Cannot get exclusive access to executable file for job

Post by cbres00 »

When developing PX jobs, I occasionally get abends. I go to Director, either hit RESET or CLEAR STATUS FILE, then attempt a recompile of my job. Quite frequently I get the message:

"Cannot get exclusive access to executable file for job xyz"

1) What is this?
2) How can I easily avoid / correct it?

Thanks,
cbres00
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Maybe one of the sub-processes is still running. Try using a Monitor to see whether any stages are still running - choose the "show instances" option. Check using the list_readu command to see whether the job is locked by DataStage. Try switching to a different job in Director (status view) to see whether the lock is freed. Make sure the job is not open in Designer - by anyone.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
data_whs_team
Charter Member
Charter Member
Posts: 18
Joined: Fri Aug 18, 2006 11:47 pm
Location: California

Post by data_whs_team »

A Monitor?? Is that a DS tool?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Monitor is one of the four views available in the Director client.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
data_whs_team
Charter Member
Charter Member
Posts: 18
Joined: Fri Aug 18, 2006 11:47 pm
Location: California

Post by data_whs_team »

VERY COOL! I never even knew this was here. I don't see the 'show instances' option, but nevertheless, this is WONDERFUL.

Thanks, Ray!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The 'Show instances' option is only applicable to PX jobs, perhaps you are looking at a Server job.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Right-click in the background area of the Monitor. You also get Show CPU which is almost vital information when tuning parallel jobs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
splayer
Charter Member
Charter Member
Posts: 502
Joined: Mon Apr 12, 2004 5:01 pm

Post by splayer »

I am getting the same problem. It would not let me rename my job.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

As Ray has suggested use MONITOR or list_readu. And also check whether some other user is accessing that job?

Sam
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can only rename a job if it is not locked. It is locked if open in Designer or Manager, or in Log or Monitor view in Director. It may also be locked by a defunct process if a connection had been terminated abnormally.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply