Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.5.1
  • All Products

Table of Contents

Search

  1. About the Data Vault Administrator Guide
  2. Introduction to the Data Vault
  3. Data Vault Service Startup and Shutdown
  4. Data Vault Configuration
  5. Data Vault SSL Setup
  6. Data Vault ODBC Setup
  7. Data Vault Administration
  8. Data Repartitioning
  9. Partial Data Vault Copy
  10. Archived Data Migration
  11. Data Validation
  12. Bulk File Uploader
  13. Data Vault Administration Tool
  14. Data Vault Logs
  15. User Account Privileges
  16. ssasql Command Line Program
  17. Data Vault Audit Log
  18. Appendix A: Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Back Next

Running the SSA Data Validation Utility on Unconnected Servers

Running the SSA Data Validation Utility on Unconnected Servers

Run the ssadatavalidation utility to validate data and metadata between two Data Vault servers that are not connected over a network.
Before you run the utility, ensure that you migrate the Data Vault.
  1. Verify that the Data Vaults are enabled in the source and target machines.
  2. Browse to the <Data Vault installation directory> on the source machine.
  3. Run the ssadatavalidation.sh or ssadatavalidation.exe command on the source machine with the following options:
    In the table, Server 1 represents the source machine and Server 2 represents the target machine.
    Option
    Description
    -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.
    -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.
    -i [0,1]
    Generates intermediate files. Use the -h, -p, -u, x options or the -H, -P, -Q, -U, -K options with the option.
    -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.
    -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 -i 1 -h INKW12DSG462.informatica.com
 -p 3300 -q 3400 -r "C:\INKW12DSG462" -u dba/dba -a 1 -v 0 -R 0 -m 5
  4. Browse to the <Data vault installation directory> on the target machine.
  5. Run the ssadatavalidation.sh or ssadatavalidation.exe command on the target machine with the following options:
    Option
    Description
    -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.
    -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.
    -i [0,1]
    Generates intermediate files. Use the -h, -p, -u, x options or the -H, -P, -Q, -U, -K options with the option.
    -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 -i 1 -H INVW16DSG1298 -P 3300
-Q 3400 -r "C:\ INVW16DSG1298" -U dba/dba
-a 1 -v 0 -R 0 -m 5
    It is recommended to run the utility on the source and target in parallel.
  6. If the utility fails on either the source or target, enable the -R option and run the utility again.
    For example: 
    On Server 1:
ssadatavalidation.exe -i 1 -h INKW12DSG462 -p 3300 -q 3400
 -r "C:\INKW12DSG462" -u dba/dba -a 1 -v 0 -R 1 -m 5

On Server 2:
ssadatavalidation.exe -i 1 -H INVW16DSG1298 -P 3300 -Q 3400
-r "C:\ INVW16DSG1298" -U dba/dba -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.
  7. Back up the ssadatavalidation_temp directories on the source and target. The directory is deleted when you run the utility to compare results. Backing up the directory helps to avoid running the utility again.
  8. Compare the tables_list_results.txt file stored in the ssadatavalidation_temp directory for both the source and target. Verify that the status of all tables is READY.
    If a table fails and has a status other than READY in both files and is the expected state, you can proceed to the next step. For example, the sct file might exist in the source but not in the target.
    If a table status is READY in one file but not in the other, run the utility again with the Resume option on the failed tables to correct the issue and then continue.
  9. Copy or move the common folder that you specified with the -r option from the source to the target machine or target to the source machine. The folder must be available on the machine where you run the utility to compare results.
    To avoid errors because of disk space issues when you run the utility, run the utility on the machine that has more storage space available. To ensure faster execution and copying of files, copy temp files from a cloud virtual machine to an on-premise machine.
  10. Run the ssadatavalidation utility again to compare checksum or result files on the server where you copy the common folder. Use the following options when you run the utility:
    Option
    Description
    -h
    The Informatica Data Vault host name of server 1.
    -f
    The parent directory of the Informatica Data Vault server 1 directory. Do not use this option with -p, -q, -u or -x options.
    -H
    The Informatica Data Vault host name of server 2.
    -F
    The parent directory of the Informatica Data Vault server 2 directory. Do not use this option with -P, -Q, -U or -X options.
    -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.
    -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.
    For example: 
    ssadatavalidation.exe -h INKW12DSG462 -f "C:\INKW12DSG462\ssadatavalidation_temp"
 -H INVW16DSG1298 -F "C:\INVW16DSG1298\ssadatavalidation_temp"
-a 1 -R 0 -r “C:\IDV644_WIN12_WIN16”
    Use separate paths for the -r and -f or -F options.
  11. If the utility fails when you run the utility to compare the checksum, enable the -R option and run the utility again. This performs the validation only for tables whose checksum comparison failed in the first run.
    For example: 
    ssadatavalidation.exe -h INKW12DSG462 -f "C:\INKW12DSG462\ssadatavalidation_temp"
 -H INVW16DSG1298 -F "C:\INVW16DSG1298\ssadatavalidation_temp\INVW16DSG1298"
-a 1 -R 1 -r “C:\IDV644_WIN12_WIN16”
    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.
After the validation is successful, you can use the Data Vault servers.
0 COMMENTS
We’d like to hear from you!