CommitTrigger
The CommitTrigger parameter indicates the type of units used in the CommitValue parameter. You can specify whether the number defined by the CommitValue parameter represents a number of seconds or a number of SQL statements committed by the High-speed Apply Engine.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [MonitorTuning] |
Abbreviation | None |
DBMS | Db2, Db2 LUW, Oracle |
Required? | No |
Valid values | Time, Count, None |
Default value | Count |
Usage
Use this parameter along with the CommitValue parameter to define how often High-speed Apply Engine displays progress messages for committed SQL statements. You can also use this parameter to prevent High-speed Apply Engine from displaying these messages. Specify one of the following values:
- Time indicates that the number defined by the CommitValue parameter represents a number of seconds.
- Count indicates that the number defined by the CommitValue parameter represents a number of SQL statements committed against the target tables.
- None prevents High-speed Apply Engine from displaying progress messages for committed SQL statements.
If the value of this parameter is Time or Count, you must specify the CommitValue parameter. For information about the CommitValue parameter, see CommitValue.
Related topic