Add Node problems 
Author Message
 Add Node problems

Hi all,
I'm trying to add a node to a cluster running on Red Hat Linux.
I installed DB2, then created an instance owner with same ID, Group ID
and password. Made sure all is mounted and remote execution works.

Was able to execute
db2 connect to mydb
from this new box.

Tried to run from catalog partition node:
db2start nodenum 2 addnode hostname 111.111.111.111 port 0 without
tablespaces
It failed giving SQL6048N,

A communication error occurred during START or STOP DATABASE MANAGER
processing.

Explanation: A TCP/IP communication error occurred while the START or
STOP DATABASE MANAGER command was trying to establish connection with
all the nodes defined in the sqllib/db2nodes.cfg file.

User Response: Do the following:

Ensure that the node has the proper authorization defined in the
.rhosts or the host.equiv files.
Ensure that the application is not using more than (500 + (1995 - 2 *
total_number_of_nodes)) file descriptors at the same time.
Ensure all the DB2 Enterprise - Extended Edition environment variables
are defined in the profile file.
Ensure the profile file is written in the Korn Shell script format.
Ensure that all the host names defined in the db2nodes.cfg file in the
sqllib directory are defined on the network and are running.

I checked for all the suggested corrections and it did not work out.
I tried to run ADD NODE command from the box I'm creating a node on
this gave me
SQL1469N instance "db2inst1" (nodenum "2") does not have node "2"
specified in its db2nodes.cfg file

Is there any way out?

Thanks,
Alkuzo



Mon, 13 Sep 2004 07:44:31 GMT
 Add Node problems

Quote:

> Hi all,
> I'm trying to add a node to a cluster running on Red Hat Linux.
> I installed DB2, then created an instance owner with same ID, Group ID
> and password. Made sure all is mounted and remote execution works.

> Was able to execute
> db2 connect to mydb
> from this new box.

> Tried to run from catalog partition node:
> db2start nodenum 2 addnode hostname 111.111.111.111 port 0 without
> tablespaces
> It failed giving SQL6048N,

> A communication error occurred during START or STOP DATABASE MANAGER
> processing.

> Explanation: A TCP/IP communication error occurred while the START or
> STOP DATABASE MANAGER command was trying to establish connection with
> all the nodes defined in the sqllib/db2nodes.cfg file.

> User Response: Do the following:

> Ensure that the node has the proper authorization defined in the
> .rhosts or the host.equiv files.

Are you sure you check this?

Quote:

> Ensure that the application is not using more than (500 + (1995 - 2 *
> total_number_of_nodes)) file descriptors at the same time.
> Ensure all the DB2 Enterprise - Extended Edition environment variables
> are defined in the profile file.
> Ensure the profile file is written in the Korn Shell script format.
> Ensure that all the host names defined in the db2nodes.cfg file in the
> sqllib directory are defined on the network and are running.

> I checked for all the suggested corrections and it did not work out.
> I tried to run ADD NODE command from the box I'm creating a node on
> this gave me
> SQL1469N instance "db2inst1" (nodenum "2") does not have node "2"
> specified in its db2nodes.cfg file

If you want to use add node, you need edit db2nodes.cfg and manualy add
the new node (db partition) before using add node command.
(Also you should check /etc/services to gurantee you keep enough ports for
all the nodes).
Regards,
Fan Ruo Xin

- Show quoted text -

Quote:

> Is there any way out?

> Thanks,
> Alkuzo



Mon, 13 Sep 2004 11:20:28 GMT
 Add Node problems
Fan Ruo Xin,
thank you for the suggestions


Quote:
> > User Response: Do the following:

> > Ensure that the node has the proper authorization defined in the
> > .rhosts or the host.equiv files.

> Are you sure you check this?

There are 2 partitions on 1 box, I'm adding the 3rd on another box.
I ran
rsh <ip address> df
from every node giving the other's IP address, got correct results, as
the disks are different and I can distinguish what's the machine.

Quote:

> If you want to use add node, you need edit db2nodes.cfg and manualy add
> the new node (db partition) before using add node command.
> (Also you should check /etc/services to gurantee you keep enough ports for
> all the nodes).
> Regards,
> Fan Ruo Xin

I've got a 10 port slot reserved in /etc/services on every machine.

I successfully added a third partition on the same machine partitions
1 and 2 are on. No problem.

Thanks,
Alkuzo



Mon, 13 Sep 2004 23:07:32 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Adding a 2nd node to a Singly node w2k/SQL2k cluster

2. PROBLEMS WITH UPDATEGRAM USING MULTIPLE NODES AT SAME NODE LEVEL

3. Adding a second node later

4. HowTo: Add Node Values as attributes to HTML Tags

5. Adding Multiple Child Node For XML Explicit

6. Adding new node members.

7. Adding a third instance to a 2 node cluster

8. sql2k clustering failure to add node

9. how to add a 3rd node to the cluster in nt4\sql server 7.0

10. adding Instances to a 2-Node OPS

11. RAC 9i add node

12. OPS adding a new node


 
Powered by phpBB® Forum Software