DB2 pureScale 軟件安裝配置及常見問題解決3

DataSource

DriverManager

Conn-Level WLB

不支持

不支持

Trx-Level WLB

增加 DataSource 的屬性：
enableSysplexWLB=true

請參考 WAS 例子 A1

增加 Connection 的屬性：
enableSysplexWLB=true

可以使用屬性或在連接串里配置，請參考下一單元格

ACR
Pre-connection

方法一：增加 DataSource 的屬性

clientRerouteAlternateServerName=172.16.24.123
clientRerouteAlternatePortNumber=50001

請參考 WAS 例子 A2

方法二：生成 jndi，binding 到 DB2，參見 A.3
修改數據源參數 (Data sources > HLJRCCB
> WebSphere Application Server data source properties)
Client reroute server list JNDI name(clientRerouteServerListJNDIName) 指向 A3 所設置的 JNDI

方法一：使用屬性
Properties props = new Properties();
props.put(“user”, “db2sdin1”);
props.put(“password”, “db2”);
props.put(“enableSysplexWLB”, “true”);
props.put(“clientRerouteAlternateServerName”, “172.16.24.123”);
props.put(“clientRerouteAlternatePortNumber “, “50001”);
Connection c = DriverManager.getConnection(“jdbc:db2://172.16.24.122:50001/mydb”, props );
方法二：在連接串里增加屬性
conn = java.sql.DriverManager
.getConnection(“jdbc:db2://172.16.24.122:50001/HLJRCCB:user=db2sdin1;password=db2;
enableSysplexWLB=true;clientRerouteAlternatePortNumber=50001;
clientRerouteAlternateServerName=172.16.24.123;”);

注意：該方式不支持多於 2 個節點

ACR
Post-connection

默認 enable，無參數配置。
發生 ACR 時系統會報錯誤信息，錯誤信息參考 A4

默認 enable，無參數配置。
發生 ACR 時系統會報錯誤信息，錯誤信息參考 A4

InitialContext registry = new InitialContext();

// Create a DB2ClientRerouteServerList object

DB2ClientRerouteServerList address =

    newDB2ClientRerouteServerList();

// Set the port number and server name for the primary server

address.setPrimaryPortNumber(50001);

address.setPrimaryServerName(“172.16.24.122”);

// Set the port number and server name for the alternate server

int[] port = {50001};

String[] server = {“172.16.24.123”};

address.setAlternatePortNumber(port);

address.setAlternateServerName(server);

registry.rebind(“cell/persistent/serverList”, address);

com.ibm.db2.jcc.am.ClientRerouteException: [jcc][t4][2027][11212][4.9.66]

A connection failed but has been re-established. The host name or IP address

is “p5503” and the service name or port number is 50,001.

Special registers may or may not be re-attempted (Reason code = 1).

ERRORCODE=-4498, SQLSTATE=08506

172.16.24.122 p5502

172.16.24.123 p5503