SAP Note 898203 - iSeries: "ALL I/O" and "UPTO ROWS" performance

Component : DB2 for AS/400 - DB Independent Database Interface

Solution : https://service.sap.com/sap/support/notes/898203 (SAP Service marketplace login required)

Key words :
dbs/db4/use_hints = upto->32767 solution set, generally return fewer records, dbs/db4/use_hints, dbs/db4/nqe_optimize_method =, requested resulting set, extensive resulting set, dbsl patch levels, apparently obvious expectation, abap language clause, individual sql statements

Related Notes :

705888DB4: Performance Enhancement: All I/O Optimizer Indicator