Set your record retention policies

Each time a view is published, log and statistics data are collected and stored in the following databases:

• Log data is stored in the PIIntegratorLogs SQL database.

  Note: If you are querying the database directly, time stamps are in GMT format.

• Statistics data is stored in the PIIntegratorStats SQL database.

Over time, these records can take up a lot of space on your server and, therefore, PI Integrator for Business Analytics periodically deletes the log and statistics records. The settings for the tasks are configured in the %PIHOME64%\Integrators\BA\CAST.UI.WindowsService.exe.config file.

The configuration file has the following separate sections for setting the policies for log records and for statistics records:

• <maintenanceTasks> section which determines when the records are deleted. There are two tasks, logRetentionPolicies and statRetentionPolicies.

• <logRetentionPolicies> and <statsRetentionPolicies> sections which determines which records are deleted