ctm_backup_bcp
The ctm_backup_bcp utility exports data from a Control-M/Server database to one of the following directories:
-
Windows: <controlm_owner>/ctm_server/bcp_backup
-
UNIX: ~<controlm_owner>/ctm_server/backup_db
Each database folder is backed up as a separate ASCII file.
The user running the ctm_backup_bcp utility must have access permission to create the directory <controlm_owner>/ctm_server/bcp_backup or ~<controlm_owner>/ctm_server/backup_db
The time taken to backup the Control-M/Server database using the ctm_backup_bcp utility can be shortened by choosing not to backup the Control-M log information—the IOALOG table.
The following table shows the differences between ctm_backup_bcp and ctmdbbck utilities:
ctm_backup_bcp |
ctmdbbck |
---|---|
Exports data in the Control-M/Server database |
Backs up an image of the database for later restoration using ctmdbrst |
The backup directory cannot be specified |
The backup directory can be specified |
Backs up each database folder to a separate ASCII file |
Backs up the entire database to a single binary file |
The original and restored databases do not need to be the same size. |
For all databases, except PostgreSQL, the restored database must be the same size as the original database. |
Can use both dedicated and existing Oracle databases |
Not relevant for Oracle databases, whether dedicated or existing |
Running the ctm_backup_bcp Utility
This procedure describes how to run the ctm_backup_bcp utility, which exports data from a Control-M/Server database to the following directories:
-
UNIX: ~<controlm_owner>/ctm_server/backup_db
-
Windows: <controlm_owner>/ctm_server/bcp_backup
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 following commands:
shut_ca
shut_ctm
-
Type the following command:
ctm_backup_bcp [-n]
-n runs the utility in silent mode. In this mode, confirmation prompt and "backing up contents" messages are not displayed.
ctm_backup_bcp example
Messages similar to the following examples are displayed:
backing up contents of CMS_NODGRPbacking up contents of CMR_AGSTAT
backing up contents of CMS_AGCOMM
backing up contents of CMS_AGSRVTIM
backing up contents of CMR_AJF
backing up contents of CMS_JOBDEF
backing up contents of CMS_USERS
…
Database backup ended successfully.
ctm_backup_bcp -n
In this case, Control-M/Server does not display the confirmation prompt and does not issue messages. Only progress dots are displayed.