Control-M/EM Database Backup and Restore

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

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 DataLink copied to clipboard

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

Begin

  1. Display the Control-M/EM Root Menu (root_menu).

  2. In the Control-M/EM Root Menu, enter the number for the Database Maintenance option.

  3. In the Database Maintenance menu, enter the number for the Export Database option.

  4. Specify the name of the file to which the database should be exported.

    The database is exported to a file you specify. The file is called export_file_name.Z.

  5. Enter q to exit the Database Maintenance menu and the Root menu.

Restoring Control-M/EM DataLink copied to clipboard

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

Begin

  1. Display the Control-M/EM Root Menu (root_menu).

  2. In the Control-M/EM Root Menu, enter the number for the Database Maintenance option.

  3. In the Database Maintenance menu, enter the number for the Import Database option.

    You are prompted for location of the export_file_name file that was created during the procedure.

    Enter the path and name for the export_file_name file. Do not include the .Z extension. When the procedure is complete, the Database Maintenance menu is displayed.

  4. Enter q to exit the Database Maintenance menu and the Root menu.

    If you quit the Root menu or its submenus while performing the database restore, you must perform Rebuilding the database schema following import interruption.

Backing up Audit RecordsLink copied to clipboard

This procedure describes how to back up audit records.

Begin

  • Invoke the util utility with -export and -type audit, using the following syntax:

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

Restoring Audit RecordsLink copied to clipboard

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

Beginctmsec

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

  2. Invoke the util utility with -import, -replace, and -type audit, using the following syntax:

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