DB2 FOR LUW / DB2FORLUW / B10 - DB2

This diag log may indicate that we hit
SQLS_MEMCONSUMER_CDE_JOIN_TEMP sort operator elasticizing case
and it may result in a 955 situation if we still can not
guarantee memory even with Sort elasticizing.

2019-10-03-04.55.07.856867+060 I17897265E4552        LEVEL:
Warning
PID     : 36074                TID : 47739039639296  PROC :
db2sysc 19
INSTANCE: db2inst1             NODE : 019            DB   :
BLUDB
APPHDL  : 0-42671              APPID:
10.85.200.124.58808.191003035452
UOWID   : 3                    ACTID: 2
AUTHID  : PP2DATASTAGE         HOSTNAME: dashmpp-data2-0
EDUID   : 320627               EDUNAME: db2agntcol (BLUDB) 19
FUNCTION: DB2 UDB, sort/list services,
sqlsReserveSharedSortSpace, probe:5477
DATA #1 : String, 186 bytes
SQLS_MEMCONSUMER_CDE_JOIN_TEMP sort operator elasticizing.
                        sortheap (4K pages): 238205
                        pagesWanted (4K pages): 476411
                        pagesHeld (4K pages): 238205
                        minimumNeeded (4K pages): 0

CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
  [0] 0x00002B5A01897D3A
_Z26sqlsReserveSharedSortSpaceP8sqeAgent16SQLS_MEMCONSUMERjjjjbP
jPP19STMM_OpAllocMonitorb + 0x48A
  [1] 0x00002B5A011E2E08
_Z21sqlriReserveSortSpaceP8sqlrr_cbjm16SQLS_MEMCONSUMERjjljlPjlP
lPP19STMM_OpAllocMonitorb + 0xE8
  [2] 0x00002B59FE084A3A
_ZN7ibm_cde5query12QueryMemMgmt7reserveEllb + 0x13A
  [3] 0x00002B59FE06C35D
_ZN7ibm_cde5query12QueryMemMgmt20maximizeReservePagesEmb + 0x8D
  [4] 0x00002B59FE069500
_ZN7ibm_cde5query13JoinSpillInfo10managePartEmmmRl + 0x1350
  [5] 0x00002B59FE06786E
_ZN7ibm_cde5query13JoinSpillInfo11manageSpillEmNS1_14JoinSpillPh
aseElm + 0x45E
  [6] 0x00002B59FE0655E5
_ZN7ibm_cde5query13JoinSpillInfo15buildHashTablesEm + 0x245
  [7] 0x00002B59FD157DDC
_ZN7ibm_cde5query23BuildHashTableEvaluator26processInputsSynchro
nouslyEv + 0x24C

Note:
The memory leak can be checked using:
db2 -v "select member, sort_shrheap_allocated,
SORT_HEAP_ALLOCATED from table(mon_get_database(-2))"

****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to fixpack when available                            *
****************************************************************

not known / see Local fix

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

30.10.2019
30.04.2020
30.04.2020