Data Archiving - EcoSys - Help - Hexagon PPM

EcoSys Performance Tuning

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
8.6

You can periodically purge some historical data to reduce the amount of data in the database. The following areas may be considered for different types of periodic maintenance and archiving.

How to check row counts:

  • In EcoSys, click System Info, and then select the Database tab. Click Row Counts to view a report of row counts from large tables in the database.

Batch Job Logs

The logs for batch jobs are stored in the EcoSys database. Typically, only one to two months of is needed. You can purge batch job logs using the EcoSys interface. On the Reports > Batch Job Log screen, select the earliest batch job for which to preserve online logs, and then select the option to delete previous batch job logs.

Scripts have been provided for each database platform. Navigate to the UTILS folder for your associated database platform where you will find fm_or_delete_batchjob_records.sql (Oracle) and fm_ss_delete_batchjob_records.sql (SQL Server).

Audit Tables

The audit tables for general modifications, spreadsheets, and other details can consume a large amount of space. You may purge these tables using a simple SQL delete script and a date range. Check with the business owner before removing any audit records. Contact EcoSys support for assistance with the specific queries.