MultiRowInsert parameters
For Db2, the [MultiRowInsert] parameters determine whether the High-speed Apply Engine inserts 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). Additional parameters enable you to control the number of rows in each insert action and to set the level of insert conflicts that High-speed Apply Engine tolerates before it switches to single row insert actions.
Parameter | Reference |
---|---|
MaxConflicts | |
MaxRows | |
MultiRowInsert |
The following figure shows an example of the [MultiRowInsert] section:
[MultiRowInsert]
MultiRowInsert=Yes
MaxRows=500
MaxConflicts=5
MultiRowInsert=Yes
MaxRows=500
MaxConflicts=5
The [MultiRowInsert] parameters are optional. If you do not specify any of the parameters, High-speed Apply Engine does not perform multiple row insert actions.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*