DB2 FOR LUW / DB2FORLUW / 950 - DB2

DB2 may abend while compiling a query if the following 
conditions are met. 
 
1. There exists a predicate that has the form of (HAVING 
SUM(column) relop LITERAL) where relop could be <, >, <=, >= or 
=. 
2. The column in the SUM has statistics. 
 
The stack trace may look something like: 
0      sqlno_ff_convolute 
1      sqlno_ff_pr_sum_uniform 
2      sqlno_ff_col_rg 
3      sqlno_ff_compute_atomprd 
4      sqlno_ff_compute 
5      sqlno_ntup_ff_scan 
6      sqlno_exe 
7      sqlno_exe 
8      sqlnn_cmpl 
9      sqlnn_cmpl 
10      sqlra_compile_var 
11      sqlra_find_var 
12      sqlra_get_var

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 10.                      * 
****************************************************************

First fixed in DB2 Version 9.5 Fix Pack 10.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84613 IC84800 
Nachfolger : 

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

23.01.2012
15.08.2012
15.08.2012

9.5.FP10