DB2 FOR LUW / DB2FORLUW / A10 - DB2

Incorrect results are possible when doing nested math operations 
on columns that are defined with NOT NULL and using functions. 
 
Example (pseudo-code): 
 
create function3(col1 bigint,col2 bigint) 
{ 
    return function1(col1)-function2(col2); 
} 
 
SELECT SUM(function3(column1,column2)) from table; 
<-- intermittent incorrect results are possible on databases 
with smaller non-automatic SORTHEAP.

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

select SUM(col1) - SUM(col2) from table

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
 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
 

The problem is first fixed in DB2 version 10.1.0.1.

keiner bekannt / siehe Local-Fix

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

10.07.2012
13.09.2012
07.12.2012