CommitTrigger
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [MonitorTuning] |
Abbreviation | None |
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.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*