For any database, the first step to accessing data is making a connection from the client to the server. You may need to establish connections from clients to your IBMÂ® DB2Â® Universal Databaseâ„¢ server across a wide area network or from the Web. If you have many connections coming in, with the potential for overloading your network or server at peak times, you may be looking at implementing a load balancing solution to spread requests across multiple servers. The flexibility of routing these connections by using facilities outside of DB2 has many potential applications.
This article discusses one method of routing TCP/IP DB2 connections using an open source TCP proxy utility called Balance.
See the complete article on developerworks