WebSphere Application Server Liberty Profile: Specifying the alternate address and port for a Db2 clustered database

For IBM® WebSphere® Application Server Liberty Profile to communicate with more than one server, specify an alternate address and port for a Db2 database.

Procedure

  1. Edit the following file:
    AIX Linux
    IS_install_path/wlp/usr/servers/iis/datasources.xml
    Windows
    IS_install_path\wlp\usr\servers\iis\datasources.xml
  2. For each <dataSource/> element in the file, add the following information in bold as attributes to the <properties.db2.jcc/> child element, substituting the alternate address and port information with your values.
    <dataSource jndiName="jdbc/ASBDataSource"
        id="DataSource_ASBDataSource" jdbcDriverRef="db2Driver"
         isolationLevel="TRANSACTION_READ_COMMITTED"
         beginTranForResultSetScrollingAPIs="true"
        connectionManagerRef="ConnectionPool_ASBDataSource">
       <properties.db2.jcc databaseName="${iis.db.name}" portNumber="${iis.db.port}"
         driverType="4" serverName="${iis.db.host}"
         password="${iis.db.password}" user="${iis.db.user}"
         clientRerouteAlternateServerName="<alternate_host_name>"
         clientRerouteAlternatePortNumber="<alternate_port>"
         maxRetriesForClientReroute="2"
         retryIntervalForClientReroute="15"
         enableSeamlessFailover="1"
      >
    </dataSource>