db2wdog

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • alexhguerra
    #1

    db2wdog

    Hello Folks

    I have a simple question. In db2 v7, AIX platform, is db2wdog or
    which process is responsible for restarting db2 automatically in case
    of a instance problem?
    And in the case of db2 process being restarted automatically by
    db2wdog, would the process skip instance userid .profile? Im having
    some problems with environment variables being 'lost' when calling TSM
    api and this is making me bored a lot. I have added the export for
    DSMI_CONFIG/DIR/LOG to userprofile file in sqllib dir expecting to
    avoid this problem

    Anyone have some insights/directions about how db2 v7 are restarted
    automatically in case of a instance crash to share?

    Thanks a lot
    Alexandre

    Tags: db2wdog
    • The Boss
      #2
      Re: db2wdog

      alexhguerra wrote:
      Hello Folks
      >
      I have a simple question. In db2 v7, AIX platform, is db2wdog or
      which process is responsible for restarting db2 automatically in case
      of a instance problem?
      And in the case of db2 process being restarted automatically by
      db2wdog, would the process skip instance userid .profile? Im having
      some problems with environment variables being 'lost' when calling TSM
      api and this is making me bored a lot. I have added the export for
      DSMI_CONFIG/DIR/LOG to userprofile file in sqllib dir expecting to
      avoid this problem
      >
      Anyone have some insights/directions about how db2 v7 are restarted
      automatically in case of a instance crash to share?
      >
      Thanks a lot
      Alexandre
      The automatic restart isn't done by the watchdog process.
      Check the DB2 Admin Guide and look for db config parm "autorestar t":
      http://publib.boulder.ibm.com/infocenter/db2v7luw/topic/com.ibm.db2v7.doc/db2d0/db2d0140.htm

      and
      http://publib.boulder.ibm.com/infocenter/db2v7luw/topic/com.ibm.db2v7.doc/db2d0/cfgdbs.htm


      HTH.

      --
      Jeroen


        Comment

        • The Boss
          #3
          Re: db2wdog

          The Boss wrote:
          alexhguerra wrote:
          >Hello Folks
          >>
          > I have a simple question. In db2 v7, AIX platform, is db2wdog or
          >which process is responsible for restarting db2 automatically in case
          >of a instance problem?
          > And in the case of db2 process being restarted automatically by
          >db2wdog, would the process skip instance userid .profile? Im having
          >some problems with environment variables being 'lost' when calling
          >TSM api and this is making me bored a lot. I have added the export
          >for DSMI_CONFIG/DIR/LOG to userprofile file in sqllib dir expecting
          >to avoid this problem
          >>
          >Anyone have some insights/directions about how db2 v7 are restarted
          >automaticall y in case of a instance crash to share?
          >>
          >Thanks a lot
          >Alexandre
          >
          The automatic restart isn't done by the watchdog process.
          Check the DB2 Admin Guide and look for db config parm "autorestar t":
          http://publib.boulder.ibm.com/infocenter/db2v7luw/topic/com.ibm.db2v7.doc/db2d0/db2d0140.htm

          and
          http://publib.boulder.ibm.com/infocenter/db2v7luw/topic/com.ibm.db2v7.doc/db2d0/cfgdbs.htm

          >
          And when you are planning to upgrade to a supported version (v8/v9), you
          would want to have a look at the Fault Monitor facility:
          http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/c0008221.htm


          --
          Jeroen


            Comment

            Previous template Next
            Working...