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 :
| 485420 | iSeries: Database hints for Open SQL/Native SQL |
| 129385 | Database hints in Open SQL |