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 |