DB2 10.5 for Linux, UNIX, and Windows

ConnectNode CLI/ODBC configuration keyword

Specifies the database partition server to which a connection is to be made.

db2cli.ini keyword syntax:
ConnectNode = integer value from 0 to 999 | SQL_CONN_CATALOG_NODE
Default setting:
Database partition server which is defined with port 0 on the machine is used.
Only applicable when:
Connecting to a partitioned database environment.
Equivalent connection attribute:
SQL_ATTR_CONNECT_NODE
Usage notes:
Used to specify the target database partition server that you want to connect to. Can be set to:
  • an integer between 0 and 999
  • SQL_CONN_CATALOG_NODE
If this variable is not set, the target defaults to the database partition server that is defined with port 0 on the machine.

This keyword (or attribute setting) overrides the value of the DB2NODE environment variable. Any out of range value specified for this keyword is ignored and the SQL_CONN_CATALOG_NODE value is used instead.