PackageUsage

The PackageUsage parameter specifies the total number of times that the High-speed Apply Engine can execute any of the distinct statement types in an unbound package before it performs a bind action.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[BindTuning]

Abbreviation

None

Required?

No

Valid values

An integer from 1 to 32767

Default value

500

Related topic

BindTuning-parameters


Usage

Specify a value to represent a number of dynamic execution attempts. (High-speed Apply Engine executes statement types in an unbound package dynamically.)

Specify a lower value to direct High-speed Apply Engine to perform more bind actions more frequently, with fewer distinct statement types in each bound package. For example, if your input includes many repeated statements of the same statement type, specify a lower value to make High-speed Apply Engine bind that statement type and execute it with static SQL sooner.

The PackageUsage parameter works in conjunction with the StatementCount and StatementUsage parameters to determine when to bind a package. You can adjust the value to expedite or delay binding of a package. For more information about using these parameters, see Using-BindTuning-parameters-for-performance.


 

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