DB2 FOR LUW / DB2FORLUW / 970 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.7.                              * 
****************************************************************

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

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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
 

The problem is first fixed in DB2 version 9.7.0.7.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC83674 IC85217 IC85221 
follow-up : 

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

21.05.2012
18.10.2012
07.12.2012

9.7.0.7