DB2 FOR LUW / DB2FORLUW / 950 - DB2

Memory allocation requirements of both LOAD and table 
compression dictionaries are inefficient, causing memory wastage 
and fragmentation.  In the case of table compression 
dictionaries, excessive memory pool level overhead (logical size 
- physical size) may be seen in db2pd -alldbs -mempools output 
for the database heap.  In the case of LOAD, frequent load 
operations may lead to an increase in database memory set level 
requirements due to fragmentation overhead. 
 
Symptoms include excess memory usage and possibly SQL0973 with 
the following db2diag.log message. 
 
EDUID   : 8786                 EDUNAME: db2lload 0 
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 
DATA #1 : String, 143 bytes 
LOADID: XXXXX 
Failed to enable fast memblocks , -1961951227, 0, Detected in 
file:sqlulbuf2.C, Line:2014

**************************************************************** 
* USERS AFFECTED:                                              * 
* All systems are affected                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix pack 10                       * 
****************************************************************

Problem first fixed in DB2 Version 9.5 Fix Pack 10

not known / see Local fix

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

01.03.2012
06.09.2012
25.11.2013

9.5.FP10