Administration Guide

Adding a Database Partition Server to an Instance

On Windows NT or Windows 2000, use the db2ncrt command to add a database partition server (node) to an instance.

Note:

Do not use the db2ncrt command if the instance already contains databases. Instead, use the db2start addnode command. This ensures that the database is correctly added to the new database partition server. DO NOT EDIT the db2nodes.cfg file, since changing the file may cause inconsistencies in the partitioned database system.

The command has the following required parameters:

   db2ncrt /n:node_number
           /u:username,password
           /p:logical_port

• /n:

  The unique node number to identify the database partition server. The number can be from 1 to 999 in ascending sequence.

• /u:

  The logon account name and password of the DB2 service.

• /p:logical_port

  The logical port number used for the database partition server if the logical port is not zero (0). If not specified, the logical port number assigned is 0.

The logical port parameter is only optional when you create the first node on a machine. If you create a logical node, you must specify this parameter and select a logical port number that is not in use. There are several restrictions:

• On every machine there must be a database partition server with a logical port 0.
• The port number cannot exceed the port range reserved for FCM communications in the services file in x:\winnt\system32\drivers\etc\ directory. For example, if you reserve a range of four ports for the current instance, then the maximum port number would be 3 (ports 1, 2, and 3; port 0 is for the default logical node). The port range is defined when db2icrt is used with the /r:base_port, end_port parameter.

There are also several optional parameters:

• /g:network_name

  Specifies the network name for the database partition server. If you do not specify this parameter, DB2 uses the first IP address it detects on your system.

  Use this parameter if you have multiple IP addresses on a machine and you want to specify the database partition server. You can enter the network_name parameter using the network name or IP address.

• /h:host_name

  The TCP/IP host name that is used by FCM for internal communications if the host name is not the local host name. This parameter is required if you add the database partition server on a remote machine.

• /i:instance_name

  The instance name; the default is the current instance.

• /m:machine_name

  The computer name of the Windows NT workstation on which the node resides; the default name is the computer name of the local machine.

• /o:instance_owning_machine

  The computer name of the machine that is the instance-owning machine; the default is the local machine. This parameter is required when the db2ncrt command is invoked on any machine that is not the instance-owning machine.

For example, if you want to add a new database partition server to the instance TESTMPP (so that you are running multiple logical nodes) on the instance-owning machine MYMACHIN, and you want this new node to be known as node 2 using logical port 1, enter:

   db2ncrt /n:2 /p:1 /u:my_id,my_pword /i:TESTMPP
      /M:TEST /o:MYMACHIN