DSXchange

Hi,

We are loading data from windows to LINUX server. Currently it is going 9000 rows/sec. To load all data(230 M) it is taking ~8hrs. Is there a way to improve performance by tweaking the parameters in DB2 bulk load.

Note that target database is partitioned.

Can anybody help me on this?

Thanks..

Define "performance".

What rate can you get writing to a text file, without doing the bulk load? Would you be prepared to do that, and run the bulk load separately?