A fix is available
APAR status
Closed as program error.
Error 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"
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.
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. * ****************************************************************
Problem conclusion
Problem was first fixed in DB2 UDB Version 9.5 FixPack 10.
Temporary fix
Comments
APAR Information
APAR number
IC80713
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-01-09
Closed date
2012-08-28
Last modified date
2012-08-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
R950 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5"}]
Document Information
Modified date:
20 September 2021