Free Plan panel
The DB2I Free Plan panel is the first of two panels through which you can specify options for freeing an application plan.
Figure 1 shows the free plan options.
DSNEBP09 FREE PLAN SSID: DSN
COMMAND ===>_
Enter plan name(s) to be freed:
1 PLAN NAME ............ ===> (* to free all authorized plans)
2 ADDITIONAL PLANS? .... ===> (Yes to include more plans)This panel lets you specify options for freeing plans.
- 1 PLAN NAME
- Lets you name the application plan to delete from Db2. Use an asterisk to free all plans for which
you have BIND authority. You can specify a name of 1–8 characters,
and the first character must be alphabetic.
If there are errors, the free process terminates for that plan and continues with the next plan.
- 2 ADDITIONAL PLANS?
- Lets you indicate whether to name more plans to free. Use YES to specify more plans on an additional panel, described in Panels for entering lists of values. The default is NO.