|
Problem IC78664
|
Status: Closed |
MEMORY ALLOCATION FAILURE DURING DATABASE ACTIVATION RESULTING IN INSTANCE ABEND IN SQLBTERMBUFFERPOOL |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* See APAR description *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 for Linux, UNIX, and Windows 9.7 Fix Pack 6 *
**************************************************************** |
| 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. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 for Linux, UNIX, and Windows 9.7 Fix
Pack 6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2011
06.06.2012
06.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
