db2set命令小结

db2set是用来设置db2实例的profile registries，总之profile registries要比实例的configuration parameters要大一点，比系统环境变量小一点
1. db2set -lr //列出所有支持的profile registries
2. db2set registry_variable = value //设值
db2set db2comm=TCPIP
3. db2set registry_variable = //恢复成默认值
db2set db2comm=
4. db2set -all //列出当前设置过的

一、SET CONNECTION
唤起休眠的链接
   CONNECT TO IBMSTHDB;
   CONNECT TO IBMTOKDB;
   SET CONNECTION IBMSTHDB;
二、SET CURRENT DEFAULT TRANSFORM GROUP
设置专用寄存器CURRENT DEFAULT TRANSFORM GROUP的值
   SET CURRENT DEFAULT TRANSFORM GROUP = MYSTRUCT1
三、SET CURRENT DEGREE
限制内部分区并行机制
   SET CURRENT DEGREE = '1'
允许内部分区并行
SET CURRENT DEGREE = 'ANY'
四、SET CURRENT EXPLAIN MODE
Syntax
                           
>>-SET CURRENT EXPLAIN MODE -+---+------------------------------>

>--+-NO----------------------+---------------------------------><
   +-YES---------------------+   
   +-EXPLAIN-----------------+   
   +-REOPT-------------------+   
   +-RECOMMEND INDEXES-------+   
   +-EVALUATE INDEXES--------+   
   +-RECOMMEND PARTITIONINGS-+   
   +-EVALUATE PARTITIONINGS--+   
   '-host-variable-----------'  
SET CURRENT EXPLAIN MODE = EXPLAIN
五、SET CURRENT EXPLAIN SNAPSHOT
Syntax
            
>>-SET CURRENT EXPLAIN SNAPSHOT--+---+--+-NO------------+------><
                                        +-YES-----------+   
                                        +-EXPLAIN-------+   
                                        +-REOPT---------+   
                                        '-host-variable-'   

六、SET CURRENT ISOLATION
Syntax
        .-CURRENT-.             .-=-.              
>>-SET--+---------+--ISOLATION--+---+--+-UR----+---------------><
                                       +-CS----+   
                                       +-RR----+   
                                       +-RS----+   
                                       '-RESET-'   
七、SET CURRENT LOCK TIMEOUT
    SET CURRENT LOCK TIMEOUT 30   
SET CURRENT LOCK TIMEOUT NULL
八、Set the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATIO
    SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION SYSTEM = USER
    EXEC SQL VALUES (CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION)
    SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION = NONE
九、Set the CURRENT PACKAGE PATH
SET CURRENT PACKAGE PATH = MYPKGS, 'ABC E', SYSIBM
SET :hvpklist = CURRENT PACKAGE PATH
The value of the host variable is: "MYPKGS", "ABC E", "SYSIBM".
Example 2: Set the CURRENT PACKAGE PATH special register to the following list of schemas: "SCH4","SCH5", where :hvar1 contains 'SCH4,SCH5'.
   SET CURRENT PACKAGE PATH :hvar1
The value of the CURRENT PACKAGE PATH special register after this statement executes is: "SCH4","SCH5".
十、SET CURRENT PACKAGESET
Example
Assume an application called TRYIT is precompiled by user ID PRODUSA, making 'PRODUSA' the default schema name in the bind file. The application is then bound twice with different bind options. The following command line processor commands were used:
   DB2 CONNECT TO SAMPLE USER PRODUSA
   DB2 BIND TRYIT.BND DATETIME USA
   DB2 CONNECT TO SAMPLE USER PRODEUR
   DB2 BIND TRYIT.BND DATETIME EUR COLLECTION 'PRODEUR'
十一、SET CURRENT QUERY OPTIMIZATION
十二、SET CURRENT REFRESH AGE
十三、SET ENCRYPTION PASSWORD
十四、SET EVENT MONITOR STATE
Example 1: Activate an event monitor named SMITHPAY.
   SET EVENT MONITOR SMITHPAY STATE = 1
Example 2: Assume that MYSAMPLE is a multiple partition database with two database partitions, 0 and 2. Partition 2 is not yet active.
On database partition 0:
   CONNECT TO MYSAMPLE;
   CREATE EVENT MONITOR MYEVMON ON DBPARTITIONNUM 2;
   SET EVENT MONITOR MYEVMON STATE 1;
十五、SET INTEGRITY
十六、SET PASSTHRU
十七、SET PATH
SET PATH=CURRENT PATH,"USER2"
SET PATH=SYSTEM PATH,"USER2"
SET PATH="USER1","USER2","USER3"
十八、SET SCHEMA
设置当前SCHEMA的值（当前SESSION有效）
   SET SCHEMA RICK
十九、SET SERVER OPTION
   select * from SYSCAT.SERVEROPTIONS with ur
二十、SET SESSION AUTHORIZATION
使用 SET SESSION AUTHORIZATION 语句将会话授权标识更改为一个新值
设置SESSION_USER的值：
   SET SESSION_USER = RAJIV
设置SESSION AUTHORIZATION的值为SYSTEM_USER
   SET SESSION AUTHORIZATION SYSTEM_USER收起