Workload balancing

Db2® pureScale® can be configured to dynamically balance the database workload across all cluster members at the transaction or connection level.

When enabled, a Db2 connection that was processing on one member could automatically shift to a less busy member in the next transaction. For example, when you add or restart a pureScale member, Db2 can gradually shift connections from the existing members to a new member to balance the utilization across each cluster members.

A flow diagram depicting how connections can be shifted from one member to another member.

To enable workload balancing, ensure to set the IBM® Db2 Driver for JDBC property, enableSysplexWLB to true. For the Sterling agents and integration servers, set the following parameter in the JDBC property file:

jdbcService.db2Pool.prop_enableSysplexWLB=true

In the WebSphere® Application Server administrative console, set the enableSysplexWLB property for the data source that your application uses to connect to the Database server.