SimpleTSClustering

The SimpleTSClustering parameter indicates whether the High-speed Apply Engine uses the same apply agent to process updates to all tables in a simple table space.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[DistributionTuning]

Abbreviation

None

Required?

No

Valid values

Yes or No

Default value

Yes

Related topics

DistributionTuning-parameters

Distribution-of-work

Usage

Select one of the following values:

  • Specify Yes to direct High-speed Apply Engine to cluster the tables of a simple table space together and send all statements for the tables to the same apply agent.
  • Specify No to direct High-speed Apply Engine to distribute the statements by a table. The consequence of specifying No is a greater risk of deadlocks between the agents.

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).

 

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