DB2 FOR LUW / DB2FORLUW / 970 - DB2

Depending on the data, XML query may return incorrect results. 
 
Here is a sample result. In this case, the count() should return 
100. 
 
$ db2 import from data.del of del xml from xmls insert into 
transact 
$ db2 -tvf a.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[action/assignor/@loginNameResponseCode 
="573076-1" and @transactState=1]' passing data as "root") 
 
1 
----------- 
         91 
 
  1 record(s) selected. 
 
$ db2 -tvf b.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[action/assignor/@loginNameResponseCode 
="573076-1"]' passing data as "root") and 
xmlexists('$root/transact[@transactState=1]' passing data as 
"root") 
 
1 
----------- 
        100 
 
  1 record(s) selected. 
 
$ db2 -tvf d.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[./action/assignor/@loginNameResponseCo 
de="573076-1" and @transactState=1]' passing data as "root") 
 
1 
----------- 
        100 
 
  1 record(s) selected. 
 
$ db2 -tvf c.txt 
SELECT count(id) FROM TRANSACT WHERE 
xmlexists('$root/transact[@transactState=1 and 
./action/assignor/@loginNameResponseCode="573076-1"]' passing 
data as "root") 
 
1 
----------- 
        100 
 
  1 record(s) selected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW ALL                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v97 FP6 or newer.                                 * 
****************************************************************

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 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
 

Fix will be delivered as part of v97 FP6 and available in all 
future releases.

not known / see Local fix

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

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

21.03.2012
13.06.2012
13.06.2012

9.7.FP6