Can we change TIBCO BusinessWorks™ ProcessMonitor database schema from partitioned to non partitioned and vice a versa after installation?
Article ID: KB0079330
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessWorks ProcessMonitor | 2.2.x, 3.0.x,3.1.x |
| Not Applicable | - |
Description
Can we change TIBCO BusinessWorks™ ProcessMonitor database schema from partitioned to non partitioned and vice a versa after installation?
Issue/Introduction
Can we change TIBCO BusinessWorks™ ProcessMonitor database schema from partitioned to non partitioned and vice a versa after installation?
Environment
Product: TIBCO BusinessWorks™ ProcessMonitor
Version: 2.2.x, 3.0.x,3.1.x
OS: All Supported Operating Systems
--------------------
Resolution
Once you create TIBCO BusinessWorks™ ProcessMonitor(BWPM) database schema with partition during installation/schema creation then you can not change it later even during migration to higher environment you can not change from partitioned to NON partition
Only a re-installation will allow to move from partitioning to non-partitioning. So while upgrading also no way to chose NON-Partition option, there is need of re-install the BWPM with NON-partition option to use BWPM without partition, Please note on reinstalling BWPM or recreating schema existing BWPM data/configuration will be lost. There will be need to configure all BWPM setting(JMS,SMTP,Data provider user and roles and other settings) again with new/reinstalled setup.
Only a re-installation will allow to move from partitioning to non-partitioning. So while upgrading also no way to chose NON-Partition option, there is need of re-install the BWPM with NON-partition option to use BWPM without partition, Please note on reinstalling BWPM or recreating schema existing BWPM data/configuration will be lost. There will be need to configure all BWPM setting(JMS,SMTP,Data provider user and roles and other settings) again with new/reinstalled setup.
Feedback
Yes
No
Powered by
