DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 Fix Pack 11                           * 
****************************************************************

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 9.7 Fix Pack 11

keiner bekannt / siehe Local-Fix

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

31.03.2015
08.10.2015
08.10.2015

9.7.FP11