BindAction

Attributes

This parameter has the following attributes:

Usage

Specify one of the following values:

• If you specify Replace, High-speed Apply Engine sets the value of the ACTION parameter to REPLACE. (The new plan replaces any existing plan with the same plan name. If no plan with the same name currently exists in the Db2 catalog, the bind action creates a new plan and corresponding entries in the Db2 catalog.)
• If you specify Add, High-speed Apply Engine sets the value of the ACTION parameter to ADD. (The new plan does not replace an existing plan with the same plan name. If a plan with the same name exists, the bind action terminates with an error message. If no plan with the same name currently exists, the bind action creates a new plan.)

• If you specify Use with a pre-bound plan (PlanName) and package (PackageName), High-speed Apply Engine runs without any binds, and all statements are dynamically executed.

  To use the pre-bound plan and package, you must set the following configuration parameters as shown:

  [Bind]
  PlanName=MyPlan
  PackageName=MyPackage
  BindAction=Use

  • You must set PlanName to the pre-bound plan name. You can find the plan name in the bind output displayed by High-speed Apply Engine from the bind job in message BMCAPT0032I.
  • You must set PackageName to the pre-bound base application package name. You can find the package name in the bind output displayed by High-speed Apply Engine from the bind job in message BMCAPT0032I.
  • You must set BindAction to Use, which indicates that the application plan and package has been bound and should be used to apply the statements. If BindAction=Use is not set, a bind is attempted.

  For more information, see Using-BindOwner-and-a-pre-bound-plan.

• If you specify Use, High-speed Apply Engine avoids binding a plan and uses the existing plan specified by the PlanName parameter to bind only the packages required for the apply request. To use this value, the configuration must meet the following requirements:

  • You must specify a value for the CollectionID parameter (CollectionID)
  • You should specify a value for the BindOwner parameter (BindOwner)
  • You must specify a value for the PlanName parameter (PlanName)
  • The plan specified by the PlanName parameter must have been previously bound using special bind options by a user ID with sufficient Db2 authorizations

  To bind a plan for use with this value, use a Db2 BIND command similar to the following:

  BIND PLAN(planName) -
       OWNER(planOwner) -
       KEEPDYNAMIC(YES) -
       PKLIST(BMCAPT.APTREB2,collectionID.*) -
       RELEASE(COMMIT) -
       ACTION(REPLACE) RETAIN -
       ISOLATION(CS) -
     VALIDATE(RUN)

  This example uses the following variables:

  • planName is the name that will be specified in the PlanName parameter (for more information, see PlanName)
  • planOwner is the authorization ID that will be specified in the BindOwner parameter
  • collectionID is the identifier that will be specified in the CollectionID parameter

  When you specify a value of Use for BindAction, High-speed Apply Engine retains the plan after use, regardless of the value of the FreeOption parameter (for more information, see FreeOption).