The figure shows how an application that is
using CS isolation with CURRENTDATA(YES) acquires locks. The following
table shows what happens in the application and in Db2®.
| Time | Event in application | Response in Db2 |
|---|---|---|
| 1 | Request row or page | Lock L |
| 2 | Unlock L | |
| 3 | Lock L1 | |
| 4 | Unlock L1 | |
| 5 | Lock L2 | |
| 6 | Request next row or page | Unlock L2 |
| 7 | Lock L3 | |
| 8 | Unlock L3 | |
| 9 | Lock L4 |