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

DB2 CAN TRAP IN SQLOGETMEMPOOLSTATSUNLATCHED OR SQLRA_SQLW_RAW_D UMP, WHEN
STACKS OR DUMPS BEING COLLECTED ON THE ACTIVE AGENTS.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In very rare timing hole, DB2 can trap when stack trace are 
dumped. 
Few ways to dump stacks, which may result in this type of crash. 
 
db2pd -stack all 
db2pd -dump all 
kill -23 on db2sysc process on Linux 
 
 
You can check the db2diag.log for this type of messages: 
 
2012-07-26-09.21.17.769725-240 I60976190E527 LEVEL: Severe 
PID : 26093 TID : 46921704008000PROC : db2sysc 1 
INSTANCE: xxx NODE : 001 
EDUID : 60342 EDUNAME: db2agntdp (xxx ) 1 
FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_raw_dump, 
probe:175 
MESSAGE : MASTER TIME INFO 
DATA #1 : Hexdump, 32 bytes 
0x00002AAB000C13F8 : B4E2 0B50 0000 0000 A303 0000 8236 0E00 
...P.........6.. 
0x00002AAB000C1408 : 8336 0E00 B4E2 0B50 0000 0000 0000 0000 
.6.....P........ 
 
This could be one of the stack dumped with signal #11 during the 
crash. 
 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        GLIBC_PRIVATE 
5        sqloGetMemPoolStatsUnlatched 
6        ICCC_GetLibraryError 
7        sqlra_sqlWC_get_common 
8        sqlra_sqlW_raw_dump 
9        sqlrr_signal_handler 
10       sqloExecuteEDUExitList 
11       sqloDumpDiagInfoHandler 
12       GLIBC_PRIVATE 
13       semtimedop 
 
You can notice from the stack sqlra_sqlW_raw_dump, which is seen 
during the stack dump.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users collecting stacks or dumps on db2 process.             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please avoid running stack dumps.                            * 
****************************************************************
Local-Fix:
Avoid running stack dumps when possible.
verfügbare FixPacks:
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
APAR will be first fixed in Fixpack 9.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.08.2012
16.12.2013
16.12.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.0.
Problem behoben lt. FixList in der Version
9.7.0.9 FixList
9.7.0.9 FixList