Solution : https://service.sap.com/sap/support/notes/501572 (SAP Service marketplace login required)
Key words :
as4/evistage2support = 1 dbs/db4/alternate_qaqqinilib = r3<sid>datadbs/db4/use_hints = 1, optimization_goal = allio force_join_order = primary star_join = cost allow_temporary_indexes = only_required, optimization_goal = allio allow_temporary_indexes = only_required star_join = cost, star schemaas/400greedy join algorithmsap_sanity_check_db4 reason, /servers/enable/site/education/abstracts/4aea_abs, remaining qaqqini parameters remain set, special query options file qaqqini, terms evi stage 2 supportjoin support, handle intensive bw database queries, r3<sid>data library
Related Notes :
| 820325 | iSeries: Using QAQQINI with SAP |
| 730627 | iSeries: Performance with joins without fact tables |
| 592073 | iSeries: ODS queries too slow |
| 568139 | iSeries: Performance Aggregate Filling and Complex Queries |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 541508 | iSeries: Checking the system parameters for BW |
| 485420 | iSeries: Database hints for Open SQL/Native SQL |
| 451808 | iSeries: Adjusting indexes to the new index schema |
| 407528 | AS/400: DB2/400 indexing Schema of the BW Fact Tables |