Quick improvement of the DB2 database IMPORT Command Performance

In a partitioned DB2 database environment, you can use Buffered Insert to improve the IMPORT performance. Before executing the IMPORT command, bind the BIND file db2uimpm corresponding to the IMPORT command with the insert buf parameter. bnd.

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 a partitioned DB2 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.

The above content describes how to improve the performance of the DB2 database IMPORT command, hoping to help you in this regard.