Chapter 50. Repository Maintenance

Certain tables of the repository database can overflow, for example, tables containing metrics and logs. To avoid table overflow, PPEM uses housekeeping rules. A housekeeping rule cleans the table by deleting the data stored longer than the specified amount of time. It can also be a set of one or multiple conditions containing a table field, logical operator, and value or function.

If a housekeeping rule is a set of multiple conditions, the AND logical connective is used.

For example, a housekeeping rule can delete the table data stored longer than 12 hours and include the condition containing the oid table field, the > logical operator, and the 10 value. With such a rule, the table data is deleted after 12 hours and if the value of the oid table field exceeds 10.

You can mark housekeeping rules as auto-run. In this case, they clean the table at the specified interval.

Important

The housekeeping rules functionality is in the beta phase. It will be updated and expanded later.