IC78638: MEMORY ALLOCATION FAILURE DURING DATABASE ACTIVATION RESULTING IN INSTANCE ABEND IN SQLBTERMBUFFERPOOL

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When a memory allocation failure occurs during a database
    activation, SQL1224N will be returned, and the instance will be
    brought down, instead of the expected graceful SQL10003C which
    would not cause an instance abend. The following symptoms will
    be seen:
    
    db2diag.log
    ===========
    2011-09-13-11.42.48.042813-240 I8461E573           LEVEL: Error
    PID     : 2768                 TID  : 47927577798976PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : TEST
    APPHDL  : 0-7                  APPID:
    *LOCAL.db2inst1.110913154221
    AUTHID  : DB2INST1
    EDUID   : 16                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbAllocateAndInitHashTable, probe:40
    MESSAGE : ZRC=0x8B0F0010=-1961951216=SQLO_NOMEM_BPH
              "No memory available in 'Buffer Pool Heap'"
              DIA8300C A memory heap error has occurred.
    
    2011-09-13-11.44.24.006867-240 I9035E623           LEVEL: Severe
    PID     : 2768                 TID  : 47927577798976PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-7                  APPID:
    *LOCAL.db2inst1.110913154221
    AUTHID  : DB2INST1
    EDUID   : 16                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:460
    MESSAGE : ZRC=0x8B0F0010=-1961951216=SQLO_NOMEM_BPH
              "No memory available in 'Buffer Pool Heap'"
              DIA8300C A memory heap error has occurred.
    DATA #1 : String, 40 bytes
    Hidden bufferpools initialization failed
    
    2011-09-13-11.44.24.007485-240 I10214E1879         LEVEL: Severe
    PID     : 2768                 TID  : 47927577798976PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000          DB   : SAMPLE
    APPHDL  : 0-7                  APPID:
    *LOCAL.db2inst1.110913154221
    AUTHID  : DB2INST1
    EDUID   : 16                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:10
    MESSAGE : Possible memory corruption detected.
    
    trap file
    =========
    EDU name     : db2agent (SAMPLE)
    Signal #11
    
    <StackTrace>
    sqloCrashOnCriticalMemoryValidationFailure
    SQLO_MEM_POOL::diagnoseMemoryCorruptionAndCrash
    sqloDiagnoseFreeBlockFailure
    sqlofmblkEx
    sqlofmblk
    sqlbTermBufferPool
    sqlbinit
    sqledint
    sqeLocalDatabase::FirstConnect
    

Local fix

  • Ensure there are no memory allocation errors during a database
    startup. The error (SQLO_NOMEM_BPH) is a consequence of a
    misconfigured operating system (shared memory kernel
    configuration parameters too low), or a lack of real memory.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * see APAR description                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * see APAR description                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB 9.5 Fix Pack 9                            *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 UDB 9.5 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78638

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-13

  • Closed date

    2012-03-08

  • Last modified date

    2012-03-08

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

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

    IC78664

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.5

Reference #:

IC78638

Modified date:

2012-03-08

Translate my page

Machine Translation

Content navigation