Rebind Package panel

Panel and field definitions

Figure 1. Rebind Package panel (1 of 2)
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFM3)                   Rebind Package
                                                                    More:     +

 Verify rebind parameters:
 REBIND PACKAGE(
    Location  . . . . .                 
    Collection  . . . . DSNUTIL                                                +
    Package . . . . . . DSNUGSQL          +    (
    Version . . . . . .                                                        +
 )) OWNER(
    Package Owner . . . ARROWSB           +
 ) QUALIFIER(
    Qualifier . . . . . ARROWSB           +
 ) 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  .                                                        +
   PLANMGMT(
    Plan management . .           (Off, Basic, Extended or blank)
 ) APREUSE(
    Reuse access paths  N         (None, Error or Warn)
 ) APREUSESOURCE(                                                               
    Package copy  . . .           (Current, Previous or Original)               
 ) APCOMPARE(
    Comp access paths .           (None, Error or Warn)
 ) APRETAINDUP(
    Retain old copies . Y         (Yes or No)
 ) GETACCELARCHIVE(
    Archived Accel data           (No or Yes)
 ) QUERYACCELERATION(             (None, All, Enable,
    Acceleration option             enableWithfailback, eliGible)
 ) CONCENTRATESTMT(
    Concentrate stmt. . N         (No or Yes)
 ) CURRENTDATA(
    Inhibit blocking  . N         (Yes or No)
 ) DBPROTOCOL(
    3 part protocol . . D         (DRDA)
 ) DEFER(PREPARE) / DEFER(INHERITFROMPLAN) / NODEFER(PREPARE)
    Defer prepare . . .           (Yes, Inherit or No)
   DEGREE(
    Parallelism . . . . 1         (1 or ANY)
 ) DESCSTAT(
    Describe SQL area . Y         (No or Yes)
 ) DYNAMICRULES(
    Dynamic rules . . .           (Run, Bind, Define, Invoke)
 ) ENCODING(
    Encoding scheme . . EBCDIC    (ASCII, EBCDIC, UNICODE, ccsid)
Figure 2. Rebind Package panel (2 of 2)
 ) EXPLAIN(
    Explain plan  . . .  N        (Yes, No or Only)
 ) FLAG(
    Bind messages . . .           (Info, Warning, Error, Completion)
 ) IMMEDWRITE(
    Group BP updates  .  N        (Inheritfromplan, No or Yes)
 ) ISOLATION(
    Isolation level . .           (CS, RR, RS, or UR)
 ) KEEPDYNAMIC(
    Keep dynamic SQL  .  N        (No or Yes)
 ) 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, Deallocate, Inheritfromplan)
 ) SWITCH(
    Package version      N        (Previous, Original)
 ) VALIDATE(
    Validation time . .  B        (Run or Bind, Bind preferred)
 ) EXTENDEDINDICATOR(
    Extended Indicators           (No or Yes)
 ) CONCURRENTACCESSRESOLUTION(
    Access Resolution .           (Waitforoutcome or Usecurrentlycommitted)
 ) BUSTIMESENSITIVE(
    Business Time Sens.  Y        (Yes or No)
 ) SYSTIMESENSITIVE(
    System Time Sens. .  Y        (Yes or No)
 ) ARCHIVESENSITIVE(
    Archive Sensitivity  Y        (Yes or No)
 ) APPLCOMPAT(
    Appl. Compatibility  V12R1    (V10R1 or V11R1)
 )
 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