4 Replies Latest reply on Aug 9, 2017 7:49 PM by Puthanampatti

    Issue with Purge MDS metadata

    920301

      We are trying to purge the metadata for MDS schema as the size of the MDS_TS table was growing considerably larger.

      Auto purging did not work as expected. Tried to manually purge using WLST & EM console,however it did not work as expected as the MDS schema size was stil showing 180g size even after purging.

      Do we need to need to rebuild the indexes to reduce the table size? Please help!

       

       

       

       

       

       

      $WC_HOME/common/bin/wlst.sh $WOS_HOME/wlst/purge_mds.py WOSP 2897

      Admin port should be used instead.

       

       

      Location changed to domainRuntime tree. This is a read-only tree with DomainMBean as the root.

      For more help, use help(domainRuntime)

       

       

      Location changed to serverRuntime tree. This is a read-only tree with DomainMBean as the root.

      For more help, use help(domainConfig)

       

       

       

       

      Purging obsolete metadata labels at Mon May 15 00:14:31 2017 ...

      purgeMetadataLabels(repository="mds-GridLink-mds-CustomPortalDS", partition="epWOS", namePattern="%ep-app%",olderThanInMin="2897")

      Already in Domain Runtime Tree

       

       

      Already in Domain Runtime Tree

       

       

      Purging metadata older than 4 hrs at Mon May 15 00:14:51 2017 ...

      purgeMetadata("ep-app", "WOSPMgd_am2413_1", 14400, "170508.0829")

      Already in Domain Runtime Tree

       

       

       

       

      Already in Domain Runtime Tree

       

       

      Purge finished at Mon May 15 00:15:26 2017

       

       

       

       

      EM -Please find the attached screenshot

       

       

       

       

       

       

      Schema Size before/after purging

       

       

      OWNER SUM(BYTES/(1024*1024*1024))

      ---------- ---------------------------

      WOS_MDS 183.926697