db2默认隔离级别为CS(游标稳定性)
db2 connect reset
db2 change isolation to ur (RR | RS | CS | UR)
能够指定特定查询所用的隔离级别,
方法是在SELECT SQL语句中加上WITH [RR | RS | CS | UR]子句
SELECT * FROM table WHERE WITH RR
db2默认隔离级别为CS(游标稳定性)
db2 connect reset
db2 change isolation to ur (RR | RS | CS | UR)
能够指定特定查询所用的隔离级别,
方法是在SELECT SQL语句中加上WITH [RR | RS | CS | UR]子句
SELECT * FROM table WHERE WITH RR