home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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 FixList