Page 1 of 1

Error in opening a job

Posted: Mon Oct 02, 2006 11:24 am
by theverma
Hi Friends...
I have ended my job forcefully by doing the end process from the Task Manager.But now it's not opening and giving an error message like 'it is being accessed by another user'.
Any help will be highly regarded...
Thanx

Posted: Mon Oct 02, 2006 11:43 am
by kris007
Ask you DSadmin to release the lock on that job. Or you can go to the Director>>Jobs>>CleanupResources and look at the process Id in the Locks Section and logout that process from the Processes section if you are familiar with it. If not, I would suggest you ask your dsadmin.

Re: Error in opening a job

Posted: Mon Oct 02, 2006 11:44 am
by avi21st
theverma wrote:Hi Friends...
I have ended my job forcefully by doing the end process from the Task Manager.But now it's not opening and giving an error message like 'it is being accessed by another user'.
Any help will be highly regarded...
Thanx

You can check from Unix if the job is accessed by doing a ps -ef|grep ds

I prefer to use the Datastage director and from there go to Cleanup resources where you can check if the job is used by someone. If you are the dsadm or the owner of the job then you can log it out.

Posted: Mon Oct 02, 2006 12:10 pm
by theverma
Thanx for the reply..but my Cleanup Resources option is coming disabled in the Director > Job .
Only i m the owner of the Job.

Thanx

Posted: Mon Oct 02, 2006 12:12 pm
by kris007
That means you might not have permission to perform that action. Talk to your dsadmin. He is the one who can help you out.

Posted: Mon Oct 02, 2006 3:14 pm
by ray.wurlod
Never kill DataStage processes in this way. You are unaware of the relationships between DataStage processes; there are typically at least two processes involved in running a server job.

Having done so, as others have pointed out, you (or an Administrator) need to effect repairs; in particular unlocking the lock on the job, but possibly also the network connection (is there still a client connected to that killed process?).

Posted: Mon Oct 02, 2006 7:56 pm
by kumar_s
"Enable job Admistration in Director" option should be checked in DS Adminstrator by the dsadm id inorder to get the Cleanup Resource option enabled for you userid.

Posted: Tue Oct 03, 2006 3:35 am
by theverma
Thanx friends...
This as been done..!!!