February 11, 2016 at 11:59 am
Hello All,
I am trying to insert millions of rows from SQL Server into DB2 database tables. Linked server in SQL Server is configured. I have also created the SSIS package to do the same but it takes a lot of time (approx 8 to 10 hours) to insert 2 millions of rows into DB2 tables.
Is there a way to finish the package within minutes? Can we insert rows in batches (say 10,000) in DB2 and commit from DB2 end once the rows are inserted? I am not sure how to improve the performance of the insert operation that could finish up the activity in minutes instead of taking hours.
Help will be appreciated.
Thanks.
February 11, 2016 at 2:12 pm
Might want to ask on a DB2 forum.
February 12, 2016 at 5:59 am
Part of your problem may be the distance between data centers / server locations. Especially if they're in different domains.
Sometimes doing batches can help speed things up, but I don't know anything about DB2, so I'm not certain this would work for you. You might consider getting a network admin to sniff the network while you're doing this transfer to help identify hardware / network issues that may be causing the issue.
Also, how fast does the SELECT from SQL Server work? Check this out in SSMS. If it's quite speedy, then your problem isn't SQL Server. But if it's quite slow, then you have code tuning you'll need to do before pushing the data to DB2.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply