home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC95326 Status: Geschlossen

IN A FEDERATION SYSTEM, AN UPDATE/DELETE STATEMENT DOES NOT APPLY THE
PREDICATES CONTAINING FUNCTION TEMPLATES

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to 10.5.0.3                                           * 
****************************************************************
Local-Fix:
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.
verfügbare FixPacks:
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

Lösung
Problem Fixed In 10.5.0.3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2013
28.02.2014
28.02.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList