Cleaning up the Database Schema

Use the DDL Script Generator utility to generate scripts to clean up the database.

Procedure

  1. On the machine that runs ActiveMatrix Administrator, configure the drivers for database using TIBCO Configuration Tool.
  2. Navigate to the TIBCO_HOME/administrator/<version>/samples/ddl folder.
  3. Edit the generate_ddl.xml file and modify the dbType and dialect for your database type under the drop target. See DDLGeneratorTask for more information. 
    <target name="drop">
           <DDLGeneratorTask
            action="drop"
            targetDirectory="${admin.ddl.samples.directory}"
            dbType="oracle11g"
            dialect="com.tibco.amf.sharedresource.runtime.core.hibernate.
            dialects.Oracle10gDialect" />
          </target>
  4. Execute ant -f generate_ddl.xml drop.
  5. Depending on what portions of the schema you want to remove, have the DBA execute the script files - drop_*.ddl in the corresponding databases as explained in the Database Models section.
  6. (Optional) In addition to the generated scripts, if you want to use the Monitoring service, the DBA needs to execute an additional script corresponding to the monitoring data. It can be found under <TIBCO_HOME>/administrator/<version>/scripts/governance/ddl/drop_*.sql. Use the script corresponding to your database type.