Update Database Statistics

• PostgreSQL
• MSSQL
• Oracle

Activates statistic procedures in the database server.

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

Build Database

• PostgreSQL
• MSSQL
• Oracle

Creates a Control-M/EM schema on the database server.

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

Cold Database Backup

• PostgreSQL
• MSSQL

Exports the Control-M/EM database schema to the specified file.

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

• Gateway
• GUI server
• BMC Batch Impact Manager
• Control-M/Forecast
• Global Conditions Server
• Control-M Configuration Management Server
• Control-M Configuration Agent

Backup File: Full path to the file into which the database should be backed up.

Administrator password: Password of the database server administrator.

NOTE: You can also run this as an interactive utility, as described in Running the DBUColdBackup utility.

Cold Database Restore

• PostgreSQL
• MSSQL

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

NOTE: This option is not enabled if Control-M database server is running.

Restore File: Value and location specified in the Backup File parameter of the Cold Database Backup option.

Administrator password: Password of the database server administrator.

NOTE: You can also run this as an interactive utility, as described in Running the DBUColdRestore utility

Extend database

Oracle

MSSQL

(Oracle and MSSQL only) Extends the database size. Contact your DBA for assistance in performing this action if you are not comfortable performing it yourself.