Loading the Initial Data Set for a Sun Master Index

Running the Bulk Matcher in Analysis Mode


Note –

This procedure includes steps that were updated for Java CAPS Release 6 Update 1. The variable JDBC_JAR_PATH was previously ORACLE_JDBC_JAR, and wasn't present in all files.


When you run the Bulk Matcher in analysis mode, use a representative sample of the actual data you are loading into the master index database. You do not need to run the entire set of input records through the analysis.


Caution – Caution –

If you are rerunning the Bulk Matcher in analysis mode, make sure to truncate the cluster synchronizer database tables first. Otherwise, unique constraint errors occur and the run fails. To truncate the tables, run cluster-truncate.sql against the cluster synchronizer database.


ProcedureTo Run the Bulk Matcher in Analysis Mode

  1. Complete the steps under Configuring the Initial Bulk Match and Load Tool.

  2. For each IBML Tool, open loader-config.xml (located in the IBML Tool home directory in the conf subdirectory).

  3. Set the matchAnalyzerMode property to true, and verify the remaining property settings.

  4. Save and close the file.

  5. To configure and run the match analysis, do one of the following.

    • If the master loader is running on Windows:

      1. Navigate to the master IBML Tool home directory and open run-loader.bat for editing.

      2. Change the value of the JDBC_JAR_PATH variable in the first line to the location and name of the database driver for the master index database platform; for example, set JDBC_JAR_PATH=C:\oracle\jdbc\lib\ojdbc14.jar.

      3. Close and save the file.

      4. Double-click run-loader.bat or type run-loader from a command line.

    • If the master loader is running on UNIX:

      1. Navigate to the master IBML Tool home directory and open run-loader.sh for editing.

      2. Change the value of the JDBC_JAR_PATH variable in the first line to the location and name of the database driver for the master index database platform; for example, export JDBC_JAR_PATH=${oracle_home}/jdbc/lib/ojdbc14.jar.

      3. Close and save the file.

      4. Type sh run-loader.sh at the command line.

  6. Examine the log files to be sure no errors occurred during the analysis.

  7. Continue to Reviewing the Match Analysis Results.