Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT02777 Status: Closed

DEAD LATCH WHEN RUNNING TRUNCATE TABLE OPERATION AND ANOTHER AGENT LOOKS TO
FLUSH THE BUFFERPOOL

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v9.7 Fixpack 10 or Later                  * 
****************************************************************
Local Fix:


Solution


First Fixed in DB2 LUW v9.7 Fixpack 10


Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.06.2014
10.11.2014
10.11.2014


Problem solved at the following versions (IBM BugInfos)


9.7.FP10



Problem solved according to the fixlist(s) of the following version(s)


9.7.0.10

FixList