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 |