DB2 FOR LUW / DB2FORLUW / 950 - DB2

package cache may be filled up with variations of "SET 
CURRENT... " 
statement when these statements are sent via the EXCSQLSET drda 
request, sent to db2 server. 
This request type is the case when client reroute support is 
configured 
 
This problem can be confirmed with db2pd -db <dbname> -dynamic 
at "Dynamic SQL Variations:" section. Following is the sample of 
output showing high number of VarID column on the same 
AnchID,StmtUID, with Val column showing "N" ( not valid ) 
 
Address            AnchID StmtUID    EnvID      VarID 
NumRef     Typ Lockname                   Val Insert Time 
Sect Size 
 
0x0700000311DD0080 255    1          1          294289     1 
9   0000000100047D9100011FE256 N   2012-01-04-22.30.39.555702 
1736 
0x0700000311DE6E00 255    1          1          294288     1 
9   0000000100047D9000011FE256 N   2012-01-04-22.30.39.467800 
1736 
0x0700000311DE52A0 255    1          1          294287     1 
9   0000000100047D8F00011FE256 N   2012-01-04-22.30.39.201001 
1736 
0x0700000311DE3740 255    1          1          294286     1 
9   0000000100047D8E00011FE256 N   2012-01-04-22.30.39.107542 
1736 
0x0700000311DE1BE0 255    1          1          294285     1 
9   0000000100047D8D00011FE256 N   2012-01-04-22.30.39.011197 
1736 
0x0700000311DE0080 255    1          1          294284     1 
9   0000000100047D8C00011FE256 N   2012-01-04-22.30.38.924375 
1736 
0x0700000311DF6E00 255    1          1          294283     1 
9   0000000100047D8B00011FE256 N   2012-01-04-22.30.38.222125 
1736 
 
 
These redundant variation can not be flushed with "db2 flush 
package cache dynamic"

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.5.                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 FixPack 10.                           * 
****************************************************************

Reduce the package cache size, as these redundant variation will 
be dropped from package cache when db2 see package cache filled 
up to configured size, and it need new space in package cache.

Problem was first fixed in DB2 UDB Version 9.5 FixPack 10.

keiner bekannt / siehe Local-Fix

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

09.01.2012
28.08.2012
28.08.2012

9.5.FP10