DB2 FOR LUW / DB2FORLUW / 970 - DB2

You might encounter incorrect results produced from a query that 
retrieves data from an XML column or produces XML data using 
constructs such as XMLELEMENT, and contains one or more 
correlated subqueries. 
 
This problem is more likely to occur in a partitioned database 
environment if the correlated subquery is not collocated to the 
other table(s) in the query, requiring a table queue in the 
correlation path in the access plan generated by the DB2 
optimizer.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users using XML data                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8.                       * 
****************************************************************

If your query is using XML functions to aggregate a list of 
string values, you can avoid this problem by using the LISTAGG 
function.

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in version 9.7 Fix Pack 8

See Local Fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91760 
follow-up : 

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

01.11.2012
20.04.2013
20.04.2013

9.7.FP8