Control-M/EM - delete prereq conditions on Distributed side?

[fyot]

Hi Tommie,

ECACONTB run normally on all Control-M Server.

Using "ecacontb deletefrom" function, you could be able to delete oldest condition. You just need to run it on each Control-M Server.

Another way could be used. Delete directly in your database using SQL command oldest conditions before a special ODAT (MMDD).

delete from CMR_CONTAB where convert(int,CMR_CONTAB.CONDDATE) < MMDD

Replace MMDD by the ODAT as 0308

[fyot]

Hi

Try following command through ctm_menu :

select * from CMR_CONTAB where convert (int,CMR_CONTAB.CONDDATE) < 0307

If you have some result you can do :
delete from CMR_CONTAB where convert (int,CMR_CONTAB.CONDDATE) < 0307

[fyot]

Well,

It must be correct now.
if you try again select command, you must have 0.

[fyot]

Hi,

It's true, ECACONTB is not supported since the version 6.0.x of Control-M Server.
It still exists as a Control-M utility with the 6.2.01 version.
I am not able to give you a feedback about the 6.3.01 version.

BMC certainly kept that utility with Control-M Server package to be compatible with the old 2.24.00 version of Control-M.

ECACONTB has been replaced by CTMCONTB, and you can do same work.

[mauriziog]

Use the utility CTMCONTB !
From the manual:

ctmcontb -DELETEFROM <Condition_name>
<From_date> <To_date>

or ctmcontb -input_file <Full_path_file_name>