Create a migration strategy that will include the DDL for a Database and save it to a GDG dataset using RC/Migrator

Products

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

Issue/Introduction

When generating a RC/Migrator for Db2 for z/OS (RCM) migration strategy analysis that includes the DDL for a database, is it possible to save the DDL to a GDG dataset.

Resolution

This can be accomplished in a few steps:

1. Create the target Base-line GDG.
   
   
2. Create a Migration strategy that will produce the DDL at the Database level or whatever level is required. 
   
   
3. Analyze the migration strategy in Batch mode and write the JCL to a PDS member.
   
   
4. Edit the JCL to include the GDG dataset:
   
   

   //DDLFILE DD DISP=(NEW,CATLG,DELETE),SPACE=(CYL,(5,10),RLSE),
   //           DCB=(LRECL=080,BLKSIZE=26800,RECFM=FB),
   //           DSN=hlq.dbname.tsname(+1)                         <======== replace with GDG name

5. Submit the strategy.

 

This is a sample of how the analysis looks like on screen:

RMS1 20.0   -------------- RC/M Strategy Services -------------- yy/mm/dd hh:mm
COMMAND ===>                                                  SCROLL ===> CSR

DB2 SSID ===> ssid
STRATEGY ===> stratnm  CREATOR ===> authid1  TYPE ===> C    SRC SSID ===> *
--------------------------------------------------------------------- authid1

                                              T S SRC  +---- LAST UPDATE ----+
O STRATEGY DESCRIPTION               CREATOR  P O SSID   USER     DATE   TIME
_ ________ _________________________ authid1  _ N ____ <== STRATEGY CREATION
_ stratnm                            authid1  C U      authid1  yy/mm/dd hh:mm
  _ hlq.dbname.tsname.G0005V00(+1)                     authid1  yy/mm/dd hh:mm
  _ ICL  hlq.dbname.tsname.G0006V00(+1)                authid1  yy/mm/dd hh:mm
******************************** BOTTOM OF DATA *******************************


The last line above shows that the same can be done when generating ICL.