In a partitioned database environment, the import utility can be enabled to use buffered inserts. This reduces the messaging that occurs when data is imported, resulting in better performance; however, since details about a failed buffered insert are not returned, this option should only be enabled if you are not concerned about error reporting.
Use the DB2 bind utility to request buffered inserts. The import package, db2uimpm.bnd, must be rebound against the database using the INSERT BUF option. For example:
db2 connect to your_database db2 bind db2uimpm.bnd insert buf
| Note: | The buffered inserts feature is disabled during any import operation in which the INSERT_UPDATE parameter is specified. |