DB2 FOR LUW / DB2FORLUW / 970 - DB2

This problem is specific to the Federation feature of DB2 and 
when a remote function is mapped to the 
Federated server in DB2 as a function template. Any 
UPDATE/DELETE statement containing predicates 
with the function template does not apply such predicates. As a 
result, the UPDATE/DELETE statement 
might update or delete more rows than it should. 
 
For example, in a Federated system has a nickname N1(c1) is 
mapped to a remote table T1(c1) and 
a function template MY_LTRIM() is mapped to a function 
SYSIBM.LTRIM() at a remote server. 
Assume that the table T1(C1) has 2 rows of values 'A' and 'B'. 
 
The statement 
 
UPDATE N1 SET C1 = 'X' WHERE MY_LTRIM(C1) = 'A' 
 
should update only the first row from 'A' to 'X'. Without 
applying this fix, the statement will update all the 
rows to 'X'. 
 
Likewise, the statement 
 
DELETE N1 WHERE MY_LTRIM(C1) = 'A' 
 
should delete only the first row. It deletes all the rows 
without applying this fix.

**************************************************************** 
* USERS AFFECTED:                                              * 
* all platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97fp9                                            * 
****************************************************************

Replace any usage of function templates in any predicates of 
UPDATE/DELETE statements 
with equivalent versions of local function in the Federated 
server. This could impact the performance 
of the UPDATE/DELETE.

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
 

upgrade to v97fp9

not known / see Local fix

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

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

07.05.2013
24.12.2013
24.12.2013

9.7.FP9