一、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