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

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

product:
DB2 FOR LUW / DB2FORLUW / A10 - 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. 
 
Client re-route is one method that can potentially flow 
EXCSQLSET drda request frequently. 
 
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 10.1                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 10.1 FixPack 1.                           * 
****************************************************************
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.
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 10.1 FixPack 1.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.06.2012
03.11.2012
03.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 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.