Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Data Management Console - MDC Table Migration

    Posted 03/29/23 02:10 PM
    Edited by Ian Bjorhovde 03/29/23 02:12 PM

    Hello,


    The documentation describes how to migrate data from normal unclustered tables to MDC tables and then modify the configuration so that DMC uses the MDC tables.

    The documented process simply copies the data from the existing tables (e.g., ACTIVITY_EVENT) to the MDC tables (e.g., ACTIVITY_EVENT_MDC).

    Once this is done, there are now 2 copies of the data.  Is it safe to truncate the non-MDC copies of the tables?  If so, it would be useful if the documentation was updated to state this. 

    Thank you,


    ------------------------------
    Ian Bjorhovde
    XTIVIA
    ------------------------------



  • 2.  RE: Data Management Console - MDC Table Migration

    Posted 03/31/23 12:34 AM

    Hello Ian,

    Yes, if you performed the step 3 to clone data from the source table to MDC-related table.  It safe to truncate the data in the non-MDC copies of the tables.

    We will add a line to describe this in the documentation.  Thanks for the suggestion.




    ------------------------------
    Kind Regards,
    Jason Sizto
    ------------------------------



Related Content