Custom table space names
There are two types of tables: static tables and runtime tables. The InfoSphere® Master Data Management Collaboration Server - Collaborative Edition creates tables by two methods.
- Static tables
- These tables are created during installation phase when you run the create_schema.sh script.
- Runtime tables
- These tables are created during run time when the following functions are used:
- Creating user-defined logs
- Deleting a catalog
- Importing items
- Integrity verification scripts
- Docstore Maintenance script
This custom table space function addresses the deployment issues and is for new installations only, so there are no migration issues. If you have an existing system that is deployed, your DBA must manually change the table space names for all tables under InfoSphere Master Data Management Collaboration Server - Collaborative Edition database schema on an appropriate maintenance window. Also, the table space parameter in the common.properties file must be updated to new table space names where you want the runtime tables to be created.
Table space names for static tables
InfoSphere Master Data Management Collaboration Server - Collaborative Edition creates tables during installation phase by using default table space names: USERS, INDX, and BLOB_TBL_DATA.
A table space mapping file can be used to define custom table space names instead of the default table space names that are mentioned previously. This file is a comma-delimited text file that maps the tables, table spaces, and index table spaces together. This file is used as a parameter for the create_schema.sh script, for example:
$TOP/bin/db/create_schema.sh --tablespace=<table space name mapping file>
The table space name mapping file has the following format for each line:
- If any of the table_tablespace_name and index_tablespace_name are not specified, the default table space names are used.
- All the tables that are used by InfoSphere Master Data Management Collaboration Server - Collaborative Edition is not included in the mapping file, use the default table space names.
- Blank lines are ignored.
- Lines that start with
#are considered as comment lines and are ignored, for example:
# This is a comment line
This file follows the format that is specified previously and it can be used as a template for customizing table space names. It includes all required table spaces that are created during installation phase of InfoSphere Master Data Management Collaboration Server - Collaborative Edition.
In production environments, it is ideal to use the table spaces as outlined in the table space
requirements section, so highly used tables such as
itd, ita, itm, icm, and
lck are stored in separate table spaces and buffer pools. This separation helps to
improve overall performance. To do so, you need to create a table space mapping file with the
Table space names for runtime tables
IBM® InfoSphere Master Data Management Collaboration Server - Collaborative Edition creates tables during run time by using default table space names: USERS and INDX.
The default table space names can be changed through the $TOP/etc/default/common.properties file.
You can change these default table space names on these parameters in the user_tablespace_name and index_tablespace_name file. For example,
After you modify the table space name parameters, InfoSphere Master Data Management Collaboration Server - Collaborative Edition must be restarted. You must ensure that the table spaces are created and usable by InfoSphere Master Data Management Collaboration Server - Collaborative Edition database user before you restart.