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 IC80713 Status: Closed

PACKAGE CACHE MAY BE FILLED UP WITH MANY VARIATIONS OF "SET CURRENT
..." STATEMENTS.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
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"
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 UDB Version 9.5.                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 FixPack 10.                           * 
****************************************************************
Local Fix:
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.
Solution
Problem was first fixed in DB2 UDB Version 9.5 FixPack 10.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
09.01.2012
28.08.2012
28.08.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.