Performing offline database cleanup


TrueSight Server Automation provides a separate database cleanup utility for offline maintenance. In most cases, data older than the retention period is not used very often and becomes an overhead to the database. You can use this utility to reduce the size of the database by deleting data that is older than the retention period. BMC recommends running the offline cleanup utility before upgrading to a newer version of the product, in order to reduce migration time.

Warning

Running the offline database cleanup utility on partitioned tables causes data corruption. For details, see Notification of a critical issue with partitioned databases.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*