|
Problem IT03247
|
Status: Geschlossen |
SQL0437W might be induced by runstats in databases that use locale-sensitive UCA-based collations |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
In databases that use locale-sensitive UCA-based collations, if
there is a string column that is longer than 66 bytes, and this
column is a leading column of an index, then the colcard that is
reported by runstats can be less than the number of frequent
values. This can lead to the following SQL0437W warning when
DB2 compiles a query that have predicates on the column:
SQL0437W Performance of this complex query might be
sub-optimal. Reason code: "6". SQLSTATE=01602 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 5. *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
Problem was first fixed in DB2 Version 10.1 Fix Pack 5. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 18.07.2014
13.07.2015
13.07.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.5
|
 |
