The figure shows the best case of avoiding
locks using CS isolation with CURRENTDATA(NO). The following table
shows what happens in the application and in Db2®.
| Time | Event in application | Response in Db2 |
|---|---|---|
| 1 | Request row or page | Test and avoid locks |
| 2 | Request next row or page | Test and avoid locks |