DataStage job stuck up in running condition
Posted: Sun Oct 25, 2009 11:29 pm
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
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