Disable "Deleted Records" for a Table

[Michael Kaufman]

We have certain tables that are filling up the Deleted Records [sys_audit_delete] table.

• report_stats_executions
• report_executions
• wf_command
• etc

We don't care about these tables in Deleted Records [sys_audit_delete] table.   They don't have "Audit" true in their dictionary records.   Is there a way to turn off recording these tables in "Deleted records"?

We are planning on turning on Table Rotations for Deleted Records [sys_audit_delete].   However it shouldn't be that big in the first place.

Mike

[Anurag Tripathi · Accepted solution]

Hi Mike,

I think this is what you are looking for, its a system property

glide.db.audit.ignore

Specifies the tables where the sys_audit_delete file is not updated when records are deleted. Type: string - a comma separated list of tables Location: System Property [sys_properties] table

[felladin]

If anyone find this as a solution, please be aware the system property is now:

glide.db.audit.ignore.delete

[Anurag Tripathi]

Thanks Mate, ill keep this in mind.

My reply there was 4 year old tho 😛

[felladin]

Yeah, it was mostly an update if anyone else (like me) found this as the only viable answer.
You did lead me in the right direction, though. 🙂