Adds a database partition server (node) to an instance.
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.
Examples
To add a new database partition
server to the instance TESTMPP on the instance-owning computer SHAYER,
where the new database partition server is known as database partition
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 /h:TEST