Hello,
I am loading 300k records from a sequential File to a DB2 Table....
This is done on my local machine......The rate of transfer is a pathetic 32 rows/sec.
(i) Initially the table does not exist.
(ii) The update Action : Update or Insert
(iii) Array size = 1 ; Transaction Size = 100
Would appreciate some advise to achieve better performance....
Thanks
Hazmar
Low Performance in Loading Records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try changing the action to Insert or Update (so Insert is attempted first).
What difference does that make?
Then try changing the array size to 100. Do not change rows/transaction.
What difference does that make?
Only change one thing at a time.
What is the average size of the data in a row?
What difference does that make?
Then try changing the array size to 100. Do not change rows/transaction.
What difference does that make?
Only change one thing at a time.
What is the average size of the data in a row?
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.