What tables are pruned by DBprune tool as a default ?

book

Article ID: 17144

calendar_today

Updated On:

Products

CA Rapid App Security CA Advanced Authentication CA API Gateway

Issue/Introduction

At 8.1.x a DB trimming capability to automatically prune a list of tables was introduced. Note that a DBprune tool also exists that can be run manually from the command prompt. The DBprue tool is an alternative to the automatic DB trimming capability. This document answers a specific question about the list of tables that are trimmed by default by these two - DB trimming capability and DBprune tool.  

 

Please refer to the following link to learn more about the DBprune tool. 

https://docops.ca.com/ca-advanced-authentication/9-0/en/administrating/administrating-ca-strong-authentication/system-administrators-utilities/remove-outdated-audit-logs-with-the-dbprune-tool



What tables are pruned  by DBprune tool as a default ?

Environment

Any (Development / Staging / Production)

Resolution

Here is a list of tables that DBprune facility acts on as a default. 

ARADMINAUDITTRAIL 
ARUDSCONFIGAUDITLOG 
ARUDSORGANIZATIONAUDITLOG 
ARUDSUSERAUDITLOG 
ARWFADMINAUDITLOG 
ARWFAUTHAUDITLOG 
ARWFISSUANCEAUDITLOG 
ARWFSVRMGMTAUDITLOG 
ARDBAUDITLOG 
ARAUTHAUDITLOG 
ARUDSAUDITLOG 
ARADMINAUDITLOG 
ARRFCASEAUDITLOG 
ARRFINSTANCEAUDITLOG 
ARRFSYSAUDITLOG 
ARRFUPLOADAUDITLOG 
ARRFSYSAUDITLOG_3DSECURE 

Additional Information

Please refer to the following link to learn more about the DBprune tool. 

https://docops.ca.com/ca-advanced-authentication/9-0/en/administrating/administrating-ca-strong-authentication/system-administrators-utilities/remove-outdated-audit-logs-with-the-dbprune-tool