ctm_restore_bcp

The ctm_restore_bcp utility imports the Control-M/Server database from the following directories:

  • UNIX: ~<controlm_owner>/ctm_server/backup_db

  • Windows: <controlm_owner>/ctm_server/bcp_backup

The content of this directory was created by the ctm_backup_bcp utility.

The following table shows the differences between the ctm_restore_bcp and ctmdbrst utilities:

ctm_restore_bcp

ctmdbrst

Imports backup created by ctm_backup_bcp

Imports backup created by ctmdbbck

Cannot specify the directory containing the exported files

Can specify the directory containing the exported files

Only relevant if Control-M/Server is down

Always relevant

Imports ASCII files

Restores from a binary file

Copy
ctm_restore_bcp
Restoring contents of database.
This procedure DELETES any information in main database
Please confirm [y/n]: y

Running the ctm_restore_bcp utility

This procedure describes how to run the ctm_restore_bcp utility, which imports the Control-M/Server database from the following directories:

  • UNIX: ~<controlm_owner>/ctm_server/bcp_backup

  • Windows: <controlm_owner>/ctm_server/backup_db ()

Begin

  1. Do one of the following:

    • UNIX: Log in to a Control-M/Server account.

    • Windows: Open a command prompt window where Control-M/Server is installed.

  2. Shut down Control-M/Server by using the shut_ctm command. Make sure no other users or processes are connected to the SQL Server.

  3. Enter the following the command:

    ctm_restore_bcp [-n]

ctm_restore_bcp utility example

Messages similar to the following examples are displayed:

Copy
restoring contents of CMS_NODGRP
restoring contents of CMR_AGSTAT
restoring contents of CMS_AGCOMM
restoring contents of CMS_AGSRVTIM
restoring contents of CMR_AJF
restoring contents of CMS_JOBDEF
restoring contents of CMS_USERS

Database restore ended successfully.
ctm_restore_bcp -n

In this case, Control-M/Server does not display the confirmation prompt and the "restoring contents" messages. Only progress dots are displayed.