DB2 connection routing using Linux load balancing

  • 07 Jul, 2011

From developerworks…

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

PrevNext

Related Posts

Homepage Search: Profiles server fails while creating the initial index

  • 10 Sep, 2013

When trying to create the initial index for Global Search from the Homepage server, the index update fails with an error. To prevent further problems with indexing, perform a search in the Profiles database for any null entries in the table EMPINST.EMPLOYEE. select \ from EMPINST.EMPLOYEE
where EMPINST.EMPLOYEE.PROF\DISPLAY\NAME is null If any entries are returned they must be updated with an entry in the display name column for the Profiles feature to index successfully. To prevent this issue from occurring, change the value of PROF\DISPLAY\NAME=256 in the validate\dbrepos\fields.properties file, to contain the following: PROF\DISPLAY\NAME=(x != null) && (x.length() > 0) && (x.lengt

Homepage Search: Profiles server fails while creating the initial indexRead More

Proud to be an HCL Ambassador 2021

  • 15 Dec, 2020

​If you have a problem, and no-one else can help, and if you can find them, maybe you can ask an HCL Ambassador… !(http://www.mysphere.com.br/wp-content/uploads/2020/12/HCLAmbassaborlight4x.png) See the HCL Ambassadors Class of 2021(https://hcltechsw.com/about/hcl-ambassadors/class-of-2021)

Proud to be an HCL Ambassador 2021Read More

Nominate an IBM Champion

  • 30 Oct, 2019

IBM Champions demonstrate both expertise in and extraordinary support and advocacy for IBM technology, communities, and solutions. I am an IBM Champion since the first class  (2011) an this year i wish to be  an IBM Champion for the year 2020. New Champion Nominations are open now through 22 November 2019. Current IBM Champions may submit a renewal through 9 November 2019. To nominate an IBM Champion use this link(https://developer.ibm.com/champions/)

Nominate an IBM ChampionRead More