DB2 FOR LUW / DB2FORLUW / 970 - DB2

There is an issue with the dumping of diagnostics in the 
subagent and coordinator agent in parallel create index. 
 
For Parallel Index Create, we have a coordinator agent waiting 
to receive on one end of a table queue, while a set of subagents 
are sending from the other end. The problem is that when agent 
dumps are generated via db2pd -dump all, the table queue data in 
the subagent dump refers to that from the coordinator (receiver) 
side. And the coordinator agent dump doesn't actually contain 
any table-queue data for the receiver side. 
 
Each subagent should have reference to it's own sender 
side table queue control block, which would also contain all the 
channel information. This needs to be dumped.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7.0.6.                              * 
****************************************************************

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
 

The problem is first fixed in DB2 version 9.7.0.6.

not known / see Local fix

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

06.12.2011
07.06.2012
07.06.2012

9.7.0.6