DB2 - Problem description
Problem IT16925 | Status: Closed |
OPTIMIZER PERFORMANCE DECREASE FP11 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Slow performance such as INSERT 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. Planned to be fixed in the next * * release of DB2. * **************************************************************** * RECOMMENDATION: * * See Local Fix * **************************************************************** | |
Local Fix: | |
Use optimizer guideline provided by DB2 Technical Support | |
Solution | |
Workaround | |
See Local Fix | |
BUG-Tracking | |
forerunner : IT16090 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.09.2016 04.09.2018 04.09.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |