Windows clustered server: Enable DB2 pureScale load balancing feature

For multithreaded Java applications, set enableSysplexWLB to true in the connection string to take advantage of transaction level workload balancing feature for DB2 pureScale. As additional members are started, clients automatically route to the new member without any interruption of service. Members can be stopped without the application knowing.

Prerequisites

Windows clustered server: Install DB2

Windows clustered server: Modify DB2 database properties

Windows clustered server: Create groups and assign users

Windows clustered server: Create DB2 databases

Windows clustered server: Set up DB2 automatically or manually

Windows clustered server: Configure Portal to use DB2

1. Open the dmgr console...
   http://your_server:9060/ibm/console/

2. Click Resources > JDBC > Data Sources.

3. Click Data sources > data source name > Custom properties.

4. Search for enableSysplexWLB.

5. Click enableSysplexWLB, and enter true in the Value field.

6. Click OK.

Parent: Windows clustered server: Set up a remote DB2 database
Previous: Windows clustered server: Configure Portal to use DB2
Next: Windows clustered server: Configure DB2 for large file handling in WCM