SAP Knowledge Base Article - Preview

2594174 - High temporary space usage (SQLS_MEMCONSUMER_CDE_GROUP_BY)

Symptom

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


Read more...

Environment

  • Db2 for LUW 10.5
  • SAP NETWEAVER 7.4

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.