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®.
Table 1. The best case of avoiding locks using CS isolation with CURRENTDATA(NO)
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