Run schema creation scripts

After you install the WebSphere®, the database and the IBM® Product Master application, you must run the scripts to create the schema for the database.

Creating a schema

IBM Product Master 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. Optional:Using the following command, you can specify --silent argument to suppress confirmation messages when the script is run.
    nohup ./create_schema.sh --silent &
  4. After you run the create_schema.sh command, review the $TOP/logs/schema.log file to check for errors.