DB2 FOR LUW / DB2FORLUW / 950 - DB2

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

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

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.

DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 UDB 9.5 Fix Pack 9

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC78664 
Nachfolger : 

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

13.09.2011
08.03.2012
08.03.2012

9.5.FP9