9.1 Installation and Configuration

Table of Contents Previous Next


9 Data Validator : 9.1 Installation and Configuration

Step 1: When you install the xDB Replication Server product, the components for the Data Validator are installed as well. See Chapter 3 for information on installing the xDB Replication Server product.
Note: XDB_HOME is the directory where xDB Replication Server is installed. This may or may not be the same as the Postgres home directory depending upon how xDB Replication Server is installed.
Step 2: If you plan to use an Oracle database as the source or target database, download the Oracle JDBC driver and place it in the JAVA_HOME/jre/lib/ext directory.
Step 3: Edit the datavalidator.properties file located in the XDB_HOME/etc directory and specify the connection information for the source and target databases you want to compare.
The following are the parameters in the datavalidator.properties file.
Type of the source database. Values may be enterprisedb, oracle, sqlserver, sybase, or mysql.
The following is the initial content of the datavalidator.properties file after installation:
Step 4: Determine the location for the Data Validator logs directory.
The Data Validator generates a log file with a name formatted as datavalidator_yymmdd-hhmiss.log in the logs directory for each run.
If there are row differences between the source and target tables, a file with a name formatted as datavalidator_yymmdd-hhmiss.diff is also generated that contains output of the errors in diff format. Use a graphical diff tool like Kompare to view this file to highlight the specific differences.
The Data Validator attempts to create a subdirectory named logs within the XDB_HOME/bin directory the first time you invoke the Data Validator without the -ld option. If you do not invoke the Data Validator as the root account, it is likely that the run will fail as it attempts to create subdirectory logs in the XDB_HOME/bin directory where typically only the root account has this privilege.
Run the Data Validator as the root account. This enables the Data Validator to create the logs subdirectory within the XDB_HOME/bin directory, and then to create the log and diff files in the logs subdirectory.
Create the XDB_HOME/bin/logs directory structure before running the Data Validator. Modify the permissions on directory XDB_HOME/bin/logs so the operating system account you use to run the Data Validator has the privilege to create files in the directory.
Use the -ld log_directory_path option to allow the Data Validator to create the log and diff files in the specified directory location log_directory_path. Be sure the operating system account you use to run the Data Validator has the proper privileges to either create the lowest level subdirectory specified by log_directory_path if it does not already exist, or to create files within the specified directory if the full directory path already does exist.

9 Data Validator : 9.1 Installation and Configuration

Table of Contents Previous Next