Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Data Management Console - MDC Table Migration

    Posted Wed March 29, 2023 02:10 PM
    Edited by Ian Bjorhovde Wed March 29, 2023 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 Fri March 31, 2023 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
    ------------------------------

    Original Message