Db2 (On Premises and Cloud)

Expand all | Collapse all

DMC - Historical Data Pruning - Space release is not expected after reorg

  • 1.  DMC - Historical Data Pruning - Space release is not expected after reorg

    Posted Thu April 15, 2021 05:41 AM
    Hi Team,

    We have configured 14 DB in DMC monitoring and set the data collection/package collection/Event Monitoring data collection to 3 days. As per my understanding data pruning happening automatically after threshold days reached.. We can see from the DMC Monitoring log and DMC repository DB, Pruning and data deletion is happening but we are not getting the free space after reorg as expected.. 

    How do we see data deletion happen, how many days data available in Table, How do we see which Monitoring DB consume more data and how do we make the free space in repository DB, if required free how do we delete the data directly from table to avail free space

    Do we have any standard procedure..

    Thanks Prashant

    ------------------------------
    PRASHANT SHIVMATH
    ------------------------------


  • 2.  RE: DMC - Historical Data Pruning - Space release is not expected after reorg

    Posted Thu May 06, 2021 04:22 PM
    Hi Prashant,

    Pruning of repository data happens automatically after the Persistence threshold set for the monitor database is reach; set in the monitoring profile.  Script to REORG the repository database objects can be found in <dmchome>/sample/DB2LUW/reorg.sql.  You can also go to Administration > Settings > Configure Repository page, and there is a Runstats and Reorg button as short cut for you to use.

    Most repository tables has a column named: collected, it is a the collection timestamp.  You can select the min() and max() of this column to confirm if pruning is happening expectedly.  The default schema for the repository object is "IBMCONSOLE".  If you are monitoring the repository database, you can go to the Monitor > Storage > Storage page and see the sizes of the table objects in this database.  (For console objects, you need to select the  "Hide System Objects" icon to see IBMCONSOLE table objects.)

    p.s. If you set up event monitor for your monitor database, the tables created for the event monitors are in the monitor database.  The reorg scripts does not cover the event monitor tables on individual monitor database.


    ------------------------------
    Jason Sizto
    ------------------------------