Control-M Database Table CMR_RUNINF

peterrowan · Post by **peterrowan** » 17 May 2010 2:29

This table seems to hold information about every job ever run by control-m. Is there a housekeeping process or utility or parameter to manage this table. I would prefer to keep 6 months of info in this table at most.

tbcaper · Post by **tbcaper** » 18 May 2010 9:50

Peter,

The table CMR_RUNINF holds information on the last 20 successful runs of any job run through controlm. If you execute the command "ctmruninf -delete <fromtime> <untiltime>" you can delete old information. The date format for fromtime & until time is YYYYMMDDHHMMSS.

I hope this helps.

Terry

Walty · Post by **Walty** » 19 May 2010 8:35

Hi,

In the <config.dat> file of the Control-M/Server you have 2 parameters:

RUNINF_PURGE_LIMIT
Number of Run Information records to keep for a given MemName/MemLib/NodeID.
Default: 20.

RUNINF_PURGE_MODE
0 - save the statistics of last x records.
1 - save the statistics of last x days.
Default: 0

Perhaps in the <config.dat> file, these two parameters are missing, in this case the defaults are used.
If you modify this file, the Control-M/Server must be recycle to make the change take effect.
This change will be take effect only the Next New Day.

Don't forget this parameters will have an impact on the Control-M/Server Database (size of the database)

See CONTROL-M/Server Admin guide (configuration parameters)

peterrowan · Post by **peterrowan** » 19 May 2010 11:10

Thanks that is just what I needed