Transaction log file growth where there is a summarization backlog - syncsort_capacity_management - Latest

Syncsort™ Capacity Management Release Notes

Product type
Software
Portfolio
Integrate
Product family
Syncsort™ Software
Product
Syncsort™ Capacity Management
Version
Latest
Language
English
Product name
Syncsort™ Capacity Management
Title
Syncsort™ Capacity Management Release Notes
Topic type
Release Notes > Fixed Issues
Release Notes > What's New
First publish date
1985
Last edition
2024-08-21
Last publish date
2024-08-21T15:07:10.518787

If you are upgrading to the current version of the Syncsort™ Capacity Management and have a backlog of historic data that needs to be summarized due to not recently running Data Management on Integrator data, the new Data Summarizer has the capability of clearing this backlog. This does take time, however, and if you are using the Full Recovery Model for the database, there is the risk that the transaction log will experience a potentially hazardous surge in growth during this process if you have a limited amount of space for this file. Therefore, Precisely advises monitoring the size of the transaction log and performing regular full or transaction log backups to reduce the log file size regularly.

It may also be prudent to turn the Data Summarizer Actions on gradually. In this case, you must turn on the options in this order: Deletion, Daily Aggregation, and then Hourly Aggregation. This will limit the amount of data that is modified during each for the first few runs of Data Summarizer, thereby reducing the impact on the log file in a single run.