Post reply

DB2 to SQL 2000 - DTS - Performance Tuning

  • February 6, 2011 at 1:50 am

    #74350

    We are exporting data (in millions) from DB2 to a SQL server 2000 through DTS. It takes about 5-6hrs for the DTS to complete. Is there any options/ways to fine tune this, so as to reduce the run time.

    Assume that the DTS is an simple source to destination without any additional tasks (ActiveX, Queries etc)

  • February 7, 2011 at 7:06 am

    #1283089

    1) Only pull the columns and rows you need from the source (instead of everything). -- In other words, Filter, Filter, Filter.

    2) Run the package when little-to-no other traffic or jobs are occurring on either DB2 or SQL Server.

    Here's a troubleshooting tip. Put a network sniffer on your traffic while the package is running. See if it's an issue with bandwidth as opposed to SQL Server or DB2. You want to check for network speed (maybe your cards are set too low) or network I/O (maybe the network is just incapable of handling that amount of data).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • March 7, 2011 at 5:44 am

    #1295266

    Check to see if you have the latest DB2 drivers installed.

    1) I would say look at the option in DB2 to export all relevant records into a flat file on DB2 side.

    2) Zip the flat file and then ftp it to SQL Server.

    3) Unzip the file on SQL Server and bulk insert the records into SQL server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply