|
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) |
