Data Retention AXA 17.3

Products

• CA Application Experience Analytics SaaS (AXA)

Issue/Introduction

We have configure AXA 17.3 on-premise and I have a question about data retention. In the doc, I've linked below it says we need to ensure the Oracle data retention value is the same as the Elasticsearch value. There is instructions on how to change it for Elasticsearch but I am wondering how can I confirm or change the value for the Oracle database.

 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/app-experience-analytics/17-3/administrating/set-up-the-administration-hierarchy/tenant-administrator.html

Environment

Release :

Component :

Resolution

Retention period:

 

Elastic retention period is by default set to 45 days. You can change it on the jarvis configuration (limits.properties and utils.properties) to 90 days to match other tiers (Dev, Trans, Prod)

 

For Oracle - While the documentation refers to a retention period, technically there is no pre-defined period.

We store data perpetually.

 

To keep data in sync, we recommend purging the Oracle DB with the help of your DBA once every 90 days.

 

Purge instructions and steps listed in the document below as well as sample SQL scripts.