Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    USA
    Posts
    6

    Unanswered: DB2 issue > db2fm

    We are running DB2 v8.1 in Linux.

    The DB is running the for last 1 year or so without any issue. Today there was a server restart and after that wehn I started the DB it started well but when I ps -ef|grep db2 i am getting the following output -

    root 22258 1161 0 10:46 ? 00:00:00 sshd: db2inst1 [priv]
    db2inst1 22260 22258 0 10:46 ? 00:00:03 sshd: db2inst1@pts/1
    db2inst1 22261 22260 0 10:46 pts/1 00:00:04 -bash
    root 22963 1 0 11:22 ? 00:00:00 /opt/IBM/db2/V8.1/bin/db2fmcd
    db2inst1 23138 1 0 11:29 ? 00:00:01 /home/db2inst1/sqllib/bin/db2fmd -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so
    db2inst1 23648 1 0 11:34 pts/1 00:00:09 /home/db2inst1//sqllib/bin/db2bp 22261A503 5 A
    root 24053 1 0 11:51 pts/1 00:00:09 db2wdog
    db2inst1 24056 24053 0 11:52 pts/1 00:00:00 db2sysc
    root 24057 24056 0 11:52 pts/1 00:00:00 db2ckpwd
    root 24058 24056 0 11:52 pts/1 00:00:00 db2ckpwd
    root 24059 24056 0 11:52 pts/1 00:00:00 db2ckpwd
    root 24060 24056 0 11:52 pts/1 00:00:00 db2gds
    db2inst1 24061 24056 0 11:52 pts/1 00:00:00 db2ipccm
    db2inst1 24062 24056 0 11:52 pts/1 00:00:00 db2tcpcm
    db2inst1 24063 24056 0 11:52 pts/1 00:00:00 db2resync
    db2inst1 24064 24060 0 11:52 pts/1 00:00:00 db2srvlst
    db2inst1 24069 24056 0 11:52 pts/1 00:00:12 db2hmon ,0,0,0,1,0,0,0,1e014,2,0,1,9fe0,0x11250000,0x11250 000,15fc000,200005,2,5c000b
    db2inst1 24081 24061 0 11:52 pts/1 00:00:00 db2agent (idle)
    db2inst1 24338 24061 0 11:55 pts/1 00:00:00 db2agent (instance)
    db2inst1 24387 24061 0 11:57 pts/1 00:00:00 db2agent (idle)
    db2inst1 24389 24061 0 11:57 pts/1 00:00:00 db2agent (idle)
    db2inst1 24390 24061 0 11:57 pts/1 00:00:00 db2agent (idle)
    root 24463 22963 0 12:02 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24464 24463 18 12:02 ? 00:05:34 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24482 22963 0 12:03 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24483 24482 16 12:03 ? 00:04:56 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24523 22963 0 12:06 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24524 24523 14 12:06 ? 00:03:49 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24639 22963 0 12:12 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24640 24639 12 12:12 ? 00:02:34 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24681 22963 0 12:15 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24682 24681 11 12:15 ? 00:01:55 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24733 22963 0 12:19 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24734 24733 10 12:19 ? 00:01:19 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24775 22963 0 12:22 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24776 24775 9 12:22 ? 00:01:01 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24886 22963 0 12:31 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24887 24886 8 12:31 ? 00:00:06 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24891 22963 0 12:32 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24892 24891 9 12:32 ? 00:00:04 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    root 24896 22963 0 12:32 ? 00:00:00 sh -c /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S 2>&1
    db2inst1 24897 24896 8 12:32 ? 00:00:01 /home/db2inst1/sqllib/bin/db2fm -i db2inst1 -m /home/db2inst1/sqllib/lib/libdb2gcf.so -S
    db2inst1 24901 22261 0 12:32 pts/1 00:00:00 ps -ef
    db2inst1 24902 22261 0 12:32 pts/1 00:00:00 grep db2


    The db2fm process is getting spawned off in regular interval with one with db2inst1 user and another one is with root user.
    I checked the fault monitor with the following command -

    # db2fm -s -S
    Gcf module 'fault monitor' state is AVAILABLE
    Gcf module '/home/db2inst1/sqllib/lib/libdb2gcf.so' state is AVAILABLE


    I am not sure whats going wrong. Please, suggest.

    Thanks
    Koushik

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    db2fm is the command to see/start/stop the fault monitor coordinating daemon
    db2fmc process (see doc)
    db2fm are processes to execute stored procedures...
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •