DB2 FOR LUW / DB2FORLUW / 970 - 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 v9.7 Fixpack 8 or higher                          * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in v9.7 Fixpack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC89458 IC91809 IC95241 IC95329 
follow-up : 

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

09.01.2013
17.12.2013
17.12.2013

9.7.FP8