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

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
  • viewed: 1068
Share:

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.