IT32125: MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When KEEPFENCED is set to NO, there might be memory leak in fmp
  process.
  
  Output of command "db2pd -memblock pid=<fmp pid> sort" shows
  File 252546453 LOC 672(can be vary on different Db2 versions)
  used a lot of memory:
  
  All memory blocks in Private memory set for process 28639648
  
  Memory blocks sorted by size:
  PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
  
  0                     224748800            175585     672
  252546453
  0                     7042520              176063     638
  1602215076
  ...
  
  
  To reproduce the memory leak:
  
  $ db2pd -memblock pid=<fmp pid> sort
  
  All memory blocks in Private memory set for process 25559196
  
  Memory blocks sorted by size:
  PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
  0                     977920               764        672
  252546453
  ...
  
  $ db2 "select * from sysibmadm.snapappl" > /dev/null
  
  $ db2pd -memblock pid=<fmp pid> sort
  
  All memory blocks in Private memory set for process 25559196
  
  Memory blocks sorted by size:
  PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
  0                     979200               765        672
  252546453
  ...
  

Local fix

• Set dbm cfg KEEPFENCED to yes, then restart the Db2 server.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * n/a                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 for LUW V11.1 Mod4 Fixpack6 or later.         *
  ****************************************************************
  

Problem conclusion

• This problem is firstly fixed on V11.1 Mod4 Fixpack6.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT32126

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSY

     UP