Page 1 of 1
datastage job stuck in running condition while pulling data
Posted: Mon Jul 19, 2010 7:42 pm
by ketanshah123
Hi
one of the job stuck while pulling data from database after certain no. of rows, have tried to run it thrice but the same result.Also not giving any error or warning its just stuck in running condition, any idea why its happening ? Is it database issue ?
Posted: Mon Jul 19, 2010 8:47 pm
by ray.wurlod
What's the row count and the approximate corresponding volume of data? What are your trying to do with these data in the job?
Posted: Mon Jul 19, 2010 8:55 pm
by ketanshah123
ray.wurlod wrote:What's the row count and the approximate corresponding volume of data? What are your trying to do with these data in the job? ...
we are not doing any kind of processing in the job its just pulling data from oracle tables and load it into .csv for downstream reporting applications.
design of job is :
oracle ------> transformer----------->sequential file
Usually it pulls 30 to 40 million but today its stuck after 10 million in running condition , twice I have tried to stop and run the job but same result
Posted: Mon Jul 19, 2010 9:23 pm
by chulett
Have you asked your DBA for help? Checked to see what the state of the Oracle process is? Grep'd for the processes in UNIX? You need to determine which bits, if any, are actually still running.