IBM® InfoSphere® Master Data Management
Collaboration Server provides
a script that you use to create the schema for your database.
Before you begin
Before you can create a schema, ensure that you:
- Create valid table space names and ensure that they are valid.
- Ensure database connectivity.
About this task
If you run the create_schema.sh script without
the tablespace option, all tables and indexes are
created in the default table spaces USERs and INDX only. If you created
all of the buffer pools and table spaces as outlined in the Creating tablespaces topic, make sure to use an
appropriate table space mapping file. The <install
dir>/bin/db/analyze_schema.sh runs the native database
schema analyzer.
Procedure
- Use the following shell script to create the schema: <install
dir>/bin/db/create_schema.sh. It creates a log file that
is called <install dir>/logs/schema.log.
Attention: When you run the create_schema.sh script,
errors are not displayed. Ensure that you review the log file to view
any errors.
Note: Only run create_schema.sh one
time. If you run create_schema.sh on an existing
schema, you replace it with an empty schema.
- Optional: You can specify the --tablespace argument
to specify a table space name mapping file that shows the customized
table space names for the required table spaces: create_schema.sh
--tablespace=<tablespace name mapping file>.
If
you do not specify the argument
--tablespace=tablespace_name_mapping_file on
the command line when you first run the
create_schema.sh script,
all tables and indexes are created in the default table spaces USERS
and INDX. If you do not specify the argument
--tablespace=tablespace_name_mapping_file in
a later run, the name that is used for the previous
create schema operation
is used. For more information about table spaces, see
Table space names for static tables
- Review the log file after running the
create_schema.sh command
to check for errors.