View previous topic :: View next topic
|
Author |
Message |
shyam6385
New User
Joined: 14 Oct 2009 Posts: 6 Location: bangalore
|
|
|
|
In RR isolation level, there is a update lock in the table.when the lock will be released.
a. When the cursor moves to the next row
b. When the transaction is committed
c. When the cursor moves to the next row and cursor closed
d. none |
|
Back to top |
|
|
Steve Davies
New User
Joined: 15 Oct 2009 Posts: 32 Location: UK
|
|
|
|
A quick google tells me...
Under an RR isolation level all page locks are held until they are released by a COMMIT (or ROLLBACK), whereas with CS read-only page locks are released as soon as another page is accessed. Repeatable read is the default isolation level if none is specified at BIND time. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
The answer could have been found by looking at the Sticky entitled: DB2 - Interview Questions with Answers. Also, the intent of this forum is for the poster to attempt to answer their own question and then invite responses. |
|
Back to top |
|
|
|