how to increase Performance of ds Job

thepakks · Post by **thepakks** » Tue Aug 11, 2009 7:41 am

I have a simple job that reads a sequential file passes it through a transformer and then write into two sequential file. The seuqential file has about 250 million rows. I'm experiencing very low performance reading and writing the file.

I am using 5 node in configuration file.

If there any parameter for increase the performance of datastage job?

Thanks in advance.

keshav0307 · Post by **keshav0307** » Tue Aug 11, 2009 7:50 am

what do you mean very low performance reading and writing the file??\
\how many records per second ?
how much you are expecting?

chulett · Post by **chulett** » Tue Aug 11, 2009 7:50 am

Define 'very low performance' and describe in detail what you are doing in the transformer.

priyadarshikunal · Post by **priyadarshikunal** » Tue Aug 11, 2009 9:28 am

In addition to that explain type of your file i.e. fixed width/delimited and
what properties are being used while reading and writing.