Db2 On Premise and Cloud

 View Only
  • 1.  Safe to delete DSM tables after DMC upgrade?

    InnerCircle
    Posted Mon April 18, 2022 01:49 PM
    Hi o/

    We upgraded from DSM to DMC about a year ago using "full migration" option with the existing DSM repo db. Is it safe to delete the tables outside of the IBMCONSOLE schema? For example, we have IBMOTS.SQL_FACT using 50gb of space, but it has not has any data inserted since we did the upgrade in April of last year and all the new data is going to IBMCONSOLE.SQL_FACT.

    DMC has been collecting the data for a year now and we don't have any need for any DSM history data so if it is safe to drop HEALTHMETRICS, DSSHSV1, IBMOTS, and the other DSM schemas we'd like to free up that storage space so it can be available for DMC.

    Thanks!

    ------------------------------
    Jared Hampson
    ------------------------------


  • 2.  RE: Safe to delete DSM tables after DMC upgrade?

    Posted Tue April 19, 2022 11:45 PM
    Edited by Tian Jiao Zhang Wed April 20, 2022 12:00 AM
    Hi Jared,

    If you don't have any need for any DSM history data, you can drop all objects of DSM from repository Db, which will not affect DMC.
    You can find the ibm-datasrvrmgr/samples/DB2LUW/drop.sql in the DSM folder, this drop.sql can drop all repository objects of DSM, so you can execute this SQL file in repository Db to drop all objects of DSM.

    ------------------------------
    Tian Jiao Zhang
    ------------------------------



  • 3.  RE: Safe to delete DSM tables after DMC upgrade?

    Posted Wed April 20, 2022 08:43 AM

    Hi Jared Hampson

    If you do not have any need for any DSM history data, you can drop all objects of DSM, which will not affect the DMC.

    You can find the ibm-datasrvrmgr/samples/DB2LUW/drop.sql in DSM folder, this SQL file can drop all objects of DSM, so you can just execute the drop.sql in your repository Db to drop all objects of DSM.

    Thanks!

    Dong Yu Zhao



    ------------------------------
    Dong Yu Zhao
    ------------------------------