ONEDB_SERVER Connection Manager configuration parameter

The ONEDB_SERVER parameter specifies database servers or Enterprise Replication nodes that the Connection Manager connects to after it starts. The values of the ONEDB_SERVER parameter are also used for providing database server information for service-level agreements when a Connection Manager's SQLHOSTS parameter is set to REMOTE or LOCAL+REMOTE.

Syntax

CLUSTER connection unit

1  ONEDB_SERVER 
2.1 + , server_name
2.1 sqlhosts_group_name
GRID connection unit

1  ONEDB_SERVER
2.1+ ,
2.1 sqlhosts_group_name
REPLSET connection unit

1  ONEDB_SERVER
2.1+ ,
2.1 sqlhosts_group_name
SERVERSET connection unit

1  ONEDB_SERVER
2.1+ ,
2.1 sqlhosts_group_name
2.1 stand_alone_server_name

Usage

The ONEDB_SERVER parameter is required, and is supported by the following connection units:
  • CLUSTER
  • GRID
  • REPLSET
  • SERVERSET

For Enterprise Replication domains, list group names for the nodes that receive client requests from the Connection Manager.

For server-set replication domains, list group names for the nodes that receive client requests from the Connection Manager. List standalone server names, as well.

For high-availability clusters, list the group name for the cluster, or list the names of database servers.

Example

In the following example, the Connection Manager connects to all database servers that are members of the my_server_group group in the Connection Manager sqlhosts file.
NAME my_connection_manager


CLUSTER my_cluster
{
   ONEDB_SERVER my_server_group
   FOC ORDER=ENABLED \
       PRIORITY=1
}