When doing a Quick Migration RC/Migrator does not display the full Data definition (DDL Missing parts)

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

Running RC/Migrator for Db2 for z/OS (RCM) r19.0 when trying to generate new DDL from existing DDL Via Quick Migration, how do we get all partitions of the DDL.

Resolution

If all the partitions have the same attributes you need not specify any partition clauses, RCM will generate global partition specifications and  will only generate partition clauses for those partitions with attributes that do not match those specified at the global level, this is referred to as compact DDL. 

To see all the DDL from the Source, use RC/Query, and list the tablespace in question, and enter DDL or HDDL command to see the complete DDL.