datastage job stuck in running condition while pulling data

ketanshah123 · Post by **ketanshah123** » Mon Jul 19, 2010 7:42 pm

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 ?

ray.wurlod · Post by **ray.wurlod** » Mon Jul 19, 2010 8:47 pm

What's the row count and the approximate corresponding volume of data? What are your trying to do with these data in the job?

ketanshah123 · Post by **ketanshah123** » Mon Jul 19, 2010 8:55 pm

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

chulett · Post by **chulett** » Mon Jul 19, 2010 9:23 pm

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.