How to improve IMPORT performance in DB2

There are three ways to improve the IMPORT command performance:

[Product] DB2

[Platform] cross-platform

[Version] 7.x, 8.1

Q: How can I improve the IMPORT command performance?

Answer:

1. In the partitioned database environment, Buffered Insert can be used to improve the IMPORT performance:

Before executing the IMPORT command, bind the BIND file db2uimpm. bnd corresponding to the IMPORT command with the insert buf parameter.

For example:

Db2 connect to database name

Db2 bind db2uimpm. bnd blocking all insert buf

Db2uimpm. bnd is in the. sqllib \ bnd directory.

2. Run the IMPORT command using the COMPOUND parameter:

For example:

Db2 connect to database name

Db2 import from data file name of ixf modified by compound = 100 insert into Table Name

In the preceding command, IMPORT will wait for the returned SQL Execution result after each 100 records instead of each record is inserted.

3. If data already exists in the table, modifying the table attribute to append mode can also speed up the IMPORT performance.

1. How to Improve Insert performance in DB2
2. DB2 database performance optimization tips
3. Several knowledge points that DB2 must understand