home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC92227 Status: Geschlossen

MEMORY LEAK IN COMPILER MEMORY POOL WHEN COMPILING A SQL QUERY THAT
REFERENCES A FEDERATED DATA SOURCE

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
When a SQL query that references a federated data source is 
compiled, memory might be leaking in the sqlch memory pool.  The 
size of the leak depends on the number of data sources 
referenced, the number of columns in each data source and the 
column names. The problem was observed so far only for the DDL 
operations on the nicknames. 
 
To check if you hit this APAR, you need to collect a few 
iterations of db2pd -memblocks output, and seek for continuously 
increasing TotalSize(Bytes) and TotalCount values in following 
LOC and File: 
 
PoolID PoolName TotalSize(Bytes) TotalCount LOC 
File 
50       sqlch        3660006            107738      1028 
2675033028 
50       sqlch        3680134            108330      1028 
2675033028 
50       sqlch        3681494            108370      1028 
2675033028 
... 
50       sqlch        4033394            118720      1028 
2675033028
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* FEDERATED                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 fix pack 3                       * 
****************************************************************
Local-Fix:
The leaked memory can be recovered by recycling the DB2 instance
verfügbare FixPacks:
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

Lösung
Problem was first fixed in DB2 version 10.1 fix pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
10.05.2013
27.09.2013
27.09.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList