Job running stage

kamesh · Post by **kamesh** » Wed Jul 30, 2008 1:14 am

Hi,
my jobs keepon running while reading oracle table. this is inconsistant some time it is working fine some times it is not. I have varchar 1 filed in my source table. i have changed that filed as last coumn in my select query then it is working fine. Please let me know what could be the reason.

Note: my job is oracle --- copy--- sequential file using RCP

thanks
kamesh

ArndW · Post by **ArndW** » Wed Jul 30, 2008 1:20 am

I don't think that this can be diagnosed from DataStage alone, you will need to involve your DBA when this happens again. Does the "hang" occur after all the data has been read or at the beginning of the SELECT?

kamesh · Post by **kamesh** » Wed Jul 30, 2008 2:40 am

At the beginning of the select query

ArndW · Post by **ArndW** » Wed Jul 30, 2008 2:45 am

"At the beginning" usually points more to a SQL or Database issue, whereas "at the end" often indicates a DataStage issue. As is often the case with sporadic problems, perhaps the column position change has just changed the frequency of the problem but hasn't solved it; I can't see how a column position can affect this query.

kamesh · Post by **kamesh** » Wed Jul 30, 2008 8:10 am

In the log it is showing the whole sql query only after that hanging