DB2 FOR LUW / DB2FORLUW / A50 - DB2

The optimizer will consider an optimization for an SQL statement 
containing a MIN or MAX aggregation without a group by clause, 
referred to as a one-fetch group by operation, if the stream is 
ordered on the aggregation source column. You can identify if 
the group by operation is optimized as a one-fetch by collecting 
an EXPLAIN of the statement and searching for the ONEFETCH 
argument in the group by operator details: 
 
                ONEFETCH: (One Fetch flag) 
                        TRUE 
 
If the input cardinality is significantly underestimated to 
value of 1 or less, then the optimizer might not choose to 
perform this optimization, and the ONEFETCH argument will not 
exist in the formatted EXPLAIN output.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Problem Description above.                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version V10.5 FP3.                            * 
****************************************************************

In most cases, collecting up-to-date statistics will improve the 
cardinality estimate if the SQL statement contains predicates 
that qualify the latest data in the table and the statistics are 
stale.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

First fixed in DB2 Version V10.5FP3.

not known / see Local fix

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

07.10.2013
17.09.2014
17.09.2014