Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC89438 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 8 or higher                          * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
First Fixed in v9.7 Fixpack 8
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC89458 IC91809 IC95241 IC95329 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.01.2013
17.12.2013
17.12.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.