Job is running for long time

somu_june · Post by **somu_june** » Wed Aug 15, 2007 1:14 pm

Hi,

I have a job which selects the records from Db2 /Zos and Iam using Db2 /API stage to read the records from the source, previously it used to take 20 minutes for the job to finish , now when Iam running the same job it is not finishing even after one hour . I am writting records to a Sequential file . I have Db2 /API stage , Transformer and Sequential file in the job .

Can some body help . Please can some body move this post to parallel section

Thanks,
SomaRaju

ArndW · Post by **ArndW** » Wed Aug 15, 2007 3:02 pm

How long does the same SQL select take from the DB2 command line? Has the table been modified recently and runstat'ed?