DB2 FOR LUW / DB2FORLUW / 970 - DB2

The trap occurs when evmon_format_ue_to_xml is told to parse 
partial 
events and a DEADLOCK record has neither lock request nor lock 
owner 
information (that is, it only has a deadlock graph record). 
 
The problem can be avoided by NOT specifying the 
LOG_PARTIAL_EVENTS 
option when calling evmon_format_ue_to_xml.  Note that this only 
affects 
the locking event monitor adn the old DEADLOCKS WITH DETAILS 
event 
monitor is unaffected.  The customer can also use that event 
monitor 
to avoid the issue. 
 
Stack #1             Signal #11        Timestamp 
2011-08-30-10.55.25.455142 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        __invoke_dynamic_linker__ 
5        monEvmonLockEvent::XMLBeginLockEvent 
6        monEvmonLockEvent::GenerateXMLDocument 
7        monLockEventFormatter::LogPartialEvents 
8        monEvmonUEToStreamCommon 
9        monEvmonUEToXML 
10       sqloInvokeFnArgs 
11       sqlriInvokerTrusted 
12       sqlriInvokeInvoker 
13       sqlri_close_udf_eos 
14       sqlricls_complex 
15       sqlricls 
16       sqlriecc 
17       sqlrr_process_close_request 
18       sqlrr_close 
19       sqljs_ddm_clsqry 
20       sqljsParseRdbAccessed 
21       sqljsParse 
22       sqljsSqlam 
23       sqljsDriveRequests 
24       sqljsDrdaAsInnerDriver 
25       sqljsDrdaAsDriver 
26       sqeAgent::RunEDU 
27       sqzEDUObj::EDUDriver 
28       sqlzRunEDU 
29       sqloEDUEntry 
30       pthread_cond_broadcast@@GLIBC_2.3.2 
31       __clone 
 
The problem can be recreated by using the following steps: 
 
db2 update db cfg for sample using mon_deadlock hist_and_values 
db2 connect to sample 
db2 create event monitor lk for locking write to unformatted 
event table manualstart 
db2 set event monitor lk state 1 
<create a deadlock> 
db2 set event monitor lk state 0 
db2 delete from lk where record_type = 0 
db2 delete from lk where record_type = 1 
db2 "SELECT XMLPARSE(DOCUMENT xmlreport) FROM TABLE( 
EVMON_FORMAT_UE_TO_XML( 'LOG_PARTIAL_EVENTS;LOG_ALL_TO_FILE', 
FOR EACH ROW OF (select * from lk) ) )"

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* INSTANCE CAN TRAP WHEN CALLING EVMON_FORMAT_UE_TO_XML        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6.                                   * 
****************************************************************

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
 

First Fixed in v9.7 Fixpack 6.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.09.2011
13.06.2012
13.06.2012

9.7.FP6