Database management

Each Control-M/Server has its own database. Each Server database contains the job processing definitions (organized by folders) for which that Server is responsible. In addition to the Definitions file, the Control-M/Server database also maintains an Active Jobs database, a Resources a Conditions table. Control-M/EM has its own database, which enables you to control your entire batch production enterprise. The Definition file of the Control-M/EM database contains a copy of all job processing definitions from all of your Control-M/Server databases. This database also includes Active Jobs.

The following procedures describe how to check database space and location and extend the size of an Oracle or MSSQL database:

• Checking Database space: Describes how to check the size of the database server.
• Checking Database location: Describes how to verify the location of the database.
• Extending the Oracle database: Describes how to extend the table space names of a data file in the Oracle database.
• Extending the MSSQL database: Describes how to extend the MSSQL database, which enables you to extend the size of the data or log files in the database.

Many of the database maintenance functions can also be performed from the database maintenance menus and sub menus, as described in Database maintenance.