Table of Contents

Search

  1. Introduction
  2. Samples and Examples
  3. Tools and Utilities
  4. SDK Resources

Step 1. Prepare for the Database Performance Test

Step 1. Prepare for the Database Performance Test

Before you test the database performance and compare the results with that of the Informatica benchmark environment, prepare the database environment.
  1. Install and configure the database that you use or want to use for the MDM Hub or Informatica PIM.
    You can use Oracle, IBM DB2, and Microsoft SQL Server.
  2. Ensure that you have the privileges for the following database operations:
    • Create tables
    • Create indexes
    • Drop tables
    • Update tables
    • Select
    • Delete
  3. Ensure that the database has 5 GB to 25 GB of space.
    To help load up to 100 million records, you require 5 GB to 25 GB of space.
  4. Set the PATH environment variable to point to the Java 7 installation directory.
    The database performance testing utility is a Java based utility that requires Java 7.
  5. Stop the application servers on which the MDM Hub runs.
  6. To ensure that all applications are stopped, restart the database server.
    All the MDM Hub processes and Informatica PIM processes are stopped.

0 COMMENTS

We’d like to hear from you!