|
Problem IC78654
|
Status: Closed |
INSTANCE CAN TRAP WHEN CALLING EVMON_FORMAT_UE_TO_XML |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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) ) )" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* INSTANCE CAN TRAP WHEN CALLING EVMON_FORMAT_UE_TO_XML *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 Fixpack 6. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First Fixed in v9.7 Fixpack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2011
13.06.2012
13.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
