Eric Yih's Blog

Do what you like, like what you do.
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

High CPU usage in db2fm when run "db2sampl" to create a sample database

Posted on 2008-10-29 23:32  Eric Yih  阅读(357)  评论(0)    收藏  举报

IBM DB2When I want to run "db2sampl" to create a sample database, I found many db2fm processes via "top" command and the CPU usage rate was 100%.

The problem is caused by db2fm consuming a great deal of CPU resource, which leads to 
unexpectedly high CPU usage on the system.
I found out two approaches to solve it from http://www-1.ibm.com/support/docview.wss?uid=swg1IY64683 
and 
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0008306.htm


1. Restart the system after comment out the the db2fmcd entry in /etc/inittab to prevent
it from respawning automatically as below:
--------------------------------------
# end of /etc/inittab
#fmc:2345:respawn:/opt/IBM/db2/V8.1/bin/db2fmcd #DB2 Fault Monitor Coordinator
--------------------------------------

2. Install the DB2 V8.2 fixpak 3 later.
Here is the solution approach from internet, please refer to: db2fm usage rate was 100%