Defaults for Bind Package and Defaults for Rebind Package panels

These DB2I panels lets you change your defaults for BIND PACKAGE and REBIND PACKAGE options.

On the following panel, enter new defaults for binding a package.

Figure 1. The Defaults for Bind Package panel
Start of change
DSNEBP10                DEFAULTS FOR BIND PACKAGE             SSID: DSN
    COMMAND ===> _
    ----------------- Use the UP/DOWN keys to access all options ------------------
                                                                      More:     + 
   Change default options as necessary:
   
    1  ISOLATION LEVEL ......... ===>            (CS, RR, RS, UR, or NC)
    2  VALIDATION TIME ......... ===>            (RUN or BIND)
    3  RESOURCE RELEASE TIME ... ===>            (COMMIT, DEALLOCATE, or 
                                                    INHERITFROMPLAN)
    4  EXPLAIN PATH SELECTION .. ===>            (NO or YES)
    5  DATA CURRENCY ........... ===>            (NO or YES)
    6  PARALLEL DEGREE ......... ===>            (1 or ANY)
    7  SQLERROR PROCESSING ..... ===>            (NOPACKAGE or CONTINUE)
    8  REOPTIMIZE FOR INPUT VARS ===>            (ALWAYS, NONE, ONCE, or AUTO)
    9  DEFER PREPARE ........... ===>            (NO, YES, or INHERITFROMPLAN)
   10  KEEP DYNAMIC SQL              
       PAST COMMIT or ROLLBACK   ===>            (NO or YES)
   11  APPLICATION ENCODING ...  ===>            (Blank, ASCII, EBCDIC,
                                                   UNICODE, or ccsid)
   12  OPTIMIZATION HINT ......  ===>          > (Blank or 'hint-id')
   13  IMMEDIATE WRITE ......... ===>            (YES, NO, or INHERITFROMPLAN)
   14  DYNAMIC RULES ........... ===>            (RUN, BIND, DEFINE, or INVOKE)
   15  DBPROTOCOL .............. ===>            (blank, DRDA, or DRDACBF)
   16  ACCESS PATH REUSE ....... ===> NONE       (ERROR, NONE, or WARN)
   17  ACCESS PATH COMPARISON .. ===> NONE       (ERROR, NONE, or WARN)
   18  SYSTEM_TIME SENSITIVE ... ===>            (blank, NO, or YES)
   19  BUSINESS_TIME SENSITIVE . ===>            (blank, NO, or YES)
   20  ARCHIVE SENSITIVE ....... ===>            (blank, NO, or YES)
   21  APPLICATION COMPATIBILITY ===>            (blank, DB2 function level,
                                                  V10R1, or V11R1)
   22  PACKAGE DEPENDENCY LEVEL  ===>            (blank, PACKAGE, or STATEMENT)
  -------------------------------------------------------------------------------
   PRESS:  ENTER to continue   UP/DOWN to scroll   RETURN to EXIT
End of change

On the following panel, enter new defaults for rebinding a package.

With a few minor exceptions, the options on this panel are the same as the options for the defaults for rebinding a package. However, the defaults for REBIND PACKAGE are different from those shown in the preceding figure, and you can specify SAME in any field to specify the values used the last time the package was bound. For rebinding, the default value for all fields is SAME.

