Administrator Server Configuration: Edit Database Settings

Note: This screen is only displayed if you selected Edit Database Settings on the Edit ActiveMatrix Administrator Server Configuration screen.

The default value for each field shows the current configuration setting.

Changing Database Details

To change the database details, perform the following steps:
  1. From the TIBCO Administrator user interface, stop the following applications from the System environment:
    • com.tibco.amx.commonlogging.logservice.app
    • com.tibco.amx.commonlogging.payloadservice.app
  2. Perform the following steps to uninstall the resource instances:
    1. Make sure that you uninstall Log Service and Payload Service first. (TIBCO ActiveMatrix Payload Service Teneo Resource, TIBCO ActiveMatrix Log Service Teneo Resource).
    2. Uninstall the Teneo resource instances from the system node (TIBCO ActiveMatrix Governance Teneo Resource).
    3. Uninstall the Hibernate Resource Instance from the system node (TIBCO ActiveMatrix Governance Hibernate Resource).
    4. Uninstall in the following order : Log Service or Payload Service in any order followed by the Governance JDBC shared resource instances from the system node. Ensure that the Governance JDBC shared resource instance must be the last to be uninstalled. It is recommended to use the Force Uninstall option for JDBC Resource Instance.
    Note: If you skip steps 3 to 7, please restart TIBCO Host manually.
  3. If required, change the configuration of the user or database.
  4. Start TIBCO Configuration Tool and select Edit TIBCO ActiveMatrix Administrator Server Configuration - V3.4.
  5. Select the enterprise name and server name from the Server Configuration drop down menu, and select Edit Database settings.
  6. Edit the database configuration, and click Configure.

    When update is complete, TIBCO Configuration Tool restarts the SystemNode node.

  7. When the SystemNode node becomes available, log in to the TIBCO Administrator GUI and update the Governance JDBC resource with the new database configuration information. Cancel the pop-up to automatically synchronize the resource instances and applications.
  8. Install the following:
    1. JDBC Resource Instance for Governance JDBC Resource Instance. Make sure that Governance Service is installed before installing Log Service and Payload Service.
    2. Install the Hibernate Resource Instance (TIBCO ActiveMatrix Governance Hibernate Resource).
    3. Install the Teneo Resource Instances. Make sure Governance Service is done before installation of Log Service and Payload Service.
Note: If the data base URL is changed to point to a different database, make sure you migrate all the data from the old database location to the new database location. Editing the configuration alone does not migrate the data.
Field/Button Description
Use Default In-Process Database Indicate that the ActiveMatrix Administrator server database is an embedded in-process database. TCT does not support editing the in-process database details. If cleared, the external database configuration fields display.
Database Driver The driver for the external database.
Database URL The URL of the external database.
Username The external database username.
Password The external database password.
Max Connections The maximum number of database connections to allocate.
Database Server is SSL Enabled Indicate that the database server is enabled for SSL. When selected, the SSL Keystore Configuration fields are enabled.
Test Connection Verifies that TIBCO Configuration Tool can connect to the database server using the information supplied on this page.
Field Description
Create a Trust Store... Invokes a wizard to import certificates from a server and create the trust store.
Browse Invokes a dialog to navigate to a keystore file.
Keystore Location Location of the keystore.
Keystore Type Type of the keystore: JKS or JCEKS.
Keystore Password Password that protects the keystore.