The figure shows positioned updates and deletes without optimistic concurrency control. The following table shows what happens in the application and in Db2® at three points.
Table 1. Without optimistic concurrency control
Time Event in application Response in Db2
1 FETCH row 1 Lock row 1
2 FETCH row 2 Unlock row 1, lock row 2
3 UPDATE WHERE CURRENT OF Update row 2