DB2 - Problem description
Problem IT10036 | Status: Closed |
MEMORY LEAK IN DB2SYSC PRIVATE MEMORY WHEN AN EXTERNAL CONVERSION TABLE IS USED | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Description: The db2sysc private memory may be leaked when following conditions are met: - External conversion tables are used (*.cnv exists in sqllib/conv/ directory) - The database code page and the application code page are different - Trusted routines are used This memory leak cannot be observed by db2pd -dbptnmem or MON_GET_MEMORY_SET/POOL, but ps or other OS monitoring tools(e.g. svmon in AIX) report the increase of the private memory. The db2pd -memblock pid=db2sysc_pid will show the many blocks from OSSe LOC=239. For example: Memory blocks sorted by size: PoolID PoolName TotalSize(Bytes) TotalCount LOC File OSSe OSSe 167033120 3941 239 0 0 13222440 105 176 1235720678 0 5242880 40 8429 3922823597 0 919088 34 1449 428345763 ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using external conversion tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * 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 : | 13.07.2015 28.01.2016 28.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 |