CLP 中关闭自动落实的问题
2011-05-20 11:09 qinuo 阅读(246) 评论(0) 编辑 收藏 举报
有没有朋友遇到这样的问题,昨天我的一个朋友问的我“打算把CLP的自动落实关掉.
db2 update command options using c off
成功
不过我再次查看 db2 list command options
显示的还是-c on 并没有改变”
这两天由于电话录音卡软件的工程赶期,我只能想到下面的方法:
解决方法如下:
The default for c is ON, see other testing:
-c Auto-Commit ON
db2 update command options using c off
-c Auto-Commit ON -----> this still
shows ON
export DB2OPTIONS= c
Command options (DB2OPTIONS) = c
OptionDescription Current Setting
-------------------------------------------------------------
-a Display SQLCA OFF
-c Auto-Commit OFF
/TMP/jmunoz/PMRS/43519->db2 update command options using c ON
DB20000IThe UPDATE COMMAND OPTIONS command completed successfully.
Command options (DB2OPTIONS) = c
OptionDescription Current Setting
-------------------------------------------------------------
-a Display SQLCA OFF
-c Auto-Commit OFF ====> is still
off.
So please check that the "EXPORT DB2OPTIONS" is an important step.
我想应该还有别的方法,希望有时间的朋友们来共同探讨一下!