Solution : https://service.sap.com/sap/support/notes/1149824 (SAP Service marketplace login required)
Key words :
starjoin 2 sjtables 4 mxtbjoin 225 tables_joined_threshold 10 mxqbce 1023 max_opt_cpu 2 max_opt_elap 4 sjmxpool >= 128 mb sjmissky, sap profile parameter dbs/db2/use_define_no = 0, sap profile parameter dbs/db2/use_define_no=1, dsnutils stored procedures sap bi, psa}_bpool_{data_index}buffer pool, fact table-> note 579863db2_runstats_optionadditional option, db2 dsnutils stored procedure, optimizer access method dynamic indexanding, recommended db2 parameter settings, db2 service programs runstats
Related Notes :
| 390016 | DB2/390: BW: Database settings and performance |
| 81737 | DB2-z/OS: APAR List |