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 Application Plans panel Child panels None. Related tasks