MultiRowInsert
For Db2, the MultiRowInsert parameter enables or disables High-speed Apply Engine’s processing of multiple row insert actions.
When the value of this parameter is Yes, High-speed Apply Engine can insert more than one row into a target table in one insert action (by using host variable arrays and the FOR n ROWS form of the INSERT statement).
Multiple row insert actions can provide performance benefits, but they can also increase the overhead of conflict resolution processing when insert-related conflicts occur. Use the MaxRows and MaxConflicts parameters to balance increased performance against increased conflict resolution overhead.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [MultiRowInsert] |
Abbreviation | None |
DBMS | Db2 |
Required? | No |
Valid values | Yes or No |
Default value | No |
Usage
Specify Yes to enable multiple row insert actions. The default value of No causes High-speed Apply Engine to perform single row insert actions for all inserts in the input file.
Be aware of the following points regarding this parameter:
- High-speed Apply Engine supports multiple row insert actions only under Db2 Version 9 and later for mainframe targets.
- The performance benefits of multiple row insert actions depend on conditions in your environment. BMC Software recommends that you measure results for several values of the MaxRows and MaxConflicts parameters in a test environment before implementing changes in a production environment.
Related topic