DB2 FOR LUW / DB2FORLUW / A50 - DB2

Certain malloc options were inadvertently left in place for DB2 
10.5 GA and up.  The multiheap and buckets options were meant to 
be temporary during development and should be removed.  These 
options cause excessive fragmentation and private virtual memory 
usage within DB2.  However, they do not impact normal operations 
as they do not normally result in additional system memory usage 
- it is only process address space that is consumed. 
 
Symptoms are visible only when diagnostics are generated or 
certain service tools are run: 
 
1. db2pd -memblocks pid=<db2sysc pid> and manual core generation 
will commit the excess address space, which will significantly 
increase DB2 memory usage, possibly causing system performance 
problems. 
 
2. coredumps generated when DB2 aborts may be much larger than 
necessary, consuming additional disk space. 
 
Note if MALLOCOPTIONS is still required after this change, it 
can be set manually, for example 
add required options to sqllib/userprofile, as in 
export MALLOCOPTIONS=MULTIHEAP:4 
 
add MALLOCOPTIONS to DB2's accepted environment variable list : 
db2set DB2ENVLIST=MALLOCOPTIONS (requires db2stop/db2start)

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 on AIX systems are affected                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Problem first fixed in DB2 Version 10.5 Fix Pack 7           * 
****************************************************************

add the following line to sqllib/userprofile : 
export MALLOCOPTIONS=

Problem first fixed in DB2 Version 10.5 Fix Pack 7

See Local Fix

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

09.12.2014
18.02.2016
18.02.2016