|
Problem IT01552
|
Status: Closed |
SQL0437W might be induced by runstats in databases that use locale-sensitive UCA-based collations |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 fixpack 10 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 version 9.7 fixpack 10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.05.2014
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
