ctm_backup_bcp

The ctm_backup_bcp utility exports data from a Control-M/Server database to one of the following directories:

• Windows: <Control-M_Owner>/ctm_server/bcp_backup

• UNIX: ~<Control-M_Owner>/ctm_server/backup_db

Each database folder is backed up as a separate ASCII file.

You can reduce the time it takes to backup the Control-M/Server database with the ctm_backup_bcp utility if you choose not to backup the Control-M log information (the IOALOG table).

Differences Between the ctm_backup_bcp and ctmdbbck Utilities

The following table shows the differences between ctm_backup_bcp and ctmdbbck utilities.

ctm_backup_bcp	ctmdbbck
Exports data from the Control-M/Server database.	Backs up an image of the database for later restoration with 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

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. Run the following commands to shut down the Configuration Agent and Control-M/Server:

   shut_ca

   shut_ctm

3. Run the following command:

   ctm_backup_bcp [-n]

   -n runs the utility in silent mode. In this mode, confirmation prompts and backing-up-contents confirmation messages do not appear.