IBM Support

JR35276: DB2 FAILS TO ALLOCATE MEMORY WHEN DB2_LARGE_PAGE_MEM=* CONFIG PARAMETER IS SET ON WINDOWS SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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."
    

Local fix

  • remove DB2_LARGE_PAGE_MEM=* registry for work around
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Windows                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ERROR DESCRIPTION:DB2_LARGE_PAGE_MEM=* is set in Windows2003 *
    * ENT SVR 64bit touselarge page memory, hit the OSERR(87)"The  *
    * parameter isincorrect." and DIA8300C A memory heaperror has  *
    * occurred.CALLED  : OS, -, VirtualAllocOSERR   : 87"The       *
    * parameter is incorrect."MESSAGE : Private memory             *
    * and/orvirtual address spaceexhaustedDATA #1 : Requested      *
    * size,PD_TYPE_MEM_REQUESTED_SIZE, 8bytes65536DATA #2 :        *
    * Current setsize, PD_TYPE_SET_SIZE, 8 bytes128974848FUNCTION: *
    * DB2 UDB,buffer pool services, sqlbinit, probe:500MESSAGE     *
    * :ZRC=0x8B0F0010=-1961951216=SQLO_NOMEM_BPH"No                *
    * memoryavailable in 'Buffer Pool Heap'"DIA8300C A memory heap *
    * errorhas occurred.DATA #1 : String, 35 bytesBufferPool       *
    * memoryallocation failedWindows API VirtualAlloc is requesed  *
    * toallocate memory ofsize64KB with flag MEM_LARGE_PAGES.This  *
    * isa non-standard allocation and the API fails with           *
    * anerror"The parameter is incorrect."                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Problem was first fixed in Version 9.5 Fix Pack 6            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6
    
    LOCAL FIX:
    remove DB2_LARGE_PAGE_MEM=* registry for work around
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR35276

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-05

  • Closed date

    2010-09-09

  • Last modified date

    2010-09-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC65447 IC66394

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 September 2010