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 Control-M Reports. 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 (Control-M Reports) 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.