Like level RR, level Read Stability (RS) ensures that:
Unlike RR, RS does not completely isolate the activation group from the effects of concurrent activation groups that use a different commitment definition. At level RS, activation groups that issue the same query more than once might see additional rows. These additional rows are called phantom rows.
For example, a phantom row can occur in the following situation:
In addition to any exclusive locks, an activation group running at level RS acquires at least share locks on all the rows it reads.
In the SQL 2003 Core standard, Read Stability is called Repeatable Read.
DB2 UDB for iSeries supports read stability through COMMIT(*ALL) or COMMIT(*RS).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.