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

Tables that Grow Rapidly

The following table grow rapidly with each transaction that is performed. Ensure that these tables are 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. Fail over the servers to use the backup database.
4. Clean up the primary database.
5. Revert to the primary database.