DB2 FOR LUW / DB2FORLUW / A50 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************

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 10.5 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

Problem Fixed In 10.5.0.3

not known / see Local fix

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

27.08.2013
28.02.2014
28.02.2014