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