db2锁和并发.ppt

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 Possible Possible 隔离级别设置方法 单元总结 为什么需要锁 列出锁的对象 描述各种锁模式和锁的兼容性 解释4种数据保护的隔离级别 隔离级别的设置方法 锁等待(lock wait)，锁超时(lock timeout) 锁转换(lock conversion)，锁升级(lock escalation) 死锁(deadlock) 锁监控方法 Student exercise ? Copyright IBM Corporation 2008 * What this unit is about This unit describes the ... What you should be able to do After completing this unit, you should be able to: Describe the major functions of... Install and configure the... Explain the concept of... How you will check your progress Accountability: Checkpoint Machine exercises References SCnn-nnnn Title of Reference Web page name Instructor notes: Estimated time 00:00 ? Copyright IBM Corporation 2008 * Notes: Instructor notes: Purpose — To introduce the content of this unit. Details — Additional information — Transition statement — Let’s first ... ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporation 2008 * ? Copyright IBM Corporat