绑定计划默认值和重新绑定计划默认值面板

这些 DB2I 面板可让您更改绑定计划（BIND PLAN）和重新绑定计划（REBIND PLAN）选项的默认设置。

在下面的面板中，输入新的默认值，用于绑定计划。

图 1。 “绑定计划”面板的默认设置
更改开始
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)
更改结束

在下面的面板中，输入重新绑定计划的新默认值。

图 2。 重新绑定计划面板的默认设置
更改开始
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)
更改结束

下表列出了绑定包默认值和重新绑定包默认值中的字段，以及相应的绑定和重新绑定选项。

表 1. 绑定计划默认值和重新绑定计划默认值面板字段以及相应的绑定或重新绑定选项
字段名称 装订或重新装订选项
应用程序编码 编码
数据 货币 CURRENTDATA
数据库协议 数据库协议
推迟 准备 DEFER和NODEFER
DISCONNECT Disconnect
动态规则 动态规则
解释路径选择 EXPLAIN
立即写 即时写入
ISOLATION LEVEL 隔离
更改开始保持动态 SQL 过去提交或回滚更改结束 keepDynamic
优化提示 OPTHINT
并行度 DEGREE
程序授权 PROGAUTH
重新优化输入变量 REOPT
资源获取时间 ACQUIRE
资源发布时间 释放
验证时间和计划 验证时间 Validate