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