I am not able to compile my job ......pls urgent
Moderators: chulett, rschirm, roy
I am not able to compile my job ......pls urgent
Hi All,
I am able to open a job and I am able to change it but it is displaying the following error while compiling.....
"Can not get exclusive access to executable file for job may be being monitored"...
It is a multi instance job, and currently I have not opened any monitor in director......
Thanks....
I am able to open a job and I am able to change it but it is displaying the following error while compiling.....
"Can not get exclusive access to executable file for job may be being monitored"...
It is a multi instance job, and currently I have not opened any monitor in director......
Thanks....
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
there are many option to get rid of this
1. in DataStage Administrator choose correct project then go to Command and Enter DS.TOOLS. from the first menu use option "5" and from the second menu that appears choose "11"th option and then enter your job name correctly, rest DS Administrator will take care
2. use putty any ssh client to login to you Datastage home, make sure no one has any job running, then in type following command in given directory
DSHOME/bin/uv -admin -stop
wait for 30-40 secs and then enter
DSHOME/bin/uv -admin -start
it will restart the DataStage engine and all the jobs will be released.
3. Make sure there are no jobs running under your project,
Go to DataStage Adminstrator in your project fire the following command
CLEAR.FILE &PH&
this command will clear all phantom process in the project you fire this command and all the job will be released
4.Or if your job get hanged due to your database gone down while the job was running than in the UNIX login to your project and fire the following command
ps auxw | grep <project>
it will list all the process that are in your project find the pid of your job from the list and use-> kill -9 <pid> to kill the zombie entries this will also make your job free.
1. in DataStage Administrator choose correct project then go to Command and Enter DS.TOOLS. from the first menu use option "5" and from the second menu that appears choose "11"th option and then enter your job name correctly, rest DS Administrator will take care
2. use putty any ssh client to login to you Datastage home, make sure no one has any job running, then in type following command in given directory
DSHOME/bin/uv -admin -stop
wait for 30-40 secs and then enter
DSHOME/bin/uv -admin -start
it will restart the DataStage engine and all the jobs will be released.
3. Make sure there are no jobs running under your project,
Go to DataStage Adminstrator in your project fire the following command
CLEAR.FILE &PH&
this command will clear all phantom process in the project you fire this command and all the job will be released
4.Or if your job get hanged due to your database gone down while the job was running than in the UNIX login to your project and fire the following command
ps auxw | grep <project>
it will list all the process that are in your project find the pid of your job from the list and use-> kill -9 <pid> to kill the zombie entries this will also make your job free.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please do NOT advise kill until ALL other avenues have been exhausted.
The correct procedure is to identify the owner of the lock, with a view to getting it released cleanly. If it is a defunct process, the administrator has an UNLOCK tool available (perhaps via the DS.TOOLS menu).
A Director open in log view will have a lock on the RT_LOGnnnn hashed file. A Director open in monitor view will have a lock on the RT_CONFIGnnnn hashed file.
Killing processes should always be the very, very last resort, even after Clear Status File. And that's so last resort it asks "are you sure?" twice!
The correct procedure is to identify the owner of the lock, with a view to getting it released cleanly. If it is a defunct process, the administrator has an UNLOCK tool available (perhaps via the DS.TOOLS menu).
A Director open in log view will have a lock on the RT_LOGnnnn hashed file. A Director open in monitor view will have a lock on the RT_CONFIGnnnn hashed file.
Killing processes should always be the very, very last resort, even after Clear Status File. And that's so last resort it asks "are you sure?" twice!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Administrative Note
We don't do "urgent" here. All poster are volunteers; no-one gets paid for posting, it's done in our valuable spare time. If you want "urgent" sign up with your support provider for premium service, and learn just how much elevated priority costs.
We don't do "urgent" here. All poster are volunteers; no-one gets paid for posting, it's done in our valuable spare time. If you want "urgent" sign up with your support provider for premium service, and learn just how much elevated priority costs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
47shailesh - I have issues with several of your recommendations -
Recommendation 1 is a correct one.
Recommendation 2 is terrible, it will stop the DataStage engine - kick out any other users on the system who might be logged in and cause them to lose data if they were editing jobs and might leave running jobs in undefinaed states. In addition, unless all processes are actually logged out in UNIX the subsequent restart will not work.
Recommendation 3 is wrong, but won't harm the system like #2 can. The &PH& directory contains log files and clearing the contents can decrease some overhead involved in job administration, but no locks are held on these files and thus it doesn't pertain to the problem.
Recommendation 4 is DANGEROUS.
NEVER, EVER do a "kill -9" unless you have tried every other alternative (including a normal kill). I can guarantee that doing a "kill -9" will corrupt the instance so that you will have no option but to stop and start the engine. Those who know how to use the UNLOCK or ipcs/ipcrm commands can fix this without having to stop the system, but the same people would never think of using kill -9 in the first place.
Recommendation 1 is a correct one.
Recommendation 2 is terrible, it will stop the DataStage engine - kick out any other users on the system who might be logged in and cause them to lose data if they were editing jobs and might leave running jobs in undefinaed states. In addition, unless all processes are actually logged out in UNIX the subsequent restart will not work.
Recommendation 3 is wrong, but won't harm the system like #2 can. The &PH& directory contains log files and clearing the contents can decrease some overhead involved in job administration, but no locks are held on these files and thus it doesn't pertain to the problem.
Recommendation 4 is DANGEROUS.
NEVER, EVER do a "kill -9" unless you have tried every other alternative (including a normal kill). I can guarantee that doing a "kill -9" will corrupt the instance so that you will have no option but to stop and start the engine. Those who know how to use the UNLOCK or ipcs/ipcrm commands can fix this without having to stop the system, but the same people would never think of using kill -9 in the first place.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
47shailesh
I have cleared status file using ur option and logged out the specified job but again it is displaying error "Can not exclusive access, job can be monitored"............
Ray,
Where these files are available which you have mentioned........and how to unlock it
" RT_LOGnnnn hashed file. A Director open in monitor view will have a lock on the RT_CONFIGnnnn hashed file. "
Thanks for your reply....
I have cleared status file using ur option and logged out the specified job but again it is displaying error "Can not exclusive access, job can be monitored"............
Ray,
Where these files are available which you have mentioned........and how to unlock it
" RT_LOGnnnn hashed file. A Director open in monitor view will have a lock on the RT_CONFIGnnnn hashed file. "
Thanks for your reply....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Where they are is irrelevant - they are hashed files in your Repository.
Use list_readu command (or LIST.READU command or Cleanup Resources in Director) to see the locks. Use the DS.TOOLS menu or the UNLOCK command to free the locks held by defunct process(es).
Use list_readu command (or LIST.READU command or Cleanup Resources in Director) to see the locks. Use the DS.TOOLS menu or the UNLOCK command to free the locks held by defunct process(es).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Yeah like ray says, should be your best option! Believe me , I've done it and it works.
Useand to find the offending locks/processes. It will also give you the USERNO to unlock.
Code: Select all
UNLOCK USER <USERNO>
Use
Code: Select all
PORT.STATUS
Code: Select all
LIST.READU EVERY
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
In DS Administrator use LIST.READU and see if you can find any locks related to your job. If you can find then note the pid, use DS.Tools command and choose option 4 and then option 7 and give the pid to release the locks. If that dosen't work then look for USERNO and use UNLOCK USER userno ALL. Make sure you are logged log in as a user with relevant privileges for this.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>