CA RiskMinder Windows Installation Guide › Database Reference › Database Tables Archival Recommendations › Tables that Grow Rapidly

Tables that Grow Rapidly

The following table types grow rapidly with every transaction, and should be archived or purged according to the archival policy of your organization:

• Tables that store audit data, such as:
  • ARADMINAUDITLOG
  • ARADMINAUDITTRAIL
  • ARRFINSTANCEAUDITLOG
  • ARRFUPLOADAUDITLOG
  • ARUDSAUDITLOG
• Tables that store transaction data, such as:
  • ARRFCASEAUDITLOG
  • ARRFSYSAUDITLOG
  • ARRFSYSAUDITLOG_<channel>
  • ARRF_CASE_TXN
  • ARRF_CASE_TXN_<channel>
  • ARRFUSERCONTEXT
• Tables that store reports data and device data, such as:
  • ARREPORTS
  • ARRFDEVICECONTEXT
  • ARRFDEVICEINFO
  • ARRFDEVUSERASSO
  • ARRFUSERCONTEXT
  • ARRF_IMA
  • ARRF_CMA
• Tables that store configuration data, such as:
  • ARRFCURRENTCMSCHEDULE
  • ARRFADVICECONFIG
  • ARRFCURRENTORGCONFIG
  • ARRFSYSORGCONFIG

When you archive data in these categories of rapidly growing tables, the following procedure is recommended:

1. Archive from the backup database.This will not affect transactions, but only reports.
2. Clean up the backup database.
3. Failover the servers to use the backup database.
4. Clean up the primary database.
5. Revert back to the primary database.