Page 1 of 1
Job Monitor and Oracle Enterprise stage
Posted: Thu Jul 17, 2008 1:42 pm
by maheshsada
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
Posted: Mon Jul 21, 2008 1:17 pm
by maheshsada
can anyone please answer the relation between job monitor and oracle enterprise stage
Posted: Mon Jul 21, 2008 1:23 pm
by chulett
There really isn't one.
Best to open a case with your official Support provider, I would think.
Posted: Mon Jul 21, 2008 9:02 pm
by keshav0307
not sure about the relationship, but it does make difference.
Posted: Mon Jul 21, 2008 9:12 pm
by chulett
What "does make a difference"? Can you expand on your comment, please?
Posted: Mon Jul 21, 2008 10:51 pm
by keshav0307
in terms of performance.
Posted: Tue Sep 16, 2008 10:03 am
by maheshsada
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
Posted: Tue Sep 16, 2008 3:21 pm
by ray.wurlod
Is your job monitor (a separate Java application) actually running?
Posted: Fri Oct 24, 2008 4:15 am
by senthil_tcs
Hi,
We are also experiencing the same issue, please let me know if you have found any solution/received any patch from IBM.