Associated table display at object selection using RC/Migrator
search cancel

Associated table display at object selection using RC/Migrator

book

Article ID: 258254

calendar_today

Updated On:

Products

RC/Migrator for DB2 for z/OS

Issue/Introduction

When selecting tables for a RC/Migrator for Db2 for z/OS (RCM) migration, it is useful to know which of the tables have associated tables.
The L (list) primary and line command is able to display the associated tables so that these can be selected if required.

Resolution

Having created a RCM migration strategy and selected tables as the primary object and a list obtained, the Command Line and Line command "L" is provided to display the associated tables.

The L command line and line command expands all base and associated table pairs into two lines where the associated table is displayed indented or collapses
all base and associated table pairs into a single line.

This command is only available when the selection is tables.

When a table has an associated table the TYPE column has a T/R. The "T" is clearly for Table but the "R" is for Archive Table.

The table type displays can be T/C, T/H, or T/R, for clone, history, and archive respectively.

 RMPLTB1         ------------- RC/M Object Selection ------------ yy/mm/dd hh:mm
 COMMAND ===>                                                  SCROLL ===> CSR

Item Name => TBR%                > Creator  => authid1   > Where => N
------------------------------------------------------------------ authid1    >

   Enter 'S' to select a Table.

Sel TABLE NAME          CREATOR  TYPE DATABASE  TSNAME    COLCOUNT  RECLEN
__ TBROLE              authid1   T/R dbname    TSROLE        4        74
__ TBROLE1             authid1   T   dbname    TSROLE1       4        74
__ TBROLE2             authid1   T   dbname    TSROLE2       4        74
__ TBROLE3             authid1   T   dbname    TSROLE3       4        74
__ TBROLE4             authid1   T   dbname    TSROLE2       4        74
__ TBROLE_R            authid1   T   dbname    TSROLE4       3        73
 ******************************* BOTTOM OF DATA ********************************

Enter the "L"  in the Command Line command.

  

 RMPLTB1         ------------- RC/M Object Selection ------------ yy/mm/dd hh:mm
COMMAND ===> L                                                  SCROLL ===> CSR

Item Name => TBR%                > Creator  => authid1   > Where => N
------------------------------------------------------------------ authid1    >

   Enter 'S' to select a Table.

Sel TABLE NAME          CREATOR  TYPE DATABASE  TSNAME    COLCOUNT  RECLEN
__ TBROLE              authid1   T   dbname    TSROLE        4        74
__  TBROLE_ARCH        authid1   R   dbname1   TSROLE        4        74
__ TBROLE1             authid1   T   dbname    TSROLE1       4        74
__ TBROLE2             authid1   T   dbname    TSROLE2       4        74
__ TBROLE3             authid1   T   dbname    TSROLE3       4        74
__ TBROLE4             authid1   T   dbname    TSROLE2       4        74
__ TBROLE_R            authid1   T   dbname    TSROLE4       3        73
 ******************************* BOTTOM OF DATA ********************************

This is a toggle command. L again and the expanded view goes back to what it was before. 

Using the "L" line command. Enter "L" next to the table that has the type T/R.


RMPLTB1         ------------- RC/M Object Selection ------------ yy/mm/dd hh:mm
 COMMAND ===>                                                  SCROLL ===> CSR

Item Name => TBR%                > Creator  => authid1   > Where => N
------------------------------------------------------------------ authid1    >

   Enter 'S' to select a Table.

Sel TABLE NAME          CREATOR  TYPE DATABASE  TSNAME    COLCOUNT  RECLEN
L_ TBROLE              authid1   T/R DBNAME    TSROLE        4        74
__ TBROLE1             authid1   T   DBNAME    TSROLE1       4        74
__ TBROLE2             authid1   T   DBNAME    TSROLE2       4        74
__ TBROLE3             authid1   T   DBNAME    TSROLE3       4        74
__ TBROLE4             authid1   T   DBNAME    TSROLE2       4        74
__ TBROLE_R            authid1   T   DBNAME    TSROLE4       3        73
 ******************************* BOTTOM OF DATA ********************************

The screen then changes as below:

 RMPLTB1         ------------- RC/M Object Selection ------------ yy/mm/dd hh:mm
 COMMAND ===>                                                  SCROLL ===> CSR

Item Name => TBR%                > Creator  => authid1   > Where => N
------------------------------------------------------------------ authid1    >

   Enter 'S' to select a Table.

Sel TABLE NAME          CREATOR  TYPE DATABASE  TSNAME    COLCOUNT  RECLEN
__ TBROLE              authid1   T   DBNAME    TSROLE        4        74
__  TBROLE_ARCH        authid1   R   DBNAME1   TSROLE        4        74
__ TBROLE1             authid1   T   DBNAME    TSROLE1       4        74
__ TBROLE2             authid1   T   DBNAME    TSROLE2       4        74
__ TBROLE3             authid1   T   DBNAME    TSROLE3       4        74
__ TBROLE4             authid1   T   DBNAME    TSROLE2       4        74
__ TBROLE_R            authid1   T   DBNAME    TSROLE4       3        73
 ******************************* BOTTOM OF DATA ********************************

This is a toggle command. L again and the expanded view goes back to what it was before. 

The Base table or the Associated table can be selected for the Migration using the "S" line command.

If you select an associated table for migration without the base table, you must ensure that the base table exists in the target environment
and matches the base table definitions from the source.

Additional Information

New L (List) Primary and Line Command