2594174 - High temporary space usage (SQLS_MEMCONSUMER_CDE_GROUP_BY)

Db2diag.log shows below error
=========================

• <DATE Timestamp> LEVEL: Error
  PID : **** TID : ************************* PROC : db2sysc 0
  INSTANCE: db2<SID> NODE : 000 DB : <SID>
  APPHDL : 0-*** APPID: ******************************
  AUTHID : SAP<SID> HOSTNAME: *********
  EDUID : ***** EDUNAME: db2agntcol**** 
  FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:556
  DATA #1 : String, 332 bytes
  DB2ErrorException: DB2 Error Exception zRC=0x801a006d, SQLCODE=-955, diagnostics:
  SQLS_MEMCONSUMER_CDE_GROUP_BY stats (4K pages)
  current state:
  shsort:
  sortheap: 28000
  sheapthres: 700000
  reserved, HWM: 57623, 79379
  physical usage: 55984
  consumer:
  reserved: 28000
  logical usage: 46514
  Thrown at Subpool.cpp : 556
  DATA #2 : Function name in Library, 68 bytes
  void ibm_cde::services::MemConsumer::throwOutOfHeapMemoryError(bool)
  DATA #3 : File name, 11 bytes
  Subpool.cpp
  CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x00007F41EB6BE600 _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16CommonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait + 0x710
  [1] 0x00007F41EF4D3E9B _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11ComponentIDEPKc + 0x22B
  [2] 0x00007F41EF4DC059 _ZN7ibm_cde8services11MemConsumer25throwOutOfHeapMemoryErrorEb + 0x389
  [3] 0x00007F41ECD47F49 _ZN7ibm_cde5query19GroupByControlBlock24handleInsufficientMemoryEll + 0x559
  [4] 0x00007F41EF6A3E66 _ZN7ibm_cde5query19GroupByControlBlock29getLongestOverflowBucketChainEjtRmlb + 0x716
  [5] 0x00007F41EF6A4EA9 _ZN7ibm_cde5query19GroupByControlBlock26spillOverflowChainIfNeededEjllbb + 0xA9
  [6] 0x00007F41ECD0ABC1 _ZN7ibm_cde5query32LookupGroupingHashTableEvaluator33processInputsSynchronously_helperINS_5types7IntegerIlLb0EEELNS0_15HashTabl + 0x1CD1
  [7] 0x00007F41ECD03D57 _ZN7ibm_cde5query32LookupGroupingHashTableEvaluator26processInputsSynchronouslyEv + 0xF7
  [8] 0x00007F41F1306936 _ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartStateEPNS0_19OptPredicateTrackerE + 0x3F6
  [9] 0x00007F41EC02326C _ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_data + 0x23C
  [10] 0x00007F41EF68ACBB _ZN7ibm_cde5query9Scheduler13runThreadTaskEPvPi + 0x4FB
  [11] 0x00007F41EF6934BE _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E
  [12] 0x00007F41EF642033 _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x83
  [13] 0x00007F41EE767C01 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x41
  [14] 0x00007F41F13F2501 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1B1
  [15] 0x00007F41EE57867C _Z16sqlrr_smp_routerP8sqlrr_cb + 0x17C
  [16] 0x00007F41EE5776CC _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x5BC
  [17] 0x00007F41ED36DE9D /db2/db2bip/sqllib/lib64/libdb2e.so.1 + 0x315BE9D
  [18] 0x00007F41ED36C95C _Z21sqleProcessSubRequestP8sqeAgent + 0x2EC
  [19] 0x00007F41ED388082 _ZN8sqeAgent6RunEDUEv + 0x4C2
  [20] 0x00007F41EEBBDDB7 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
  [21] 0x00007F41EE36FE43 sqloEDUEntry + 0x303
  [22] 0x00007F41F5AD1744 /lib64/libpthread.so.0 + 0x8744
  [23] 0x00007F41E8F40AAD clone + 0x6D

• <DATE Timestamp> LEVEL: Severe
  PID : **** TID : ************************* PROC : db2sysc 0
  INSTANCE: db2<SID> NODE : 000 DB : <SID>
  APPHDL : 0-*** APPID: ******************************
  AUTHID : SAP<SID> HOSTNAME: *********
  EDUID : ***** EDUNAME: db2agntcol****
  FUNCTION: DB2 UDB, CDE Aggregation, LookupGroupingHashTableEvaluator::calculateOverflowBucketSize, probe:625
  MESSAGE : No memory for local HTs, throw 955:
  DATA #1 : Function name in Library, 0 bytes
  Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL
  DATA #2 : File name, 36 bytes
  LookupGroupingHashTableEvaluator.cpp

• <DATE Timestamp> LEVEL: Error
  PID : **** TID : ************************* PROC : db2sysc 0
  INSTANCE: db2<SID> NODE : 000 DB : <SID>
  APPHDL : 0-*** APPID: ******************************
  AUTHID : SAP<SID> HOSTNAME: *********
  EDUID : ***** EDUNAME: db2agntcol****
  FUNCTION: DB2 UDB, CDE Data, DatabaseTempTable::writeTempData, probe:445
  MESSAGE : Write to temp table failed with rc: -2147221501 Pool ID 3 Object ID 2
  DATA #1 : Function name in Library, 0 bytes
  Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL
  DATA #2 : File name, 21 bytes
  DatabaseTempTable.cpp

• Db2 for LUW 10.5
• SAP NETWEAVER 7.4

SQLS_MEMCONSUMER_CDE_GROUP_BY, throwOutOfHeapMemoryError, LookupGroupingHashTableEvaluator, calculateOverflowBucketSize, GroupByControlBlock , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem