IBM Traveler: How to setup enableSysplexWLB on Traveler JDBC connection to DB2?
One customer wants to use some Load balance features of DB2 JDBC drivers. This is done by parameter enableSysplexWLB.
enableSysplexWLB: Indicates whether the Sysplex workload balancing function of the IBM Data Server Driver for JDBC and SQLJ is enabled. The data type of enableSysplexWLB is boolean. The default is false.
How to setup enableSysplexWLB on Traveler ?
enableSysplexWLB is a JDBC parameter and can simply be specified on the connection URL.
To do this edit notes.ini and add to the NTS_DBCONNECTIONURL parameter, similar to shown below.
NTS_DBCONNECTIONURL=jdbc:db2://primaryDBbserver.yourco.com:50000/TRAVELER:parameter1=value1;parameter2=value2; ex: NTS_DBCONNECTIONURL=jdbc:db2://primaryDBbserver.yourco.com:50000/TRAVELER:enableSysplexWLB=true;
A server restart will be required for the change to take effect.
For a complete list of possible JDBC parameters please see: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052038.html