"Cannot get exclusive access to executable file for job

cbres00 · Post by **cbres00** » Fri Aug 18, 2006 7:19 pm

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 · Post by **ray.wurlod** » Fri Aug 18, 2006 10:53 pm

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.

data_whs_team · Post by **data_whs_team** » Sat Aug 19, 2006 12:07 am

A Monitor?? Is that a DS tool?

ray.wurlod · Post by **ray.wurlod** » Sat Aug 19, 2006 2:01 am

Monitor is one of the four views available in the Director client.

data_whs_team · Post by **data_whs_team** » Sat Aug 19, 2006 9:19 am

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 · Post by **chulett** » Sat Aug 19, 2006 2:50 pm

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

ray.wurlod · Post by **ray.wurlod** » Sat Aug 19, 2006 10:10 pm

Right-click in the background area of the Monitor. You also get Show CPU which is almost vital information when tuning parallel jobs.

splayer · Post by **splayer** » Wed Sep 06, 2006 9:49 am

I am getting the same problem. It would not let me rename my job.

us1aslam1us · Post by **us1aslam1us** » Wed Sep 06, 2006 12:08 pm

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

Sam

ray.wurlod · Post by **ray.wurlod** » Wed Sep 06, 2006 4:27 pm

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.