DB2 FOR LUW / DB2FORLUW / 970 - DB2

A query that uses SUM, GROUP BY and UNNEST can trap with a 
SIGSEGV if the SUM is applied as a vector aggregation. 
To cause the trap, a query must be issued and has a SUM and 
GROUP BY with a sub-select that contains UNNEST, an example: 
 
SELECT sum(c1) 
FROM    ( SELECT t.c1 
     FROM UNNEST(arrgv1) AS t (c1) ) 
GROUP BY c1@ 
 
This will cause a trap with SIGSEGV with sqlrivsum on the top of 
the stack as a result of bad input going into the vector sum. 
 
Stack example: 
 
 
sqlrivsum 
sqlsVectorize 
sqlsChecknVectorize 
sqlsopen 
sqlrsopen 
sqlrsopen 
sqlrisrt 
sqlriunn 
sqlriset 
sqlriSectInvoke 
sqlrr_process_fetch_request 
sqlrr_fetch 
sqljs_ddm_cntqry 
sqljsParseRdbAccessed 
sqljsParse.fdpr.clone.104 
sqljsSqlam 
sqljsDriveRequests 
sqljsDrdaAsInnerDriver 
RunEDU 
EDUDriver 
sqloEDUEntry

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

First Fixed in Version 9.7 Fix Pack 10.

not known / see Local fix

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

12.08.2014
22.10.2014
22.10.2014

9.7.FP10