DB29 for Linux,UNIX,and WINDOWS - section 9(DB2 Concurrent)

 

Isolate

UR: the lowest level,Uncommitted Read(脏读-未提交的数据都照读）。

CS: the default leve, Cursor Stability(committed read and lock the row which the select cursor at)

RS:Read stability(committed read and lock the rows set which select)

RR: the top level(committed read and lock the whole table)

 

Lock:

IN: Intent None

IS: Share

S:Share

IX:Exclusive

SIX

U:Update

X:Exclusive

ZX:super