Configuring load balancing with the ObjectServer
Learn how to configure load balancing or high availability (HA) with an ObjectServer as the database.
ObjectServer-based HA requires Jazz® for Service Management 1.1.3.12 (DASH 3.1.3.12) or later and IBM® Netcool®/OMNIbus WebGUI 8.1.0.24 or later.
If you want to configure load balancing or high availability (HA) with Db2 as the database, see Configuring load balancing for on-premises WebGUI or Dashboard Application Services Hub nodes with Db2
ObjectServer configuration
Complete the following tasks on the IBM
Tivoli®
Netcool/OMNIbus ObjectServer
administration client (<Omnibus_home>/bin/nco_config).
- Create an ObjectServer group named
WebHA
, which has two roles,CatalogUser
andDatabaseAdmin
. - Create a non-root user in the ObjectServer and assign the user to the
WebHA
group. - Create a database in the ObjectServer named
dashdb
. Open the ObjectServer UI and select the database section. Click Create Database.
WebGUI configuration
Log in to WebGUI, start the
WebSphere®
Application Server administration
console, and complete the following tasks.
- Create the stored credentials alias for the JDBC connection.
- From the navigation page, click J2C authentication data. . Expand the Java™ Authentication and Authorization Service section and click
- Create an alias to specify the ObjectServer credentials to be used for the
tipds
data source. - Specify the non-root user, which you added to the WebHA group in the ObjectServer.
- Click Apply and Save.
- Create a Sybase JDBC provider for the ObjectServer.
- Select .
- Under Scope: Cell=JazzSMNode01Cell, Node=JazzSMNode01, Server=server1, select Node=JazzSMNode01, Server=server1 and click New.
- Complete the JDBC provider configuration.
- Create the
tipds
JDBC data source.- Select .
- Under Scope: Cell=JazzSMNode01Cell, Node=JazzSMNode01, Server=server1, select Node=JazzSMNode01, Server=server1 and click New.
- Provide the data source name as
tipds
and the JNDI name asjdbc/tipds
, and click Next. - Select an existing JDBC Provider and choose Sybase JDBC 3 Driver. Click Next.
- Provide the port number and server name of the ObjectServer. Enter
dashdb
for the database name. Click Next. - Set up security aliases and click Next.
- Check the summary and click Finish.
- Test the connection by selecting the data source and clicking Test connection.
- Open the
tipds
data source and select Custom properties. - Click New and create a property that is called
APPLICATIONNAME
. Set the value toWebHA
. Then click Apply. Save the link that is displayed.
- Add signer certificates for the other WebGUI cluster members to establish server-to-server trust. For more information, see JazzSM DASH - Exchanging signer certificate for DASH server in a high-availability load-balancing cluster in IBM Support.
- Update the WebGUI HA properties in the <WebGUI_Home>/etc/server.init file. For more information, see Configuring load balancing for on-premises WebGUI or Dashboard Application Services Hub nodes with Db2.
- Restart the WebGUI server process.
- Repeat the previous steps to create the JDBC provider and
tipds
data source on all WebGUI servers.
Configuring fail-over to a secondary ObjectServer HA database.
Complete the following steps to configure fail-over between two ObjectServers.
- Install two ObjectServers AGG_P(Primary) and AGG_B(Backup). For more information, see Installing the primary aggregation ObjectServer
in the Netcool/OMNIbus documentation.
- Set up a gateway.
- Download the AGG_GATE.tblrep.def.txt file and append the contents into the <NCHOME>/omnibus/etc/AGG_GATE.tblrep.def file.
- Download the AGG_GATE.map.txt file and append the contents into the <NCHOME>/omnibus/etc/AGG_GATE.map file.
- Verify that the
<NCHOME>/omibus/etc/AGG_GATE.props
file contains the correct ObjectServer instance names. - To create the dashdb database, download the webha.sql script and run it on both AGG_P and AGG_B.
- Start AGG_P and AGG_B:
$NCHOME/omnibus/bin/nco_objserv -name AGG_P $NCHOME/omnibus/bin/nco_objserv -name AGG_B
- Start the
gateway:
NCHOME/omnibs/bin/nco_g_objserver_bi -propsfile NCHOME/omnibus/etc/AGG_GATE.props (or) nco_g_objserv_bi -name AGG_GATE -objectserveraserver NCOMS_AGG_P -objectserverbserver NCOMS_AGG_B
- Add fail-over properties to the
tipds
data source.- In the WebSphere Application Server administration console, go to .
- Click New.
- Set the name to
REQUEST_HA_SESSION
and the value totrue
. Then click Apply. Save the link that is displayed. - Click New.
- Set the name to
SECONDARY_SERVER_HOSTPORT
and the value to<Secondary_objectserver_host>:<port>
. Then click Apply. Save the link that is displayed.
- Restart the WebGUI server.