Applying changes to target objects

After you run a comparison, you can apply the changes in the compare report to the target object or objects.

About this task

Object Comparison Tool supports changes to implicit LOB and XML table spaces. When tables have implicit LOB or XML table spaces defined, Object Comparison Tool generates multiple image copies, which requires that a template be used for the SYSCOPY data set. You can define your own SYSCOPY template or Object Comparison Tool can use the default. The default template is: 
DSN(&US..&SSID..&DB..&SN..&UQ)
The default template for clones is: 
DSN(&US..&SSID..&DB..&SN..CLONE.&UQ)
For more information about templates and how to associate them with certain data sets, see Associating templates with data sets (IBM Db2 Administration Tool for z/OS 13.1.0).

Procedure

To apply changes to the target objects:

  1. On the DB2 Object Comparison Tool Menu (GOCMENU) panel, select option 5 - Generate compare job, and press Enter.
  2. On the Generate Compare Jobs (GOC5) panel, set the Generate Apply Job field to Yes and set any other fields as needed, and press Enter.
  3. On the Specify Data Set Name for Apply Jobs (GOC5AJ) panel, enter the name of the data set where you want the apply jobs generated.
  4. Edit the generated compare job as needed, and submit the job.
  5. Check the output to confirm that the job completed successfully.
  6. Run the generated apply job to make the changes to your target objects or if you requested a work statement list (WSL), Run the WSL to apply the changes.