How to Cleanup PAUDIT and PAUDITX Tables (Doc ID 2751805.1)

Last updated on AUGUST 08, 2023

Applies to:

Goal

The PAUDIT and PAUDITX tables continue to accumulate rows, but old data is not being purged by the background jobs. 

For example (Run all queries below as the schema owner - default admuser):

1. Run counts from the table(s) to determine row counts by month and year:
   
2. In this example, the queries indicate that there are audit records going back to June 2019;
   • 20190614      49855
   • 20190615    164903
   • 20190616    415381
3. Review the BGPLOG table to see if audit rows are being deleted by the background jobs.  While it is possible for the cleanup to show 0 rows, it would not be expected to see 0 rows deleted when there is audit data going back to June 2019 - example BGPLOG entry;
           Complete cleanup_paudit-0 Sec
4. Review the SETTINGS table for audit-related and data_monitor settings;
   1. database.cleanup.auditing - KeepInterval = 15d
   2. database.background.Damon - Interval = FREQ=DAILY;BYHOUR=1
   3. database.background.Damon - HeartBeatTime = 12/11/2020 13:10

Solution