db2锁和并发.pptVIP

4种隔离级别对比(UR/CS/RS/RR) RS or RR ID NAME QTY 1 DISP 10 2 KEYB 3 3 MOUSE 15 4 CABLE 18 5 CPU 1 6 SOUND 4 F E T C H 1 2 3 4 5 6 NO ROW LOCKS FOR READ-ONLY CURSORS COMMIT POINT Application Bound CS UR W or X-ROW LOCKS ALWAYS HELD UNTIL COMMIT 1 2 3 4 5 6 隔离级别对比总结 Isolation level Access to uncommitted data Nonrepeatable reads Phantom read phenomenon Repeatable Read (RR) Not possible Not possible Not possible Read Stability (RS) Not possible Not possible Possible Cursor Stability (CS) Not possible Possible Possible Uncommitted Read (UR) Possible Possib