DB2 FOR LUW / DB2FORLUW / A10 - 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 v101fp4                                           * 
****************************************************************

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.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

upgrade to v101fp4

not known / see Local fix

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

26.09.2013
28.04.2014
28.04.2014