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.