Command Reference

db2nchg - Change Database Partition Server Configuration

Modifies database partition server configuration. This includes moving the database partition server (node) 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 (node). This command can only be used if the database partition server is stopped.

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

Authorization

Local Administrator

Command Syntax

>>-db2nchg----/n:--node_number----+---------------------+------->
                                  '-/i:--instance_name--'
 
>-----+---------------------+---+--------------------+---------->
      '-/u:--user,password--'   '-/p:--logical_port--'
 
>-----+----------------+---+--------------------+--------------->
      '-/h:--hostname--'   '-/m:--machine_name--'
 
>-----+--------------------+-----------------------------------><
      '-/g:--network_name--'
 

Command Parameters

/n:node_number

Specifies the node 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 node 2, which participates in the instance TESTMPP, to logical port 3, enter the following command:

   db2nchg /n:2 /i:TESTMPP /p:3

See Also

db2ncrt - Add Database Partition Server to an Instance.