Configuring environments and setting configuration parameters for connection management

Before you start a Connection Manager, you must configure its environment.

About this task

To set environment variables:

For UNIX™ C use the appropriate shell command. The following examples use C shell (csh).
For Windows™, use the Environment tab of the setnet32 utility.

Procedure

If clients or Connection Managers are installed on hosts where database servers are not installed, set each host's ONEDB_HOME environment variable to the directory the client or Connection Manager is installed in.
Run the following command:
```
setenv ONEDB_HOME path
```
If clients or Connection Managers are installed on hosts where database servers are not installed, set each host's ONEDB_ SQLHOSTS environment variable to the location of the sqlhosts file that the host uses.
Run the following command:
```
setenv ONEDB_ SQLHOSTS path_and_filename
```
If a Connection Manager's configuration file is in a directory other than $ONEDB_HOME/etc, set the CMCONFIG environment variable to the directory.
Run the following command:
```
setenv CMCONFIG path_and_filename
```
If Connection Managers control failover for a high-availability cluster, set the onconfig file DRAUTO configuration parameter to 3 on all managed cluster database servers.
For example:
```
DRAUTO 3
```
If Connection Managers control failover for a high-availability cluster, set the onconfig file HA_FOC_ORDER configuration parameter on the primary server of each cluster to a failover order.
For example:
```
HA_FOC_ORDER SDS,HDR,RSS
```

On each database server that uses multiple ports, set the onconfig file DBSERVERALIASES configuration parameter to the alias names listed in Connection Manager and database server sqlhosts file entries.

For example:

A Connection Manager's host has the following sqlhost file entries:

#dbservername   nettype    hostname   servicename   options
 my_servers     group      -          -             c=1,e=server_3
 server_1       onsoctcp   host_1     port_1        s=6,g=my_servers
 server_2       onsoctcp   host_2     port_2        s=6,g=my_servers
 server_3       onsoctcp   host_3     port_3        s=6,g=my_servers

 my_aliases     group      -          -             c=1,e=a_server_3
 a_server_1     onsoctcp   host_1     port_4        g=my_aliases
 a_server_2     onsoctcp   host_2     port_5        g=my_aliases
 a_server_3     onsoctcp   host_3     port_6        g=my_aliases

In the onconfig file for server_1, set the following value:

DBSERVERALIASES a_server_1

In the onconfig file for server_2, set the following value:

DBSERVERALIASES a_server_2

In the onconfig file for server_3, set the following value:

DBSERVERALIASES a_server_3