Difference among "connect reset", "disconnect",
There are quite a lot of subtly differences:
CONNECT RESET and DISCONNECT are SQL statements, TERMINATE is a DB2 command.
From the manuals:
CONNECT RESET:
==============
On type 1 connections, it disconnects and runs a COMMIT before.
http://publib.boulder.ibm.com/infoc...in/r0000906.htm
On type 2 connections, it connects to the default database. But there are a
few more options to control what happens.
http://publib.boulder.ibm.com/infoc...in/r0000908.htm
DISCONNECT:
===========
Can only be used from an application and not interactively. Also, there
must not be an UOW running at the time of DISCONNECT.
http://publib.boulder.ibm.com/infoc...in/r0000943.htm
TERMINATE:
==========
Explicitly terminates the command line processor's back-end process.
http://publib.boulder.ibm.com/infoc...re/r0001973.htm
Through that, it also disconnects from the DB2 server.
20同行回答
connect reset 只有在 client connect 为1, 也就是 RUOW的情况下才能用.
client connect 为2, 是 DUOW, connect reset 就不能用了.
connect reset 和 disconnect 的 结果应该是一样的, 只不过 connect 为2 的情况下 connect reset 不能用了.
至于terminate 和 connect reset的区别 就是 terminate 会 中断 后台进程(back-end process), 而 connect reset 只会断开当前的数据库连接.收起
client connect 为2, 是 DUOW, connect reset 就不能用了.
connect reset 和 disconnect 的 结果应该是一样的, 只不过 connect 为2 的情况下 connect reset 不能用了.
至于terminate 和 connect reset的区别 就是 terminate 会 中断 后台进程(back-end process), 而 connect reset 只会断开当前的数据库连接.收起
浏览645
let me see see收起
浏览632