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.

workload_balancing

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:

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.