Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: Autostarting instance after server restart

    Do you control instance autostart at the DB2 level (db2iauto/db2autostart) or OS level (db2start scripts in inittab/init.d)?

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    It depends on whether or not there is any clustering in place.
    With clustering, use the cluster-manager to start the resources (including db2).
    With no clustering, on modern DB2 versions on Linux/Unix, I use db2fmc (when you use db2iauto, that just sets a registry variable, but the fmc will search for instances with this registry variable set and start them).
    For Windows, without clustering, I ensure the relevant system-services are marked as auto-start.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    No clustering.


    I've seen enough problems with fault monitor so don't know if I can trust it 100%.

    Do you see any potential issue with setting the instance to autostart in two places (FM/reg var and inittab)? This is just in case FM fails to autostart the instance. With inittab, I will activate the db in some env as well. FM first and then the manual script:

    # grep -i db2 inittab
    fmc:2:respawn:/opt/IBM/db2/V9.7/bin/db2fmcd #DB2 Fault Monitor Coordinator
    rcdb2:2nce:/etc/rc.db2 > /dev/console 2>&1 # Autostart DB2 Services


    I tested [fmc; rcdb2] and [rcdb2; fmc] combinations with no issues. With [rcdb2; fmc] sequence, FM will restart db2sysc (I saw a new PID for db2sysc).

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Only 1 copy of the instance can stay running on the box...if one copy is already running, the second copy must fail.
    So if your alerting solution can cope with the false alarm (if fail to start the instance that is already started generates an alert) then ok...

    The fm job is to restart the instance on failure, so if there's no clustering I want the fm to do its job both at system reboot and otherwise.

    Otherwise keep raising those pmr's.

Posting Permissions

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