Automating Control-M database hot backups

As an administrator you may want to automate your database backup jobs in order to avoid manual effort. Here are the steps to do that:

Prior to taking hot backup make sure archival is on. You may create a Control-M OS type job to automate it to take hot backup of Control-M database periodically. Use DBUHotBackup utility for that. Path for this utility is as given below.

<Control-M server home directory>\BMC Software\Control-M Server\ctm_server\exe\DBUtils\DBUHotBackup

e.g. If installation is done in C:\Program Files then path will be as below:

C:\Program Files\BMC Software\Control-M Server\ctm_server\exe\DBUtils\DBUHotBackup


Syntax:

DBUHotBackup -BACKUP_DIRECTORY <full path of backup directory> -ADMINISTRATOR_PASSWORD <database administrator password>

e.g.

DBUHotBackup -BACKUP_DIRECTORY e:\ctmbackups\ -ADMINISTRATOR_PASSWORD Ctm123

One prerequisite is that your backup directory folder should be empty. So you need to make sure you move the files after taking backups to another directory. You may schedule this job to run daily at non peak hours.