General Page
Steps to upgrade JazzSM/DASH High Availability on NETCOOL/OMNIbus ObjectServer v8.1 or greater
1. Steps to run the upgrade JazzSM High Availability on ObjectServer
- The existing tables of DASH, WEBGUI in "dashdb" database including database need to be removed from the Omnibus ObjectServer. The steps are as follows
- Download attached "webha_rollback.sql" file and move to "$NCHOME/omnibus/bin" and execute below command
Example:
Unix: $NCHOME/omnibus/bin/nco_sql -server ObjectServer_name -username <username> -password <password> < webha_rollback.sql
Windows: %NCHOME%\omnibus\bin\isql -S ObjectServer_name -U username -P password -i webha_rollback.sql
2. After removal of database and tables, remove the existing data source in WebSphere Application Server
- Log in to WebSphere Application Server console
- From left navigation, click Resources ->JDBC ->data sources ->check 'tipds' -> click delete button
-
- click Save
- Perform same removal of data source on all other nodes, which are on high availability
3. After successful removal database, tables, and data source, start the JazzSM (DASH) application upgrade.
4. After completion of the application upgrade, create the database "dashdb" and required tables in Omnibus ObjectServer with the help of following steps
- Create database on ObjectServer: Run below mentioned script against AGG_P and AGG_B (ObjectServer) to initialize and create necessary DASH and WebGUI tables in the dashdb database for the primary and backup servers.
- Download attached script "webha.sql" and move to "$NCHOME/omnibus/bin" and run script as shown below
Example:
Unix: $NCHOME/omnibus/bin/nco_sql -server ObjectServer_name -username <username> -password <password> < webha.sql
Windows: %NCHOME%\omnibus\bin\isql -S ObjectServer_name -U <username> -P <password> -i webha.sql
5. Configure the data source in WebSphere Application Server
- Log in to WebSphere Application Server console
- Configure the data source: click data sources ->Select Scope: Node=JazzSMNode01, Server= server1->click Ne
- Provide the data source Name as ‘tipds’ and JNDI name as "jdbc/tipds" and click Next button
- Select an existing JDBC Provider ‘Sybase JDBC 3 Driver’ from drop and click Next
- Provide Port Number, Server Name of the ObjectServer. User "dashdb" for Database Name and click Next
- Setup security aliases ->click Next
- Check the summary and click Finish
- Test Connection ->Select the data source ->click Test connection
6. Repeat the same data source configuration steps on other nodes
7. Restart JazzSM profile server on all HA nodes
[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEKCU","label":"Jazz for Service Management"},"ARM Category":[{"code":"a8m500000008bsvAAA","label":"DASH"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.1.3"}]
Was this topic helpful?
Document Information
Modified date:
25 June 2021
UID
ibm16462897