Generate TIBCO Service Performance Manager Database Schema

You can use TIBCO Configuration Tool to generate the database schema. Alternatively, you can use the TIBCO_HOME/spm/<version>/bin/tibspmddlgenerator utility from the command prompt to generate the Service Performance Manager database schema.

Provide the following details:
Item Description
Database Type The target database for which the database DDL schema files must be generated. Select one of the supported databases.
Config folder Location of the Service Performance Manager schema XML files. By default, it is at TIBCO_HOME/spm/<version>/config.
Output Folder The generated scripts are stored at this location. By default, it is at TIBCO_HOME/spm/<version>/bin/<Database_Type_Name>.
Property File Default values for database output folders and so on are read from a property file. By default, it is at TIBCO_HOME/spm/<version>/bin/tibspmddlgenerator.tra.

Click Generate Scripts to generate the database schema. An information window indicating the successful creation of the schema is displayed. Click OK. In the Output folder location, the following files are generated: 

spm_<database_type_name>_cleanupdml.sql
spm_<database_type_name>_createddl.sql
spm_<database_type_name>_dropddl.sql