Job is hanging!!

arun_im4u · Post by **arun_im4u** » Tue May 15, 2007 5:04 pm

Hello,

When I try to run some of my DS jobs it just hangs and does nothing. eventually I had to kill them from the server. This happens to all jobs that tries to access one particular database. Every other job runs fine. I am able to access that database through TOAD. I am also able to view data thru the Oracle Enterprise Stage, but when I actually try to run the job ithangs.

Could someone please direct me in identifying a fix for this issue??

Thanks.

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 9:16 pm

Hire a consultant with DataStage and Oracle experience. Get the DBA to clean up the consequences of your killing processes. Get the DataStage Administrator to clean up the consequences of your killing processes. Cease relying upon killing processes.