FREE PLAN subcommand (DSN)

The DSN subcommand FREE PLAN deletes application plans from Db2.

The FREE PLAN subcommand deletes corresponding table entries from the SYSIBM.SYSPLAN catalog tables. All authorization against an application plan name is dropped. The application plan name is then available for use in a BIND PLAN subcommand to create a new package.

The FREE PLAN subcommand does not proceed until all currently executing applications using that plan finish executing.

Environment

You can enter this subcommand from DB2I, or from a DSN session under TSO that is running in either foreground or background.

Data sharing scope: Group

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:
  • Ownership of the plan
  • BIND privilege on the plan
  • BINDAGENT privilege granted by the plan owner
  • System DBADM authority
  • SYSCTRL authority
  • SYSADM authority

Syntax

Read syntax diagramSkip visual syntax diagramFREE PLAN(,plan-name*)FLAG(IWEC)

Option descriptions

( plan-name , …)
Lists the names of one or more plans you want to free.
( * )
Frees all application plans over which you have BIND authority. Be careful when using this form of the command.
FLAG
Indicates what messages you want the system to display. Use one of the values listed to show messages of the corresponding types.
( I )
All: informational, warning, error, and completion messages.
(W)
Only warning, error, and completion messages.
(E)
Only error and completion messages.
(C)
Only completion messages.

Usage notes

Freeing multiple plans

If you free multiple plans with this subcommand, each successful free is committed before freeing the next plan.

If an error occurs on a certain plan specified explicitly in a list or implicitly with (*), FREE PLAN terminates for that plan and continues with the next plan to be processed.

Trace information for data sharing members
When this command with group scope is issued in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.

Example

Free plan DSN8BC81 from Db2. Generate only warning, error, and completion messages (not informational messages). 
FREE PLAN (DSN8BC81) FLAG (W)