Run schema creation scripts

After you install the WebSphere Application server, the database and the IBM® InfoSphere® Master Data Management Collaboration Server - Collaborative Edition application, you must run the scripts to create the schema for the database.

Creating a schema

IBM InfoSphere Master Data Management Collaboration Server - Collaborative Edition provides a script that you use to create the schema for your database.

Before you can create a schema, ensure that you:
  • Create valid table space names and ensure that they are valid.
  • Ensure database connectivity.
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 described in the Creating tablespaces, make sure to use an appropriate table space mapping file.

The <install dir>/bin/db/analyze_schema.sh runs the local database schema analyzer.

  1. 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: Run create_schema.sh only one time. If you run create_schema.sh on an existing schema, you replace the existing schema with an empty schema.
  2. 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.

  3. Review the log file after you have run the create_schema.sh command to check for errors.