Quick Migration Batch Only Options to Explode and Implode objects within RC/Migrator
Article ID: 190576
Updated On:
Products
Issue/Introduction
There are three new RC/Migrator for Db2 for z/OS (RCM) 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 dependent 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
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 dependent objects.
DATABASE TABLESPACE TABLENAME TBCREATR INDEXNAME IXCREATR
dbname tsname table creator ix1 creator
ix2 creator
ix3 creator
ix4 creator
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 dbname
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.dbname
X TS dbname.tsname
X T creator.table
X I creator.ix1
X I creator.ix2
X I creator.ix3
X I creator.ix4
With a QUICKMI analysis (implode all) the objects selected are:
M SG AUTHID.stogroup
P DB AUTHID.dbname
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.stogroup
P DB AUTHID.dbname
X TS dbname.tsname
X T creator.table
X I creator.ix1
X I creator.ix2
X I creator.ix3
X I creator.ix4
You can see above that the Storage Group has also been selected in the IMPLODE.
Additional Information
Feedback
