burelamanohar

• Feb 6th, 2007

 

DB2 takes a lock on the page that the cursor is accessing and releases it when the cursor moves on to another page.Cursor Stability provids better CONCURRENCY.

radibioinfo

 Profile Answers by radibioinfo Questions by radibioinfo

• Oct 2nd, 2007

 

Cursor stability  isolation level ensures that any row that was changed by an application process cannot be read untill committed by that process. It ensures that the current row of every updatable cursor is not changed by other application process. Rows that were read during a unit of work can be changed by other application process.

sintalam4

 Profile Answers by sintalam4 

• Dec 20th, 2010

 

The Cursor Stability (CS) isolation level is the default isolation level and locks any row on which the cursor is positioned during a unit of work. The lock on the row is held until the next row is fetched or the unit of work is terminated. If a row has been updated, the lock is held until the unit of work is terminated. A unit of work is terminated when either a COMMIT or ROLLBACK statement is executed.

An application using Cursor Stability cannot read uncommitted data. In addition, the application locks the row that has been currently fetched, and no other application can modify the contents of the current row. As the application locks only the row on which the cursor is positioned, two identical queries may still get different results even if they are issued within a unit of work.

When you want the maximum concurrency while seeing only committed data from concurrent applications, choose this isolation level.