Rebuilding a Control-M/Server database

This procedure describes how to rebuild a Control-M/Server database if the database structure (schema) is corrupt. After you rebuild the database, you need to restore the data.

Before you begin

Before rebuilding the database, verify that the following requirements are met:

• Back up the database data (see Backing up a Control-M/Server MSSQL database)
• Shut down Control-M/Server and Control-M/Server Configuration Agent
• The SQL database is running
• No Control-M/Server utilities are connected to the SQL Server

To rebuild a Control-M/Server database:

1. Display the Control-M Main Menu by typing the ctm_menu command.
2. In the Control-M Main menu enter the number for the Database Menu option.

   The Database Utilities Menu appears.

3. In the Database Utilities Menu, enter the number for Management.

   Management Menu appears.

4. In the Management Menu, enter the number for the Build Database option.
5. Follow the prompts online, and specify or change the parameters as required.

   Default values are provided for most of the parameters. Modify them as required.

   NOTE: When rebuilding the database, working in an existing mode, the full path names of the log and data devices must be different from the original path names.

6. In the Main Menu, enter the number of the Database Maintenance option.
7. In the Database Maintenance, enter the number of the Cold Database Restore option to load the data into the new database.
8. Follow the displayed prompts.

   The backup device must be a valid device defined in the database, or the full path name of a backup file to be used as input for the ctmdbrst utility.

   If you do not know the name of the backup device, display the list of backup devices by entering the number of the List Backup Devices option in the Database Maintenance menu, and then note the name of the device.

9. When you are done, enter q to quit.