Data Vault Administrator Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Running the SSA Data Validation Utility on Servers Connected Over a Network

Run the ssadatavalidation utility to validate data and metadata between two Data Vault servers.

Before you run the utility, ensure that you migrate the Data Vault.

Verify that the Data Vaults are enabled in the source and target machines.

Browse to the <Data Vault installation directory> on either the source or the target machine.

Run the ssadatavalidation.sh or ssadatavalidation.exe command depending on the operating system, on either the source or target with the following options:

In the table, server 1 represents the source and server 2 represents the target.

Option	Description
-h	The Informatica Data Vault host name of server 1.
-p	The Informatica Data Vault port of server 1.
-q	The Informatica Data Vault exe port of server 1.
-u UID[/PWD]	The Informatica Data Vault user name and password of server 1.
-H	The Informatica Data Vault host name of server 2.
-P	The Informatica Data Vault port of server 2.
-Q	The Informatica Data Vault exe port of server 2.
-U UID[/PWD]	The Informatica Data Vault user name and password of server 2.
-r <dir>	The temporary directory for log, report, and run time files. All Informatica data validation logs, reports, or deviations are stored under the directory that you enter.
-v [0,1]	Compares based on column values without calculating checksum. Default is 0 or disabled.
-a [0,1]	Performs data validation on all eligible tables without exit on first failure. Set to 1 to continue validation even if errors are found.
-R [0,1]	Resumes the process. Default is 0 or disabled. You can choose to enable the -R option on all repeat utility runs.
-m nnn	The number of threads for data validation. Default is 4.

For example:

ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV" -a 1 -v 0 -R 0 -m 5

If the utility fails, enable the -R option and run the utility again.

For example:

ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV" -a 1 -v 0 -R 1 -m 5

The resume.txt file indicates the step from which the utility resumes. The tables_list_results.txt file stored in the temp folder on the source and target machines indicates the table from which the utility resumes.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Running the SSA Data Validation Utility on Servers Connected Over a Network

Running the SSA Data Validation Utility on Servers Connected Over a Network