DSXchange

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

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.

A Monitor?? Is that a DS tool?

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

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

Thanks, Ray!

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

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

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

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

Sam

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.