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.