5. Generating a compare batch job

A compare batch job is a JCL job that performs the requested comparison.

Before you begin

Before you can generate a compare job, you must complete the following tasks:

You can tell whether the source and target are specified by looking at the Specification Status column on the DB2 Object Comparison Tool Menu (GOCMENU) panel.

You can optionally complete the following additional tasks before generating a compare batch job:

If you want to use previous compare batch job selections that were saved as a dialog, restore that dialog before you begin. See Managing and restoring dialogs.

Procedure

To generate a compare batch job:

  1. On the DB2 Object Comparison Tool Menu (GOCMENU) panel, specify option 5, and press Enter.
    The Generate Compare Jobs (GOC5) panel is displayed.
  2. If want to use Change Management (CM) or do a multi-target import, skip the remaining steps and complete one of the following procedures instead:
  3. On the Generate Compare Jobs (GOC5) panel, specify a value for each option, and press Enter.

    For information about each option on this panel, see Compare job options.

    Tip: Set Save compare results to YES if you want to analyze data about the comparison, ignore changes, or increase the efficiency of subsequent comparisons. The saved compare results contain information about objects that were part of the comparison, including detected differences, changes to make, and how those changes are to be implemented. You can save the compare results only for tables, indexes, global variables, and distinct data types.
  4. If the Change Management Prompt (ADB2CMRO) panel is displayed (because CM is enabled and optional for your ID), specify whether to use CM, and press Enter.

    If you use CM, complete the steps in Generating a compare batch job to make changes through Change Management instead.

  5. Complete the requested input on any subsequent panels that are displayed.

    One or more of the following panels might be displayed depending on the compare job options that you selected. For more information about one of these panels, see the related job option description.

    Panel Option on Generate Compare Jobs (GOC5) panel
    Save Compare Results (ADB2C22) panel Save compare results
    Specify Compare Reporting Options (GOC5RO) panel Change reporting options
    Specify Data Set Name for Apply Jobs (GOC5AJ) panel Generate apply jobs
    Specify Work Statement List Data Set (ADB2WLDA) panel As work statement list
    Specify Work Statement List (ADB27WLD) panel As work statement list
    Specify Work Statement List Data Set (GOC5WL) panel As work statement list
    Specify Job Parameters (ADB2W1R) panel As work statement list
    DB2 Object Compare Warning (GOCGCMPW) panel Generate apply jobs
  6. Edit the generated JCL job as needed and submit it to run the comparison.
    For information about the Object Comparison Tool parameters in the generated JCL job, see Parameters in the generated compare batch job.

What to do next

Tip: Consider saving your current compare batch job selections for later use. See Saving dialogs.