The correct getForUpdateString for DB2 should be "for update with rr"
DB2 will release all locks created in a result set if the isolation level is lower than TRANSACTION_SERIALIZABLE (RR in DB2).
Locks and concurrency control in DB2:
The duration of row locking varies with the isolation level being used:
UR scans: No row locks are held unless row data is changing.
CS scans: Row locks are only held while the cursor is positioned on the row.
RS scans: Only qualifying row locks are held for the duration of the transaction.
RR scans: All row locks are held for the duration of the transaction.
Bulk closing stale resolved issues