Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2009
    Posts
    4

    Unanswered: should db2 autostart on my linux?

    Hi all,

    i'm new to linux/unix so please forgive me if this is obvious.

    I've been experimenting with db2 (9.5) on SLES 10 (sp3).

    Everything installed ok and i ran first steps and could also see my instance from another command center on another machine (windows). everything looked ok.

    But then i had to restart the box.... after which i could no longer connect to the instance or get command center to discover it.

    The only way I can get it up and running after a boot is to logon as the dbusr and do a db2admin start, then log on as the instance user and do a db2start!

    What do I have to do to get the thing to start up at boot time?

    surely i don't have to write my own startup script do i?

    sorry if this is obvious.

    TIA

    bg

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    db2iauto -on <instance-name>
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2009
    Posts
    4
    thanks - i've tried that, but to no luck. After a restart - in command center if i right click on the instance (on the host the db2 instance is running on) and choose About from the menu. i get:

    SQL103N no start manager command was issued. ......

    If i do a db2set DB2AUTOSTART -i db2inst it returns YES. so i guess something must be going wrong in the boot - i'll check the console logs.

    many thanks for the help.

    bg

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    I pasted the wrong link, here's the correct one:
    IBM - How to use fault monitors to automatically restart DB2 UDB instances

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by brg666 View Post
    thanks - i've tried that, but to no luck. After a restart - in command center if i right click on the instance (on the host the db2 instance is running on) and choose About from the menu. i get:

    SQL103N no start manager command was issued. ......

    If i do a db2set DB2AUTOSTART -i db2inst it returns YES. so i guess something must be going wrong in the boot - i'll check the console logs.

    many thanks for the help.

    bg
    I think there was a problem with some releases of Linux. Seems to work on RHEL 5.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Dec 2009
    Posts
    4
    thanks db2girl - actually that first link is very useful. i'll try the fm stuff tomorrow and report back.

    many thanks all.

  8. #8
    Join Date
    Dec 2009
    Posts
    4

    working now - thanks!

    did what db2girl suggested via the links she posted and it would appear to now be working.

    thank you v much.

    db2girl =

  9. #9
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if fmcd and fmc are started it should work.. just wait a moment after boot and see;; otherwise you did an incorrect setup
    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
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

Posting Permissions

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