Command Reference

db2ncrt - Add Database Partition Server to an Instance

Adds a database partition server (node) to an instance.

This command is available on Windows NT and Windows 2000 only.

Scope

If a database partition server is added to a machine where an instance already exists, a database partition server is added as a logical node to the machine. If a database partition server is added to a machine where an instance does not exist, the instance is added and the machine becomes a new physical node. This command should not be used if there are databases in an instance. Instead, the db2start addnode nodenum command should be used. This ensures that the database is correctly added to the new database partition server. To add a node to an instance in which a database has been created, refer to the Administration Guide.

Note:

The db2nodes.cfg file should not be edited since changing the file may cause inconsistencies in the partitioned database system.

Authorization

Local Administrator authority on the machine where the new node is added.

Command Syntax

>>-db2ncrt----/n:--node_number----/u:--username,password-------->
 
>-----+---------------------+---+--------------------+---------->
      '-/i:--instance_name--'   '-/m:--machine_name--'
 
>-----+--------------------+---+-----------------+-------------->
      '-/p:--logical_port--'   '-/h:--host_name--'
 
>-----+--------------------+------------------------------------>
      '-/g:--network_name--'
 
>-----+-------------------------------+------------------------><
      '-/o:--instance_owning_machine--'
 

Command Parameters

/n:node_number

A unique node number which identifies the database partition server. The number entered can range from 1 to 999.

/u:domain_name\username,password

Specifies the domain, logon account name and password for DB2.

/i:instance_name

Specifies the instance name. If a parameter is not specified, the default is the current instance.

/m:machine_name

Specifies the computer name of the Windows NT workstation on which the node resides. This parameter is required if a database partition server is added on a remote machine.

/p:logical_port

Specifies the logical port number used for the database partition server. If this parameter is not specified, the logical port number assigned will be 0.

Note:

When creating a logical node, this parameter must be specified and a logical port number that is not in use must be selected. Note the following restrictions: Every machine must have a database partition server that has a logical port 0. The port number cannot exceed the port range reserved for FCM communications in the x:\winnt\system32\drivers\etc\ directory. For example, if a range of 4 ports is reserved for the current instance, then the maximum port number is 3. Port 0 is used for the default logical node.

/h:host_name

Specifies the TCP/IP host name that is used by FCM for internal communications. This parameter is required when the database partition server is being added on a remote machine.

/g:network_name

Specifies the network name for the database partition server. If a parameter is not specified, the first IP address detected on the system will be used. This parameter can be used to apply a specific IP address to the database partition server when there are multiple IP addresses on a machine. The network name or the IP address can be entered.

/o:instance_owning_machine

Specifies the computer name of 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.

Examples

To add a new database partition server to the instance TESTMPP on the instance-owning machine SHAYER, where the new database partition server is known as node 2 and uses logical port 1, enter the following command:

   db2ncrt /n:2 /u:QBPAULZ\paulz,g1reeky /i:TESTMPP /m:TEST /p:1 /o:SHAYER

See Also

db2nchg - Change Database Partition Server Configuration.