Quick Beginnings EEE for Windows**


Adding a Logical Database Partition Server to an Instance

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.

Figure 00002674 not displayed.

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:

/n:node_number
Is a unique node number to identify the database partition server. This number can be from 1 to 999. This parameter is required.

/u:domain_name\username, password
Is the domain, logon account name, and password for the DB2 service that represents the database partition server. This parameter is required.

/i:instance_name
Is the instance name. This parameter is optional. If you do not specify this parameter, the default is the current instance.

/m:machine_name
Is the computer name of the Windows workstation on which the node resides. This parameter is required if you add the database partition server on a remote machine.

/p:logical_port
Specifies the logical port number used for the database partition server. This parameter is optional. If you do not specify this parameter, the logical port number assigned will be 0.

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:

/h:host_name
Specifies the TCP/IP host name that is used by FCM for internal communications (the port is not a node). This parameter is required if you add the database partition server on a remote machine.

/g:network_name
Specifies the network name for the database partition server. This parameter is optional.

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.

/o:instance_owning_machine
Is the computer name of the instance-owning machine; the default is the local machine. This parameter is required when the db2ncrt command is invoked on any machine that is not the instance-owning machine.

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

Changing the Database Partition Server Configuration

To re-configure a database partition server, you can use the db2nchg command. With the db2nchg command you can do the following:



Figure 00002674 not displayed.

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--'
 

/n:node_number
Specifies the node number of the database partition server's configuration you want to change. This parameter is required.

/i :instance_name
Specifies the instance that this database partition server participates in. This parameter is optional. If you do not specify this parameter, the default is the current instance.

/u:domain_name\username, password
Specify this option to change the domain, logon account name, and password for the DB2 service that represents the database partition server. This parameter is optional. If you do not specify this parameter, the domain, logon account, and password will remain the same.

/p:logical_port
Specify this option to change the logical port for the database partition server. This parameter must be specified if you move the database partition server to a different machine. If you do not specify this parameter, the logical port number will remain unchanged.

/h:host_name
Specify this option to change the TCP/IP hostname used by FCM for internal communications. This parameter is optional. If you did not specify this parameter, the host name is unchanged.

/m:machine_name
Specify this option to move the database partition server to another machine. The database partition server can only be moved if there are no existing databases in the instance. This parameter is optional.

/g:network_name
Specify this option to change the network name for the database partition server. This parameter is optional.

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


[ Top of Page | Previous Page | Next Page ]