Page 1 of 1

compile error

Posted: Fri Mar 24, 2006 1:01 am
by scorpion
hi all,

when i make some changes for source file and try to compile the job
it is giving error like

"cannot get exclusive access to executable file for job (jobname)
-job may be being monitered"


can any one helpme on this

thanks,

Posted: Fri Mar 24, 2006 1:08 am
by balajisr
Are you are monitoring your job in the director? if so you cannot compile it. you need to close the monitor window in the director.

Posted: Fri Mar 24, 2006 1:11 am
by scorpion
hi

thanks for quick reply,but i am not monitoring the job in director.

how can i over come this problem.

Posted: Fri Mar 24, 2006 1:23 am
by balajisr
Is anyone else monitoring your job?

Posted: Fri Mar 24, 2006 1:35 am
by scorpion
how should i know some body monitoring my job..is there any process to get details of my job monitoring is currently from somebody?

Posted: Fri Mar 24, 2006 2:16 am
by ArndW
The message comes because there is a lock on a table record fro that job. If another user is editing the job, if it is running or if a monitor is open this is the message you will see. One other cause is if the job has somehow aborted or been killed so that the locks remain. If this is the case then you will need to wait for the dsdlockd process to clean up the locks for you - if you have it running.

You can try to view and track the locks in the Director but it is not always easy to identify the correct locks. There are many posts here that explain how to do this.

Posted: Fri Mar 24, 2006 6:04 am
by kumar_s
Yes, use LIST.READU EVERY from TCL to get all list of locks.
If you find the job you mentioned in the list, perhap you can release it.
If you dont run any job at the moment, any any client being opened at the moment, you can simply use UNLOCK ALL to release all the locks.

Posted: Fri Mar 24, 2006 6:16 am
by ArndW
Kumar - UNLOCK ALL as administrator is very powerful and should not be used! It has a potential to really mess up a DS environment since all concurrency control in DataStage is based on locks.

In this case if no jobs are running and no users are logged in the appropriate lock(s) should be easy to spot using LIST.READU

Posted: Fri Mar 24, 2006 6:24 am
by kumar_s
I was under the impression that, if all the clients as disconected and if no running jobs, UNLOCK ALL can be executed :o
Infact while following some set of instruction given by IBM support people, I was asked to do the same.