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®.
Table 1. How an application using CS isolation with CURRENTDATA(YES) acquires locks
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