|Applies To||RSA Product Set: RSA Identity Governance and Lifecycle |
RSA Version/Condition: 6.9.1, 7.0.0, 7.0.1
|Issue||This document explains how to determine if an RSA Identity Governance & Lifecycle database has tables which are large and may benefit from a purge.|
Large tables in a database may have the following negative impacts to the product
|Tasks||The easiest way to get an understanding of the RSA Identity Governance & Lifecycle database size is to run a Statistics Report.|
This table represents the same data represented in the aveksaServer.log. It is governed by Admin > System > Logs tab > Settings button and the field entitled Database Retention N days, as depicted:
Configuring N days will increase/decrease the table size, as will a change to debug levels captured.
To purge from this table one can configure Database Retention N days as described above
This table represents the data which is displayed primarily within a job detail page as from Admin > Monitoring and specifically the link named Database Logs for Run ###, for example:
And the data represented behind the link Database Logs for Run ID ### is similar to what is seen here:
To which this data is used so as to understand the database packages and procedures, along with duration, that were called to complete the job. Often times, this is the largest table in the schema for a single job under Admin > Monitoring can add from hundreds to thousands of rows to this table.
To purge from this table one can run the following SQL statement as the Oracle database user avuser to remove all data in the T_AV_JOB_STATS table that is older than 90 days:
If Access Fulfillment Express (AFX) is installed, this table holds log messages that are also logged in the connectors log file on the Linux host. Data from this tab is displayed in the UI at AFX > Servers > Logs tab and the AFX > Connectors tab:
To purge data from T_AV_AFX_LOG_MESSAGE one can do the following:
Prior to version 6.9.1
There is no procedure available to purge T_AV_AFX_LOG_MESSAGE table.
On version 6.9.1
As the oracle database user run the following SQL to remove all data in the T_AV_AFX_LOG_MESSAGE table that is older than 90 days.
On version 7.0 or later
T_AV_AFX_LOG_MESSAGE will be purged per the same parameter for purging T_AV_APPLICATION_LOG.
This table holds a record of every email that was sent out via the application and is equivalent to the display in the Admin > Email > Logs tab:
The size of the table is governed by the configuration parameter defined in the Admin > Email > Settings tab for the value of Days to retain email log ( 0 = forever): N days
As detailed above, one can control the size of T_EMAIL_LOG but the field 'Days to retain email log ( 0 = forever): N days' from the Admin > Email > Settings tab.
|Notes||The Data_Retention_Pkg was deprecated in RSA Identity Governance & Lifecycle 7.0.2. For RSA Identity Governance & Lifecycle 7.0.2 and 7.1.0 and later, data purging is automatic and is configured on the Data Management tab on the Admin System menu. See the online helps section "Managing Data Purging" and the knowledge base article entitled ORA-06550 error when attempting to run the Data_Retention_Pkg in RSA Identity Governance & Lifecycle 7.0.2 and 7.1.0 for more information.|