Rebind Application Plan panel

Panel and field definitions

Figure 1. Rebind Application Plan panel (1 of 2)
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)              Rebind Application Plan

 Verify rebind parameters:

 REBIND PLAN(
    Plan name . . . . .  FMN2PLN1                
 ) OWNER(
    Plan owner  . . . .  SHRIKES           +
 ) QUALIFIER(
    Qualifier . . . . .  SHRIKES           + (qualifier for unqualified SQL)
 ) ENABLE(                        (use ? to get current values from the catalog)
    Enable connects . .                                                       
 ) DISABLE(                       (use ? to get current values from the catalog)
    Disable connects  .                                                       
 )                                (use ? to get current values from the catalog)
    En/disable names  .                                                       
 ) PKLIST(                        (use ? to get current values from the catalog)
    Package lists . . .                                                         +
 ) NOPKLIST(                      (use ? to get current values from the catalog)
    No package list . .           (Yes or No to remove current package list)
 ) DEFER(PREPARE)/NODEFER(PREPARE)
    Defer prepare . . .           (Yes or No)
 ) CACHE(
    Cache size  . . . .  3072     (Cache size in bytes for authorization IDs)
 ) CURRENTDATA(
    Inhibit blocking  .           (Yes or No)
 ) CURRENT SERVER(
    Server name . . . .                     (blank=local, else first location)
   DEGREE(
    Parallelism . . . .  1        (1 or ANY)
 ) DISCONNECT(
    Disconnect  . . . .  E        (Explicit, Automatic or Conditional)
 ) DYNAMICRULES(
    Dynamic rules . . .           (Run or Bind)
 ) ENCODING(
    Encoding scheme . .           (ASCII, EBCDIC, UNICODE, ccsid)
 ) EXPLAIN(
    Explain plan  . . .  N        (Yes or No to explain access path)
Figure 2. Rebind Application Plan panel (2 of 2)
 ) FLAG(
    Bind messages . . .           (Info, Warning, Error, Completion)
 ) IMMEDWRITE(
    Group BP updates  .  N        (No or Yes)
 ) ISOLATION(
    Isolation level . .           (CS, RR, RS, or UR)
 ) KEEPDYNAMIC(
    Keep dynamic SQL  .  N        (Yes or No)
 ) REOPT(VARS)/NOREOPT(VARS)
    Re-opt at exec  . .  N        (None, Always, Once, aUto)
 ) OPTHINT(
    Access path hint  .                                                        +
 ) PATH(
    UDT/UDF/STP path  .                                                         +
 ) PATHDEFAULT
    Default path  . . .           (Yes or No)
 ) RELEASE(
    Release at  . . . .  C        (Commit or Deallocate, Commit preferred)
 ) ROUNDING(                     (Ceiling, Down, Floor,
    DFP Rounding  . . .             HalfDown, HalfEven, HalfUp, Up)
 ) SQLRULES(
    Connect2 rules  . .  D        (Db2 or STD)
 ) VALIDATE(
    Validation time . .  B        (Run or Bind, Bind preferred)
 ) CONCURRENTACCESSRESOLUTION(
    Access Resolution .           (Waitforoutcome or Usecurrentlycommitted)
 ) PROGAUTH(
    Progauth checking .           (Disable or Enable)
 )
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=Expand    F7=Backward  F8=Forward
  F9=Swap     F10=Left     F11=Right    F12=Cancel

Parent panels

Child panels

None.

Related tasks