|
Problem IC77659
|
Status: Closed |
INSTANCE TRAP AFTER LOAD OPERATION FAILS AT VERY EARLY STAGE (USUALLY DUE TO OUT OF SYSTEM RESOURCES) |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
You may encounter an instance trap after a LOAD operation fails
(usually due to out of system resources) at a specific place
very early on (at LOAD startup stage).
The db2diag.log may show the following message indicating out of
memory condition, or other message indicating out of system
resources:
2011-07-03-22.08.15.079591+120 I289048634E522 LEVEL: Error
PID : 29498 TID : 47458223191968PROC :
db2agent (SAMPLE)
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-362 APPID:
*LOCAL.db2inst1.110703200802
AUTHID : DB2INST1
FUNCTION: DB2 UDB, data protection services, sqlpwpen, probe:10
RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH
"No memory available in 'Database Heap'"
DIA8302C No memory available in the database heap.
The stack of failing LOAD buffer manipulator (db2lbm) looks
like:
ossDumpStackTrace
OSSTrapFile::dump
sqlo_trce
sqloEDUCodeTrapHandler
__invoke_dynamic_linker__
sqluTermLoadEDU
sqluInitLoadEDU
sqlulbuf
sqloCreateEDU
sqloSpawnEDU
sqlulInitOneEDU
sqlulInitNBM
sqlulCreateQAndEDU
sqluvload
call_sqluvload
It may be another LOAD process than db2lbm that fails; the
common signature is sqluInitLoadEDU() calls sqluTermLoadEDU()
and we trap inside sqluTermLoadEDU().
DB2 fails (due to out of system resource) early in LOAD
initialization code before setting up some internal pointers.
During LOAD termination DB2 frees resources and dereferences the
not initialzed pointer and traps. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All DB2 LOAD users on Version 9.5 Fixpack 8 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 FixPack 9 or later. *
**************************************************************** |
| Local Fix: |
n/a (Proactively avoid hitting out of system resources, would
avoid hitting this issue) |
| available fix packs: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Version 9.5 FixPack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.07.2011
14.03.2012
14.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.9
|
 |
