DB2 FOR LUW / DB2FORLUW / 970 - DB2

The problem only happen when customer is using the "set current 
package path" and db2 try to use the package that is not the 
default one. 
 
  When db2 work on a new statement, monitor code will try to 
check if the statement is new or not. If it is a new statement, 
it will create a new entry in the statement list. However, 
monitor code create the entry before RDS able to resolve the 
package path. So we got code to update the creator  in the 
statement list to the new creator. That is not correct. Because 
next time when the agent work on the same statement, Monitor 
will think it is a new statement and it will create other entry 
in the statement list again. And monitor end up with a huge 
statement list , as we can see in the customer case. 
 
Operating system and level: 
 
All system 
 
System setup 
 
All setup 
 
Diagnostic information: 
 
list application show lot of statement

**************************************************************** 
* USERS AFFECTED:                                              * 
* An entry is added to statement list prior to resolving       * 
* package path resulting into a large monitor                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The problem only happen when one is using the "set current   * 
* package path" and db2 try to use the package that is not the * 
* default one.                                                 * 
*                                                              * 
*   When db2 work on a new statement, monitor code will try to * 
* check if the statement is new or not. If it is a new         * 
* statement, it will create a new entry in the statement list. * 
* However,  monitor code create the entry before RDS able to   * 
* resolve the package path. So we got code to update the       * 
* creator  in the statement list to the new creator. That is   * 
* not correct. Because  next time when the agent work on the   * 
* same statement, Monitor will think it is a new statement and * 
* it will create other entry in the statement list again. And  * 
* monitor end up with a huge statement list                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First Fixed DB2 v9.7 fixpak 5                                * 
****************************************************************

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 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
 

not known / see Local fix

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

07.07.2011
02.01.2012
02.01.2012

9.7.