DB2 Connect load balancing

Donna Domovic

DB2 Connect load balancing

Hello,

We are running DB2 Connect on 1 server and would like to have it connect to a 2 member data sharing group on z/OS.  We'd like to have the connections round robined or load balanced between the 2 DB2 members on the mainframe (each is on a different CPU).

We know that we can set a primary and secondary node in the DB2 Connect Configuration but this seems to provide fail over if the primary DB2 subsystem is down not load balancing.

Is there some way to configure DB2 Connect on the server to load balance requests as they come in so that they are split between the 2 DB2 members on the mainframe?

Thanks,

Donna Domovic

[login to unmask email]

Jørn Thyssen

RE: DB2 Connect load balancing
(in response to Donna Domovic)

Hi Donna,

Have you considered to sunset your Db2 Connect server and instead use direct connection from your clients to Db2 for z/OS with property enableSysplexWLB = true

If you have the unlimited Db2 Connect license you can install the license in Db2 for z/OS. 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Chad Walmer

DB2 Connect load balancing
(in response to Donna Domovic)
You can use virtual addresses and the sysplex distributor feature of TCPIP. It will workload balance the connections based on feedback from WLM. It does require a fair amount of TCPIP setup but does work well once done. After the mainframe work is completed, there are changes required in the DB2 Connect node and DCS database definitions as well.

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/dshare/src/tpc/db2z_dvipanetworkaddress.html

http://www.redbooks.ibm.com/redpapers/pdfs/redp4449.pdf

Chad Walmer

From: Donna Domovic [mailto:[login to unmask email]
Sent: Friday, September 15, 2017 11:22 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 Connect load balancing


Hello,

We are running DB2 Connect on 1 server and would like to have it connect to a 2 member data sharing group on z/OS. We'd like to have the connections round robined or load balanced between the 2 DB2 members on the mainframe (each is on a different CPU).

We know that we can set a primary and secondary node in the DB2 Connect Configuration but this seems to provide fail over if the primary DB2 subsystem is down not load balancing.

Is there some way to configure DB2 Connect on the server to load balance requests as they come in so that they are split between the 2 DB2 members on the mainframe?

Thanks,

Donna Domovic

[login to unmask email]<mailto:[login to unmask email]>

-----End Original Message-----

Donna Domovic

RE: DB2 Connect load balancing
(in response to Chad Walmer)

Thanks for the replies.  We do have the unlimited license and it's enabled on the mainframe.

I may have used wrong terminology.  When I said DB2 Connect server, I meant that the application has DB2 Connect installed on the servers where the application runs. Since we have multiple applications, our preference right now is to control the DB2 Connect load balancing from the server side (hopefully directly through DB2 Connect settings).

Attached is a sample of our current DB2 Connect settings on the 2 servers this application uses with actual values changed for safety.  In my example, all connections from Server1 go to the MFLPAR1 LPAR and all connections from SERVER2 go to the MFLPAR2 LPAR.  We'd like connections from both of these servers to be split between MFLPAR1 and MFLPAR2 since the workload from each server can vary from day to day.

Are there any DB2 Connect settings that would allow this type of round robin connection?

Thanks,

Donna Domovic

Attachments

  • Sample DB2 Connect config.docx (12.4k)

J&#248;rn Thyssen

RE: DB2 Connect load balancing
(in response to Donna Domovic)

Hi Donna,

It looks like Db2 Connect is configured to connect to a specific member/LPAR instead of the group.

You should use the group VIPA instead and port instead:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/dshare/src/tpc/db2z_dvipanetworkaddress.html

To enable workload balancing you also need to set enableSysplex property. For CLI applications see:

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.cli.doc/doc/c0056065.html

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal.