DB2 Bulk Load Performance

rajendharreddy · Post by **rajendharreddy** » Tue Jan 20, 2009 4:06 am

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..

ray.wurlod · Post by **ray.wurlod** » Tue Jan 20, 2009 4:49 am

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?

ray.wurlod · Post by **ray.wurlod** » Tue Jan 20, 2009 4:50 am

Moderator: please move to server forum