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
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.
Joined: 14 Jul 2008 Posts: 1239 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.