1. Routing Hub Configuration User Guide
  2. Audit Purging / Archiving

11 Audit Purging / Archiving

Purging/Archiving of audit data is done on the basis of retention policy.

This process uses plato-batch-server for Job execution.

The following steps are required to schedule purging/archiving job (routingHubAuditRetentionJob) once cmc-obrh-services and plato-batch-server is UP and RUNNING:

  1. On Home screen, click Task Management. Under Task Management menu, click Configure Tasks.
  2. Select Schedule option.
  3. Select Task Name as routingHubAuditRetentionJob and Task Trigger Name will be generated automatically.
  4. Specify the CRON expression to daily EOD.

In order to resolve table space issue of Audit table (CMC_RH_AUDIT_EVENT_LOG), Database Management Team has to configure database job which should be triggered after routingHubAuditRetentionJob. This database job can be redefining the table (DBMS_REDEFINITION) after purging/archiving is done or other approach. So, the unused LOB segment space can be released. And in order to resolve table space issue of Audit history table (CMC_RH_AUDIT_EVENT_LOG_HISTORY), Database Management Team has to configure database job to truncate table periodically basis.