Update Database Statistics

• PostgreSQL
• MSSQL
• Oracle

Updates statistic procedures in the database server.

NOTE: You can also run this as an interactive utility by typing DBUUpdateStatistics.

Database Consistency Check

• PostgreSQL
• MSSQL

MSSQL: Performs allocation checks and verifies the structural and logical integrity of all objects in the database

Oracle: Detects bad blocks and checks table and index schema consistency.

Hot Database Backup

PostgreSQL

Only enabled when:

• Database Archive Mode is set to On
• Control-M/Server is active and running with a dedicated database server.

Online backup of a dedicated PostgreSQL database server file system and the Control-M/Server databases. This backup can be used to restore the database up to and including the last completed transaction.

Parameters:

• Backup Directory: Full path to the directory into which the server file system and Control-M/Server databases should be backed up.

  NOTE: This directory should be empty.

• Administrator password: Password of the PostgreSQL database server administrator.

NOTE: To run this as an interactive utility, see Running the DBUHotBackup utility.

Cold Database Backup

• PostgreSQL
• MSSQL

Exports the Control-M/Server database schema to the specified file when Control-M/Server is shut down.

The following Control-M/Server components must be shut down prior to activating this backup:

• Control-M/Server Configuration Agent (shut_ca)
• Control-M/Server (shut_ctm)

Parameters:

• Backup File: Full path to the file into which the database should be backed up.
• Administrator password: Password of the PostgreSQL database server administrator

NOTE: To run this utility interactively, see DBUColdbackup

Hot Database Restore

()

PostgreSQL

Only enabled when Control-M/Server is active and running with a dedicated PostgreSQL database server.

Online restore of the PostgreSQL database server file system and the Control-M/Server databases. When this option completes successfully, the previous PostgreSQL database server file system is saved to the following location:

<pghome_directory/old_pgsql_<date of operation>

If Control-M/Server databases do not exist in the <pghome_directory> it is saved in the following location:

<db location>/<db name>_old_<date of operation>

The PostgreSQL database server and the following Control-M/Server components must be shut down for this option to be enabled:

• Control-M/Server Configuration Agent (shut_ca)
• Control-M/Server (shut_ctm)

Parameters:

• Restore Directory: Full path to the directory from which the server file system and Control-M/Server databases should be restored.
• Archive Directory: Value and location specified in the Archive Directory parameter of the Set Database Archive Mode option.

  NOTE: When this action is finished successfully, the PosgreSQL database server archive mode switches to off, and the PosgreSQL database server shuts down.

  The specified directory should be exported from the PostgreSQL database server with the same parameter values as the destination PostgreSQL database server.

NOTE: You can also run this as an interactive utility by typing DBUHotRestore.

Cold Database Restore

• PostgreSQL
• MSSQL

Imports the Control-M/Server database schema from the file specified in Backup File parameter of the Cold Database Backup option.

NOTE: The following Control-M/Server components must be shut down for this option to be enabled:

• Control-M/Server Configuration Agent (shut_ca)
• Control-M/Server (shut_ctm)

Parameters:

• Restore File: Value and location specified in the Backup File parameter of the Cold Database Backup option.
• Administrator password: Password of the PostgreSQL database server administrator.

NOTE: To run this utility interactively, see DBUColdRestore.