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..
DB2 Bulk Load Performance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: