Tablespaces Configuration

TIBCO MDM manages the master data of the enterprises across different tables in the database. To manage the data in the database, create individual tablespaces for all the large tables and their indexes.

Create all the indexes including unique and primary keys for each large table in a separate table space.

Create separate tablespaces for the following tables and their associated indexes:

• Master Catalog Table (MCT)
• MV_SHARED Tables for different data types
• MV Non Shared Tables (MVT)
• Relationship Attribute Tables (RCT)
• GOLDENCOPY
• PRINCIPALKEY
• PROCESSLOG
• PRODUCTKEY
• PRODUCTLOG
• RELATIONSHIP

For optimal performance it is recommended to have the data files on Solid State Drives (SSD).