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