Solaris 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

Solaris clustered server: Install DB2

Solaris clustered server: Modify DB2 database properties

Solaris clustered server: Create groups and assign users

Solaris clustered server: Create DB2 databases

Solaris clustered server: Set up DB2 automatically or manually

Solaris 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: Solaris clustered server: Set up a remote DB2 database
Previous: Solaris clustered server: Configure Portal to use DB2
Next: Solaris clustered server: Configure DB2 for large file handling in WCM