Which of the following methods can improve the IMPORT command performance of the DB2 database?

This article mainly introduces three basic operations to improve the IMPORT command performance of the DB2 database, if you are interested in the three basic operations to improve the IMPORT command performance of the DB2 database, you can click the following article to view it.

In a partitioned database environment, you can use Buffered insert to improve the IMPORT performance of the DB2 database: 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:

Environment

[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 of the DB2 database:

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. sqllibbnd 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 is an introduction to three ways to improve the performance of the DB2 database IMPORT command. I hope you will have some gains.