DB2 - Problem description
Problem IT16090 | Status: Closed |
OPTIMIZER PERFORMANCE DECREASE FP11 | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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: * * See SYSROUTE APARs to see where this APAR is addressed * **************************************************************** | |
Local Fix: | |
Use optimizer guideline provided by DB2 Technical Support | |
Solution | |
Workaround | |
See LOCAL FIX. | |
BUG-Tracking | |
forerunner : follow-up : IT16594 IT16924 IT16925 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.07.2016 08.05.2017 08.05.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |