Configuring environments and setting configuration parameters for connection management

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

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.
  1. If clients or Connection Managers are installed on hosts where database servers are not installed, set each host's INFORMIXDIR environment variable to the directory the client or Connection Manager is installed in. Run the following command:
    setenv INFORMIXDIR path
  2. If clients or Connection Managers are installed on hosts where database servers are not installed, set each host's INFORMIXSQLHOSTS environment variable to the location of the sqlhosts file that the host uses. Run the following command:
    setenv INFORMIXSQLHOSTS path_and_filename
  3. If a Connection Manager's configuration file is in a directory other than $INFORMIXDIR/etc, set the CMCONFIG environment variable to the directory. Run the following command:
    setenv CMCONFIG path_and_filename
  4. 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
  5. 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
  6. 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

Copyright© 2019 HCL Technologies Limited