DB2 FOR LUW / DB2FORLUW / A50 - DB2

Excessive memory overhead may occur withing shared sort memory 
when executing queries on column-based data, leading to various 
symptoms associated with high memory usage - SQL0955, paging, 
out of memory errors. 
 
In order to identify that this APAR is a match for a given 
problem, confirm that the physical size of the sort memory 
subpool is both large enough to be impacting the system AND 
significantly exceeds the logical size (say by more than 10%). 
 
For example : 
db2pd -alldbs -mempools 
 
Memory Pools: 
MemSet PoolName LogSz      PhySz       CfgSize 
SAMPLE shsorth  8950812168 15287517184 41538355200

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 systems using column-based storage                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7                       * 
****************************************************************

Allow for the additional overhead when configuring the system 
(for example, reduce SHEAPTHRES_SHR by 10-25% to allow for the 
additional overhead requirement)

Problem first fixed in DB2 Version 10.5 Fix Pack 7

See Local Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

16.01.2015
18.02.2016
18.02.2016