Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2016
    Posts
    14

    Answered: DB2 not getting started after reboot

    After the reboot of the AIX Server DB2 is not cumming up,
    When i try to start it manually i got the below error

    SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "10".

    Then i have checked db2nodes.cfg in sqllib, nothing got changed.

    So as per urgent requirement of server, i have updated the instance ./db2iupdt and DB got up.

    This situation i faced many times.

    Can some one help/suggest me What is getting changed while reboot ?

    DB2 V9.7 FP7
    AIX: 7.1

  2. Best Answer
    Posted by mark.b

    "What's the output of the following commands after reboot?

    lsattr -El inet0 -a hostname
    hostname
    uname -n
    cat ~/sqllib/db2nodes.cfg

    The last command must be run from the db2 instance owner.
    Is the hostname resolved correctly (check the /etc/hosts file, for example)?"


  3. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    What's the output of the following commands after reboot?

    lsattr -El inet0 -a hostname
    hostname
    uname -n
    cat ~/sqllib/db2nodes.cfg

    The last command must be run from the db2 instance owner.
    Is the hostname resolved correctly (check the /etc/hosts file, for example)?
    Regards,
    Mark.

  4. #3
    Join Date
    Apr 2016
    Posts
    14

    Thanks Mark

    Quote Originally Posted by mark.b View Post
    What's the output of the following commands after reboot?

    lsattr -El inet0 -a hostname
    hostname
    uname -n
    cat ~/sqllib/db2nodes.cfg

    The last command must be run from the db2 instance owner.
    Is the hostname resolved correctly (check the /etc/hosts file, for example)?

    From your question, i got the solution
    in /etc/hosts we did not gave hostname.

    now issue got resolved

    Thanks for your help.

Tags for this Thread

Posting Permissions

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