Overview
You may have noticed that the disk space on your LGP servers tends to saturate, and you need to reduce the amount of data kept. You may want to archive the data that exceeds a period of time (e.g., six months).
Solution
To reduce the amount of data stored in the LGP server's database, you must configure archiving by completing the following steps:
Configuring Logging Properties
To configure logging properties, complete the following steps:
- In the left navigation bar, select Logging > Properties.
The Properties tab appears. - In the Convert To Archive Storage After field specify the period (in hours) after which the LGP log record tables will be converted to archive storage. The default value is -1 which indicates that no archiving will be performed. The maximum allowed value is 26304 hours (1096 days).
- In the Database Archive Schedule field specify the time when LGP starts converting the log records tables into Archive format or vice-versa (i.e. un-archiving already archived table records). DB archive schedule is written as a comma separated list of hh24mm time schedules. For example 1 AM and 1 PM is 0100,1300. Default value is 0135. Maximum 24 durations can be configured as DB archive schedule.
DB archive schedule must be set to off-peak hours period. Archival/Un-archival procedure can take time and transaction/event files are not loaded during archival/un-archival. Configuring DB archive schedule parameter to peak-hours will impact the performance of LGP loader and LGP query module. - In the Background Query Max Run Time field specify the maximum run time (in seconds) for a background query. Default value is '36000' (10 Hours). Maximum allowed value is 65535
In case you want the support team to configure this or if there's an immediate requirement to free up space (which requires archiving) open a support ticket with the appropriate details (eg: how much data you want to keep (eg: last 12 months)).
Bear in mind that this type of services might be out of support's scope and thus, might be escalated to our Professional Services team.
When determining how long data will stay before it is archived, consider how much data will be archived if you select the period you have in mind (eg: six months). If most of the data is newer than that, archiving will have little effect in freeing up disk space.
Testing
The disk usage can be checked by running df -kh. In case you experience any issue with the Archiver process, make sure you check the Archiving process is failing KB Article.