Creating the Database Schema

You can explicitly generate DDL scripts and use them to create the database schema.

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 create target. See DDLGeneratorTask for more information.

   <target name="create">
              <DDLGeneratorTask
               action="create"
               targetDirectory="${admin.ddl.samples.directory}"
               dbType="oracle11g"
               dialect="com.tibco.amf.sharedresource.runtime.core.hibernate.
               dialects.Oracle10gDialect" />
           </target>

   Note: If you are creating the second instance of a replicated ActiveMatrix Administrator Server, skip steps 2 and 3 while creating the ActiveMatrix Administrator server.
4. Execute ant -f generate_ddl.xml create.
5. Ensure that the Database Prerequisites mentioned under Configuring External Databases are met. Have the DBA execute the script files - create_*.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/create_*.sql. Use the script corresponding to your database type.
7. Run TIBCO Configuration Tool again to create the ActiveMatrix Administrator server.