DB2 10.5 for Linux, UNIX, and Windows

db2nchg - Change database partition server configuration command

Modifies database partition server configuration. This includes moving the database partition server from one machine to another; changing the TCP/IP host name of the machine; and selecting a different logical port number or a different network name for the database partition server.

This command can only be used if the database partition server is stopped.

This command is available on Windows operating systems only.

Authorization

Local Administrator

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-db2nchg--/n:--dbpartitionnum--+--------------------+--------->
                                 '-/i:--instance_name-'   

>--+------------------------+--+-------------------+------------>
   '-/u:--username,password-'  '-/p:--logical_port-'   

>--+----------------+--+-------------------+-------------------->
   '-/h:--host_name-'  '-/m:--machine_name-'   

>--+-------------------+---------------------------------------><
   '-/g:--network_name-'   

Command parameters

/n:dbpartitionnum
Specifies the database partition number of the database partition server's configuration that is to be changed.
/i:instance_name
Specifies the instance in which this database partition server participates. If a parameter is not specified, the default is the current instance.
/u:username,password
Specifies the user name and password. If a parameter is not specified, the existing user name and password will apply.
/p:logical_port
Specifies the logical port for the database partition server. This parameter must be specified to move the database partition server to a different machine. If a parameter is not specified, the logical port number will remain unchanged.
/h:host_name
Specifies TCP/IP host name used by FCM for internal communications. If this parameter is not specified, the host name will remain the same.
/m:machine_name
Specifies the machine where the database partition server will reside. The database partition server can only be moved if there are no existing databases in the instance.
/g:network_name
Changes the network name for the database partition server. 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.

Examples

To change the logical port assigned to database partition 2, which participates in the instance TESTMPP, to logical port 3, enter the following command:
   db2nchg /n:2 /i:TESTMPP /p:3