How to back out (reverse) the DDL that is created in a Migration or Compare strategy?

Document ID : KB000022055
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Is there a way to back out (reverse) the DDL that is created in a Migration or Compare strategy?

Answer:

The strategy analysis screen provides an option to generate the information necessary to recover the objects. The method to use is the RECOVERY option (set to Y) in the Execution Specifications section of the screen when creating the strategy.

The Recovery option permits recovery from a strategy execution. Using the Recovery option, all objects in the strategy can be returned to their original versions.

 

Field:  RECOVERY                                          

Description:  Indicate whether you want the migration,    

alteration, or compare to be recoverable.                 

                                                           

Values:  Y   Yes.  Generate the information necessary to  

             recover, and save it in a recovery dataset.  

             Also display the Recovery Options screen.    

                                                          

             N   (Default)  No.  Do not make the objects      

            recoverable.     

                            

            U  Display the Recovery Options  Screen

   

Note: The recovery information is gathered by the generated SNAPSHOT step during execution of the strategy.

 

Additional Information:

R18: Recovery Option

R19: Recovery Option