db2ncrt - Add database partition server to an instance command

This command is available on Windows operating systems only.

Scope

If a database partition server is added to a computer where an instance already exists, a database partition server is added as a logical database partition server to the computer. If a database partition server is added to a computer where an instance does not exist, the instance is added and the computer becomes a new physical database partition server. This command should not be used if there are databases in an instance. Instead, the START DATABASE MANAGER command should be issued with the ADD DBPARTITIONNUM option. This ensures that the database is correctly added to the new database partition server. It is also possible to add a database partition server to an instance in which a database has been created. The db2nodes.cfg file should not be edited since changing the file might cause inconsistencies in the partitioned database environment.

Authorization

Local Administrator authority on the computer where the new database partition server is added.

Command syntax

>>-db2ncrt--/n:--dbpartitionnum--/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:dbpartitionnum

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

/u:username,password

Specifies the 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 workstation on which the database partition server resides. This parameter is required if a database partition server is added on a remote computer.

/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. When creating a logical database partition server, this parameter must be specified and a logical port number that is not in use must be selected. Note the following restrictions:

• Every computer 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 database partition server.

/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 computer.

/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 computer. The network name or the IP address can be entered.

/o:instance_owning_machine

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

Usage notes

db2ncrt command can be executed only on a partitioned database instance.