Job Hanging!!

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Job Hanging!!

Post by allavivek »

Hi All,

One of my jobs is getting hanged in "running" state...

I was using oracle stage for reading values...is this can be causing hanging job or any other isue might be??

I tried to stop job from director but still its in running state..

How to stop job ??
What to do to eliminate this hanging?

Thank you...
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

Go to Administrator client to UNLOCK the job.
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Post by allavivek »

Hi All,

I did killed the job using kill and noe while again trying to compile job i was getting compilation error as ..

"cannot get exclusive access to job xxxxxxxxx-job may be monitored"

I cleared status files and resources , logged off and again logged in , but theres no use...

How to get rid of this???

Thak you..
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Unlock the job.

Never kill jobs. You get into this trouble. Issue stop requests instead.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Post by allavivek »

ray.wurlod wrote:Unlock the job.

Never kill jobs. You get into this trouble. Issue stop requests instead. ...
Thanks ray..

But how to get rid of this issue....
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

Did you go to Administrator client to UNLOCK the job like I said in previous post?
allavivek
Premium Member
Premium Member
Posts: 211
Joined: Sat May 01, 2010 5:07 pm

Post by allavivek »

lstsaur wrote:Did you go to Administrator client to UNLOCK the job like I said in previous post?
Yes but it said verb "UNLOCK" is not in your VOC..

Do we need to be dsadmin to do unlock??

Thanks
vinothkumar
Participant
Posts: 342
Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India

Post by vinothkumar »

In the administrator command prompt, type ds.tools and execute. It will guide you from there.
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

That's because unlock comannd is not available by defaut in the projects.
Go back to your Administrator client and issue the following two commands:
>SET.FILE UV VOC UV.VOC
>COPY FROM VU.VOC TO VOC UNLOCK
Post Reply