Once you have created your partitioned database system by installing the instance-owning database partition server on one machine, and installing a database partition server on the other machines participating in the partitioned database system, you have the option of adding additional database partition server nodes (logical nodes) to your instance to create a multiple logical node (MLN) configuration.
Use the db2ncrt command to add a database partition server
(logical node) to an instance. Adding a database partition server to a
machine where an instance already exists using the db2ncrt command
adds a database partition server as a logical node to the machine.
![]() | Do not use the db2ncrt command if there are databases in an
instance, or if you are migrating databases from a previous version of
DB2.
Instead, you should use the db2start addnode nodenum command to scale your system after you have completed the post-installation migration tasks. This ensures that the database is correctly added to the new database partition server. If you want to add a node to an instance in which a database has been created, refer to the Administration Guide. Do not edit the db2nodes.cfg file, since changing the file may cause inconsistencies in the partitioned database system. |
The syntax of the db2ncrt command is as follows:
db2ncrt command >>-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--'
where:
If you are creating a logical node, you must specify this parameter and select a logical port number that is not is use. Note the following restrictions:
Use this parameter if you have multiple IP addresses on a machine and you want to use a specific IP address for the database partition server. You can enter the network_name parameter using the network name or IP address.
For example, if you want to add a new database partition server to the instance TESTMPP (so that you are running multiple logical nodes) on the instance-owning machine SHAYER, and you want this new node to be known as node 2 using logical port 1, enter the following command:
db2ncrt /n:2 /u:QBPAULZ\paulz,pas1wrd /i:TESTMPP /m:TEST /p:1 /o:SHAYER
To re-configure a database partition server, you can use the db2nchg command. With the db2nchg command you can do the following:
![]() |
You can only use this command if the database partition server is
stopped.
|
The syntax of the db2nchg command is as follows:
db2nchg command >>-db2nchg----/n:--node_number----+---------------------+-------> '-/i:--instance_name--' >-----+----------------------+---+--------------------+---------> '-/u:--user, password--' '-/p:--logical_port--' >-----+-----------------+---+--------------------+--------------> '-/h:--host_name--' '-/m:--machine_name--' >-----+--------------------+----------------------------------->< '-/g:--network_name--'
Use this parameter if you have multiple IP addresses on a machine and you want to use a specific IP address for the database partition server. You can enter the network_name using the network name or IP address.
For example, to change the logical port assigned to node 2, which participates in the instance TESTMPP, to use the logical port 3, enter the following command: db2nchg /n:2 /i:TESTMPP /p:3