|Applies To||RSA Product Set: Identity Management and Governance, RSA Via Lifecycle and Governance (L&G), Aveksa ACM|
RSA Product/Service Type: Access Fulfillment Express (AFX)
RSA Version/Condition: 6.9
Platform: Suse Linux
|Issue||There is currently no available feature to automate the retention date range or file size of AFX logs in version 6.9 and earlier. AFX logs can get quite large when viewed through UI via AFX > Connectors > Logs and there is no current automatic mechanism to purge the table that stores AFX log entries.|
Should tablespace growth due to AFX logging become an issue, the below SQL can be leveraged to clean up and shrink the involved tables.
DELETE FROM T_AV_AFX_LOG_MESSAGE where TRUNC(CREATE_DATE)<'01-JAN-14';
The first 2 SQL statements above will delete all rows in the table T_AV_AFX_LOG_MESSAGE which were created before January 1, 2014 and then commit the transaction. SQL Statements 3-5 will release the deleted rows from the table from a table size perspective.
Please note if you choose to proceed as above, you will no longer be able to see AFX Log messages before January 1, 2014 (or whatever data you enter in the WHERE clause of TRUNC(CREATE_DATE)<'01-JAN-14')
|Resolution||Retention control and automate cleanup functionality has been implemented in 6.9.1.|