锁等待的问题
linux5 + db2 V9.7 表test
id name
-----------------------------
1 1111
1 2222
2 aaaaaaaa
session1:
db2 +c "delete from test where id=1"
session2:
db2 "select * from test where id =2" 这时出现了锁等待
如何让session2不要出现锁等待？
当然在v9.7中，用cur_commit参数可以做到，除了这个方法外还有什么办法？
当然也不要出现脏读的现象
id name
-----------------------------
1 1111
1 2222
2 aaaaaaaa
session1:
db2 +c "delete from test where id=1"
session2:
db2 "select * from test where id =2" 这时出现了锁等待
如何让session2不要出现锁等待？
当然在v9.7中，用cur_commit参数可以做到，除了这个方法外还有什么办法？
当然也不要出现脏读的现象
9同行回答
学习了~~收起
浏览910
浏览900
学习了收起
浏览937
LZ说的是伪命题.
不存在锁等待.
db2 "create table test (id int ,name varchar(10)) "
db2 "insert into test values(1,'1111'),(1,'2222'),(2,'aaaaaa')"
session 1:
db2 +c "delete from test where id=1"
session 2:
db2 "select * from test where id =2"
存在锁等待情况
session 1:
db2 +c "delete from test where id=1"
session 2:
db2 "select * from test where id =2 with rs"
才会出现锁等待,除了设置db2set参数,还可以对谓词建索引来避免.
db2 "create index test_idx on test(id)"收起
不存在锁等待.
db2 "create table test (id int ,name varchar(10)) "
db2 "insert into test values(1,'1111'),(1,'2222'),(2,'aaaaaa')"
session 1:
db2 +c "delete from test where id=1"
session 2:
db2 "select * from test where id =2"
存在锁等待情况
session 1:
db2 +c "delete from test where id=1"
session 2:
db2 "select * from test where id =2 with rs"
才会出现锁等待,除了设置db2set参数,还可以对谓词建索引来避免.
db2 "create index test_idx on test(id)"收起
浏览899