Low Performance in Loading Records

[cosec]

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

[ray.wurlod]

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?