DSXchange

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

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?