Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing Identity Resolution
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading Identity Resolution
  7. Uninstalling Identity Resolution

Installation and Configuration Guide

Installation and Configuration Guide

Step 3. Create Tables

Step 3. Create Tables

Informatica provides scripts that you can run to create tables in IBM DB2 UDB. You can find the scripts in the following directory:
  • On Windows:
    <Identity Resolution Installation Directory>\dbscript\udb
  • On UNIX:
    <Identity Resolution Installation Directory>/dbscript/udb
For a complete list of the database objects that the scripts create, see the database scripts.
  1. On each database, run the following command to run the
    idstbudb.sql
    script:
    db2 -v -t -f idstbudb.sql -z <Log File Name> +o
    The
    idstbudb.sql
    script creates the following objects on the database:
    • IDS_FDT_META
    • IDS_FDT_RECID
    • IDS_RB_GROUPS
  2. On each source database that requires synchronization, run the
    udbsyncu.sql
    script.
    The
    udbsyncu.sql
    script creates the IDS_UPD_SYNC_TXN object on the source database.
    Never rerun the
    udbsyncu.sql
    script on a source database that you have already synchronized. Rerunning the script might result in a loss of synchronization.
  3. On each target database that requires synchronization, run the
    udbsynci.sql
    script.
    The
    udbsynci.sql
    script creates the following synchronizer objects on the target database:
    • IDS_UPD_SYNC_NSA
    • IDS_2PC