Previous Topic

Next Topic

Book Contents

Book Index

Control-M/EM utilities

This table lists the Control-M/EM utilities for database maintenance.

Utility Type

Description

build_db

The build_db (build database) utility enables you to define a Control-M/EM Sybase database, or configure a Sybase database client if they become corrupted or if you want to move the database to a different server.

db_check

The db_check utility provides the following information about Control-M/EM databases:

  • Size of the database
  • Availability of space in the database
  • Verification of database integrity.
  • Automatic database and transaction log monitoring

db_check_space

The db_check_space utility provides the following information for Control-M/EM databases that use Sybase Adaptive and Oracle database servers.

em_database_menu

The em_database_menu utility can be invoked interactively to facilitate day-to-day maintenance and diagnostics of Control-M/EM running with PostgreSQL, Oracle and MSSQL databases.

arc_database_menu

The arc_database_menu utility can be invoked interactively to facilitate day-to-day maintenance and diagnostics of Control-M Workload Archiving running with a PostgreSQL database.

em_rebuild_database

The em_rebuild_database utility can be invoked to rebuild the Control-M/EM database in the specified PostgreSQL server database.

em_SQL

The em_SQL utility enables you to connect to the database from the command line.

loader

The loader utility is used to load default data to the Control-M/EM database.

sweep

The sweep utility deletes jobs that are no longer active from the Control-M/EM and Control-M/Server databases.

util

util is a multi-purpose utility that can perform the following functions from the command line:

  • Export data from the Control‑M/EM database
  • Import data to the Control‑M/EM database
  • Delete the Control‑M/EM database
  • Clear the Control‑M/EM database
  • Build the Control‑M/EM database
  • Export a specified definition folder
  • Import a specified definition folder
  • Import Control-M/Forecast data
  • Export Control-M/Forecast data
  • Remove Control-M/Forecast data (to save disk space)

Parent Topic

Database maintenance