ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
When doing a Quick Migration RCM doesn't display the full Data definition (DDL Missing parts)
Article ID: 130135
Updated On:
Products
RC Compare for DB2 for z/OS
Database Analyzer for DB2 for z/OS
Fast Unload for DB2 for z/OS
Fast Check for DB2 for z/OS
Fast Index for DB2 for z/OS
Fast Load for DB2 for z/OS
Rapid Reorg for DB2 for z/OS
Issue/Introduction
Running CA-DB2 RC/Migrator Version 19.0 when trying to generate new DDL from existing DDL Via Quick Migration, how do we get all partitions of the DDL?
Environment
DB2 V10 & 11, CA Release 19 and 20.
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.
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.
Feedback
Yes
No
Powered by
