CA RC/Migrator for DB2 for Z/OS : Quick Migration Batch Only Options to Explode and Implode objects

Products

• RC/Migrator for DB2 for z/OS

Issue/Introduction

There are three new Quick Migration options that , in a batch job only , allows you to customize the Quick Migration data set input parameters in order to specify different Db2 objects to include in the migration.
This avoids the need to repeat the process of generating the JCL from the Quick Migration panels and selecting the object types to process. Simply change the input parameters in the job and then submit the job for execution.

QUICKME will explode all the dependent objects, QUICKMI will implode all the parent objects and QUICKMIE will implode all parent objects and explode all dependant objects.

These keywords include parent and dependent objects in the migration without knowing what they are beforehand.

These keywords eliminate the need to specify individual IMPLODE and EXPLODE statements for each object type like these in the PARMFILE.

IMPLODE    STOGROUP
EXPLODE    TABLESPACE
EXPLODE    TABLE
EXPLODE    INDEX
EXPLODE    VIEW
EXPLODE    SYNONYM
EXPLODE    TRIGGER
EXPLODE    MQTB_T
EXPLODE    MQTB_I
EXPLODE    MQTB_V
EXPLODE    MQTB_S
EXPLODE    MQVW_VW
EXPLODE    MQVW_I
EXPLODE    MQVW_V
EXPLODE    MQVW_S

Environment

DB2 for Z/OS

Resolution

When an analysis output using QUICKME, QUICKMI or QUICKMIE is examined, it behaves as if it were a QUICKM Quick Migration strategy with the appropriate IMPLODE and EXPLODE statements included in the generated JCL.

To illustrate, take note of the Database below and the dependant objects. 

DATABASE  TABLESPACE   TABLENAME           TBCREATR INDEXNAME               IXCREATR
DVFTS005  SFTFTR00     TFT_FTR             DBA5     IFTFTR00                DBA5
                                                    IFTFTR01                DBA5
                                                    IFTFTR02                DBA5
                                                    IFTFTR03                DBA5
In the JCL for a Quick Migration.....

//PARMFILE DD   *
 STRTSSID ssid
 CREATOR  authid
 QUICKME                          <================Instead of QUICKM replace with QUICKME, QUICKMI or QUICKMIE
 DATABASE   authid     DVFTS005
 QUICKEND
 TRGSSID  ssid
 AUXIMP   Y
 MQTIMP   Y
.
. 
 PREFIX   authid
 MODEL4   @DEFAULT
 MODEL4C  authid
/*

With a QUICKME analysis (explode all) the objects selected are:

P DB AUTHID.DVFTS005
X   TS DVFTS005.SFTFTR00
X     T  DBA5.TFT_FTR
X       I  DBA5.IFTFTR03
X       I  DBA5.IFTFTR02
X       I  DBA5.IFTFTR01
X       I  DBA5.IFTFTR00


With a QUICKMI analysis (implode all) the objects selected are:

M SG AUTHID.SYSDEFLT
P   DB AUTHID.DVFTS005

You can see above that the Storage Group has also been selected in the IMPLODE.

With QUICKMIE analysis (implode all and explode all) the objects selected are:

M SG AUTHID.SYSDEFLT
P   DB AUTHID.DVFTS005
X     TS DVFTS005.SFTFTR00
X       T  DBA5.TFT_FTR
X         I  DBA5.IFTFTR03
X         I  DBA5.IFTFTR02
X         I  DBA5.IFTFTR01
X         I  DBA5.IFTFTR00


You can see above that the Storage Group has also been selected in the IMPLODE.

Additional Information

Quick Migration Batch Only Options