MaxRows
For Db2, the MaxRows parameter enables you to control how many rows High-speed Apply Engine includes in each multiple row insert action of an apply request. Use this parameter to balance the improved performance of multiple row insert actions against the increased overhead that can occur when High-speed Apply Engine must process conflicts and possibly retry the insertion of large numbers of rows.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [MultiRowInsert] |
Abbreviation | None |
DBMS | Db2 |
Required? | No |
Valid values | An integer value between 1 and 32,767 |
Default value | 100 |
Usage
Specify any integer value greater between 1 and 32,767. The default value is 100 rows in each multiple row insert action.
Be aware of the following points regarding this parameter:
- 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 this parameter in a test environment before implementing changes in a production environment.
- When the insertion of any row during a multiple row insert action violates a constraint or causes a conflict, High-speed Apply Engine performs the actions defined by the conflict rule in the [InsertConflict] section that specifies a Code value of MultiRowConflict. For more information, see Codes-for-conflict-resolution-SQL-codes.
Related topic