Solution : https://service.sap.com/sap/support/notes/710814 (SAP Service marketplace login required)
Key words :
terms db6 db2udb optimizer level reason, db2 udb v7 fixpak 11b, db2 udb v8 fixpak 4d, problem affects db2 udb v7, db2 software problem, wrong optimization level, statement drops dramatically, explain utility show, long query runtimes, acceptable access plan
Related Notes :
609384 | DB6: Known Errors and available Fixes in DB2 UDB V8 |
597053 | |
418318 | DB6: Known Problems and available Fixes in DB2 UDB V7 |