DB2 FOR LUW / DB2FORLUW / 970 - DB2

A deadlatch  situation can occur when running TRUNCATE TABLE 
operation and another  EDU tries to FLUSH the BUFFERPOOL, either 
via the FLUSH BUFFERPOOL statement, or a command that also 
requires the BUFFERPOOLs to be FLUSHED (e.g. Online Backup). 
 
db2pd -latches 
 
may show :  a lot of Waiters on latch : 
SQLO_LT_SQLB_BufferPool__prevBPDCachingLatch and the EDU holding 
this latch, waiting on SQLO_LT_SQLB_BPD__bpdLatch_SX.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v9.7 Fixpack 10 or Later                  * 
****************************************************************

First Fixed in DB2 LUW v9.7 Fixpack 10

keiner bekannt / siehe Local-Fix

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

25.06.2014
10.11.2014
10.11.2014

9.7.FP10