home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC77384 Status: Geschlossen

INSTANCE TRAP AFTER LOAD OPERATION FAILS AT VERY EARLY STAGE (USUALLY DUE
TO OUT OF SYSTEM RESOURCES)

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 LOAD users on Version 9.1 Fixpack 10                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.1 Fix Pack 11.                      * 
****************************************************************
Local-Fix:
n/a (Proactively avoid hitting out of system resources, would 
avoid hitting this issue)
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
First fixed in Version 9.1 Fix Pack 11.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC77659 IC77660 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
07.07.2011
09.12.2011
09.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP11
Problem behoben lt. FixList in der Version
9.1.0.11 FixList