Row Comparison Jobs

A row comparison sorts rows by a primary or a unique key, from all participating database tables and compares them one by one. A comparison summary is stored in the Data Assurance System Database (DASD). Detailed text or XML reports showing the row differences are stored in the data directory.

In a row job, you create a comparison object, then add a compareset to that particular comparison, set the various comparison parameters, and set the time when the comparison must take place.

• Creating a Row Comparison Job
  Set up a row comparison job.
• Comparison and Column Options
  Be familiar with the comparison and column options provided for creating a row job.
• Editing a Row Comparison Job
  Modify details of a Data Assurance (DA) row comparison job.
• Scheduling a Row Comparison Job
  Schedule a Data Assurance (DA) row comparison job.
• Creating a Job Based on Replication Server System Database
  Create a Data Assurance (DA) job based on an existing table-level replication definition and subscription in a Replication Server.