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

keiner bekannt / siehe Local-Fix

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

30.10.2014
19.01.2016
19.01.2016