CommitValue
The CommitValue parameter specifies a numeric value that determines how often the High-speed Apply Engine displays progress messages for committed SQL statements. The units for this parameter are based on the value that you specify for the CommitTrigger parameter.
Attributes
This parameter has the following attributes:
Attribute | Value |
---|---|
Section | [MonitorTuning] |
Abbreviation | None |
DBMS | Db2, Db2 LUW, Oracle |
Required? | No |
Valid values | An integer from 1 to 32767 that represents one of the following:
depending on the value specified for the CommitTrigger parameter |
Default value | 5000 |
Usage
Use this parameter along with the CommitTrigger parameter to define how often High-speed Apply Engine displays progress messages for committed SQL statements.
Specify a numeric value for the number of seconds or the number of committed SQL statements.
If the value of the CommitTrigger parameter is Time or Count, you must specify this parameter. For more information about the CommitTrigger parameter, see CommitTrigger.
Related topic