home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT02670 Status: Closed

TRAP IN SQLPKILLIFWAITING AFTER DEADLOCK

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 and Fix Pack 5                   * 
****************************************************************
Local Fix:
Solution
Problem was first fixed in DB2 Version 10.5 and Fix Pack 4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.06.2014
08.09.2014
08.09.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.4 FixList