Administrator Database

Prerequisites

The script files are located in TIBCO_HOME/administrator/version/scripts.

Edit the file /TIBCO_HOMEadministrator/versionscripts/bootstrap-edit-build.properties. Specify appropriate values for the following properties:
  • instance.properties.file - the location of the remote_props.properties file.
  • tibco.config.mgmt.home - the folder containing runtime object configuration, referred to as CONFIG_HOME.
  • admin.enterprise.name - the enterprise name.
  • admin.instance.name - the name of the Administrator server instance.

Internal Database

Procedure

  1. If moving from a different database, use the database specific migration tools to export or import existing data to the new database.
  2. Edit the data file for the application database. The file is located at TIBCO_HOME/administrator/3.2/scripts/edit-inprocess-database-data.xml.
  3. From the command-line prompt, navigate to the TIBCO_HOME/administrator/3.2/scripts folder.
  4. Run ant -f bootstrap-edit-build.xml edit-inprocess-database.

External Database

If using a Microsoft SQL server database make sure you use the case insensitive collation setting.

To point to a new database or to update the configuration of the existing database:

Procedure

  1. If moving from a different database, use the database specific migration tools to export or import existing data to the new database.
  2. Edit the data file for the application database. The file is located at TIBCO_HOME/administrator/3.2/scripts/edit-external-database-data.xml. The following properties have to be updated
    • dialect - the value of this property should match the value specified in the Teneo resource. For example com.tibco.amf.sharedresource.runtime.core.hibernate.dialects.SQLServerDialect.
    • dbURL - the location of the database. For example jdbc:sqlserver://localhost:1433;databaseName=sql.
    • jdbcDriver - the database driver class. For example com.microsoft.sqlserver.jdbc.SQLServerDriver.
    • username and password - the credentials to access the database.
  3. If using database drivers that have to be installed in the resolve mode, specify the provisionMode="resolve" attribute.
  4. From the command-line prompt, navigate to the TIBCO_HOME/administrator/3.2/scripts folder.
  5. Run ant -f bootstrap-edit-build.xml edit-external-database.
  6. Update and install the JDBC resource instances and the teneo and hibernate resource instances used by the applications.
  7. Stop and undeploy the following applications from the SystemEnvironment:
    • amx.payloadservice.app
    • amx.logservice.app
    • governance.mcr.aggregator
  8. Uninstall the Teneo and hibernate resource instances used by the applications listed in step GUID-574F4229-E2D4-45F3-81D8-1BADE3B878FE.html#GUID-574F4229-E2D4-45F3-81D8-1BADE3B878FE__STEP_9FDA7AB1DAA84D5CBFFDECAAE0362CEE.
  9. Uninstall the following JDBC resource instances:
    • GovernanceJDBCSharedResource
    • cl_logservice_jdbc
    • payloadJdbcSharedResource
  10. Install the JDBC resource instances listed in the previous step.
  11. Install the Teneo and hibernate resource instances used by the applications listed in step GUID-574F4229-E2D4-45F3-81D8-1BADE3B878FE.html#GUID-574F4229-E2D4-45F3-81D8-1BADE3B878FE__STEP_9FDA7AB1DAA84D5CBFFDECAAE0362CEE.
  12. Deploy and start the applications listed in step GUID-574F4229-E2D4-45F3-81D8-1BADE3B878FE.html#GUID-574F4229-E2D4-45F3-81D8-1BADE3B878FE__STEP_9FDA7AB1DAA84D5CBFFDECAAE0362CEE.
Contents
Search Results