DB2 FOR LUW / DB2FORLUW / B50 - DB2

CDE join causes crash when Db2 trace is turned on

We see the following db2diag entry


EDUID   : 57870                EDUNAME: db2agntcol (BLUDB) 2
FUNCTION: DB2 UDB, oper system services,
sqloPGRPRegisterOneCrash, probe:2161
MESSAGE : lastCrashCount
DATA #1 : unsigned integer, 8 bytes
0
DATA #2 : String, 10 bytes
inRecovery
DATA #3 : Boolean, 1 bytes
false
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
  [0] 0x00002B37DDB235CC sqloPGRPRegisterOneCrash + 0x20C
  [1] 0x00002B37DDC9F278 sqloEDUCodeTrapHandler + 0xB28
  [2] 0x00002B37D44B55D0 /lib64/libpthread.so.0 + 0xF5D0
  [3] 0x00002B37DB7DF471
_ZN7ibm_cde5query13JoinSpillInfo20computeAgentUsePartsEmRNS_5typ
es9BitStringEm + 0x391
  [4] 0x00002B37DB7D9735
_ZN7ibm_cde5query13JoinSpillInfo16reserveAgentPartEmRNS_5types9B
itStringEmRm + 0x175
  [5] 0x00002B37DB7D900C
_ZN7ibm_cde5query13JoinSpillInfo21reserveAgentPartGroupEmRNS_5ty
pes9BitStringEmRm + 0x10C
  [6] 0x00002B37DA9676F0
_ZN7ibm_cde5query23GetJoinPayloadEvaluator25loadWorkunitsAndPart
GroupEPNS0_5QueueERb + 0x260
  [7] 0x00002B37DA966E6E
_ZN7ibm_cde5query23GetJoinPayloadEvaluator26processInputsSynchro
nouslyEv + 0x180E
  [8] 0x00002B37D8DA797D
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x4CD
  [9] 0x00002B37D8D256F4
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x304
  [10] 0x00002B37D96A191C
_ZN7ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRout
ineERmj + 0x64C
  [11] 0x00002B37D96A5070
_ZN7ibm_cde5query9Scheduler15runWorkerThreadEPvPi + 0x2F0
  [12] 0x00002B37D96B4E8E
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E
  [13] 0x00002B37DA20A27E
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x27E
  [14] 0x00002B37DEAE877F _Z14sqlriInvokeCdeP8sqlrr_cb + 0x3F
  [15] 0x00002B37DE9475A5
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4F5
  [16] 0x00002B37DE3530EB
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xE6B
  [17] 0x00002B37DBD108BB
/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1 +
0x72A38BB
  [18] 0x00002B37DBD0F0EC _Z21sqleProcessSubRequestP8sqeAgent +
0x3EC
  [19] 0x00002B37DBD44754 _ZN8sqeAgent6RunEDUEv + 0x604
  [20] 0x00002B37DF82F19E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
  [21] 0x00002B37DDC9BFBB sqloEDUEntry + 0x57B
  [22] 0x00002B37D44ADDD5 /lib64/libpthread.so.0 + 0x7DD5
  [23] 0x00002B37E777102D clone + 0x6D

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to db2 v115m4fp0 or later                            *
****************************************************************

Do not start Db2 trace

not known / see Local fix

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

17.04.2020
30.06.2020
30.06.2020