DROP OBJECTS ===> Y (Y,N,O)
DROP / RE-CREATE ===> Y (Y,N)
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 |
For further information please refer to the Valid PARMFILE DD analysis parameters and Analysis options documentation.