Installing and setting up the database

Complete these procedures 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_12 for the production database. Using this naming convention can help other members of your organization and IBM® Support understand the mapping between instances, accounts, and databases.

Procedure

  1. Complete the applicable database worksheets that are listed as related reference.
  2. If you are using IBM Db2® for your database, download the required parts and assets:
    1. Download IBM Db2 Standard Edition from IBM Fix Central. For information, see the article Db2 Version 11.5 Mod 5 Fix Pack 0 for Linux®, UNIX, and Windows on the IBM Support site.
    2. Download the part Bundled Software for IBM InfoSphere Master Data Management 12.0 - IBM Db2 Standard 11.5.5 from IBM Passport Advantage®. This part contains your Db2 license. For more information downloading this part, see the article Download IBM® InfoSphere® Master Data Management 12.0 on the IBM Support site.
  3. Create your database user accounts with appropriate permissions and ensure that other prerequisites are in place. If you are using Db2, see the Db2 installation prerequisites. If you are using another database type, see the corresponding documentation provided by the database vendor.
  4. Install your database instances. If you are using Db2, see the Db2 installation documentation. If you are using another database type, see the corresponding documentation provided by the database vendor.
  5. For each Db2 installation instance, apply the license that you downloaded from IBM Passport Advantage. For more information, see the Db2 documentation.
  6. Extract the Installation Startup Kit from the downloaded distribution asset part (IBM InfoSphere Master Data Management Standard & Advanced Edition <version> Multiplatform Multilingual eAssembly). The Startup Kit provides scripts that you can use to create the MDM database.
    The location that you extract the Startup Kit to will be referred to in this documentation as the STARTUPKIT_INSTALL_HOME.
  7. 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.