Symptoms
Parallels Infrastructure Manager (PIM) stores events, resource and operation logs in database inside the service container. If Master node in PIM is Windows server Microsoft SQL Server Desktop Engine (MSDE) is used as database store inside the service container. MySQL is used if Master node in PIM is Linux server.MSDE has a limitation which does not allow to use database more than 2 GB. PIM data may grow beyond the limit. If this occurs, it is recommended to clear databse from old events, resource and operation logs.
Resolution
This article provides scripts which clear database from old records on Master node of PIM infrastructure.If Master node is Windows 2003 server use attached win_w2k3_remove_old_logs.cmd script.
If Master node is Windows 2008 server use attached win_w2k8_remove_old_logs.cmd script.
Note the script has hardcoded DAYS_TO_LEAVE variable (amount of days for which db entries are left). The value is changed directly in the script file.
If Master node is Linux server use attached lin_remove_old_logs.sh script. Linux script accepts DAYS_TO_LEAVE value as command line parameter.