One Two or Three Table spaces Option

If you choose to create one, two, or three table spaces, you need to modify the sqlscripts in the $MQ_HOME/db/oracle/install/scripts/ddl directory to create data structures in the appropriate table spaces.

  • One table space for data and indexes
  • Two table spaces, one for data and one for indexes
  • Separate table spaces for each set of tables
  • A combination of one of these three options
    Database SQL Scripts - One, Two, or Three Tablespaces Option
    SQL Script Description
    create_tabs.sql All fixed tables used in TIBCO MDM are created by this script. These tables are created by default in the VELODBDATA1 table space. The name of the table space needs to be modified appropriately in this script. If the default storage parameters are not good enough for some tables, contact your Database Administrator to modify this script to create tables with the appropriate storage parameters.
    create_PK.sql The primary keys for all the fixed tables are created by this script. These primary keys are created by default in the VELODBINDX1 table space. The table space name needs to be modified appropriately in this script.
    create_indexes.sql The indexes for all the fixed tables are created by this script. These indexes are created by default in the VELODBINDX1 table space. The table space name needs to be modified appropriately in this script.
    create_ds_tables.sql All data source tables used in TIBCO MDM are created by this script. These tables are created by default in the VELODBDF table space. The name of the table space needs to be modified appropriately in this script.

After modifying the SQL scripts, you need to perform the two steps required for the five table space option. The output of these scripts goes into the log file $MQ_HOME/db/oracle/install/logs/output.log. Ensure that there are no errors during the execution of these scripts.