db2 connect reset 与commite 、terminate的区别？？

nice ，very good收起

学习了:)收起

回答的挺好收起

回复 3# fyhlove


   best answer!收起

Please note there is an implicit commit for CONNECT RESET and TERMINATE.
For CLPPlus, QUIT will also issue commit by default;
The DISCONNECT statement (can only be embedded within an application program) will not result in a commit operation.收起

回复 3# wangzhonnew

This is the very best answer收起

db2 connect  reset 的意思是连接重置
db2 commit 提交当前事务
db2 terminate 相当于先connect reset后quit收起

connect reset，断开连接，但是后台db2bp依然存在
terminate，中断连接，干掉db2bp

(taoewang@db2debug) /home/taoewang $ db2 connect to sample

   Database Connection Information

Database server        = DB2/AIX64 9.7.3
SQL authorization ID   = TAOEWANG
Local database alias   = SAMPLE

(taoewang@db2debug) /home/taoewang $ ps -elf | grep -i db2bp | grep taoewang
  240001 A taoewang 16597040        1   0  60 20 12cd6b3400  3420          08:56:19      -  0:00 /home/taoewang/sqllib/bin/db2bp 16437340A21406 5 A
  200001 A taoewang 16781316 16437340   2  60 20 1001a00400   212 f10001102d102118 08:56:28  pts/4  0:00 gnugrep -i db2bp
(taoewang@db2debug) /home/taoewang $ db2 connect reset
DB20000I  The SQL command completed successfully.
(taoewang@db2debug) /home/taoewang $ ps -elf | grep -i db2bp | grep taoewang
  240001 A taoewang 16597040        1   0  60 20 12cd6b3400  3428          08:56:19      -  0:00 /home/taoewang/sqllib/bin/db2bp 16437340A21406 5 A
  200001 A taoewang 16781318 16437340   2  61 20 16dddb7400   212 f10001102b967180 08:56:34  pts/4  0:00 gnugrep -i db2bp
(taoewang@db2debug) /home/taoewang $ db2 terminate
DB20000I  The TERMINATE command completed successfully.
(taoewang@db2debug) /home/taoewang $ ps -elf | grep -i db2bp | grep taoewang
  200001 A taoewang 16785424 16437340   2  61 20 163dd8f400   212 f10001102b967180 08:56:39  pts/4  0:00 gnugrep -i db2bp
(taoewang@db2debug) /home/taoewang $收起