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 IC95241 Status: Geschlossen

DB2 SQL QUERY OPTIMIZER HAS IMPROVED THE PERFORMANCE OF SIMPLE SINGLE-ROW
MERGE STATEMENT

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
DB2 SQL Query Optimizer has improved the performance of 
merge statements when all of the following conditions are 
satisfied: 
 
(1) the merge source is provably single-row.  It includes the 
cases when the merge source is: 
- a single row VALUES clause 
- a sub-SELECT with with FETCH FIRST 1 ROWS ONLY 
- a simple sub-select from a table with unique key columns bound 
to constants, host variables or parameter markers. 
(2) the merge target table has a unique key defined on the merge 
join columns 
(3) the join predicates in the ON clause are simple equality 
predicates that join columns from the source and target tables 
(4) the merge target table has no trigger, constraint, 
dependent immediate MQT or staging table 
(5) the merge statement has at most two WHEN clauses with only 
UPDATE or INSERT operations.  In the case of two WHEN clauses, 
one operation must be an UPDATE and the other operation must be 
an INSERT 
(6) there is no additional predicate in the merge WHEN clause 
(7) The partitioning keys (DPF, MDC or data partitioning) are 
not modified by the UPDATE operation
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 3 or Higher.                * 
****************************************************************
Local-Fix:
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
First Fixed in DB2 LUW v10.5 Fixpack 3.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2013
07.05.2014
07.05.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
10.5.0.4 FixList