As of DB2 version 12, it now supports the notion of OFFSET queries:

SELECT * FROM TAB OFFSET 10 ROWS FETCH FIRST 10 ROWS ONLY;

It would be useful to introduce this so that DB2 users using the newer versions would not have to enable the poor performing legacy limit handler functionality when wanting to use offset-based pagination queries.

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/wnew/src/tpc/db2z_12_sqlpagination.html