Start Database

PostgreSQL

Only enabled when Control-M/Server is running with a dedicated database server. Starts the PostgreSQL database server, and services involved.

NOTE: If this option is invoked on Control-M/Server running with an existing database, an error message is displayed. To run this utility interactively, see Running the DBUStart utility.

Stop Database

PostgreSQL

Only enabled when Control-M Server is running with a dedicated database server.

Stops the PostgreSQL database server, and services involved.

To run this utility interactively, see Running the DBUStop utility.

NOTE: If this option is invoked on Control-M/Server running with an existing database, an error message is displayed.

Set Database Archive Mode

PostgreSQL

Only enabled when Control-M/Server is running with a dedicated PostgreSQL database server. Changes the archive mode of the PostgreSQL database server.

Parameters available:

Mode

• On
• Off (default)

Archive Directory (only available when Mode is ON)
Full directory path to which the database server logs are archived.

NOTE: This directory should be empty. When Archive mode is On, the Hot Database Backup option is enabled. You can also run this as an interactive utility by typing DBUArchive.

Build Database

• PostgreSQL
• MSSQL
• Oracle

Creates a Control-M/Server database.

NOTE: This option is only enabled on Control-M/Server running with either an existing or a dedicated database server. You can also run this as an interactive utility by typing DBUBuild.

Extend Database

• Oracle
• MSSQL

Extends the size of the existing user database datafile, or adds a new datafile, to provide extra space for schema objects.

Parameters:

• Mode: Current or New
• Current – a current data file is extended
• New – an additional data file will be added to the database
• Directory Path: the full directory path to the new datafile if parameter mode is set to New
• Administrator Password: DBA password (for Oracle only)
• Size: specified in MB
• (MSSQL only) Type: Data or Log