DB2_SKIPINSERTED/DB2_SKIPDELETED/DB2_EVALUNCOMMITTED这几个关于延迟锁定的注册变量在9.7版本中还有效么,怎么试了如下的并行查询,并不会产生锁等: db2 +c "select * from t_test where i_id=2 for update with rs" db2 +c "select * from t_test where i_id=20 for update with rs" 注:试的时候在将CUR_COMMIT关闭的情况下,无论以上三个注册变量是启用还是关闭,上述两个SQL语句并行执行时都不会发生锁等。建表语句和使用的基础数据如下: create table t_test (i_id int not null, i_cola int, i_colb int); insert into t_test with tmp(id,cola,colb) as (values(1,1,1) union all select id+1,id+1,id+1 from tmp where id<100000)select * from tmp;