Hi All,
I am trying to Delete a job which I have created and I am getting the following error message:-
Message : Cannot get exclusive access to log for job <jobname>
Could anyone let me know what's the issue about,This is the first time I am getting this error.
I have checked by releaseing the job through the Director and also cleared the Status file of the Job,inspite of which I am getting this message.
I am able to Complie the job and run the job but I am not able to delete the Job.
If anybody could let me know what else needs to be done or how to go about deleting this would be of great help.
Thanks & Regards
SMK
During Deletion of the Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Re: During Deletion of the Job
Usually, the rest of this message is something like: "job may be being monitored". Is there any chance someone has a monitor window open for this job?MaheshKumar Sugunaraj wrote:Message : Cannot get exclusive access to log for job <jobname>
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I thought 5 and up would have this fixed.
In 4.3.2 we actually had to copy the job as another version of the job and use the newer version until one day the original job was free to delete (we couldnt bring down the server).
i hope this isnt the case.
In 4.3.2 we actually had to copy the job as another version of the job and use the newer version until one day the original job was free to delete (we couldnt bring down the server).
i hope this isnt the case.
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
"what the thinker thinks, the prover proves" - Robert Anton Wilson
as a test:denzilsyb wrote:I thought 5 and up would have this fixed.
In 4.3.2 we actually had to copy the job as another version of the job and use the newer version until one day the original job was free to delete (we couldnt bring down the server).
i hope this isnt the case.
1) have everyone logout of datastage (from manager, director, ...) and kill -15 the remaining ds_apislave processes on the UNIX server: ps -ef | grep slave
2) check for any running phantoms in which your job name appears: ps -ef | grep phantom. And kill them.
3) use a combination of list_readu and "select * from ds_job where jobno = 'number'" from a uv session to find the offending locks
Ogmios
My hunch is that the job is still locked somewhere, but because the lock is on job number you always look over it.
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: During Deletion of the Job
Hi,
This message
Message : Cannot get exclusive access to log for job <jobname>
happend when the job was created using a different user, and you try to delete using other user that dont have permission..
Check your permissions in the directory.
This message
Message : Cannot get exclusive access to log for job <jobname>
happend when the job was created using a different user, and you try to delete using other user that dont have permission..
Check your permissions in the directory.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 84
- Joined: Thu Dec 04, 2003 9:55 pm
Hi All,
Thanks for your responses, The problem was resolved and wanted to share the same with you'll,
1. I have check for the Monitor window and everything is closed.There was no one except me working on the Job.
2. I check in the Director for the Process ID and nothing was allocated so I checked in UNIX for the process and tried to Kill it but there was'nt any.
3. Then I checked with a senior person and he told me to use list_readu and I checked,so this had a PID allocated to the RTLOG file and Killed the process.
Thanks again,
Have a great day.
Regards
SMK
Thanks for your responses, The problem was resolved and wanted to share the same with you'll,
1. I have check for the Monitor window and everything is closed.There was no one except me working on the Job.
2. I check in the Director for the Process ID and nothing was allocated so I checked in UNIX for the process and tried to Kill it but there was'nt any.
3. Then I checked with a senior person and he told me to use list_readu and I checked,so this had a PID allocated to the RTLOG file and Killed the process.
Thanks again,
Have a great day.
Regards
SMK