Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is cursor stability?

asked mar August 20, 2014 11:57 AM  

What is cursor stability?


1 Answers

answered By Mswami   0  
Cursor stability:

Like levels RR(Repeatable Read) and RS(Read stability), level Cursor Stability (CS) ensures that any row that was changed (or a row that is currently locked with an UPDATE row lock) by another activation group using a different commitment definition cannot be read until it is committed. Unlike RR and RS, level CS only ensures that the current row of every updatable cursor is not changed by other activation groups using different commitment definitions.

Thus, the rows that were read during a unit of work can be changed by other activation groups that use a different commitment definition. In addition to any exclusive locks, an activation group running at level CS may acquire a share lock for the current row of every cursor.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!