DB2 FOR LUW / DB2FORLUW / A50 - DB2

Query may produced the error SQL0901N with the message: 
"no space to insert key into CHT 85 0" 
 
The stack for the error will show similar to the following: 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000000564F14 pthread_kill + 0xD4 
0x0900000022429B20 sqloDumpEDU + 0xC4 
0x090000002244AC98 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 + 
0x110 
0x0900000020AA4F38 sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x940 
0x0900000020AA4480 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x28 
0x09000000205A4A5C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc + 
0x234 
0x09000000205A41F0 sqlrrSqlCode + 0xA4 
0x0900000034D760FC 
done__Q3_7ibm_cde8services24AssertionFailedExceptionFv + 0x1290 
0x0900000032D189C8 
constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio 
nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8serv 
ices16CdeOStringStream + 0x208 
0x0900000032D07ACC 
constructAndThrow__Q3_7ibm_cde8services24AssertionFailedExceptio 
nFCQ3_7ibm_cde8services11ComponentIDCPCcCUlN22RCQ3_7ibm_cde8serv 
ices16CdeOStringStream@glue7B + 0x7C 
0x0900000033AC69E4 
formCompactHashTable__Q3_7ibm_cde5query18RegularLPHashTableXTlTl 
SP0SP0_Hll_UibCP13SQLO_MEM_POOL_Q2_3std8auto_ptrXTQ3_7ibm_cde5qu 
ery9CompactHTXTlTlTlTlSP0SP1SP1__ + 0xD4 
0x0900000033AC5254 
formCompactHashTable__Q3_7ibm_cde5query14JoinProbeTableXSP0SP1SP 
100SP0_FUibCP13SQLO_MEM_POOL + 0xDC 
0x0900000032FE08F4 
managePart__Q3_7ibm_cde5query13JoinSpillInfoFUlN21Rl + 0x2F8 
 
with: 
DATA #1 : String, 206 bytes 
AssertionFailedException: An assertion 'false' failed. 
Additional info: no space to insert key into CHT 85 0 
Thrown at 
/view/db2_v105fp8_aix64_s160901_special_36402/vbs/engn/cde/group 
by/HashTable.hpp : 1522 
DATA #2 : Function name in Library, 137 bytes 
ibm_cde::query::CompactHT<long,long,long,long,0,1,1>::lookupAndI 
nsertKey<1>(long *, KeyIndex *, long *, Uint, Uint32, Uint, 
bool, bool &) 
DATA #3 : File name, 80 bytes 
/view/db2_v105fp8_aix64_s160901_special_36402/vbs/engn/cde/group 
by/HashTable.hpp 
... 
 
This fix will change the error produced from -901 to -955 as the 
problem is caused by insufficient hash buckets for the query to 
complete.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************

First fixed in Db2 10.5 Fix Pack 9

not known / see Local fix

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

25.07.2017
29.09.2017
29.09.2017

9.0.