RC/Migrator: Archive tables in a Migration
Article ID: 190806
Updated On:
Products
RC/Migrator for DB2 for z/OS
Issue/Introduction
Migration of a base table, it's archive table and all their dependent objects are able to be processed by RC/Migrator without the need to directly select the associated Archive table specifically.
The control of the selection and processing of base and associated tables in the migration strategy is achieved now with the use of the Auxiliary Implode = Y analysis option.
This will implode the archive table and pull in the archive tablespace, database, and storage group or whatever implode/explode that is required.
Global changes for the table creator/name and the archive table and name can also be applied.
The ALTER TABLE ENABLE ARCHIVE statements are generated also.
The control of the selection and processing of base and associated tables in the migration strategy is achieved now with the use of the Auxiliary Implode = Y analysis option.
This will implode the archive table and pull in the archive tablespace, database, and storage group or whatever implode/explode that is required.
Global changes for the table creator/name and the archive table and name can also be applied.
The ALTER TABLE ENABLE ARCHIVE statements are generated also.
Environment
Environment : DB2 for Z/OS
Release : R20
Resolution
Consider this structure:
TABLESPACE DATABASE TABLENAME TBCREATR INDEXNAME IXCREATR
TSROLE DBCORP TBROLE authid TXROLE authid
TSROLE DBCORP1 TBROLE_ARCH authid TXROLE_ARCH authid
Table TBROLE uses TBROLE_ARCH as it's archive table.
When a Migration Strategy is used where the tablespace or base table of the archive table is analyzed using Aux Implode = Y and all the object types are selected
for Implode and Explode, the analysis selects the archive table and it's dependant and parent objects.
When the analysis output is examined, the selected structure can be seen.
SG authid.SYSDEFLT
DB authid.DBCORP1
TS DBCORP1.TSROLE
T authid.TBROLE_ARCH
I authid.TXROLE_ARCH
DB authid.DBCORP
TS DBCORP.TSROLE
T authid.TBROLE
I authid.TXROLE
If utilities were selected then the analysis generates unloads for the the base and archive table, generates the DDL for the objects above and also the
"ALTER TABLE authid.TBROLE ENABLE ARCHIVE USE authid.TBROLE_ARCH" statement to set up the target archive table, generates the loads for the base table and the archive table,
then generates the image copies and runstats for the two tablespaces if those are selected.
So, essentially the user does not have to know or specifically select the archive table or it's dependant objects. The strategy handles it for you.
When updating the Strategy where the primary object is the table (TBROLE above), in order to see if the archive table has been selected use the "L" line command in
the "S" column.
STRATEGY ===> TBROLE1 DESCRIPTION ===>
CREATOR ===> authid SHARE OPTION ===> U (U,Y,N,X,L)
SRC SSID ===> ssid NEW OBJECTS ===> N (U,Y,N)
------------------------------------------------------------------ authid >
+IMPLODE+ +----- PRIMARY OBJECT ---------+ +------ EXPLODE OPTIONS ------->
S SG DB TS TABLE NAME CREATOR TYPE MQ(IX VW A) IX VW(MQ(IX VW A))
L A A A TBROLE authid T/R _ _ _ _ A _ _ _ _ _
******************************* BOTTOM OF DATA ********************************
after pressing enter.....
STRATEGY ===> TBROLE1 DESCRIPTION ===>
CREATOR ===> authid SHARE OPTION ===> U (U,Y,N,X,L)
SRC SSID ===> ssid NEW OBJECTS ===> N (U,Y,N)
------------------------------------------------------------------ authid >
+IMPLODE+ +----- PRIMARY OBJECT ---------+ +------ EXPLODE OPTIONS ------->
S SG DB TS TABLE NAME CREATOR TYPE MQ(IX VW A) IX VW(MQ(IX VW A))
_ A A A TBROLE authid T _ _ _ _ A _ _ _ _ _
_ A A A TBROLE_ARCH authid R _ _ _ _ A _ _ _ _ _
The archive or "associated table" is listed indented below the primary table. Additional implode or explode options can then be specified for the archive table.
The "R" that can be seen in the TYPE column above indicates that it is an Archive Table.
The "L" command is also available on the command line: COMMAND ===> L, it is a toggle which expands or collapses the associated tables.
From the online HELP:
The "L" command expands all base and associated table pairs into two lines or collapses all base and associated table pairs into a single line. When expanded, options can be specified for the tables individually.
TABLESPACE DATABASE TABLENAME TBCREATR INDEXNAME IXCREATR
TSROLE DBCORP TBROLE authid TXROLE authid
TSROLE DBCORP1 TBROLE_ARCH authid TXROLE_ARCH authid
Table TBROLE uses TBROLE_ARCH as it's archive table.
When a Migration Strategy is used where the tablespace or base table of the archive table is analyzed using Aux Implode = Y and all the object types are selected
for Implode and Explode, the analysis selects the archive table and it's dependant and parent objects.
When the analysis output is examined, the selected structure can be seen.
SG authid.SYSDEFLT
DB authid.DBCORP1
TS DBCORP1.TSROLE
T authid.TBROLE_ARCH
I authid.TXROLE_ARCH
DB authid.DBCORP
TS DBCORP.TSROLE
T authid.TBROLE
I authid.TXROLE
If utilities were selected then the analysis generates unloads for the the base and archive table, generates the DDL for the objects above and also the
"ALTER TABLE authid.TBROLE ENABLE ARCHIVE USE authid.TBROLE_ARCH" statement to set up the target archive table, generates the loads for the base table and the archive table,
then generates the image copies and runstats for the two tablespaces if those are selected.
So, essentially the user does not have to know or specifically select the archive table or it's dependant objects. The strategy handles it for you.
When updating the Strategy where the primary object is the table (TBROLE above), in order to see if the archive table has been selected use the "L" line command in
the "S" column.
STRATEGY ===> TBROLE1 DESCRIPTION ===>
CREATOR ===> authid SHARE OPTION ===> U (U,Y,N,X,L)
SRC SSID ===> ssid NEW OBJECTS ===> N (U,Y,N)
------------------------------------------------------------------ authid >
+IMPLODE+ +----- PRIMARY OBJECT ---------+ +------ EXPLODE OPTIONS ------->
S SG DB TS TABLE NAME CREATOR TYPE MQ(IX VW A) IX VW(MQ(IX VW A))
L A A A TBROLE authid T/R _ _ _ _ A _ _ _ _ _
******************************* BOTTOM OF DATA ********************************
after pressing enter.....
STRATEGY ===> TBROLE1 DESCRIPTION ===>
CREATOR ===> authid SHARE OPTION ===> U (U,Y,N,X,L)
SRC SSID ===> ssid NEW OBJECTS ===> N (U,Y,N)
------------------------------------------------------------------ authid >
+IMPLODE+ +----- PRIMARY OBJECT ---------+ +------ EXPLODE OPTIONS ------->
S SG DB TS TABLE NAME CREATOR TYPE MQ(IX VW A) IX VW(MQ(IX VW A))
_ A A A TBROLE authid T _ _ _ _ A _ _ _ _ _
_ A A A TBROLE_ARCH authid R _ _ _ _ A _ _ _ _ _
The archive or "associated table" is listed indented below the primary table. Additional implode or explode options can then be specified for the archive table.
The "R" that can be seen in the TYPE column above indicates that it is an Archive Table.
The "L" command is also available on the command line: COMMAND ===> L, it is a toggle which expands or collapses the associated tables.
From the online HELP:
The "L" command expands all base and associated table pairs into two lines or collapses all base and associated table pairs into a single line. When expanded, options can be specified for the tables individually.
Additional Information
Feedback
Yes
No
Powered by
