If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Problem with "db2nodes.cfg" file

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,164
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
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,164
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
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Jun 2009
Posts: 1
I restart in windows service "COM +" I have problem resolved
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On