DB2 FOR LUW / DB2FORLUW / 970 - DB2

Concurrently executing CREATE EVENT MONITOR statements may 
deadlock.  Deadlock event monitor output shows that both 
statements are holding row locks in SYSIBM.SYSTABLES that the 
other application is requesting.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Version 9.7 GA through to Fix Pack 1 servers on      * 
* Linux, Unix and Windows platforms executing concurrent       * 
* create event monitor statements.                             * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Create event monitor statements which are defined to make    * 
* use of tables (either explicitly specified in the create     * 
* statement, or implicitly defined based on the event monitor  * 
* name), need to create these tables as part of the statement. * 
* Incorrect isolation levels while scanning SYSIBM.SYSTABLES   * 
* to carry out the necessary logic lead to the possibility of  * 
* deadlocks.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Avoid creating event monitors concurrently, or apply DB2     * 
* Version 9.7 Fix Pack 2.                                      * 
****************************************************************

Ensure that applications are not creating event monitors 
concurrently.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

Problem first fixed in DB2 Version 9.5 Fix Pack 6 and all 
subsequent Fix Packs.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC66789 
Nachfolger : 

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

23.02.2010
25.05.2010
25.05.2010

9.5.FP6,
9.7.FP2