Pruning no longer taking place for the STATS, BL and RT tables in BPPM which is causing the database to grow very large in size.

Version 19
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    ProactiveNet Performance Management Suite



    PROBLEM:

     

    Pruning no longer taking place for the STATS, BL and RT tables in BPPM which is causing the database to grow very large in size.

     


    SOLUTION:

     

    Legacy ID:KA414783

      

    If there are a large number of records in the STATS_ERRORS and ITEMCFG_DTLSLOG tables then it can cause pruning to hang.
     
    The count on those tables should be verified by running the following steps:

      

    *note : This required 15-20 minutes downtime.

      

    1. Stop BPPM using command 'pw sys stop'
     
    2. Start only DB using command 'pw p s dbsrv' only in case of Sybase DB.

      

    3. Login to dbisql editor using dba user only in case of Sybase DB.

      

    *note : If Oracle DB, login to SQL prompt using BPPM user.

      

    4. Verify count of the tables:

      

    select count(*) from ITEMCFG_DTLSLOG

      

    select count(*) from STATS_ERRORS

      

    5. The pruning period of those tables should be changed by running the following:
     
    update prune_cntl SET DELTAHOURS=48 where TABLENAME='ITEMCFG_DTLSLOG'

      

    update prune_cntl SET DELTAHOURS=72 where TABLENAME='STATS_ERRORS'

      

    commit;

      

    6. Truncate the tables:

      

    truncate table ITEMCFG_DTLSLOG

      

    truncate table STATS_ERRORS

      

    7. Verify the counts again to ensure they are 0:

      

    select count(*) from ITEMCFG_DTLSLOG

      

    select count(*) from STATS_ERRORS

      

    8. Start BPPM using command 'pw sys start'

      

    9. Verify pruner.log to ensure pruning taking place.

      

    10. If there are unwanted partitions due to no pruning, the attached contains a procedure for removing them.

    *** These steps only work for windows, If you need to run in Linux/Unix follow Linux-Connect-Sybase.doc attached before them.

     


    Article Number:

    000107875


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles