DB2 - Problem description
Problem IT16924 | Status: Closed |
OPTIMIZER PERFORMANCE DECREASE FP11 | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
Slow performance after upgrading from v9.7 FP5 to FP10 or FP11. Cardinality over adjustment affects index choices leading to slow performance. APAR description to be updated in future with more information. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Fixed in a future release. Upgrade to v10.5 which contains * * fix for IT16594 or v11.1 (IT16925) * **************************************************************** | |
Local Fix: | |
Use optimizer guideline provided by DB2 Technical Support | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT16090 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.09.2016 02.03.2017 02.03.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |