Solution : https://service.sap.com/sap/support/notes/908313 (SAP Service marketplace login required)
Key words :
db2 registry variable db2_reduced_optimization fp9, terms db6 db2udb prepare reason, observe long prepare times, db2 udb v8 solution, db2udb v8 fix pack 12, ibm apar # iy78641, join fp10/fp11, transaction st04, prerequisites problem, join --> 2
Related Notes :
609384 | DB6: Known Errors and available Fixes in DB2 UDB V8 |
101809 | DB6: Supported Fix Packs IBM DB2 for Linux,UNIX and Windows |