Default distribution of work


If you do not change any default values, the High-speed Apply Engine distributes work between multiple agents according to the following criteria:

  • By default, High-speed Apply Engine always uses distribution by the object. You must explicitly request distribution by UR. For more information, see DistributionType.
  • For tables that are part of RI relationships, High-speed Apply Engine uses the same agent to process updates to both parent and child tables (subject to parameters that you can adjust). For more information, see RIRecursionLimit.
  • For partitioned tables, High-speed Apply Engine distributes work by partition.
  • For tables that reside in a simple (nonsegmented) table space, High-speed Apply Engine uses the same agent to process all updates to all tables in the table space.
  • For tables that reside in segmented table spaces and are not subject to RI, High-speed Apply Engine distributes work by the table. High-speed Apply Engine uses the same agent for all updates to each table.


 

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