purge_runinfo

There are two main tables in Control-M/Forecast:

• AVG_RUN_INFO: Calculates job run times. This table migrates by default, even if you choose not to migrate Forecast data.
• RUNINFO_HISTORY: Generates Forecast reports using the Reporting facility. The RUNINFO_HISTORY table is a larger table than the AVG_RUN_INFO table and it contains run information used by the Control-M/Forecast Server.

In the last 90 days, for each job execution, a record is entered in the RUNINFO_HISTORY table. The RunTimeHistoryDays system parameter determines how many days the data is kept in the RUNINFO_HISTORY table. The parameter can be set for fewer days, or it can be set to zero (0). Forecast reports (Reporting Facility) keeps only one day of data and no other forecast features are affected. The purge_runinfo maintenance utility needs to run periodically to maintain this table and to clean out Control-M/Forecast run information. The settings are site-specific. The utility is located in one of the following directories, depending on your operating system:

• EMHome\bin (on Windows)
• EMHome/scripts (on UNIX)

The log files of the purge_runinfo utility are located in the installation log directory both in UNIX and in Windows. The log file that shows the run flow of the utility is called purge_runinfo_run.log.