DB2 FOR LUW / DB2FORLUW / A10 - DB2

When running a query that uses an ORDER BY on a Federated table 
the data may not be ordered correctly. This will occur when the 
ORDER BY is performed on multiple columns and one of them is not 
included in the list of columns in the Select. 
 
For example, the following query will not order the data by 
column 'c': 
    db2 "select a,b from testtab order by a,c" 
 
Changing the Select to include all the columns in the Order By 
then displays the data with the correct ordering. e.g.: 
    db2 "select a,b,c from testtab order by a,c"

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Federated Users                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW 10.1 Fix Pack 5                           * 
****************************************************************

Include all the columns in the Order By in the Select or set 
PUSHDOWN to 'N' in the server options for the Federated server 
e.g.: 
    db2 "ALTER SERVER <servername> OPTIONS (add PUSHDOWN 'N')"

First fixed in DB2 LUW 10.1 Fix Pack 5

not known / see Local fix

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

28.04.2015
13.07.2015
13.07.2015