DB2 FOR LUW / DB2FORLUW / A50 - DB2

Whenever performing tcpip connection to database, small amount 
of memory leaks in CLP db2bp or embedded SQL application, but 
only when a db2dsdriver.cfg file exists regardless of its usage. 
 
  It can be checked by "work text data BSS heap" memory in 
"svmon -P" command output as below. 
  And difference of "db2pd -memblock private pid=" outputs shows 
the possible location of memory block leak. 
 
$ ps -elf | grep db2inst1 | grep db2bp 
  240001 A  db2inst1 34865220        1   0  60 20 8c2e38590 
6664          23:18:16      -  0:01 
/home/hirosjp/sqllib/bin/db2bp 24445048A22988 5 A 
 
$ svmon -P 34865220 | grep "BSS " 
  8b17d6        11 work text data BSS heap          sm    491 
0    0     491 
 
$ db2pd -memblock private pid=34865220 | tee db2pd_memb0.out 
 
$ touch ~/sqllib/cfg/db2dsdriver.cfg 
$ ls -l ~/sqllib/cfg/db2dsdriver.cfg 
-rw-r--r--    1 db2inst1  build             0 May 21 23:21 
/home/hirosjp/sqllib/cfg/db2dsdriver.cfg 
 
$ i=0; while [ $i -lt 100 ] ; do 
  i=$( expr $i + 1 ); 
  echo "Count: " $i 
  db2 connect to DBNAME user db2inst1 using xxxxxxxx 
  db2 connect reset 
done; 
 
### Private memory size of db2bp process is increased after 100 
times connection 
$ svmon -P 34865220 | grep "BSS " 
  8b17d6        11 work text data BSS heap          sm    727 
0    0     727 
 
$ db2pd -memblock private pid=34865220 | tee db2pd_memb100.out 
$ diff db2pd_memb0.out db2pd_memb100.out 
... 
> 0                     392000               100        1166 
84318411

**************************************************************** 
* USERS AFFECTED:                                              * 
* db2dsdriver.cfg file user                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 10.5 FixPack 7 or higher              * 
****************************************************************

Not use and delete db2dsdriver.cfg for the database connection

Problem was first fixed in Version 10.5 FixPack 7

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.05.2015
27.01.2016
27.01.2016