DB2 FOR LUW / DB2FORLUW / A50 - DB2

An XML query may return incorrect result when it has all the 
following characteristics 
  1. The query has a sub-select referencing OLAP function, such 
as rownum in Ora comparability mode, row_number() over (), etc. 
  2. There is ORDER BY clause in the same or outer sub-select of 
the OLAP, and the columns in ORDER BY clause have expressions 
whose out-most function is XMLCAST.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 10.5                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.5 FixPack 8.                           * 
****************************************************************

Manually rewrite the query to compute the ORDER BY XMLCAST 
expression as close as possible to the base table access, and 
replace ORDER BY expression with simple column returned from 
inner sub-select.

DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
 DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 UDB Version 10.5 FixPack 8.

not known / see Local fix

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

24.06.2015
11.01.2017
11.01.2017