DB2 FOR LUW / DB2FORLUW / A10 - DB2

Under very rare scenarios, DB2 might give a SQL0901N error 
message. 
A. The query has a RATIO_TO_REPORT olap function 
B. The datatype of the input expression is not decfloat 
 
Example: 
 
select t1.c1, ratio_to_report(sum(cast(t1.volume as float)))OVER 
(Partition By t1.c1) 
  from t1 
  where t1.c2 = 1 
  group by t1.c1; 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "".) 
SQLSTATE=58004 
 
Similar stack will be dumped in the Trap file: 
 
ossDumpStackTraceEx 
OSSTrapFile::dumpEx 
sqlo_trce 
sqloDumpDiagInfoHandler 
__pthread_mutex_cond_lock 
pthread_kill 
sqloDumpEDU 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeMapZrc 
sqlrrMapZrc 
sqlrimth_divintdfp 
sqlriSectInvoke 
sqlrr_open

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW version v10.1 fixPack 3                   * 
****************************************************************

Manually rewrite the RATIO_TO_REPORT into a (cast(expression as 
decfloat))/SUM(expression) over () form

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
 

Upgrade to DB2 LUW version v10.1 fixPack 3

not known / see Local fix

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

25.09.2013
11.11.2013
11.11.2013