FreeOption
The FreeOption parameter specifies whether to free the Db2 or Db2 LUW plan or packages after the apply request has been completed.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [Bind] |
Abbreviation | None |
DBMS | Db2, Db2 LUW |
Required? | No |
Valid values |
|
Default value | All |
Usage
For Db2, 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.
For Db2 LUW, set the FreeOption parameter as follows:
- Specify Packages or All to free the packages.
- Specify None to retain the packages.
Related topic