Installing and setting up the database

You must complete this procedure to install and prepare your database before installing the InfoSphere® MDM application.

About this task

When you define names for your databases and user accounts, consider giving the associated database instance, user account, and data source configuration the same name. You might also want to include the InfoSphere MDM version in the name. For example, you might name each of these elements mdmprod_116 for the production database. Using this naming convention can help other members of your organization and IBM® Software Support understand the mapping between instances, accounts, and databases.

Procedure

  1. Complete the applicable database worksheets that are listed as related reference.
  2. Install the database software and create database user accounts with appropriate permissions. Use the documentation provided by the database vendor to complete your installation. Review the database user accounts topic before installing the database software.
  3. Extract the Installation Startup Kit from Part 1 of the downloaded distribution assets (IBM InfoSphere Master Data Management Standard & Advanced Edition Mulitplatform Multilingual <version> Part 1). The location that you extract the Startup Kit to will be referred to in this documentation as the STARTUPKIT_INSTALL_HOME.
    This toolkit provides scripts that you can use to create the MDM database.
  4. Create the MDM database using one of the following methods:
    • Run the Installation Startup Kit script that is applicable to your database type. The scripts automatically create the appropriate table spaces, buffer pools, and encoding specifications that are required for your InfoSphere MDM edition. For details, see the related topics Preparing a DB2 database and Preparing an Oracle database.
    • Manually create the database using another method.
    Note: For details about the required database configuration and settings, see the related reference topics.