DB2 - Problem description
Problem IT30770 | Status: Closed |
SORTHEAP IS TOO SMALL | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
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))" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to fixpack when available * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.10.2019 30.04.2020 30.04.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |