DB2 FOR LUW / DB2FORLUW / 980 - DB2

DB2_LARGE_PAGE_MEM=* is set in Windows 2003 ENT SVR 64bit to use 
large page memory, hit the OSERR(87) "The parameter is 
incorrect." and DIA8300C A memory heap error has occurred. 
 
CALLED  : OS, -, VirtualAlloc 
OSERR   : 87 "The parameter is incorrect." 
MESSAGE : Private memory and/or virtual address space exhausted 
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes 
65536 
DATA #2 : Current set size, PD_TYPE_SET_SIZE, 8 bytes 
128974848 
 
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:500 
MESSAGE : ZRC=0x8B0F0010=-1961951216=SQLO_NOMEM_BPH 
          "No memory available in 'Buffer Pool Heap'" 
          DIA8300C A memory heap error has occurred. 
DATA #1 : String, 35 bytes 
BufferPool memory allocation failed 
 
Windows API VirtualAlloc is requesed to allocate memory of size 
64KB with flag MEM_LARGE_PAGES. 
This is a non-standard allocation and the API fails with an 
error "The parameter is incorrect."

**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2_LARGE_PAGE_MEM=* is set in Windows 2003 ENT SVR 64bit    * 
* touselarge page memory, hit the OSERR(87) "The parameter     * 
* isincorrect." and DIA8300C A memory heap error has           * 
* occurred.CALLED  : OS, -, VirtualAllocOSERR  : 87 "The       * 
* parameter is incorrect."MESSAGE : Private memory and/or      * 
* virtual address spaceexhaustedDATA #1 : Requested size,      * 
* PD_TYPE_MEM_REQUESTED_SIZE, 8bytes65536DATA #2 : Current set * 
* size, PD_TYPE_SET_SIZE, 8 bytes128974848FUNCTION: DB2 UDB,   * 
* buffer pool services, sqlbinit, probe:500MESSAGE :           * 
* ZRC=0x8B0F0010=-1961951216=SQLO_NOMEM_BPH"No memory          * 
* available in 'Buffer Pool Heap'"DIA8300C A memory heap error * 
* has occurred.DATA #1 : String, 35 bytesBufferPool memory     * 
* allocation failedWindows API VirtualAlloc is requesed to     * 
* allocate memory ofsize64KB with flag MEM_LARGE_PAGES.This is * 
* a non-standard allocation and the API fails with anerror     * 
* "The parameter is incorrect."                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.8 Fix Pack 3                        * 
****************************************************************

remove DB2_LARGE_PAGE_MEM=* registry for work around

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem was first fixed in DB2 Version 9.8 Fix Pack 3

not known / see Local fix

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

17.02.2010
10.01.2011
10.01.2011

9.8.FP3