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.
Note: This
keyword does not affect the Control Center. The Control Center always
connects to the catalog partition referred to by the SQL_CONN_CATALOG_NODE setting.
Important: The Control
Center and its associated components have been deprecated in Version
9.7 and might be removed in a future release.
Start using IBM® Data Studio and IBM Optim™ tools.
For a mapping between these recommended tools and Control Center tools,
see Table of recommended tools versus Control
Center tools.
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.