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