Clarity

  • 1.  How to purge CA PPM Data Warehouse?

    Posted Apr 11, 2017 05:35 AM

    Hi Friends,

     

    We would like to remove the entire contents of the CA PPM Data Warehouse. We don't need them in this lower, trimmed environment of Clarity, but anyway the database refresh from PROD brought them here as we included that schema too during the DB refresh.

     

    Any supported method to clean this up now?

     

    Regards,

    Georgy



  • 2.  Re: How to purge CA PPM Data Warehouse?
    Best Answer

    Broadcom Employee
    Posted Apr 11, 2017 05:47 AM

    Hi Georgy,

     

    Go ahead and drop the DWh schema and re import the blank DWH and ensure DB link is created and you need to run admin db dwh-upgrade -Dupgrade.phase=maintenance  to bring the DWH schema to PPM patch level.

     

    Regards

    Suman Pramanik