467,200 Members | 1,039 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,200 developers. It's quick & easy.

db2 import and microsoft host integration server

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

Nov 12 '05 #1
  • viewed: 1068

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by David Berry | last post: by
2 posts views Thread by David Berry | last post: by
1 post views Thread by Chicagoboy27 | last post: by
9 posts views Thread by cabrenner@optonline.net | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.