DB2 - Problem description
Problem IT10480 | Status: Closed |
RUNNING "DB2LOOK -L" IN DPF RESULTS IN VERY HIGH MEMORY USAGE - MEMORY LEAK | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Running "db2look -l" in a DPF (multiple partition) environment will allocate huge amount of private memory from the Operating System. You might even observe paging depending on machine ressources. You can monitor db2look execution with "ps -elf" and will see that memory (SZ) constantly grows into multiple GB range. The issue has been seen with large DPF installations that have many (several thousand) tablespaces that are defined as DMS tablespaces, spawning multiple partitions. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2015 21.01.2016 21.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |