ctm_backup_bcp

The ctm_backup_bcp utility exports data from a Control-M/Server database to one of the following directories:

• Windows: <controlm_owner>/ctm_server/bcp_backup
• UNIX: ~<controlm_owner>/ctm_server/backup_db

ctm_restore_bcp

The ctm_restore_bcp utility imports the Control-M/Server database from the bcp_backup (Windows) or backup_db directory.

ctmdbbck

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

• Control-M/Server was installed by using 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 (described on ctm_backup_bcp).
• Control-M/Server was installed by using an MSSQL database server.

ctmdbcheck

The ctmdbcheck utility displays information about the memory capacity and the status of the Control‑M/Server database.

ctmdbopt

The ctmdbopt utility calculates database statistics.

ctmdbrst

The ctmdbrst utility restores the Control‑M/Server database in the following cases:

• Control-M/Server was installed by using 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 restore an existing Oracle database or a PostgreSQL database, use the ctm_restore_bcp utility (described on ctm_restore_bcp).
• Control-M/Server was installed by using an MSSQL database server.

ctmdbspace

The ctmdbspace utility checks the data and log usage in the Control-M/Server database and displays the usage.

ctmdbtrans

The ctmdbtrans utility lists the active transactions in the database.

ctmdbused

The ctmdbused utility displays the size (in MB), amount, and percentage of current space usage in the Control‑M/Server database data and log.

dbversion

The dbversion utility retrieves the database server version and tests the connectivity of the Control-M/Server database in use.

dbu_menu

Facilitates day-to-day maintenance and diagnostics of Control-M/Server running with PostgreSQL, Oracle and MSSQL databases.

For maintenance and diagnostics of Control-M/EM database running with PostgreSQL, Oracle and MSSQL see em_database_menu.

NOTE: You can run many of the utilities interactively, as described in Interactive database utilities.

restore_host_config

Enables you to update the host name configuration.