Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2008
    Posts
    62

    Problem with "db2nodes.cfg" file

    Hello,

    I am using db2 v9.1 on windows.

    I could not start or update the db2 instance; even for any db2 command it is giving the same following error:

    SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "3".

    I checked the file db2nodes.cfg file in ...\sqllib\db2\ directory & its permission, its all seems to be correct. Correct Hostname and node number is properly specified there.

    I am not able to get the solution. For me its all seems to be fine.

    Can you please help me or give some clue for finding the solution?


    Regards,
    Prashant

  2. #2
    Join Date
    Feb 2009
    Posts
    114
    SQL6031N Error in the db2nodes.cfg file at line number "<line>". Reason
    code "<reason-code>".

    Explanation:

    The statement cannot be processed because of a problem with the
    db2nodes.cfg file, as indicated by the following reason codes:

    .....

    (3) Cannot open the db2nodes.cfg file in the sqllib directory.

    --------------------------------------------------------------------

    Is there anything in the file? If so, copy/paste the contents here

  3. #3
    Join Date
    Feb 2008
    Posts
    62
    Thanks for the reply.

    here are its contents:

    0 PUCHP4225 PUCHP4225 0


    i tried to change it & make it look like:

    0 PUCHP4225 0

    but it doesn't worked.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,274
    it should be
    nodenumber hostname computername logicalport netname resourcesetname
    On Windows operating systems, these entries to the db2nodes.cfg are added by the db2ncrt or db2 add db partition commands. You should not add these lines directly or edit this file.
    db2stop before making any changes
    changes
    db2start
    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

  5. #5
    Join Date
    Feb 2008
    Posts
    62
    That's good! It really add up value to my knowledge base.

    Today it gave me the error in diag.log that the evaluation period has expired. I think this was the same reason which was causing the previous error of dbnodes.cfg file but was not showing exact error in log file before.

    Thanks u all for your replyies.


    One more question from my side:

    What if somebody changed the hostname of the OS. In that case should i update the same hostname in db2nodes.cfg file manually? or is there any other way around?

    Thanks again,
    Prashant

  6. #6
    Join Date
    Feb 2009
    Posts
    114
    Those are not host names but network node names and should resolve to IP address, or you can use IP addresses to avoid any interaction with DNS.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,274
    here a doc about changing the hostname
    IBM - Changing hostname of the DB2 server
    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

  8. #8
    Join Date
    Feb 2008
    Posts
    62
    Thank you for all your replyies and valuable inputs.

    That what exactly i was looking for.


    Thanks again

    Prashant

  9. #9
    Join Date
    Jun 2009
    Posts
    1
    I restart in windows service "COM +" I have problem resolved

Posting Permissions

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