DB2 FOR LUW / DB2FORLUW / A50 - DB2

Calling ROUND() function on an integer data type (INT, SMALLINT, 
BIGINT) might return incorrect overflow error, SQL0802N. 
 
The number arguments needs to be big or small enough for a 
negative, such that the bit representation given it's type may 
result in some of the high order bits being set, either in the 
original number or the expected rounded number. 
 
Here is an example: 
 
values( ROUND( -555555555 , -9 ) ) 
 
-> aborts with SQL0802N, where the expected result should be: 
-1000000000

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7.                      * 
****************************************************************

First fixed in DB2 Version 10.5 Fix Pack 7.

not known / see Local fix

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

13.02.2015
21.01.2016
21.01.2016