Page 1 of 1

DataStage job stuck up in running condition

Posted: Sun Oct 25, 2009 11:29 pm
by ketanshah123
HI

My job design is like

oracle ent. stage ----> transformer------> seq file stage


ususally this job fetches 5000000 rows from orace tables and write it to seq. file and take 2 hours to run but today it stuck up after fetching around 20000000 and stuck up in running condition neither giving any error nor aborting since last 6 hours. Twice I have tried to stop and run it again but again the same issue

last message in log is : main_program: Starting step execution.


any suggestion what to do for this...


Thanx in Advance

Posted: Mon Oct 26, 2009 1:56 am
by ArndW
Since sequential files tend not to be the blocking factor, I would start by looking into the Oracle conection. I would talk to the DBA and use Oracle tools to monitor the query and it's progress, as it is likely that Oracle is causing the issue here.

Posted: Mon Oct 26, 2009 4:37 am
by ketanshah123
Thanx for your reply ..

I am having discussion with DBA they are also analysing the issue. This job never failed in last 2 years this is 1st time we are facing this issue only clue we do have that before running of this job DataBase server was shut down for an hour for maintainence purpose ...
ArndW wrote:Since sequential files tend not to be the blocking factor, I would start by looking into the Oracle conection. I would talk to the DBA and use Oracle tools to monitor the query and it's progress, as i ...