Time

The Time parameter specifies the number of seconds that can pass before an apply agent issues a COMMIT statement during apply processing.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[CommitTriggers]

Abbreviation

None

Required?

No

Valid values

An integer from 1 to 32400

Default value

None

Related topics

BindTuning-parameters

CommitTriggers-parameters

CheckpointFrequency

Usage

Specify a value for the Time parameter to indicate the number of seconds between COMMIT statements during apply processing. Each time that an agent reaches or exceeds the value of the Time parameter, the agent issues a COMMIT statement.

Be aware of the following points about the Time parameter:

  • The value of the Time parameter applies to each agent.
  • If you specify both the StatementCount and Time parameters, the High-speed Apply Engine issues a COMMIT statement when either parameter reaches its specified limit. Both counters are reset after a commit or rollback occurs. At the end of a request, High-speed Apply Engine issues a final COMMIT statement as part of termination processing.
  • High-speed Apply Engine ignores this parameter when it distributes work between multiple agents based on units of recovery (when the DistributionType parameter is UR).
  • The value of this parameter affects checkpoint and restart processing. For more information, see Usage.

Important

Some conflict actions might cause a commit to occur, overriding the Time value (see Usage).


 

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