How to improve the performance of the import command in DB2

When data is imported using the Import command provided by DB2, all constraints are validated, all loaded rows are logged, and triggers are activated, so the import utility performs significantly less well than the DB2 load utility when loading large amounts of data, to increase import Performance, here are two ways to provide users.

For the import utility for DB2, using the compound option or adding a buffer insertion option when you BIND db2uimpm.bnd files can improve the performance of the import and, in most cases, to import a partitioned database with a large amount of data, for IM The improvement of PORT performance is particularly important.

Here is a brief introduction to the implementation steps of these two methods:

1. Use the Insert BUF option to bind the IMPORT utility to enable buffer insertion, which is to rebind to the database using the Insert BUF option for the DB2UIMPM package.

For example:

DB2 C onnect to sample

DB2 bind DB2UIMPM.BND Insert Buf

DB2 Import from MyFile of Del inserts into MyTable

2. Use the compound option when issuing import commands for importing data, such as using Compound=n after the MODIFIED by statement so that N-Row Records in the INSERT statement are imported together as a group. This approach reduces network traffic by comparing the way line-by-Row records are inserted. The range of compound is 1-100.

For example:

DB2 Connect to sample

DB2 import from MyFile to Del Modified by compound=100 INSERT INTO mytable