Slow import

Posted on 2004-11-23
Medium Priority
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

Lowfatspread earned 2000 total points
ID: 12657578
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

ID: 12657629
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

807 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