|
Problem IC66696
|
Status: Geschlossen |
MINOR MEMORY LEAK WHEN USING FEDERATION PASSTHRU FEATURE. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problembeschreibung: |
When user runs some query in passthru session like this
set passthru server1;
select * from sometable;
set passthru reset;
and then dump the DB2 memory blocks using db2pd like "db2pd
-memblock", they can see some leaked memory blocks like below:
Address PoolID PoolName BlockAge Size(Bytes) I
LOC File
0x0000000110E7EB88 88 private 445 16 1
451 2074526459
0x0000000110E7EBC8 88 private 452 16 1
451 2074526459
0x0000000110E7ECA8 88 private 450 144 1
451 2074526459
0x0000000110E7ED68 88 private 451 144 1
451 2074526459
0x0000000110E7EEA8 88 private 457 144 1
451 2074526459
0x0000000110E7EF68 88 private 458 144 1
451 2074526459
0x0000000110E7F0A8 88 private 461 144 1
451 2074526459
0x0000000110E7F168 88 private 462 144 1
451 2074526459
In databases with health monitor enabled and Federated
datasource servers defined, this issue manifests itself even
though user doesn't run explicitly and passthru commands. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* User using passthru session in DPF environment. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When user runs some query in passthru session like this *
* *
* set passthru server1; *
* *
* select * from sometable; *
* *
* set passthru reset; *
* *
* *
* *
* and then dump the DB2 memory blocks using db2pd like "db2pd *
* *
* -memblock", they can see some leaked memory blocks like *
* below: *
* *
* *
* Address PoolID PoolName BlockAge Size(Bytes) I *
* LOC File *
* *
* 0x0000000110E7EB88 88 private 445 16 1 *
* 451 2074526459 *
* *
* 0x0000000110E7EBC8 88 private 452 16 1 *
* 451 2074526459 *
* *
* 0x0000000110E7ECA8 88 private 450 144 *
* 1 *
* 451 2074526459 *
* *
* 0x0000000110E7ED68 88 private 451 144 *
* 1 *
* 451 2074526459 *
* *
* 0x0000000110E7EEA8 88 private 457 144 *
* 1 *
* 451 2074526459 *
* *
* 0x0000000110E7EF68 88 private 458 144 *
* 1 *
* 451 2074526459 *
* *
* 0x0000000110E7F0A8 88 private 461 144 *
* 1 *
* 451 2074526459 *
* *
* 0x0000000110E7F168 88 private 462 144 *
* 1 *
* 451 2074526459 *
* *
* *
* *
* In databases with health monitor enabled and Federated *
* *
* datasource servers defined, this issue manifests itself even *
* *
* though user doesn't run explicitly and passthru commands. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.8 Fix pack 3. *
**************************************************************** |
| Local-Fix: |
Not available. |
| verfügbare FixPacks: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Lösung |
Problem was first fixed in Version 9.8 Fix Pack 3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.02.2010
21.12.2010
21.12.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.8.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.8.0.3
|
 |
