ctmdbbck

The ctmdbbck utility backs up the Control-M/Server database in the following cases:

• Control-M/Server was installed with a dedicated PostgreSQL database server.

  Do not use this utility if Control-M/Server was installed with an Oracle database (either existing or dedicated) or an existing PostgreSQL database. To back up an existing Oracle database or an existing PostgreSQL database, use the ctm_backup_bcp utility.

• Control-M/Server was installed with an MSSQL database server.

For information about Archive mode, see Set Database Archive Mode referred to in the table in Accessing the Database Utilities Menu.

Running the ctmdbbck Utility

This procedure describes how to run the ctmdbbck utility to back up the Control-M/Server database.

Begin

1. Do one of the following:

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

   • Windows: Open a command prompt on the Control-M/Server host.

2. Do one of the following:

   • To run the ctmdbbck utility in interactive mode, run the following command:

     ctmdbbck

   • To run the ctmdbbck utility in non-interactive mode, run the following commands:

     • UNIX:

       ctmdbbck [ -p<administrator password>]

       [ -f<administrator password file>]

       [ -d<full path of backup directory/file>]

       [ -m<backup mode H/C>]

     • Windows:

       ctmdbbck [ -p<administrator password>]

       [ -f<administrator password file>]

       [ -d<full path of backup directory/file>]

Backing Up the Control-M/Server Database

This procedure describes how to back up the Control-M/Server database (not the PostgreSQL database).

Before You Begin

• Shut down Control-M/Server as described in shut_ctm.

• Shut down the Configuration Agent, as described in shut_ca.

Begin

1. Do one of the following:

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

   • Windows: Open a command prompt window on the Control-M/Server host.

     For Windows client installations, open a command prompt and navigate to the <Control-M/Server_Home>\ctm_server\directory.

2. Run the following command:

   ctmdbbck

3. Follow the prompts to continue the backup.

   For MSSQL, you are prompted for the backup device (<backupDevice>). The device that is defined by this parameter must be one of the following:

   • A valid device defined in an existing MSSQL.

   • The full pathname of a file to be created by the backup procedure for MSSQL.

4. If no backup devices exist, or if you want to use a new backup device, choose 6 - Add Backup Device from the Database Maintenance menu.

Backing Up the Control-M/Server Database (PostgreSQL)

This procedure describes how to back up the Control-M/Server database with a PostgreSQL.

Before You Begin

• Shut down Control-M/Server as described in shut_ctm.

• Shut down the Configuration Agent, shut_ca.

Begin

1. Do one of the following:

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

   • Windows: Open a command prompt on the Control-M/Server host.

     For Windows client installations, open a command prompt and navigate to the <Control-M/Server_Home>\ctm_server\directory.

2. Enter the following command:

   ctmdbbck

   For MSSQL, you are prompted for the backup device (<backupDevice>).

3. Follow the prompts to continue the backup.

   Prompts and messages similar to the following are displayed:

   Copy

   Please Enter Postgres Administrator Password:*******
   Detecting current archive mode ...
   Archive Mode=off
   Done.
   Enter full path destination file name:c:\bckup
   Performing Cold backup into c:\bckup ...
   backup succeeded. It is recommended to check backup file by restoring it to test
   environment.
   You can start Control-M/Server.
   The back up is complete.

Running the ctmdbbck in Silent Mode

This procedure describes how to run the ctmdbbck utility in silent mode.

Begin

1. Do one of the following:

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

   • Windows: Open a command prompt on the Control-M/Server host.

2. Enter the following command:

   ctmdbbck -pmanager / -f<passwordFile> -d<backupDirectory> - m<H/C>

   With a PostgreSQL databse, silent mode is available only on UNIX.