db2fm !!! urgent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

span3d@yahoo.com - 07 Dec 2005 14:45 GMT

Hi,

The db2fm process on our server is using 12 % cpu even when no
applications are connected. Can i stop this process? Is this required
for db2 to function normally? we are on db2 v8.1 with logical
partitioning.

Thanks

Reply to this Message

Dan Scott - 08 Dec 2005 13:34 GMT

db2fm is the DB2 Fault Monitor. It notices if the database has stopped
abnormally and restarts it for you -- so it's not absolutely required.
12% CPU usage seems quite high, btw; are you running a recent DB2
FixPak?

To prevent db2fm from automatically starting and restarting, run the
following command as root to remove the db2fm entry from /etc/inittab:

# /opt/IBM/db2/V8.1/bin/db2fmcu -d

Dan

Reply to this Message

span3d@yahoo.com - 08 Dec 2005 14:32 GMT

Hi Dan,

Thanks for the reply, we are running on db2 v8.1.1.80, special_14324
and fixpack 8

Thanks
Raj

Reply to this Message

UDBDBA - 12 Dec 2005 17:05 GMT

Two issus to address:

db2fmcd problem using cpu:
As mentioned by Dan, you will have to stop it or edit the inittab file
to once from respawn.
This is addressed in APAR:IY64683 (Fixed in Fixpak9)
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=db2fm&uid=swg1I
Y64683&loc=en_US&cs=utf-8&lang=en

db2fmd problem using cpu:
Also check technote on db2fmd, which helps in reducing CPU usage by
chaging STATUS_INTERVAL to a higher number in fm.<hostname>.reg file
under sqllib.
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=db2fmd&uid=swg2
1217055&loc=en_US&cs=utf-8&lang=en

HTH

Vijay

Reply to this Message