Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Jul 2011
    Posts
    14

    Unanswered: DB2 autostart under ubuntu 11.04

    Hello.

    I'm wondering why my db2 9.7 does not start automatically under ubuntu 11.04 (running into vmware - but I don't think it's important).

    Of course I tried
    Code:
    db2iauto -on admin
    ... not working.

    So I searched on internet and found that

    But there is a problem.

    So
    Code:
    ./db2fmcu -u -p /opt/ibm/db2/V9.7/bin/db2fmcd
    the file inittab contains
    Code:
    fmc:2345:respawn:/opt/ibm/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator
    It's ok.

    Then (my instance name is admin)
    Code:
    ./db2fm -i admin -U
    ./db2fm -i admin -u
    ./db2fm -i admin -f on
    ./db2fm -s -S
    ->
    Code:
    Gcf module 'fault monitor' state is AVAILABLE
    Gcf module '/opt/ibm/db2/V9.7/lib32/libdb2gcf.so' state is AVAILABLE
    Reboot

    Code:
    ./db2fmcu
    ->
    Code:
    FMC: down
    and

    Code:
    ./db2fm -s -S
    ->
    Code:
    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
    And of course db2 not starting.

    So what can I do ?
    Last edited by tweetysat; 08-05-11 at 09:56.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    after the reboot you should find the process : db2fmcd coord-daemon
    check with ps..
    it is at the end of inittab - so it can take some minutes after the boot
    if this process is not present - instance will not be started because daemon looks in reg file to see if instance need to be started..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2011
    Posts
    14
    ok, i did a ps -ef | grep db2fm

    Code:
    admin     2535     1  0 14:29 ?        00:00:00 /opt/ibm/db2/V9.7/bin/db2fmd -i admin -m /opt/ibm/db2/V9.7/lib32/libdb2gcf.so
    So I suppose the is not working

    What do you mean by look in reg file ? (I don't know very well linux).

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by tweetysat View Post

    Of course I tried
    Code:
    db2iauto -on db2inst1
    ... not working.


    Then (my instance name is admin)
    Code:
    ./db2fm -i admin -U
    ./db2fm -i admin -u
    ./db2fm -i admin -f on
    ./db2fm -s -S
    If your instance name is admin, then that's what you should have used in db2iauto.

    Use db2greg -dump to display the actual state of the instance (run db2greg without parameters do see the description of fields).

  5. #5
    Join Date
    Jul 2011
    Posts
    14
    Hi

    Sorry i did well db2iauto -on admin It's an error on this post. I will change it.

    So db2greg -dump
    Code:
    S,DB2,9.7.0.4,/opt/ibm/db2/V9.7,,,4,0,,1312534376,0
    V,DB2GPRF,DB2SYSTEM,Virtual-Ubuntu,/opt/ibm/db2/V9.7,
    V,DB2GPRF,DB2_COMPATIBILITY_VECTOR,MYS,/opt/ibm/db2/V9.7,
    S,DAS,9.7.0.4,/opt/ibm/db2/V9.7/das,lib/libdb2dasgcf.so,,4,, ,,
    I,DAS,9.7.0.4,dasusr1,/home/dasusr1/das,,1,,/opt/ibm/db2/V9.7/das,,
    V,DB2GPRF,DB2ADMINSERVER,dasusr1,/opt/ibm/db2/V9.7,
    I,DB2,9.7.0.4,admin,/home/admin/sqllib,,1,0,/opt/ibm/db2/V9.7,,
    V,DB2GPRF,DB2INSTDEF,admin,/opt/ibm/db2/V9.7,

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    but executing ps you should see : db2fmcd
    this can be started manually after boot also from indicated path with root
    db2fmd is a process by istance or admin user
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  7. #7
    Join Date
    Jul 2011
    Posts
    14
    I tried

    Code:
    /opt/ibm/db2/V9.7/bin/db2fmcd
    and now I've got

    Code:
    root      7491  6058  2 15:53 pts/0    00:00:00 /opt/ibm/db2/V9.7/bin/db2fmcd
    But now ?

    Why it's not starting at reboot ?

    And now when I do

    Code:
    ./dbfmcu
    still
    Code:
    FMC: down

  8. #8
    Join Date
    Jul 2011
    Posts
    14
    Up.

    Still not working. Don't know if inittab is not executed or if there is an error.
    Perhaps I can see it in a log file ? But witch one ?

  9. #9
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    should be in startup message in system log /var/log/message
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  10. #10
    Join Date
    Jul 2011
    Posts
    14
    /var/log/message does not exists ...


  11. #11
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have a closer look /var/log/messages (typo error - ls would have revealed..)
    I understand making an entry in forum is easier than having a look at the system..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  12. #12
    Join Date
    Jul 2011
    Posts
    14
    Even with a closer look, no /var/log/message and no /var/log/messages.
    I understand that you think that I think it's easier to add a post on a forum than making a simple ls command ... but I did the ls command and don't waited for you to tell me ...

  13. #13
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the ubuntu doc :
    Switch to VT4 or view the contents of /var/log/syslog (use nano as editor) to check for any specific error messages. After that, also check the output of dmesg.
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  14. #14
    Join Date
    Jul 2011
    Posts
    14
    Ok, so ...

    I found how to 'reactivate' /var/log/messages (deactivated under ubuntu because redundant with other log files).
    But no trace of any db2 message in messages,syslog and dmesg.

  15. #15
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    so....
    this is the challenge - pd/psi
    and this means : problem determiniation / problem source identification...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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