DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fixpack 10                        * 
****************************************************************

Problem was first fixed in DB2 version 9.7 fixpack 10

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

05.05.2014
10.11.2014
10.11.2014

9.7.FP10