DB2 FOR LUW / DB2FORLUW / 970 - DB2

Negative COLCARD value can cause OPTIMIZER to choose a bad plan 
resulting in poor query performance. This issue can occur if all 
of the following conditions are present: 
 
1. If COLCARD exceeds 2147483647. 
 
2. Almost all possible values between high2key and low2key 
appear in the table. 
 
3. The column is BIGINT type. 
 
4. The column is not the leading column of any index. 
 
5. The column is not unique.

**************************************************************** 
* USERS AFFECTED:                                              * 
* NA                                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 FP10 or higher                               * 
****************************************************************

Workaround for this issue is to manually update COLCARD in 
SYSSTAT.COLUMNS table. You can do this as follows: 
 
1. db2  "select count(distinct(<columnname>)) from 
<schema>.<tablename>" 
 
where: 
<columnname> is the name of the column with the negative COLCARD 
value. 
<schema> is the schema for the table. 
<tablename> is the name of the table. 
 
2. Update the value as follows: 
 
db2 "UPDATE SYSSTAT.COLUMNS SET COLCARD=<value> WHERE COLNAME = 
'<coulmnname>' AND TABNAME = '<tablename>' AND TABSCHEMA = 
'<schema>' " 
 
where: 
<value> is the result of the query from step 1.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.08.2014
10.11.2014
10.11.2014

9.7.FP10