Figure 2. The Defaults for Rebind Package panel
Start of change
DSNEBP11                DEFAULTS FOR REBIND PACKAGE           SSID: DSN
    COMMAND ===> _
    ----------------- Use the UP/DOWN keys to access all options ------------------
                                                                      More:     + 
   Change default options as necessary:
   
    1  ISOLATION LEVEL ......... ===>            (SAME, CS, RR, RS, UR, or NC)
    2  PLAN VALIDATION TIME .... ===>            (SAME, RUN, or BIND)
    3  RESOURCE RELEASE TIME ... ===>            (SAME, DEALLOCATE, COMMIT,
                                                   or INHERITFROMPLAN)
    4  EXPLAIN PATH SELECTION .. ===>            (SAME, NO, or YES)
    5  DATA CURRENCY ........... ===>            (SAME, NO, or YES)
    6  PARALLEL DEGREE ......... ===>            (SAME, 1 or ANY)
    7  REOPTIMIZE FOR INPUT VARS ===>            (SAME, ALWAYS, NONE, ONCE, AUTO)
    8  DEFER PREPARE ........... ===>            (SAME, NO, YES,
                                                   or INHERITFROMPLAN)
    9  KEEP DYNAMIC SQL 
       PAST COMMIT OR ROLLBACK.  ===>            (SAME, NO, or YES)
   10  APPLICATION ENCODING ...  ===>            (SAME, Blank, ASCII, EBCDIC,
                                                   UNICODE, or ccsid)
   11  OPTIMIZATION HINT ......  ===>          > (Blank or 'hint-id')
   12  IMMEDIATE WRITE ......... ===>            (SAME, NO, YES,
                                                   or INHERITFROMPLAN)
   13  DBPROTOCOL .............. ===>            (blank, DRDA, or DRDACBF)
   14  DYNAMIC RULES ........... ===>            (SAME, RUN, BIND, 
                                                   DEFINERUN, DEFINEBIND,
                                                   INVOKERUN or INVOKEBIND)
   15  PLAN MANAGEMENT ......... ===>            (DEFAULT, BASIC, EXTENDED, OFF)
   16  ACCESS PATH REUSE ....... ===>            (DEFAULT, ERROR, NONE, or WARN)
   17  ACCESS PATH COMPARISON .. ===>            (DEFAULT, ERROR, NONE, or WARN)
   18  ACCESS PATH RETAIN DUPS . ===>            (DEFAULT, NO, OR YES)
   19  SYSTEM_TIME SENSITIVE ... ===>            (SAME, NO, or YES)
   20  BUSINESS_TIME SENSITIVE . ===>            (SAME, NO, or YES)
   21  ARCHIVE SENSITIVE ....... ===>            (SAME, NO, or YES)
   22  APPLICATION COMPATIBILITY ===>            (SAME, DB2 funtion level,
                                                  V10R1, or V11R1)
   23  PACKAGE DEPENDENCY LEVEL  ===>            (SAME, PACKAGE, or STATEMENT)
  -------------------------------------------------------------------------------
   PRESS:  ENTER to continue   UP/DOWN to scroll   RETURN to EXIT
End of change

The following table lists the fields on the Defaults for Bind Package and Defaults for Rebind Package panels, and the corresponding bind and rebind options.

Table 1. Defaults for Bind Package and Defaults for Rebind Package panel fields and corresponding bind or rebind options
Field name Bind or rebind option
ACCESS PATH COMPARISON APCOMPARE
ACCESS PATH RETAIN DUPS APRETAINDUP
ACCESS PATH REUSE APREUSE
APPLICATION COMPATIBILITY APPLCOMPAT
APPLICATION ENCODING ENCODING
ARCHIVE SENSITIVE ARCHIVESENSITIVE
BUSINESS_TIME SENSITIVE BUSTINESENSITIVE
DATA CURRENCY CURRENTDATA
DBPROTOCOL DBPROTOCOL
DEFER PREPARE DEFER and NODEFER
DYNAMIC RULES DYNAMICRULES
EXPLAIN PATH SELECTION EXPLAIN
IMMEDIATE WRITE IMMEDWRITE
ISOLATION LEVEL ISOLATION
KEEP DYNAMIC SQL PAST COMMIT OR ROLLBACK KEEPDYNAMIC
OPTIMIZATION HINT OPTHINT
Start of changePACKAGE DEPENDENCY LEVELEnd of change Start of changeDEPLEVEL bind optionEnd of change
PARALLEL DEGREE DEGREE
PLAN MANAGEMENT PLANMGMT
REOPTIMIZE FOR INPUT VARS REOPT
RESOURCE RELEASE TIME RELEASE
SQLERROR PROCESSING SQLERROR
SYSTEM_TIME SENSITIVE SYSTIMESENSITIVE
VALIDATION TIME and PLAN VALIDATION TIME VALIDATE