ConnectNode CLI/ODBC and IBM data server driver 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
IBM® data server driverconfiguration file (db2dsdriver.cfg) syntax:: <parameter name = "Connect Node" value = "integer value from 0 to 999 | SQL_CONN_CATALOG_NODE"/>

Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.

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.