Data Compare Strategy Creation Steps

Each of the steps listed for creating and using a Data Compare Strategy is described in detail in the sections that follow.
carcupdb218
Each of the steps listed for creating and using a Data Compare Strategy is described in detail in the sections that follow.
  • Access the Data Compare facility. Use the DC option on the Main Menu to enter the Data Compare Strategy Services screen.
  • Create a Data Compare strategy. On the Data Compare Strategy Services screen, define the parameters and strategy name. Users can create a new strategy or update or template an existing strategy.
  • Select table pairs to be compared. On the Data Compare Table Mapping screen, each source table is mapped to its target table. Multiple table pairs can be included in a strategy.
  • Specify a column order to be used by both tables. On the Data Compare Explode Services panel, a Data Query is specified to define the order in which data will be processed. The number of rows of data that will be compared can also be limited.
  • Map the columns between the table pairs. On the Data Compare Column Mapping screen, for each table pair defined, map the columns from the source table to the target table. Automapping is available for columns with the same name in both tables.
  • Generate unload control statements and unload the table data for each table. The Data Compare Unload Generation, Data Compare Unload Specification, and Data Compare Execution specification screens allow users to control the unloading of the data from the DB2 tables to data sets for the compare process.
  • Run the compare function. From the Data Compare Explode Services panel, issuing the C (Compare) line command initiates the compare on the unload data sets.
  • Examine the comparison results. The Data Compare Report shows the differences between the two tables being compared.