RC/MIGRATOR : Show before/after attribute changes to an object during alteration
Article ID: 246043
Updated On:
Products
RC/Migrator for DB2 for z/OS
Issue/Introduction
RC/Migrator has ALTERATION and COMPARE types of strategy. While they are each defined in a different way, both produce the end result of DB2 Database objects being altered. Sometimes alterations to objects can contain many changes which can be hard to keep track of when preparing the alteration.
Environment
DB2 for Z/OS
Release : R20
Resolution
When a COMPARE or ALTERATION strategy has been created , there is a list of objects to be altered.
---------------- RC/M Compare Explode Services ---------------- yyyy/mm/dd hh:mm:ss
COMMAND ===> SCROLL ===> CSR
STRATEGY ===> ACT DESCRIPTION ===> ACT TABLE
CREATOR ===> AUTHID1 SHARE OPTION ===> U (U,Y,N,X,L)
VIEW STRATEGY INFO ===> N CREATE/DROP OBJECTS ===> N (U,Y,N)
--------------------------------------------------------------------- AUTHID1
SOURCE SSID ===> ssid | TARGET SSID ===> ssid
SOURCE LOC ===> LOCAL | TARGET LOC ===> LOCAL
|
E TY | Ob Dep
S X PE NAME CREATOR VERSION | CH CH NAME CREATOR VERSION
E E X T ACT DSN81110 | ACT QASYSJO
******************************* BOTTOM OF DATA ********************************
-------------- RC/M Alteration Strategy Services -------------- yyyy/mm/dd hh:mm:ss
COMMAND ===> SCROLL ===> CSR
Strategy ===> ALTER Description ===>
Creator ===> AUTHID1 Share Option ===> U (U,Y,N,X,L) SSID ===> ssid
--------------------------------------------------------------------- AUTHID1
Option => (A,C,T,D) Object => (SG,DB,TS,T,I,V,S,A,TG,SQ,PR,UF)
Name => * > Creator => * > Where ==> N
CMD OBJECT TYPE NAME CREATOR PROCESS
E TABLE TBROLE AUTHID1 ALTER
******************************* BOTTOM OF DATA ********************************
When editing an object on the list with an "E" in the "S" column of a compare strategy or the "CMD" column of an Alteration strategy, there is a command called COMPARE.
This command displays a BEFORE and AFTER value for each attribute in the object so that the user can see at a glance what has been changed and what will be implemented
ROPTBALX ---------------- CA - Table Alter --------------- yyyy/mm/dd hh:mm:ss
COMMAND ===> COMPARE SCROLL ===> CSR
Table => TBROLE > Creator => AUTHID1 > Comm/Lab => N
Database => DBCORP Editproc => Data Cap => CHANGES
Tablespace => TSROLE Validproc => OBID =>
Partitioning > NO (TS Parts:NONE) Audit => NONE Volatile => N
Table Type => REGULAR Restrict => Y CCSID => UNICODE
Row Size => 87/-3,961 Forgn Key => N Chk Const > N
Append => Y
CMD ### PS COLUMN NAME COLUMN TYPE SIZE N D FORDAT PK UK FK
___ 1 ROLE_ID CHAR 6 N _ SBCS 1
___ 2 ROLE_DESC CHAR 60 N _ SBCS __
___ 3 ROLE_SALARY1 DECIMAL 16,0 N Y _____ __
___ 4 ROLE_SALARY_CODE CHAR 1 N C SBCS __
___ 5 ROLE_SALARY_GRP CHAR 1 N _ SBCS __
___ 6 ROLE_SALARY_TYPE CHAR 10 N _ SBCS __
******************************* BOTTOM OF DATA ********************************
The screen report below shows the after/before attribute values that have been altered from the original object on the catalog.
It can also show when columns are deleted or inserted or updated.
This can be helpful as a reviewing tool to check if all required changes have been made.
ROPTBALY ---------------- CA - Table Alter --------------- yyyy/mm/dd hh:mm:ss
COMMAND ===> SCROLL ===> CSR
Table => TBROLE > Creator => AUTHID1 > Comm/Lab => N
=> TBROLE > => AUTHID1 > => N
Database => DBCORP Editproc => Data Cap => CHANGES
=> DBCORP => => NONE
Tablespace => TSROLE Validproc => OBID =>
=> TSROLE => => 28
Partitioning > NO (TS Parts:NONE) Audit => NONE Volatile => N
=> NO => NONE => N
Table Type => REGULAR Restrict => Y CCSID => UNICODE
=> REGULAR => N => EBCDIC
Row Size => 87/-3,961 Forgn Key => N Chk Const > N
=> 66 => N =>
Append => Y
=> N
CMD ### PS COLUMN NAME COLUMN TYPE SIZE N D FORDAT PK UK FK
___ 1 ROLE_ID CHAR 6 N _ SBCS 1
OLD 1 ROLE_ID CHAR 6 N SBCS 1
___ 2 ROLE_DESC CHAR 60 N _ SBCS __
OLD 2 ROLE_DESC CHAR 50 N SBCS
___ 3 ROLE_SALARY1 DECIMAL 16,0 N Y _____ __
OLD 3 ROLE_SALARY DECIMAL 16,0 N Y
___ <-- COLUMN DELETED -->
OLD 4 ROLE_SALARY_CODE CHAR 1 N C SBCS
___ 4 ROLE_SALARY_GRP CHAR 1 N _ SBCS __
OLD <-- COLUMN INSERTED -->
___ 5 ROLE_SALARY_TYPE CHAR 10 N _ SBCS __
OLD <-- COLUMN INSERTED -->
In the example above the next opportunity to see the changes to be made is when the Analysis of the strategy has been produced.
The Analysis contains the "ALTERATION CHANGE ANALYSIS REPORT" for Alterations and "COMPARE FACILITY CHANGE ANALYSIS REPORT" for Compare reports.
--= 20.0.04 CA-DB2 ALTERATION CHANGE ANALYSIS REPORT yyyy/mm/dd hh:mm:ss
--======================================================================
--
--************************** SELECTED OBJECTS **************************
-- OBJECT TYPE NAME/CREATOR
-- ----------- ------------
-- T TBROLE
-- AUTHID1
--
-- TOTAL SELECTED OBJECTS: 1
--
--+++++++++++++++++++++++++ NO DROPPED OBJECTS +++++++++++++++++++++++++
--
--+++++++++++++++++++++++++++ NO NEW OBJECTS +++++++++++++++++++++++++++
--
--+++++++++++++++++++++++++++ ALTERED OBJECTS ++++++++++++++++++++++++++
--
-- Table Changes for:
-- Creator: AUTHID1
-- Name: TBROLE
--
-- Attribute Status Value
-- ------------- ----------- ----+----1----+----2----+----3--
-- APPEND Currently: N
-- Changed To: Y
-- DATACAPTUR Currently: NONE
-- Changed To: CHANGES
-- RESDROP Currently:
-- Changed To: Y
-- CCSID Currently: E
-- Changed To: U
--
-- ------------ Table Column Changes --------------------
-- Attribute Status Value
-- ------------- ----------- ----+----1----+----2----+----3--
-- NAME Currently: ROLE_DESC
-- Changed To: (NOT CHANGED)
-- SIZE Currently: 50
-- Changed To: 60
--
-- NAME Currently: ROLE_SALARY
-- Changed To: ROLE_SALARY1
--
-- NAME Currently: ROLE_SALARY_CODE
-- Changed To: (DELETED)
--
-- NAME Currently: (INSERTED)
-- Changed To: ROLE_SALARY_GRP
-- BITDATA Currently:
-- Changed To: S
-- DEF TYPE Changed To: (NONE)
--
-- NAME Currently: (INSERTED)
-- Changed To: ROLE_SALARY_TYPE
-- SIZE Currently: 1
-- Changed To: 10
-- BITDATA Currently:
-- Changed To: S
-- DEF TYPE Changed To: (NONE)
Feedback
Yes
No
Powered by
