Slow import

Posted on 2004-11-23
Last Modified: 2006-11-17
We are importing into DB2 UDB (used version 8.1 and version 8.2) using DataDirect ODBC drivers v4.2 and the import is extremely slow (10,000 records take about 15 minutes). Any pointers on how to improve import performance?

Thanks in advance.
Question by:aporras
    LVL 50

    Accepted Solution

    is it just import which is slow?

    have you got sufficient buffers, etc..

    how many indexes are defined on the tables...
    constraints etc...

    consider removing the constraints/ indexes  and adding after the load...


    Author Comment

    The answer was the "LOAD" part - the programmer was inserting rows rather than loading the data. Thanks very much for the prompt reply.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now