Configuring multiple logical partitions

There are two methods of configuring multiple logical partitions.

About this task

  • Configure the logical partitions (database partitions) in the db2nodes.cfg file. You can then start all the logical and remote partitions with the db2start command or its associated API.
    Note: For Windows, you must use db2ncrt to add a database partition if there is no database in the system; or, db2start addnode command if there is one or more databases. Within Windows, the db2nodes.cfg file should never be manually edited.
  • Restart a logical partition on another processor on which other logical partitions are already running. This allows you to override the hostname and port number specified for the logical partition in db2nodes.cfg.

To configure a logical database partition in db2nodes.cfg, you must make an entry in the file to allocate a logical port number for the database partition. Following is the syntax you should use:
   nodenumber hostname logical-port netname
Note: For Windows, you must use db2ncrt to add a database partition if there is no database in the system; or, db2start addnode command if there is one or more databases. Within Windows, the db2nodes.cfg file should never be manually edited.
The format for the db2nodes.cfg file on Windows is different when compared to the same file on UNIX. On Windows, the column format is:
     nodenumber hostname computername logical_port netname

Use the fully-qualified name for the hostname. The /etc/hosts file also should use the fully-qualified name. If the fully-qualified name is not used in the db2nodes.cfg file and in the/etc/hosts file, you might receive error message SQL30082N RC=3.

You must ensure that you define enough ports in the services file of the etc directory for FCM communications.