Piece-wise deletion of data

Db2 12 introduces functionality that helps to mitigate the effects of locking, when potentially millions of rows could be affected by a DELETE statement.

Db2 12 adds FETCH FIRST n ROWS ONLY syntax to the searched DELETE statement to limit the number of rows that are deleted in a single SQL statement.