Synchronous

The Synchronous parameter specifies whether the High-speed Apply Engine can perform other processing (such as dynamic SQL) at the same time as it binds static SQL.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[BindTuning]

Abbreviation

None

Required?

No

Valid values

Yes or No

Default value

Yes

Related topic

BindTuning-parameters

Usage

Use this parameter to adapt bind processing to your environment.

  • Specify a value of No to allow High-speed Apply Engine to perform other processing during bind actions. This setting can slightly improve performance because it increases parallelism. It also increases the amount of dynamic SQL processing. However, this setting can slightly increase the possibility of authorization conflicts during bind actions.
  • Specify a value of Yes (the default value) to prevent High-speed Apply Engine from performing other processing. This setting reduces the amount of dynamic SQL processing.

Be aware of the following points about the Synchronous parameter:

  • To force High-speed Apply Engine to use static SQL for all input statements, set this parameter to Yes and set the StatementCount parameter to 1. If you use this technique, ensure that the MaxPackages value is high enough to accommodate the total number of distinct statement types in your input file.
  • If you specify a value for the AuthID parameter, High-speed Apply Engine forces the value of the Synchronous parameter to Yes and issues message BMC0198.


 

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