Compare analysis generates CREATE DDL for Stored Procedures using RC/Migrator

Products

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

Issue/Introduction

CREATE DDL is generated for Stored Procedures despite the RC/Migrator for Db2 for z/OS (RCM) Ruleset attributes for Routines set to N.

Resolution

The CREATE DDL can be explained by the following.

1. The Stored Procedures that are included in the analysis are dependent on objects in the strategy, so their inclusion as dependents is correct.

2. These Stored Procedures exist on the source subsystem but do not currently exist on the target.

3. CREATE DDL is generated for the Stored Procedures as they are source created new.

4. The Rule Set is only applicable to paired objects (those that exist in source and target) so they will not be applied to the Stored Procedures.