PLAN bind options

These plan-name value specifies the plan or plans to bind or rebind.

Command option Option values Used with
PLAN
  • (plan-name )
  • (*) 1
Note:
  1. The PLAN(*) option is valid only for REBIND PLAN.

Descriptions for BIND PLAN

PLAN(plan-name)

Specifies the name of the application plan.

The Db2 catalog record for the plan-name value is the NAME column in SYSPLAN catalog table.

For descriptions of the other options in the syntax diagram, see BIND and REBIND options for packages, plans, and services .

Descriptions for REBIND PLAN

(plan-name)
Specifies the name of the application plan to rebind, as stored in the NAME column in SYSPLAN catalog table.
(*)
Rebinds all plans for which the applicable authorization ID has the BIND privilege. The applicable authorization ID is:
  • The value of OWNER, if you specify it. See OWNER bind option.
  • The authorization ID of the process running the bind, if you specify the OWNER option.
Other options for REBIND PLAN

For descriptions of the options shown in the syntax diagram, see the topic BIND and REBIND options for packages, plans, and services.

Catalog record for PLAN

See the NAME column in SYSPLAN catalog table.