Bind Processing window

Use the Bind Processing window to view statistics on plans successfully bound, attempts to REBIND a plan, automatic binds, and attempts to FREE a plan.

To display this window, select Bind Processing from the DB2® Statistics Detail panel.

Figure 1. Bind Processing window

 DGOMSWBI             Bind Processing

                                    INTERVAL 9:21.950
                                                More:   - +
 Bind
   Plans bound . . . . . . . . . . . . . . . . . . :      6
   Plan ADD subcommands  . . . . . . . . . . . . . :      0
   Plan REPLACE subcommand . . . . . . . . . . . . :      6
   Test binds no plan ID . . . . . . . . . . . . . :      0
   Packages bound  . . . . . . . . . . . . . . . . :      4
   Package ADD subcommands . . . . . . . . . . . . :      0
   Package REPLACE subcommands . . . . . . . . . . :      4

 Rebind
   Plan subcommands  . . . . . . . . . . . . . . . :      0
   Plan attempts . . . . . . . . . . . . . . . . . :      0
   Plan successful . . . . . . . . . . . . . . . . :      0
   Package subcommands . . . . . . . . . . . . . . :      0
   Package attempts  . . . . . . . . . . . . . . . :      0
   Package successful  . . . . . . . . . . . . . . :      0

 Autobind
   Plan attempts   . . . . . . . . . . . . . . . . :      6
   Plan successful . . . . . . . . . . . . . . . . :      2
   Invalid resource ID . . . . . . . . . . . . . . :      4
   Package attempts  . . . . . . . . . . . . . . . :      0
   Package successful  . . . . . . . . . . . . . . :      0

 Free
   Plan subcommands  . . . . . . . . . . . . . . . :      0
   Plan attempts . . . . . . . . . . . . . . . . . :      0
   Plan successful . . . . . . . . . . . . . . . . :      0
   Package subcommands . . . . . . . . . . . . . . :      0
   Package attempts  . . . . . . . . . . . . . . . :      0
   Package successful  . . . . . . . . . . . . . . :      0

 Command ===> _____________________________________________
  F1=Help     F2=Split    F3=Exit     F5=Auto    F6=History
  F7=Up       F8=Down     F9=Swap    F10=Delta  F11=Interval
 F12=Cancel  F16=Look    F17=Collect

The Bind Processing window consists of the following sections:

Bind: This section shows statistics on bind events. These events occur when an explicit Db2 BIND subcommand is issued to bind a plan or package.
Rebind: This section shows statistics on rebind events. These events occur when an explicit Db2 REBIND subcommand is issued to rebind an existing plan or package.
Autobind: This section shows statistics on autobind events. These events occur if the plan becomes invalid since the last time the plan was bound. In this case, Db2 rebinds the plan before the plan is executed.
Free: This section shows statistics on free events. These events occur when an explicit Db2 FREE subcommand is issued to remove a Db2 plan or package from the Db2 catalog and directory.