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 must 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 action does not affect transactions, but only reports.
2. Clean up the backup database.
3. To use the backup database, failover the servers.
4. Clean up the primary database.
5. Revert to the primary database.