Installation Guide for IBM Db2 with Red Hat JBoss

Back Next

Step 2. Create a Database and Tablespaces

After you install and configure IBM Db2, create and configure databases and tablespaces. You must create a database for each database instance.

If you want to create multiple MDM Hub Master Databases, create unique tablespaces for each MDM Hub Master Database.

The following table describes the tablespaces that you require for the MDM Hub schemas:

Tablespace Name	Description
CMX_DATA	Default tablespace for the Operational Reference Store schema. Contains the metadata and user data of the MDM Hub.
CMX_INDX	Tablespace to contain indexes that the MDM Hub creates and uses.
CMX_TEMP	Tablespace to contain temporary tables that the MDM Hub creates and uses.
CMX_REPOS	Tablespace to contain the Operational Reference Store objects.
CMX_USER_TEMP	Temporary tablespace to contain operational temporary tables.
CMX_SYS_TEMP	Temporary tablespace for SQL operations.