Defaults for Bind Plan and Defaults for Rebind Plan panels
These DB2I panels let you change your defaults for BIND PLAN and REBIND PLAN options.
On the following panel, enter new defaults for binding a plan.
DSNEBP10 DEFAULTS FOR BIND PLAN SSID: DSN
COMMAND ===>
Change default options as necessary:
1 ISOLATION LEVEL ......... ===> RR (RR, RS, CS, or UR)
2 VALIDATION TIME ......... ===> RUN (RUN or BIND)
3 RESOURCE RELEASE TIME ... ===> COMMIT (COMMIT, DEALLOCATE, or
INHERITFROMPLAN)
4 EXPLAIN PATH SELECTION .. ===> NO (NO or YES)
5 DATA CURRENCY ........... ===> NO (NO or YES)
6 PARALLEL DEGREE ......... ===> 1 (1 or ANY)
7 RESOURCE ACQUISITION TIME ===> USE (USE or ALLOCATE)
8 REOPTIMIZE FOR INPUT VARS ===> NONE (ALWAYS, NONE, ONCE, AUTO)
9 DEFER PREPARE ........... ===> NO (NO, YES, INHERITFROMPLAN)
10 KEEP DYNAMIC SQL
PAST COMMIT OR ROLLBACK.. ===> NO (NO or YES)
11 APPLICATION ENCODING ... ===> (Blank,ASCII,EBCDIC,UNICODE,
or ccsid)
12 OPTIMIZATION HINT ...... ===> > (Blank or 'hint-id')
13 IMMEDIATE WRITE ......... ===> NO (NO, YES, INHERITFROMPLAN)
14 DYNAMIC RULES ........... ===> RUN (RUN or BIND)
15 SQLRULES................. ===> DB2 (DB2 or STD)
16 DISCONNECT .............. ===> EXPLICIT (EXPLICIT, AUTOMATIC,
or CONDITIONAL)
17 PROGRAM AUTHORIZATION ... ===> DISABLE (DISABLE, ENABLE)
On the following panel, enter new defaults for rebinding a plan.
DSNEBP11 DEFAULTS FOR REBIND PLAN SSID: DSN
COMMAND ===>
Change default options as necessary:
1 ISOLATION LEVEL ......... ===> SAME (SAME, RR, RS, CS, or UR)
2 PLAN VALIDATION TIME .... ===> SAME (SAME, RUN, or BIND)
3 RESOURCE RELEASE TIME ... ===> SAME (SAME, DEALLOCATE, COMMIT,
or INHERITFROMPLAN)
4 EXPLAIN PATH SELECTION .. ===> SAME (SAME, NO, or YES)
5 DATA CURRENCY ........... ===> SAME (SAME, NO, or YES)
6 PARALLEL DEGREE ......... ===> SAME (SAME, 1 or ANY)
7 REOPTIMIZE FOR INPUT VARS ===> SAME (SAME, ALWAYS, NONE, ONCE, AUTO)
8 DEFER PREPARE ........... ===> SAME (SAME, NO, YES,
or INHERITFROMPLAN)
9 KEEP DYNAMIC SQL
PAST COMMIT OR ROLLBACK.. ===> SAME (SAME, NO, or YES)
10 APPLICATION ENCODING ... ===> SAME (SAME,Blank,ASCII,EBCDIC,
UNICODE, or ccsid)
11 OPTIMIZATION HINT ...... ===> > (SAME, 'hint-id')
12 IMMEDIATE WRITE ........ ===> SAME (SAME, NO, YES,
or INHERITFROMPLAN)
13 SQLRULES ............... ===> SAME (SAME, DB2 or STD)
14 DYNAMIC RULES ........... ===> SAME (SAME, RUN, or BIND)
15 RESOURCE ACQUISITION TIME ===> SAME (SAME, ALLOCATE, or USE)
16 DISCONNECT .............. ===> SAME (SAME, EXPLICIT, AUTOMATIC,
or CONDITIONAL)
17 PROGRAM AUTHORIZATION ... ===> SAME (SAME, DISABLE, ENABLE)The following table lists the fields on the Defaults for Bind Package and Defaults for Rebind Package, and the corresponding bind and rebind options.
| Field name | Bind or rebind option |
|---|---|
| APPLICATION ENCODING | ENCODING |
| DATA CURRENCY | CURRENTDATA |
| DBPROTOCOL | DBPROTOCOL |
| DEFER PREPARE | DEFER and NODEFER |
| DISCONNECT | DISCONNECT |
| DYNAMIC RULES | DYNAMICRULES |
| EXPLAIN PATH SELECTION | EXPLAIN |
| IMMEDIATE WRITE | IMMEDWRITE |
| ISOLATION LEVEL | ISOLATION |
| KEEP DYNAMIC SQL PAST COMMIT OR ROLLBACK | KEEPDYNAMIC |
| OPTIMIZATION HINT | OPTHINT |
| PARALLEL DEGREE | DEGREE |
| PROGRAM AUTHORIZATION | PROGAUTH |
| REOPTIMIZE FOR INPUT VARS | REOPT |
| RESOURCE ACQUISITION TIME | ACQUIRE |
| RESOURCE RELEASE TIME | RELEASE |
| VALIDATION TIME and PLAN VALIDATION TIME | VALIDATE |