DB2 FOR LUW / DB2FORLUW / 970 - DB2

This issue is a timing condition that can result in an 
application hang.  Other queries and applications in the 
database will not be affected. 
 
There are a number of conditions that have to happen that allow 
for a timing window when this problem can occur as follows: 
- DPF database 
- an access plan that involves table queues where one subsection 
will receive on one tablequeue and then send into another 
different table queue. 
- in between the two table queues in the access plan, there is a 
type of join that features the ability to do an "early out", 
such as a merge join. 
- during the query execution, some of the table queue processing 
have caused table queue spilling. 
- one of the partition's subsections that is producing rows and 
sending into the table queue finishes producing data and enters 
the table queue closing codepath with a particular timing.

APPLICATION HANG IN DPF DATABASE

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 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 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 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 was first fixed in Version 9.7 Fixpak 1

not known / see Local fix

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

13.08.2009
19.12.2009
19.12.2009

9.7.