These two problems could happen as a result of recent memory
management enhancements:
1. A failure during reporting of SQL0955N error:
EDUID : 971 EDUNAME: db2agntcol (xxx) 1
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx,
probe:1000
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
memory addr"
DIA8561C A invalid memory block was encountered.
DATA #1 : String, 43 bytes
Memory management block allocation failure.
DATA #2 : Codepath, 8 bytes
8
DATA #3 : Memory pool handle pointer,
PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
0x0000100a58a55e00
stack (from -955
0x0000101B40FE80B0 0x00001000108486F0
_Z36sqlsDumpSingleQueryDiagnosticsFor955P8sqlrr_cbPc14pdOutageTy
pe_t + 0x0cc0
0x0000101B40FE97C0 0x000010001084A120
_Z21sqlsGet955DiagMessage16SQLS_MEMCONSUMERP19STMM_OpAllocMonito
rPcm + 0x0780
0x0000101B40FE9DB0 0x0000100004E213B8
_ZN7ibm_cde8services4Heap20throwMemoryExceptionEimPKcmS3_mPKv +
0x02b8
0x0000101B40FEB850 0x0000100004E1ECEC
_ZN7ibm_cde8services4Heap8allocMemEPKcmS3_mP13SQLO_MEM_POOLm +
0x020c
0x0000101B40FEB970 0x000010000504CD10
_ZN7ibm_cde5types9BitStringC1EPKcmS3_mbP13SQLO_MEM_POOL + 0x0080
0x0000101B40FEBA10 0x0000100007857D88
_ZN7ibm_cde5query13NaryEvaluator16evaluateCoalesceINS_5types7Int
egerIiEEEEvv + 0x0228
note the pool handle on stack :
0x0000101B40FEB840: 0x0000100A58A55E00 0x0000000000000000
0x0000101B40FEB850 0x0000100004E1ECEC
_ZN7ibm_cde8services4Heap8allocMemEPKcmS3_mP13SQLO_MEM_POOLm +
0x020c
2. SQL0901N :
EDUID : 1959 EDUNAME: db2agntcol (xxx) 1
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:601
DATA #1 : String, 135 bytes
AssertionFailedException: An assertion 'pMon != 0' failed.
Additional info: Bad pMon value: 0x0000000000000000
Thrown at Heap.cpp : 601
DATA #2 : Function name in Library, 8 bytes
allocMem
DATA #3 : File name, 8 bytes
Heap.cpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x0000100003D4EAE0 pdLog + 0x640
[1] 0x0000100004EA4EC8
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0xB38
[2] 0x0000100004DFAA40
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x220
[3] 0x0000100004DEFA5C
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xFC
[4] 0x0000100004E22AF8
_ZN7ibm_cde8services4Heap8allocMemEPKcmS3_mP13SQLO_MEM_POOLm +
0x1078
[5] 0x000010000504FD10
_ZN7ibm_cde5types9BitStringC1EPKcmS3_mbP13SQLO_MEM_POOL + 0x80
[6] 0x0000100007860348
_ZN7ibm_cde5query13NaryEvaluator16evaluateCoalesceINS_5types7Int
egerIiEEEEvv +
..... |
