Need to Purge/Delete Data on DevTest Databases

Products

• CA Application Test
• Service Virtualization

Issue/Introduction

Our databases are starting to fill up.

Is there a way to purge the data?

More importantly how to delete VSE Metrics?

Environment

All supported DevTest releases.

Cause

N/A

Resolution

Add these two properties in the local.properties file of where the Registry is running to control how often old VSE metric data is scanned and deleted:

lisa.vse.metrics.delete.cycle=1h 
lisa.vse.metrics.delete.age=30d

Add these two properties in the local.properties file of where the Registry is running to control how often old Test/Suite data is scanned and deleted:

perfmgr.rvwiz.whatrpt.autoExpire=true
perfmgr.rvwiz.whatrpt.expireTimer=30d

Sets the expiration value of a suite or test. Once a suite or test is older than this value, it is deleted. The property value is a number followed by a suffix. The following suffixes are valid, with t being the default:

t=milliseconds
s=second
m=minutes
h=hours
d=days
w=weeks

The Registry will have to be restarted to pick up these properties.

Additional Information

Refer to section "DevTest Property File (lisa.properties)" in the documentation of the DevTest release you are running.

Refer to sections "Database Maintenance" and "Report Cleaner" in the documentation of the DevTest release you are running.