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 |
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
-
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.
-
-
Shut down Control-M/Server by using the shut_ctm command. Make sure no other users or processes are connected to the SQL Server.
-
Enter the following the command:
ctm_restore_bcp [-n]
ctm_restore_bcp utility example
Messages similar to the following examples are displayed:
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.