Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see High-speed Apply Engine 13.1.

SimpleTSClustering

For Db2, 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

DBMS

Db2

Required?

No

Valid values

Yes or No

Default value

Yes

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

Related topics

DistributionTuning-parameters

Distribution-of-work



 

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