DB2 FOR LUW / DB2FORLUW / A50 - DB2

Under rare conditions and memory constraints a query with 
aggregation and high intra partition parallelism might hit the 
out of 
memory error -955 (SQL0955N). 
 
Erorr similar to following will be reported in the db2diag.log: 
 
EDUID   : 12345                EDUNAME: db2agntcol (db2inst1) 
FUNCTION: DB2 UDB, CDE Aggregation, 
GroupByControlBlock::handleInsufficientMemoryForAggDistinct, 
probe:4976 
DATA #1 : String, 118 bytes 
SORTHEAP needs to be larger for DISTINCT processing. Current 
surplus -5136, inUse 263934992, reserved 263929856 bytes. 
DATA #2 : Object [PD_TYPE_FUNC_NAME] not dumped 
Address: 0x0000000000000000 Size: 0 Reason: Address is NULL 
DATA #3 : File name, 23 bytes 
GroupByControlBlock.cpp

**************************************************************** 
* USERS AFFECTED:                                              * 
* CDE Tables and groupby                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install this fix                                             * 
****************************************************************

Lowering DFT_DEGREE for the query might help the query to finish 
successfully

See Error Description

keiner bekannt / siehe Local-Fix

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

19.01.2015
26.01.2016
26.01.2016