I'm running with Control-M6.3 with Oracle, there are around 7000 jobs/day, 3 days of retention for the log.
When I run ctmdbcount, I can see the CMR_IOALOG=883122, it seems a huge value regarding the number of jobs.
We are running daily 'ctmlog -delete from date to date' and the 'ctmdbopt'.
Do you think that this value is normal or can we reduce it ??
Thanks,
How to reduce the number of records in CMR_IOALOG?
How to reduce the number of records in CMR_IOALOG?
Hi,
in the past, i have encountered a situation where the IOALOG was not removed correctly.
- Check the amount of entries in the CMR_IOALOG table:
select count(*) from CMR_IOALOG or ctmdbcount | grep CMR_IOALOG
Normaly this table is supposed to be cleaned during New Day Procedure, and old IOALOG records are removed.
- If you have put: Maximum Days Retained by CONTROL-M Log=3
Check that you don't have older days: select count(*) from CMR_IOALOG where ODATE<'yyyymmjj' (ODATE -3)
If you have entries oldest that ODATE -3, it shows that Control-M is unable to clean correctly the log during the General Daily.
- Clean manually the unwanted entries in this table:
delete from CMR_IOALOG where ODATE<'yyyymmjj' (ODATE -3)
in the past, i have encountered a situation where the IOALOG was not removed correctly.
- Check the amount of entries in the CMR_IOALOG table:
select count(*) from CMR_IOALOG or ctmdbcount | grep CMR_IOALOG
Normaly this table is supposed to be cleaned during New Day Procedure, and old IOALOG records are removed.
- If you have put: Maximum Days Retained by CONTROL-M Log=3
Check that you don't have older days: select count(*) from CMR_IOALOG where ODATE<'yyyymmjj' (ODATE -3)
If you have entries oldest that ODATE -3, it shows that Control-M is unable to clean correctly the log during the General Daily.
- Clean manually the unwanted entries in this table:
delete from CMR_IOALOG where ODATE<'yyyymmjj' (ODATE -3)
Best regards
Walty
Walty
Hi,
I think the retention period determines number of days the log keeps in CMR_IOALOG, so you should filter the table by LOGDATE, not the ODATE.
Try the query as follow (GETDATE()-3 means retention period is 3):
select * from CMR_IOALOG where LOGDATE < CONVERT(char( 8 ), GETDATE()-3, 112)
You should get 0 row counts.
PS - I am running Control-M 6.4, but it should work on either version.
I think the retention period determines number of days the log keeps in CMR_IOALOG, so you should filter the table by LOGDATE, not the ODATE.
Try the query as follow (GETDATE()-3 means retention period is 3):
select * from CMR_IOALOG where LOGDATE < CONVERT(char( 8 ), GETDATE()-3, 112)
You should get 0 row counts.
PS - I am running Control-M 6.4, but it should work on either version.
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France