Solution : https://service.sap.com/sap/support/notes/1126400 (SAP Service marketplace login required)
Key words :
terms db6 db2udb db2luw udb luw msjoin nljoin performance explain reason, 11619e+06 fetch filter ixscan table, 11614e+06 ixscan fetch ixscan table, setting cap offthis setting, db2 registry variable db2_reduced_optimizationmust, db2 udb version 8, 11619e+06 ixscan table, 125 msjoin fetch, sapr3 ixscan table, registry variable db2_reduced_optimization
Related Notes :
| 101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |