Page 1 of 1

Job is running for long time

Posted: Wed Aug 15, 2007 1:14 pm
by somu_june
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

Posted: Wed Aug 15, 2007 3:02 pm
by ArndW
How long does the same SQL select take from the DB2 command line? Has the table been modified recently and runstat'ed?