Create an SLA

Use this wizard to create a service level agreement (SLA) for a connection unit.

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). 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

The servers in the SLA listed 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.