on 03-12-2013 9:58 AM
Hi,
We have restore one test server which is called kfrestoretest by copying the file system from our original D2P server which is kfd2pd01
After restoring we want to start the database but we are getting error while starting database
SQL6031N Error in the db2nodes.cfg file at line number "1". Reason code "10".
We have check the entry in .rhosts file and db2nodes.cfg and they are correct
Anyone having idea what need to be check
Thanks everyone for your suggestion
The issue was resolved as there was incorrect entry in host file
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Amit,
Reason:
The hostname at line line of the db2nodes.cfg file in the sqllib directory is not valid.
It can be caused by incorrect permissions on /etc/hosts , /etc/services or incorrect or missing host name in the /etc/hosts file
Run ls -la on /etc/hosts and /etc/services. Must be readable for group and public (r--r--r--) .
Verify host name by running command 'hostname'
What is returned from the hostname command needs to reachable.
To test if your system's /etc/hosts file is properly configured, issue
following command:
ping <hostname>
If it fails, correct the /etc/hosts file so that the proper internet
address and corresponding hostname are included. For example:
192.168.1.101 myhostname myhostname.us.ibm.com
DB2 requires the system's hostname information in order to update the database manager configuration. If the /etc/hosts file is not properly configured, or the system files do not have the correct permissions the db2icrt command will fail when you attempt to create a new instance.
Resolve the problem by taking these steps:
1. Correct the permissions on the file /etc/host and /etc/services to 444.
2. Add proper ipaddress/hostname to /etc/hosts file.
Regards,
Varun.Ch
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Could you check entries in /etc/services whether it points to correct service name.
Also you may try with adding IP address in db2nodes.cfg
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.