RC/Compare Analysis detects false changes when comparing an input DDL file.

book

Article ID: 6412

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

When comparing a DDL input file to a subsystem, unexpected results are being generated, detecting changes between the source and target objects, that cannot be explained. The changes do not reflect the attributes of the objects contained in the DDL file.

This results in DDL being generated by the Analysis to perform the false changes.

The 'CA-DB2 COMPARE FACILITY CHANGE ANALYSIS REPORT' section of the Analysis Report will also report these false changes, for example:

<Please see attached file for image>

Capture.JPG

            

Cause

This is a DDL to ssid comparison and the user was not creating a new strategy for each new DDL input file. 

For compare strategies that involve DDL files, CA RC/Compare maps objects that are contained in the input file when the strategy is created. This mapping is retained as part of the strategy definition. CA RC/Compare does not refresh the strategy based on the current contents of the DDL file when an analysis is performed. Therefore this type of strategy can not be used repeatedly if the content of the input file is changed.

 

Environment

Release:
Component: RCM

Resolution

In this scenario, a new strategy must be created, each time the content of the DDLIN input file is changed.

If the requirement is to regularly compare the input file to a subsystem(s), after amending the content of the input file, then we would recommend using the Batch Compare Facility. This will create a new strategy (replacing the old) each time it is executed, comparing the latest input DDLFILE to your subsystem.

We can compare the source DDLFILE to either a target subsystem, or to a target DDLFILE.

So one approach could be to create a DDLFILE for the production subsystem and a DDLFILE for the test subsystem. The Batch Compare Facility can then be used to create an Automap compare strategy, comparing these two files. Analysis can then be performed against this new strategy.  

Additional Information

For further details on DDL File Comparisons and any special considerations, please refer to the following:

Comparison Strategies

 

For further details on the Batch Compare Facility, please refer to the following:

Using the Batch Compare Facility

 

Attachments

1558714693858000006412_sktwi1f5rjvs16tj8.jpeg get_app