DB2 FOR LUW / DB2FORLUW / A50 - DB2

Incorrect values might be inserted into a table as a result of 
an incorrect plan being chosen for an INSERT from a SELECT. 
 
The problem only occurs when intrapartition parallelism is 
enabled via the INTRA_PARALLEL database manager configuration 
parameter. 
 
The problem is more likely to occur if all of the following 
statements are true: 
- The table contains very wide columns -- close to 8KB or 
larger. 
- The reference to the target table in the subselect is within a 
separate query block.  In the following example, t1 is the 
target table.  Note how it is accessed in a separate query block 
in the subselect:  insert into t1 select t2.* from t2, (select 
c00 from (select c00,  ROWNUMBER() OVER() RN FROM t1 where c00 
is not null) as t WHERE RN BETWEEN 30 AND 33) as TT where t2.c00 
<> TT.c00.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5.0.4.                             * 
****************************************************************

Disable intrapartition parallelism using the INTRA_PARALLEL 
database manager configuration parameter.

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
 

The problem is first fixed in DB2 version 10.5.0.4.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

12.05.2014
08.09.2014
08.04.2015