Control-M/EM Database Backup and Restore

The following procedures describe how to back up and restore a Control-M/EM database:

• Backing up Control-M/EM Data
• Restoring Control-M/EM Data
• Backing up Audit Records
• Restoring Audit Records

You can use the ctmsec batch utility to export and import Control-M Security Definition tables. The file that is generated by the ctmsec command is an executable file containing API functions that redefines all the security entries when the script runs. The generated file can be modified and imported to any Control-M installation.

Backing up Control-M/EM Data

This procedure describes how to back up Control-M/EM data by exporting the data to a file in a defined location.

Begin

1. Run the following command to navigate to the Control-M/EM Root Menu:

   root_menu

2. From the Control-M/EM Root Menu, press the number listed for the Database Maintenance Menu.

   The Database Maintenance Menu appears.

3. From the Database Maintenance Menu, press the number listed for the Export Database option.

   A prompt appears that requests the filename where the database is exported.

4. Type the required filename.

   The database exports to the user-defined filename, in the following format:

   <Export_Filename>.Z

5. Press q to exit the Database Maintenance Menu and Control-M/EM Root Menu.

Restoring Control-M/EM Data

This procedure describes how to restore Control-M/EM data.

Begin

1. Run the following command to navigate to the Control-M/EM Root Menu:

   root_menu

2. From the Control-M/EM Root Menu, press the number listed for the Database Maintenance Menu.

   The Database Maintenance Menu appears.

3. From the Database Maintenance Menu, press the number listed for Import Database.

   A prompt appears that requests the exported database filename, as described in Backing up Control-M/EM Data.

4. Type the required path and filename, without the .Z file extension.

   Control-M restores the database.

5. After the database is restored, press Enter to return to the Database Maintenance Menu, and press q to exit the Database Maintenance Menu and Control-M/EM Root Menu.

   If you quit the Root menu or its sub-menus while the database restore is performed, you must perform Rebuilding the database schema following import interruption.

Backing up Audit Records

This procedure describes how to back up audit records.

Begin

• Run the util utility with the -export and -type audit parameters, as follows:

  util -U DBO_name -P DBO_password -export -type audit

Restoring Audit Records

This procedure describes how to restore Control-M/EM audit records. The command described in this procedure deletes old audit records.

Begin

1. To save old audit records, run the util utility with the -export and -type audit parameters.

2. Run the util utility with the -import, -replace, and -type audit parameters, as follows:

   util -U DBO_name -P DBO_password -import -replace -type audit