Need to Purge/Delete Data on DevTest Databases
search cancel

Need to Purge/Delete Data on DevTest Databases

book

Article ID: 189288

calendar_today

Updated On:

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.