SAP Note 710814 - DB6: DB Performance suddenly drops for one Statement

Component : DB2 Universal Database for Unix / NT - BW DB2 Universal Database

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 :

609384DB6: Known Errors and available Fixes in DB2 UDB V8
597053
418318DB6: Known Problems and available Fixes in DB2 UDB V7