实在是无法理解DB2的锁机制
db2 +c "insert into t1 values (3)"DB20000I The SQL command completed successfully.然后在同一个窗口中执行$ db2 "select * from t1" 觉得这个语句是不是相当于db2 +c "commit"，因为执行完这个之后，发现另外一个窗口发现居然有数据A &nbs...显示全部
查看其它 3 个回答daolin2005的回答
第一个窗口
[db2inst1@p78005lpar1/home/db2inst1]db2 "create table daolin (col1 int)"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]db2 "insert into daolin values (1)"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]db2 +c "insert into daolin values (2)"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]
第二个窗口。
[db2inst1@p78005lpar1/home/db2inst1/work]db2 "select * from daolin"
COL1
-----------
1
1 record(s) selected.
[db2inst1@p78005lpar1/home/db2inst1/work]
完全没问题啊。
楼主的问题出在第一个窗口执行select的时候数据库自动把前面一个+c的insert也自动commit了。
所以select出来就包含了insert的数字3.
[db2inst1@p78005lpar1/home/db2inst1]db2 "create table daolin (col1 int)"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]db2 "insert into daolin values (1)"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]db2 +c "insert into daolin values (2)"
DB20000I The SQL command completed successfully.
[db2inst1@p78005lpar1/home/db2inst1]
第二个窗口。
[db2inst1@p78005lpar1/home/db2inst1/work]db2 "select * from daolin"
COL1
-----------
1
1 record(s) selected.
[db2inst1@p78005lpar1/home/db2inst1/work]
完全没问题啊。
楼主的问题出在第一个窗口执行select的时候数据库自动把前面一个+c的insert也自动commit了。
所以select出来就包含了insert的数字3.