Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Pre-Upgrade Tasks
  4. Database Tasks
  5. Application Server Tasks
  6. Hub Store Upgrade
  7. Hub Server Upgrade (In-place Upgrade)
  8. Process Server Upgrade (In-place Upgrade)
  9. Resource Kit Upgrade (In-place Upgrade)
  10. Post-Upgrade Tasks
  11. Search Configuration Upgrade
  12. ActiveVOS Post-Installation Tasks for the Application Server
  13. ActiveVOS Post-Upgrade Tasks for Business Entity Adapter
  14. ActiveVOS Post-Upgrade Tasks for Subject Areas Adapter
  15. Troubleshooting the Upgrade Process
  16. Frequently Asked Questions
  17. Processing Existing ActiveVOS Tasks
  18. Configuring Metadata Caching

Upgrading from Version 9.5.1

Upgrading from Version 9.5.1

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!