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

DB2 can crash during automatic statistics processing under rare
circumstances

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Under rare circumstances, with AUTO_RUNSTATS enabled, you might 
experience a crash with a stack that includes sqlrr_atm and 
sqlrlc_foreach, for example: 
 
stack trace: 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        __pthread_mutex_cond_lock 
5        entryCallback 
6        sqlrlc_foreach 
7        atmGetHardeningList 
8        atmAPI 
9        sqlrr_atm 
10       atmAPIEntry 
11       sqlerKnownProcedure 
 
You can also observe the following entry in the db2diag.log: 
 
2011-09-14-15.20.19.819600+540 I1244631E561        LEVEL: Severe 
 
PID     : 2646                 TID  : 47155783919936  PROC : 
db2sysc 0 
INSTANCE: db2inst1       NODE : 000                   DB   : 
SAMPLE 
APPHDL  : 0-3604           APPID: *LOCAL.db2inst1.110914062023 
AUTHID  : DB2INST1      EDUID   : 93                   EDUNAME: 
db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, RAS/PD component, 
pdResilienceIsSafeToSustain, probe:800 
DATA #1 : String, 37 bytes 
Trap Sustainability Criteria Checking 
DATA #2 : Hex integer, 8 bytes 
0x0000000400001040 
DATA #3 : Boolean, 1 bytes 
false 
 
The purpose of this apar is to prevent this crash to happen. 
 
Note: Since this APAR was created, root cause has been 
determined as APAR IC81500.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.7 FP6                                   * 
****************************************************************
Local-Fix:
Disable automatic statistics by setting AUTO_RUNSTATS to OFF.
verfügbare FixPacks:
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

Lösung
First fixed in V9.7 FP6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
16.12.2011
19.06.2012
19.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList