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 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 FixList