Service Virtualization

Expand all | Collapse all

Auto Delete DB Records

Jump to Best Answer
  • 1.  Auto Delete DB Records

    Posted 03-28-2018 05:33 AM

    Is there any way to delete DB records automatically(weekly schedule)  in #devtest10.2



  • 2.  Re: Auto Delete DB Records
    Best Answer

    Posted 03-28-2018 06:55 AM

    We have a way to delete the test reports over a given age. This clean-up process removes records over 30 days old by default, but is configurable.  

     

    For more information, please see Database Maintenance - DevTest Solutions - 10.2 - CA Technologies Documentation 

     

    We also have an equivalent for VSE metrics, that have the defaults shown below. Should you wish to override any of these then the properties should be added to your local.properties file

     

    # These properties are used to control metrics collection in VSE servers. The metrics
    # collected can be viewed in the web-based VSE dashboard. The values here are the defaults.

    # Main property to turn overall metrics collection on (true) or off (false).
    lisa.vse.metrics.collect=true

    # This property controls the level at which transaction counts are recorded. Options are none
    # (or false), service (the default), operation, or arguments.
    lisa.vse.metrics.txn.counts.level=service

    # This property controls how often transaction rate and response times are sampled.
    lisa.vse.metrics.sample.interval=5m

    # These properties control how often old metric data is scanned for and deleted, along with what
    # counts as old.
    lisa.vse.metrics.delete.cycle=1h
    lisa.vse.metrics.delete.age=30d


  • 3.  Re: Auto Delete DB Records

    Posted 04-06-2018 02:00 AM

    Hi Dave,

     

    This will delete all the suite transaction records every 30d?+



  • 4.  Re: Auto Delete DB Records

    Posted 04-06-2018 02:14 AM

     Is this parameter purges / cleansing data only for VSE or all (incl ACL, registry, etc...)?



  • 5.  Re: Auto Delete DB Records

    Posted 04-09-2018 08:58 PM

    Is this parameter purges / cleansing data only for VSE or all (incl ACL, registry, etc...)?



  • 6.  Re: Auto Delete DB Records

    Posted 04-10-2018 05:10 AM

    Hi.

     

    As per the defaults, these properties will delete all metrics (test or VSE) that are older than 30 days. The ACL etc will not be affected, only test and VSE metrics