Table Cleanup & Rotation
- We created three data management policies with tables (sys_audit, sys_audit_delete, sys_audit_relation) to clean records over two years. After they were in use, dashboard (data management console) won’t display any data.
What happened? Any way we can view logs, checking job progress?
- Any way to change the table cleaner job running frequency? Is there a way we can check with the job has completed?
- Rotation table (shards) has date overlapped, are those records duplicated?
- When utilizing tools, such as table cleaners, how to make sure all related records are being deleted?
Archiving & Data Retention
- When a record is archived, will the record be removed from the primary table to consider possible space saving? When records were saved in flattened tables (ar_table, sys_archive_log), how much would be saved?
For example, 1 GB of original data, after archiving, how much would be saved? After the destroy rules run, will the space be reclaimed automatically?
- Are we able to query these records after they are archived?
- It seems there is a job that runs every hour for table archiving, table cleanup, are they the same job? How many jobs are there?
Archiving job runs every hour, if a job runs over an hour, another job starts as scheduled, how to deal with such situations?
- How will the archive table limitations affect the archiving?
- If we don’t consider restoring archived records, will table cleaner is a better tool?
