Job Monitor and Oracle Enterprise stage

maheshsada · Post by **maheshsada** » Thu Jul 17, 2008 1:42 pm

We have a job which reads from Oracle Enterprise stage and does sorting, join and writes to sequential file. When the job monitor is on the oracle stage is running forever without selecting any rows. If the job monitor is off then the same job completes within minutes.
I am not able to understand the relation between job monitor and oracle staging not selecting the records.
Can anyone throw some light

regards
Magesh S

maheshsada · Post by **maheshsada** » Mon Jul 21, 2008 1:17 pm

can anyone please answer the relation between job monitor and oracle enterprise stage

chulett · Post by **chulett** » Mon Jul 21, 2008 1:23 pm

There really isn't one.

Best to open a case with your official Support provider, I would think.

keshav0307 · Post by **keshav0307** » Mon Jul 21, 2008 9:02 pm

not sure about the relationship, but it does make difference.

chulett · Post by **chulett** » Mon Jul 21, 2008 9:12 pm

What "does make a difference"? Can you expand on your comment, please?

keshav0307 · Post by **keshav0307** » Mon Jul 21, 2008 10:51 pm

in terms of performance.

maheshsada · Post by **maheshsada** » Tue Sep 16, 2008 10:03 am

I have enable APT_STARTUP_STATUS & APT_DUMP_SCORE and checked for the execution. The job comes upto "main_program: Starting step execution." after than it just hangs.

If i enable $APT_NO_JOBMON to True then the job completes. Any ideas

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2008 3:21 pm

Is your job monitor (a separate Java application) actually running?

senthil_tcs · Post by **senthil_tcs** » Fri Oct 24, 2008 4:15 am

Hi,

We are also experiencing the same issue, please let me know if you have found any solution/received any patch from IBM.