DB2 FOR LUW / DB2FORLUW / 970 - DB2

This trap will be triggered in situations where DB2 have the new 
locking event monitor running, and there are lock conflicts in 
the path of a backup operation in progress, resulting in 
lockwait events.  Typical stack trace will be: 
 
Stack #1             Signal #11        Timestamp 
 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        __pthread_mutex_cond_lock 
5        sqmLockEvents::collectRequestorAppInfo 
6        sqmLockEvents::collectLockEvent 
7        sqlplnfd 
8        sqlplrq 
9        SqlubTableLock::request 
10       sqlubReadSMS 
11       sqlubBMCont 
12       sqlubbuf 
13       sqleSubCoordProcessRequest 
14       sqeAgent::RunEDU 
15       sqzEDUObj::EDUDriver 
16       sqlzRunEDU 
17       sqloEDUEntry 
18       pthread_create@@GLIBC_2.2.5 
19       clone

Users Effected: 
 
Problem Description: 
DB2 TRAPPED WITH SIGSEGV ON BACKUP THREAD (DB2BM) WITH 
SQMLOCKEVENTS::COLLECTREQUESTORAPPINFO IN STACK TRACE 
 
Problem Summary: 
 
This trap will be triggered in situations where DB2 have the new 
 
locking event monitor running, and there are lock conflicts in 
the path of a backup operation in progress, resulting in 
lockwait events.  Typical stack trace will be: 
 
Stack #1             Signal #11        Timestamp 
 
0        ossDumpStackTraceEx 
1        OSSTrapFile::dumpEx 
2        sqlo_trce 
3        sqloEDUCodeTrapHandler 
4        __pthread_mutex_cond_lock 
5        sqmLockEvents::collectRequestorAppInfo 
6        sqmLockEvents::collectLockEvent 
7        sqlplnfd 
8        sqlplrq 
9        SqlubTableLock::request 
10       sqlubReadSMS 
11       sqlubBMCont 
12       sqlubbuf 
13       sqleSubCoordProcessRequest 
14       sqeAgent::RunEDU 
15       sqzEDUObj::EDUDriver 
16       sqlzRunEDU 
17       sqloEDUEntry 
18       pthread_create@@GLIBC_2.2.5 
19       clone

disable the new lock event monitor (the monitor created with 
'CREATE EVENT MONITOR FOR LOCKING')

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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
 

defect  wsdbu00845928 
CSD     First fixed in DB2 UDB Version 9.7, FixPak 5 
module  engn_sqm

Upgrade to DB2 Version Version 9.7, FixPak 5

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

28.06.2011
07.12.2011
07.12.2011

9.7.