High CPU usage in db2fm when run "db2sampl" to create a sample database
Posted on 2008-10-29 23:32 Eric Yih 阅读(357) 评论(0) 收藏 举报
When 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
andhttp://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%
浙公网安备 33010602011771号