cancel
Showing results for 
Search instead for 
Did you mean: 

Db2 start up failed

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thanks everyone for your suggestion

The issue was resolved as there was incorrect entry in host file

Answers (3)

Answers (3)

Former Member
0 Kudos

Dear Amit,

Reason:

The hostname at line line of the db2nodes.cfg file in the sqllib directory is not valid.

Cause

It can be caused by incorrect permissions on /etc/hosts , /etc/services or incorrect or missing host name in the /etc/hosts file

Diagnosing the problem

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.

Resolving the problem

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


Former Member
0 Kudos

This message was moderated.

former_member188883
Active Contributor
0 Kudos

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

former_member188883
Active Contributor
0 Kudos

Hi Amit,

Hope you have resolved this issue.

Regards,

Deepak Kori