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.

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

book

Article ID: 50095

calendar_today

Updated On:

Products

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

Issue/Introduction

When generating a migration strategy analysis that includes the DDL for a database, is it possible to save the DDL to a GDG dataset?

Environment

Release: R20
Component: RCM

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.DBCORP.TSROLE(+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.DBCORP.TSROLE.G0005V00(+1)             authid1 yy/mm/dd hh:mm
_ ICL  hlq.DBCORP.TSROLE.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.