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

TRAP IN SQLPKILLIFWAITING AFTER DEADLOCK

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
DB2 might trap with the following stack when there is a 
deadlock and at least one of the involved transactions is in 
one of these states (shown in db2pd -db <dbname> -transactions 
output collected as part of FODC): Prepare (PREP), Abort 
(ABORT), Commit (COMMIT), or Rollback to Save Point (SAVEPNT). 
 
0        ossDumpStackTraceInternal 
1        ossDumpStackTraceV98 
2        OSSTrapFile::dumpEx 
3        sqlo_trce 
4        sqloEDUCodeTrapHandler 
5        __PRETTY_FUNCTION__.6093 
6        sqlpKillIfWaiting 
7        sqlpCheckAndKillTransaction 
8        sqlplLDDResolveLocalDeadlocks 
9        sqlpldl 
10       sqpLLMEdu::RunEDU 
11       sqzEDUObj::EDUDriver 
12       sqloEDUEntry 
13       pthread_tryjoin_np 
14       clone 
 
Note the agent that will be trapping is the deadlock 
detector EDU (db2dlock). 
 
EDUNAME: db2dlock (<database_name>) 0 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:90 
MESSAGE : ADM14011C  A critical failure has caused the following 
type of error: 
          "Trap". The DB2 database manager cannot recover from 
the failure. 
          First Occurrence Data Capture (FODC) was invoked in 
the following 
          mode: "Automatic". FODC diagnostic information is 
located in the 
          following directory:
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 and Fix Pack 5                   * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 Version 10.5 and Fix Pack 4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.06.2014
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList