Taking a long time to load logs into the DMC for a single day


Diagnostics

Product: DataMigrator
Release: 8205
Primary OS: Windows
Solution Date:

Problem

When trying to retrieve logs for a single day on our Data Management Console, it take over 15 seconds to retrieve and display them where it use to instantaneously in the past.

Solution

The ETL log files have grown large because there are many ETL Flows running daily. 

For information that allows the ETL logs to be manageable and readable for daily or weekly reviewing, refer to the Custom Procedures for Managing FOCUS Logs and Statistics section for the following:

How to Automatically Delete Rows From the ETL Log and Statistics Table
How to Automatically Backup and Recreate the ETL Log and Statistics Tables