Is there a way to migrate objects without creating a RC/Migrator migration strategy
Article ID: 53484
Updated On:
Products
Issue/Introduction
Sometimes there is a need to migrate objects quickly without wanting to create a RC/Migrator for Db2 for z/OS (RCM)
Migration strategy. Is there a way of doing this?
Resolution
This can be done using either option 4 - Quick Migration option from the RC/Migrator Main menu, or the QM command
from anywhere within the Database Management for Db2 for z/OS tools.
This will begin in the "RC/M Quick Migration Services" panel which allows you to specify the objects that you want to
migrate as well as the implode/explode options. These objects and options will be included in the QUICKM/QUICKEND
section of the analysis JCL.
An example is as follows:
QUICKM
TABLESPACE creator.tsname1
IMPLODE STOGROUP
IMPLODE DATABASE
EXPLODE TABLE
EXPLODE INDEX
EXPLODE VIEW
EXPLODE SYNONYM
EXPLODE TRIGGER
QUICKEND
Once the analysis JCL is generated, it can be updated to change, add or remove the object names being migrated as well
as the implode/explode options. For example, the requirement is to migrate another tablespace including its tables and indexes
only, the analysis options can be changed within QUICKM/QUICKEND section as follows:
QUICKM
TABLESPACE creator.tsname2
IMPLODE STOGROUP
IMPLODE DATABASE
IMPLODE TABLE
IMPLODE INDEX
QUICKEND
Note: If there are any problems/errors resulting from the modified parameters from the QUICKM/QUICKEND section, it would be
recommended that a re-generation of these cards be performed. Doing this would also ensure any changes in the product over
time (eg. after an upgrade, or applying maintenance, etc.) will be reflected in the QUICKM/QUICKEND section.
When the Quick Migration analysis is performed, the information entered on the Quick Migration Services and Quick Migration Analysis
screens is stored in a default strategy called QUICKM with the description "Quick Migration" and the strategy type Q. Note that this
QUICKM strategy cannot be analyzed, templated, or updated, and that there is only one QUICKM strategy for each user.
The analysis output from a Quick Migration can either be a managed output or saved to a PDS.
If you direct the output to a PDS, the dataset member for the analysis is initially set to QUICKnnn on the Quick Migration Analysis screen, but it can be changed.
Additional Information
Feedback
