DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v10.1 Fixpack 3 or Higher                     * 
****************************************************************

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First Fixed in DB2 v10.1 Fixpack 3

not known / see Local fix

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

22.04.2013
28.10.2013
28.10.2013