Reading the contents of partition windows

" " Node number
" " Host name
" " Port number
" " Switch name


" " Node Number

This column contains icons and node numbers.

The node numbers are unique numbers, and can be from 0 to 999. The numbers are stored in the db2nodes.cfg file. Node numbers are displayed in ascending sequence, though there may be gaps in the sequence.

Node numbers, once assigned, cannot be changed. This ensures that the information in the partitioning map (which details how data is partitioned) is not compromised.

" " Host name

The host name is the IP address used by FCM for internal communications (unless a switch name is specified. In this situation, FCM uses the switch name, and the host name is only used for DB2START, DB2STOP, and db2_all.) The host name is stored in the db2nodes.cfg file.

" " Port Number

The port number is the logical port number for the node. This number is used with the database manager instance name to identify a TCP/IP service name entry in the etc/services file. This number is stored in the db2nodes.cfg file.

The combination of the IP address (host name) and the logical port is used as a well-known address, and must be unique among all applications to support communication connections between nodes.

For each displayed host name, one port number will be 0. Port number 0 indicates the default node on the host to which clients connect. (To override this behavior, use the DB2NODE environment variable in db2profile script.)

" " Switch Name

The switch name is used to support a host that has more than one active TCP/IP interface, each with its own host name. The switch name is stored in the db2nodes.cfg file.

The switch name is only used for RS/6000 SP machines that have a primary host name that is either an Ethernet or a token-ring name, and DB2 Universal Database Extended Enterprise Edition is using the alternative switch name. If the switch name was not specified in the db2nodes.cfg file, it is the same as the host name.