test

Loading the Initial Data Set for a Sun Master Index

Creating the Cluster Synchronizer Database

The cluster synchronizer database helps manage the various processes perform by the IBML Tool. The database is required whether you run the IBML Tool in a distributed environment or on a single processor. The database consists of only three tables, and must be installed in the master index database.

Tip –

Before you begin each phase of the match and load process, make sure to truncate these tables with the script provided to avoid unique constraint errors in subsequent processes.

ProcedureTo Create the Cluster Synchronization Tables

  1. Complete the steps under Configuring the Environment.

  2. Obtain information about the master index database, such as the login ID and password of the user who created the master index database, the SID name, the port number, and the server name.

  3. Open a SQL editor, and log in to the master index database using the above information.

  4. Run NetBeans_Projects/Project_Name/loader-generated/cluster-synchronizer.sql against the database instance.

  5. Continue to Configuring the Initial Bulk Match and Load Tool.