Add a Connection Unit

Use this wizard to assign a connection unit to a Connection Manager, to create a service level agreement, and for a cluster, to configure failover.

A connection unit is a collection of database servers in a grid, a high-availability cluster, a replicate set, or a server set. A Connection Manager provides load balancing and directs client connection requests to the appropriate server in a connection unit based on service level agreements (SLA). A single Connection Manager can manage multiple connection units.

Connection Unit Type

Select the connection unit type.

Connection Unit

Select the connection unit. If you selected grid, cluster, or replicate set as the connection unit type, select a grid, cluster, or replicate set from the list of available connection units. The available connection units are on database servers that are in the current OAT group; that is, servers that the current server has connection information about. If the connection unit is not displayed in the list, click the Add button to connect to a server and add the server to the current OAT group. If you selected server set as the connection unit type, name the server set and select the servers. The Connection Manager requires that the server set name is in all ASCII characters, even for non-English locales.

Alarm Program

Optional: Specify the path and file name of a program or script to capture Connection Manager information and to initiate corrective actions or notifications. The Connection Manager event alarm is enabled by default.

Administrative Servers

Specify the database server that the Connection Manager connects to when it starts.

Failover Configuration

For a cluster, configure failover. A failover configuration specifies the secondary server that takes over the role of the primary server if the primary server fails. For example, HDR+server1 indicates that if the primary server is not available, the Connection Manager attempts to convert any HDR server to the primary server. If no HDR servers are available, the Connection Manager attempts to convert server1 to the primary server.

Service Level Agreement (SLA)

Define an SLA. An SLA is the contract between specified client applications and their service providers, in this case, the Informix database servers. Based on service level agreements, the Connection Manager connects the client applications to the appropriate servers.

SLA name

Enter the name. The client applications use the SLA name to connect to a server through the Connection Manager. The Connection Manager requires that the SLA name is in all ASCII characters, even for non-English locales.

Service Port

Specify the port number associated with the SLA.

Connection mode

Specify the connection mode.

Redirect

The Connection Manager redirects client connection requests to the appropriate server. The Connection Manager returns the appropriate server node, IP address, and port number to the client application (depending on the SLA definition). The client application connects to the server using the IP address and port number that the Connection Manager provides.

Proxy

The Connection Manager functions as a proxy server when clients connect to database servers from outside a firewall. The Connection Manager actively routes all client communications to and from the database servers.

Servers in the SLA

Specify the servers for the SLA in order of connection preference with the first server listed having the highest connection priority. For example, the list g_one,g_two,g_three indicates that the client is connected first to server g_one. If server g_one is not available, the client is connected to server g_two. If server g_two is not available, the client is connected to server g_three. When a group of servers is in parenthesis, all the servers have the same connection priority. For example, the following list gives each server equal priority: (g_one,g_two,g_three). For a cluster, the SLA can contain servers and server types. For example, the list SDS,HDR,RSS,primary indicates that the client is connected first to a shared disk secondary server (SDS).

Add Group

Click to create a group for load balancing. An empty group is displayed in the list of Servers in SLA. Select the load-balancing group and add servers or server types to it. Expand the group to display or remove servers and server types in the group.