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.

Related topic

MonitorTuning-parameters

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[MonitorTuning]

Abbreviation

None

Required?

No

Valid values

An integer from 1 to 32767 represents one of the following:

  • A number of seconds
  • A number of committed SQL statements

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*