Drop Objects and Drop and Recreate analysis options within RC/Migrator and RC/Compare

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS

Issue/Introduction

What is the impact of the Drop analysis options on the differing strategy types in RC/Migrator for Db2 for z/OS (RCM) and
RC/Compare for Db2 for z/OS (RCC):

    DROP OBJECTS            ===>   Y        (Y,N,O)  
    DROP / RE-CREATE        ===>   Y        (Y,N)

Resolution

The Drop Objects analysis option is available during analysis of Migration, Quick Migration and Dependency Strategy types.

This option indicates whether to drop the existing objects before the new objects are created. This activity is useful for "in place" migrations.

This field is ignored for the following types of analyses: REBIND only, DATA only, STATS only, GRANTS only, and RI only.

Value	Description	PARMFILE DD analysis parameter
O	Generate DROP DDL statements for all old-named objects that exist on the target subsystem.	DROPO
Y	Yes - Generate DROP DDL statements for all new-named objects that already exist on the target subsystem.	DROP
N	Default, do not generate DROP DDL statements.	n/a

 

The Drop & Recreate analysis option is available only during analysis of Comparison strategies, Alteration strategies, and Incremental Change Language (ICL).

This option indicates whether you want to use ALTER statements whenever possible to update changed objects or whether you want to always DROP and RECREATE changed objects.

Value	Description	PARMFILE DD analysis paramteter
Y	DROP and RE-CREATE all objects that have changed.	DROPALL
N	Default, use the ALTER statement whenever possible to make the requested changes.	n/a

 

Additional Information

For further information please refer to the Valid PARMFILE DD analysis parameters and Analysis options documentation.