db2 import and microsoft host integration server

Alex

Hi,
We loading data to db2 udb 7.2 from sql 2000

Using db2 import import 180000 rows with commit every 1000 rows.
It takes 7 minutes to complete import
Using microsoft DTS and microsoft ole db provider for db2
we call DTS 180 times load 1000 rows each time
it takes 1 hr to complete import

Any setting in db2 client part could speed up import ?

Thank you

Alex

Nov 12 '05 #1