Configuring for a Db2 database in HADR

Configure Db2 for generating Dynamic Workload Console reports when Db2 is configured for HADR.

About this task

You can optionally configure Db2 in HADR configuration so that you can connect to the secondary database if the primary database becomes unreachable.

To configure Db2 for generating reports when Db2 is configured for HADR, perform the following steps

Procedure

  1. Stop WebSphere® Application Server Liberty, as described in Application server - starting and stopping.
  2. Browse to the following paths, depending on your operating system:
    On UNIX operating systems
    TWA_home/usr/servers/engineServer/configDropins/templates
    On Windows operating systems
    TWA_home\usr\servers\engineServer\configDropins\templates
  3. Copy the datasource.xml file to a working location and edit it by adding the following strings: 
    
<variable name="db.clientRerouteAlternateServerName" value="secondary_database"/>
<variable name="db.clientRerouteAlternatePortNumber" value="secondary_database_port_number"/>
  4. You also need to add the call to the above variables. To perform this operation, modify the string: 
    <jndiEntry value="jdbc:db2://${db.serverName}:${db.portNumber}/${db.databaseName}" jndiName="db.url"/>
    as follows:
    :clientRerouteAlternateServerName=${db.clientRerouteAlternateServerName};clientRerouteAlternatePortNumber=${db.clientRerouteAlternatePortNumber};"
    The resulting string must be as follows:
    <jndiEntry value="jdbc:db2://${db.serverName}:${db.portNumber}/${db.databaseName}:clientRerouteAlternateServerName=${db.clientRerouteAlternateServerName};clientRerouteAlternatePortNumber=${db.clientRerouteAlternatePortNumber};" jndiName="db.url"/>
  5. Copy the edited file to the following paths:
    On UNIX operating systems
    TWA_DATA_DIR/usr/servers/engineServer/configDropins/overrides
    On Windows operating systems
    TWA_home\usr\servers\engineServer\configDropins\overrides
  6. Start WebSphere® Application Server Liberty, as described in Application server - starting and stopping.

Results

You have now configured your Db2database in HADR.

For more information about HADR configuration, see An active-active high availability scenario. For more information about templates, see Configuring HCL Workload Automation using templates.