Database maintenance

The database maintenance utilities can be used to maintain the various Control-M databases and to import and export information to and from additional databases.

Many of the tasks performed by the database maintenance utilities can also be performed using the Control-M Configuration Manager or the root menu. However, by including a utility command in the command line of a job processing definition, you can run the utility at a predetermined time or under a predetermined set of conditions without being present.

Some of the parameter names changed for Control-M version 8.0.00 and above. Terminology from previous versions is still supported.

Utilities used to maintain the various Control-M databases

Utility	Description
build_db	Enables you to define a Control-M/EM Sybase database, or configure a Sybase database client if it became corrupted or if you want to move the database to a different server.
ctm_backup_bcp	Exports data from a Control-M/Server database to the ~<controlmOwner>/ctm_server/backup_db directory.
ctm_restore_bcp	Imports the Control-M/Server database from the bcp_backup directory.
ctmcheckmirror	Checks the mirroring of the Control-M/Server database and displays the status.
ctmdbbck	Creates back-ups of the Control-M/Server database.
ctmdbcheck	Displays information about the memory capacity and the status of the Control-M/Server database.
ctmdbmused	Returns the size of a Control-M/Server Master database (Sybase only) and the percent used.
ctmdbopt	Calculates database statistics.
ctmdbrst	Restores the Control-M/Server database in certain cases.
ctmdbspace ctmdbrst ctmdbspace	Checks the data and log usage in the Control-M/Server database and displays the usage.
ctmdbtrans	Lists the active transactions in the Control-M/Server database.
ctmdbused	Displays the size (in MB), amount, and percentage of current space usage in the Control-M/Server database data and log.
ctmreindex	Accesses the Control-M/Server database, reads the data dictionary, reads the index definitions, and then reorganizes indexes. (UNIX only)
db_check	Provides information about the database. (Sybase only)
db_check_space	Provides information for Sybase Adaptive and Oracle database servers. (Sybase and Oracle only)
dbversion	Displays a general description of the Control-M/Server database in use, including the current version number.
em_database_menu	Provides an interactive menu to facilitate day-to-day maintenance and diagnostics of Control-M/EM running with PostgreSQL database.
arc_database_menu	Provides an interactive menu to facilitate day-to-day maintenance and diagnostics of Control-M Workload Archiving running with PostgreSQL database.
em_rebuild_database	Rebuilds the Control-M/EM database in the specified PostgreSQL server database.
em_SQL	Enables you to connect to the database from the command line.
loader	Used to load default data to the Control-M/EM database.
sweep	Deletes jobs that are no longer active from the Control-M/EM and Control-M/Server databases.
Interactive database utilities	Utilities that can be invoked interactively to facilitate day-to-day maintenance and diagnostics of Control-M/EM running with a PostgreSQL database.
util	Multi-purpose utility that can perform various functions from the command line.