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