|
Problem IT06540
|
Status: Closed |
EXCESSIVE OVERHEAD IN SHARED SORT MEMORY, DATABASE MEMORY WHEN EXECUTING QUERIES ON COLUMN_BASED DATA |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 systems using column-based storage *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
Allow for the additional overhead when configuring the system
(for example, reduce SHEAPTHRES_SHR by 10-25% to allow for the
additional overhead requirement) |
| Solution |
Problem first fixed in DB2 Version 10.5 Fix Pack 7 |
| Workaround |
See Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.01.2015
18.02.2016
18.02.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
