How to move TIBCO BusinessWorks ProcessMonitor (BWPM) database from one host to another.
Article ID: KB0089565
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessWorks ProcessMonitor | - |
| Not Applicable | - |
Description
Description:
After installation of TIBCO BusinessWorks ProcessMonitor (BWPM), there is a requirement for the database to be moved from one host to another host.
Resolution
In order to change the database host, the customers needs to obtain help from their DBA to do a database export from old host and
import the database to the new host. After this step, follow the steps below in order to successfully change the database host of the TIBCO BusinessWorks ProcessMonitor(BWPM) Server.
1). Stop Tomcat, Make a backup of TOMCAT_HOME/webapps/bwpm/WEB-INF/data/njams.minimal.config.properties file.
2). Change "dbServer" value to the new host in njams.minimal.config.properties. To find the new host value, execute the following query in the database of the new host:
select host_name from v$instanc;
Now change the "dbServer" value to the host_name which is a result from the above query.
3). Restart Tomcat.
Note that we have to use same username, password and schema name from the old host in the new host for a successful database move.
Issue/Introduction
Feedback
