What is the difference between Cursor stability and Repeatable read.
| 1)Â Â Â Â Â DB2 takes a lock on the page cursor is accessing and releases it as the cursor moves on. 2)Â Â Â Â Â This isolation level is not the default. 3)Â Â Â Â Â This provides more concurrency and lesser integrity. 4)Â Â Â Â Â The lock is acquired at page level in both CS and RR | 1)Â Â Â Â Â DB2 takes lock on all the pages and releases only when transaction is committed. 2)Â Â Â Â Â This isolation level is the default. 3)Â Â Â Â Â This provides more integrity and less concurrency. 4)Â Â Â Â Â The lock is acquired at page level in both CS and RR |
; ; ; ;