SAP Note 531337 - iSeries: Performance with Open SQL "FOR ALL ENTRIES"

Component : DB2 for AS/400 -

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

Key words :
rsdb/min_blocking_factor = 1   rsdb/max_blocking_factor = 1to implement, dbs/db4/use_hints = dbif->1or, dbs/db4/use_hints profile parameter, monat  <=  l_monat  %_hints as400 '&max_blocking_factor 1&', dbs/db4/use_hints = 1the, query optimizer internally resolves, query condition increases considerably, anln1 = <internal table1>-anln1, anln2 = <internal table1>-anln2, %_hints as400 '&max_blocking_factor 1&'

Related Notes :

485420iSeries: Database hints for Open SQL/Native SQL
129385Database hints in Open SQL