DB2 - Problem description
| Problem IT03821 | Status: Closed |
MEMORY LEAK IS POSSIBLE ON WINDOWS IF CALLING ENV_GET_DB2_SYSTEM_RESOURCES | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
Memory allocated in DB2 function ossGetProcessRawCPUUsage,
it not freed and can lead to increase memory usage on Windows
platforms.
This memory leak may not be visible through db2pd -mempool or
db2pd -dbptmem output.
REPRODUCTION:
loop:
db2 connect to <database>
SET COUNT=0
:MyLoop
IF "%COUNT%" == "1000" GOTO EndLoop
db2 "SELECT COUNT(*) FROM
TABLE(ENV_GET_DB2_SYSTEM_RESOURCES(-2))"
SET /A COUNT+=1
GOTO MyLoop
:EndLoop | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 10.1 Fixpack 5 or Later. * **************************************************************** | |
| Local Fix: | |
Avoid calling the ENV_GET_DB2_SYSTEM_RESOURCES | |
| Solution | |
First Fixed in DB2 LUW Version 10.1 Fixpack 5. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.08.2014 14.07.2015 14.07.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.1.0.5 |
|