Running the purge_runinfo utility

This procedure describes how to run the purge_info utility, which enables you to clean out run information retained by Control-M/Forecast for the purposes of performing its calculations.

To run the utility:

• Do one of the following
  • To run the utility interactively, type the following commands depending on your operating system:
    • On Windows

    <emHome>\bin\purge_runinfo.bat

    • On UNIX

    <emHome>/scripts/purge_runinfo shell script

  • Answer the prompts when they are displayed. You are prompted for the following information:
    • The number of days to retain the information about the run of the jobs
    • The Control-M/EM database owner (DBO) password user name and password

  The utility has finished when the message Ended successfully is displayed.

• To run the utility silently, type the following command:

  purge_runinfo –U <emUser> -P <emPass> -keep_days <numDaysRetain>

  On UNIX, you can hide the password using the file method (in this example, X is the name of the file that contains the password):

  EXAMPLE: cat X | purge_runinfo –U <emUser> -P <emPass> -keep_days <numDaysRetain>

  <numDaysRetain> is the number of days to retain the statistics. If <numDaysRetain> is 2, all statistics prior to two days before the current date will be deleted. For example:

  purge_runinfo –U myuser -P mypassword -keep_days 2

  The DeleteChunkSize system parameter determines the number of records deleted in one transaction by the purge_runinfo utility when removing run information from the RUNINFO_HISTORY table in the Control-M/EM database. If the DeleteChunkSize value is smaller than the parameter value, no data is deleted.