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 IC73785 Status: Geschlossen

DB2 MAY CRASH AFTER AN OUT-OF-STATEMENT-HEAP ERROR.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
After "Out of memory failure for Statement Heap" errors, 
db2agent may crash with the following callstack: 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        OSSTrapFile::dump 
3        sqlo_trce 
4        sqloEDUCodeTrapHandler 
5        __invoke_dynamic_linker__ 
6        sqlnq_pid::set_flag 
7        sqlns_bld_error_check_for_restrict_box 
8        sqlns_ri_restrict_bld_correlation 
9        sqlns_ri_restrict 
10       sqlns_ri 
11       sqlns_cmpl_cstrnts 
12       sqlns_cmpl_cstrnts_main 
13       sqlns_exp_constraints 
14       sqlns_qgs 
15       sqlnn_cmpl 
16       sqlnn_cmpl 
17       sqlra_compile_var 
18       sqlra_find_var 
19       sqlra_get_var 
 
We will run into this crash when the following conditions are 
met: 
1. Out of memory failure for Statement Heap error reported in 
the d2diag.log 
 
 
2. One of the following situations is encountered: 
  a. INSERT/UPDATE on a child table that has 2 or more foreign 
key constraints, OR 
  b. DELETE from a parent table that has 2 or more foreign key 
constraints both defined with the same NOACTION 
      or RESTRICT delete rule, OR 
  c. UPDATE a parent table that has 2 or more foreign key 
constraints both defined with the same NOACTION 
      or RESTRICT delete rules
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See above.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pack 8 or a later release that    * 
* includes the fix.                                            * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.5 Fix Pack 8.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC74072 IC74073 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.01.2011
11.07.2011
11.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList