DB2 FOR LUW / DB2FORLUW / A50 - DB2

You may find that when you run a query with with Count(Distinct 
x ) against a column based table that you get intermittent slow 
performance for the query. 
 
For example, for the query: 
 select count(distinct id) from test  where date > '2014-04-20'; 
run against a table with 130 million rows that normal takes 5 
seconds to run you will intermittently find that the query takes 
greater than 40 seconds.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Column Based table users                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW 10.5 Fix Pack 5                           * 
****************************************************************

First fixed in DB2 LUW 10.5 Fix Pack 5

not known / see Local fix

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

30.10.2014
19.01.2016
19.01.2016