Audit Trail Purging
It is recommended that the following Audit Trail tables are purged periodically to keep the tables at a reasonable size:
• IPCS_AUDIT_TRAIL
• IPCS_AUDIT_TRAIL_DETAILS
Use these instructions to enable and configure Audit Purging at the system level:
1. Run the following SQL to add the Gateway Clean-up process to the Manual tab of the AutoPilot page:
UPDATE IPCS_AUTO_PILOT
SET IsManualProc = 'y'
WHERE ProcID = 1021;
3. Run the following AutoPilot processes:
◦ Database Maintenance
◦ Get Host Data
◦ Gateway Clean-up