 |
返回文章
连接集中器的行为
在 清单 1 中，一个应用程序状态 "decoupled" 意味着应用程序连接到数据库，但是这时没有任何事务在运行。
命令输入：
conniel@bugdbug:/home/conniel> db2 list applications show detail |
清单 1. db2 list applications show detail 的输出
CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status
--------------- ---------------- ----- --------------------------- ---- --------- ------------ -------------- -----------------
CONNIEL db2bp 7 *LOCAL.conniel.094C58200237 0001 1 0 0 Decoupled
|
Uncommitted transaction:
conniel@bugdbug:/home/conniel> db2 +c "select * from t1" |
COL1
-----------
0 record(s) selected.
|
命令输入：
conniel@bugdbug:/home/conniel> db2 list applications show detail |
清单 2. db2 list applications show detail for uncommitted transaction 的输出
CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status
--------------- ---------------- ----- --------------------------- ---- --------- ------------ -------------- -----------------
CONNIEL db2bp 7 *LOCAL.conniel.094C58200237 0001 1 0 0 UOW Waiting
|
Upon Commit:
conniel@bugdbug:/home/conniel> db2 list applications show detail |
清单 3. db2 list applications show detail for committed transaction 的输出
CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status
--------------- ---------------- ----- --------------------------- ---- --------- ------------ -------------- -----------------
CONNIEL db2bp 7 *LOCAL.conniel.094C58200237 0001 1 0 0 Decoupled
|
注意：要打印该页面，请使用 landscape 打印选项。
返回文章
| |
|
