Update database statistics

Activates statistic procedures in the database server.

Passwords: Database Owner, Database server administrator

Hot Database Backup

Only enabled when:

• Database Archive Mode is set to On
• Control-M Workload Archiving is running with a dedicated database server.

Online backup of the database server file system, and the Control-M Workload Archiving database. This can be used to restore the database up to and including the last completed transaction.

Parameters available:

Backup Directory
Full path to the directory into which the server file system and Control-M Workload Archiving database must be backed up.

This directory must be empty.

Passwords: Database Owner, Database server administrator

Cold Database Backup

Exports the Control-M Workload Archiving database schema to the specified file.

Parameters available:

Backup File

Full path to the file into which the database must be backed up.

Passwords: Database Owner, Database server administrator

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

Hot Database Restore

NOTE: Only enabled when Control-M Workload Archiving is running with a dedicated database server.

Online restore of the PostgreSQL database server file system and the Control-M Workload Archiving database. 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 Workload Archiving database does not exist in the <pghome_directory> it is saved in the following location:

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

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

Parameters available:

Restore Directory
Full path to the directory from which the server file system and Control-M Workload Archiving databases must 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.

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

Cold Database Restore

Imports the Control-M Workload Archiving 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 Workload Archiving server is running.

Parameters available:

Restore File

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

Passwords: Database Owner, Database server administrator