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

  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 following commands:

    shut_ca

    shut_ctm

  3. 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:

Copy
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.