You may be able to use the IQ Network Client to balance the query load among multiplex query servers. This method requires an intermediate system that is able to dispatch the client connection to a machine in a pool, depending on the workload of the machine.
To use this method, on the client system you create a special ODBC DSN, with the IP address and port number of this intermediate load balancing system, a generic server name, and the VerifyServerName connection parameter set to NO. When a client connects using this DSN, the load balancer establishes the connection to the machine it determines is least loaded.
For details on how to define an ODBC DSN for use in query server load balancing, see “VerifyServerName parameter [Verify]” in Chapter 4, “Connection and Communication Parameters” of the Sybase IQ System Administration Guide.
