More about Cursor Blocking

To control the number of rows getting blocked, one can either tune RQRIOBLK (remote client) or ASLHEAPSZ. If using CLI or JDBC-2, the db2cli keyword BlockForNRows gives much more precise control on number of rows to block (equivalent of Oracle's array size).