If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2fm - fault monitor service does not startup after issue db2stop

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-22-11, 10:35
vpong vpong is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
db2fm - fault monitor service does not startup after issue db2stop

hi all,
I am encountering a weird issue here, i have configured db2fm as below:

root@chialeep:/opt/ibm/db2/V9.7/bin# grep db2 /etc/inittab
fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator

started db2fm with below command:
./db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so.1 -U -u

however, when i issue db2stop via user: db2inst1 (instance owner), the fault monitor service will not able to startup by itself:

root@chialeep:/opt/ibm/db2/V9.7/bin# grep db2 /etc/inittab
fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator

Any idea?
Reply With Quote
  #2 (permalink)  
Old 04-22-11, 11:26
vpong vpong is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
Quote:
Originally Posted by vpong View Post
hi all,
I am encountering a weird issue here, i have configured db2fm as below:

root@chialeep:/opt/ibm/db2/V9.7/bin# grep db2 /etc/inittab
fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator

started db2fm with below command:
./db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so.1 -U -u

however, when i issue db2stop via user: db2inst1 (instance owner), the fault monitor service will not able to startup by itself:

root@chialeep:/opt/ibm/db2/V9.7/bin# grep db2 /etc/inittab
fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator

Any idea?
I tried this, and it always shows down:
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fmcu
FMC: down
Reply With Quote
  #3 (permalink)  
Old 04-22-11, 17:06
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Quote:
Originally Posted by vpong View Post
however, when i issue db2stop via user: db2inst1 (instance owner), the fault monitor service will not able to startup by itself
"With Fault Monitor facility, if the DB2® Universal Database™ (DB2 UDB) instance exits prematurely, the fault monitor will restart it."

db2stop != prematurely

Check this technote for info on how to configure and test it:
https://www-304.ibm.com/support/docv...id=swg21209001
Reply With Quote
  #4 (permalink)  
Old 04-22-11, 21:14
vpong vpong is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
db2fm - fault monitor service does not startup after system restart

hi BELLO4KA,
Thanks for your replied. I have follow the link given by you to setup the fault monitor.

root@chialeep:/opt/ibm/db2/V9.7/bin# cat /etc/inittab | grep db2fmcd
fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator
root@chialeep:/opt/ibm/db2/V9.7/bin# ps -ef | grep db2fm
root 1618 1462 0 09:00 pts/0 00:00:00 grep --color=auto db2fm
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fm -i db2inst1 -U
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fm -i db2inst1 -u
oot@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fm -i db2inst1 -f on
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fm -i db2inst1 -a on
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fm -i db2inst1 -f on
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fm -i db2inst1 -a on


But db2fmcu still showing:
root@chialeep:/opt/ibm/db2/V9.7/bin# ./db2fmcu
FMC: down

Any idea why?
Reply With Quote
  #5 (permalink)  
Old 04-22-11, 21:28
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Did you reboot the server? What's the output from step #11?
Reply With Quote
  #6 (permalink)  
Old 04-22-11, 21:34
vpong vpong is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
db2fm - fault monitor service does not startup

restarted the server and try to tail log:

root@chialeep:/home/db2inst1# cd /home/db2inst1 && tail -f ./sqllib/db2dump/db2diag.log
FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:70
MESSAGE : ECF=0x900003A4=-1879047260=ECF_FM_POSSIBLE_TIME_HOLE_BEFORE_SET_RE AD_LOCK
Possible timing hole between releasing write lock and getting read lock

2011-04-23-09.28.33.592193+480 I82022G347 LEVEL: Warning
PID : 2752 TID : 1629152 PROC : db2fm
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Common, Fault Monitor Facility, fmNotifyDaemon, probe:40
MESSAGE : ECF=0x90000369=-1879047319=ECF_FM_NO_DAEMON_RUNNING
There is no db2fmd daemon running


Here is my fault monitor registry file content:
root@chialeep:/home/db2inst1# cd /home/db2inst1 && tail -f ./sqllib/db2dump/db2diag.log
FUNCTION: DB2 Common, Fault Monitor Facility, db2fm, probe:70
MESSAGE : ECF=0x900003A4=-1879047260=ECF_FM_POSSIBLE_TIME_HOLE_BEFORE_SET_RE AD_LOCK
Possible timing hole between releasing write lock and getting read lock

2011-04-23-09.28.33.592193+480 I82022G347 LEVEL: Warning
PID : 2752 TID : 1629152 PROC : db2fm
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 Common, Fault Monitor Facility, fmNotifyDaemon, probe:40
MESSAGE : ECF=0x90000369=-1879047319=ECF_FM_NO_DAEMON_RUNNING
There is no db2fmd daemon running
Reply With Quote
  #7 (permalink)  
Old 04-22-11, 21:44
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
What's the output from step #11?
Reply With Quote
  #8 (permalink)  
Old 04-22-11, 21:49
vpong vpong is offline
Registered User
 
Join Date: Apr 2011
Posts: 5
db2fm - fault monitor service does not startup

step11 output:

chialeep@chialeep:~$ sudo su - db2inst1
[sudo] password for chialeep:
$ db2fm -s -S
Gcf module 'fault monitor' is INSTALLED PROPERLY but NOT ALIVE
Gcf module '/opt/ibm/db2/V9.7/lib32/libdb2gcf.so' is INSTALLED PROPERLY but NOT ALIVE

Last edited by vpong; 04-22-11 at 21:50. Reason: add in result
Reply With Quote
  #9 (permalink)  
Old 04-22-11, 23:08
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Something is not right. I'd suggest to redo it from the beginning, including db2fmcu -d, and save the output from each step. If this still doesn't work, consider opening a PMR.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On