Bind/Rebind/Free Selection panel

The Bind/Rebind/Free selection panel lets choose whether to bind, rebind, or free plans and packages.

Figure 1. The Bind/Rebind/Free selection panel

DSNEBP01                  BIND/REBIND/FREE                    SSID: DSN
 COMMAND ===>_
 
 Select one of the following and press ENTER:
 
  1  BIND PLAN               (Add or replace an application plan)
 
  2  REBIND PLAN             (Rebind existing application plan or plans)
 
  3  FREE PLAN               (Erase application plan or plans)
 
  4  BIND PACKAGE            (Add or replace a package)
 
  5  REBIND PACKAGE          (Rebind existing package or packages)
 
  6  REBIND TRIGGER PACKAGE  (Rebind existing package or packages)
 
  7  FREE PACKAGE    (Erase a package or packages)

This panel lets you select the process you need.

1 BIND PLAN: Lets you build an application plan. You must have an application plan to allocate Db2 resources and support SQL requests during run time. If you select this option, the Bind Plan panel displays. For more information, see Bind Plan panel.
2 REBIND PLAN: Lets you rebuild an application plan when changes to it affect the plan but the SQL statements in the program are the same. For example, you should rebind when you change authorizations, create a new index that the plan uses, or use RUNSTATS. If you select this option, the Rebind Plan panel displays. For more information, see Rebind Plan panel.
3 FREE PLAN: Lets you delete plans from Db2. If you select this option, the Free Plan panel displays. For more information, see Free Plan panel.
4 BIND PACKAGE: Lets you build a package. If you select this option, the Bind Package panel displays. For more information, see Bind Package panel.
5 REBIND PACKAGE: Lets you rebuild a package when changes to it affect the package but the SQL statements in the program are the same. For example, you should rebind when you change authorizations, create a new index that the package uses, or use RUNSTATS. If you select this option, the Rebind Package panel displays. For more information, see Rebind Package panel.
6 REBIND TRIGGER PACKAGE: Lets you rebuild a trigger package when you need to change options for the package. When you execute CREATE TRIGGER, Db2 binds a trigger package using a set of default options. You can use REBIND TRIGGER PACKAGE to change those options. For example, you can use REBIND TRIGGER PACKAGE to change the isolation level for the trigger package. If you select this option, the Rebind Trigger Package panel displays. For more information, see Rebind Trigger Package panel.
7 FREE PACKAGE: Lets you delete a specific version of a package, all versions of a package, or whole collections of packages from Db2. If you select this option, the Free Package panel displays. For more information, see Free Package panel.