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
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?
"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.