Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Pre-Installation Tasks
  4. Hub Store Installation
  5. Hub Server Installation
  6. Hub Server Post-Installation Tasks
  7. Process Server Installation
  8. Process Server Post-Installation Tasks
  9. ActiveVOS Post-Installation Tasks for the Application Server
  10. ActiveVOS Post-Installation Tasks for the Business Entity Adapter
  11. Resource Kit Installation
  12. Resource Kit Post-Installation Tasks
  13. Troubleshooting the MDM Hub
  14. Uninstallation

Installation Guide for IBM DB2 with Red Hat JBoss

Installation Guide for IBM DB2 with Red Hat JBoss

Use a Script to Create a Database and Tablespaces

Use a Script to Create a Database and Tablespaces

The MDM Hub distribution includes a script to create the database and associated tablespaces. To run the script, you need administrative privileges with write and execute permissions to the DB2 data directory.
On UNIX, before you create the database, update the
db2.storage.path
property in the
database.properties
file with the correct database storage path. The
database.properties
file is in the following directory:
<
MDM Hub distribution directory
>/database/bin/db2
  1. Open a command prompt, and change to the following directory:
    <
    MDM Hub distribution directory
    >/database/bin
  2. To create the database, run the following command:
    On UNIX.
    ./sip_ant.sh create_db
    On Windows.
    sip_ant.bat create_db
  3. Answer the prompts described in the following table:
    Prompt
    Description
    Enter the database type (ORACLE, MSSQL, DB2)
    Database type. Specify DB2.
    Enter the database instance name [db2]
    Name of the database instance. Default is
    db2
    .
    Enter the database name [SIP97]
    Name of the database. Default is
    SIP97
    .
    Enter the database storage path [C:\DB2DATA]
    Path to the directory where the database must be stored. Default is
    C:\DB2DATA
    .
    On UNIX, accept the default value. The database storage path that you specify in the
    database.properties
    file will be used.
    Enter the DBA user name [DB2ADMIN]
    User name of the administrative user. Default is
    DB2ADMIN
    .
    Enter the DBA password
    Password of the administrative user.
    The script creates the database and the following tablespaces:
    • CMX_DATA
    • CMX_INDX
    • CMX_TEMP
    • CMX_REPOS
    • CMX_USER_TEMP
    • CMX_SYS_TEMP
To verify that the database was created successfully, review the
sip_ant.log
file in the
<
MDM Hub distribution directory
>/database/bin
directory.

0 COMMENTS

We’d like to hear from you!