DB2 - Problembeschreibung
Problem IC80713 | Status: Geschlossen |
PACKAGE CACHE MAY BE FILLED UP WITH MANY VARIATIONS OF "SET CURRENT ..." STATEMENTS. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.5 FixPack 10. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.01.2012 28.08.2012 28.08.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP10 | |
Problem behoben lt. FixList in der Version | |
9.5.0.10 |