FreeOption

The FreeOption parameter specifies whether to free the Db2 or packages after the apply request has been completed.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[Bind]

Abbreviation

None

Required?

No

Valid values

Plan, Packages, None, or All

Default value

All

Related topic

Bind-parameters

Usage

Set the FreeOption parameter as follows:

  • Specify Plan to free the plan.
  • Specify Packages to free the packages.
  • Specify None to retain the plan and packages.
  • Specify All to free both the plan and the packages. All is the default value.

If the value of BindAction is Use, High-speed Apply Engine retains the plan after use, regardless of the value of FreeOption (for more information, see BindAction).

If you configure High-speed Apply Engine to use a pre-bound plan and package (you set PlanName, PackageName, and BindAction=Use), High-speed Apply Engine retains the plan and package regardless of the value of FreeOption. For more information, see BindAction.

 

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