DB2 FOR LUW / DB2FORLUW / A10 - DB2

Some queries might see performance degradation starting DB2 
version 970 fix pack 6 if the following conditions are true: 
1. The query is a merge statement with only the matched 
condition 
2. The Source of the merge is a distinct join between two or 
more tables, alias 
3. (Optional) One of the tables in this join is the same as the 
target table 
eg. MERGE INTO MYALIAS.TAB1 AS TGT USING <----------- condition 
1 
         (SELECT DISTINCT A.TRN, A.SYS, A.LANG <----------- 
condition 2 
          FROM MYALIAS.TAB2 A, MYALIAS.TAB1 B <----------- 
condition 3 
          WHERE A.TRN = B.TRN AND NULLIF(B.TRN , '') IS NOT NULL 
AND A.SYS = B.SYS AND A.LANG = B.LANG) AS STG 
        ON STG.TRN = TGT.TRN 
     WHEN MATCHED THEN 
     UPDATE SET TGT.TRN = STG.TRN;

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 fixpack 3                        * 
****************************************************************

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
 

Fixed in DB2 version 10.1 fixpack 3

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC95526 
follow-up : 

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

22.08.2013
11.11.2013
11.11.2013