ctmdbopt

The ctmdbopt utility calculates database statistics. This utility wraps the relevant database packages that collect statistics on all Control-M/Server database folders. You can run this utility while Control-M/Server is running.

The ctmdbopt utility collects folder and index statistics on the Control-M schema by using the DBMS_STATS package. It affects all Control-M/Server for UNIX and Microsoft Windows database folders. The statistics helps the optimizer to choose the fastest way to retrieve data—full folder scan, index scan, or any other way.

Gathering statistics improves database performance. BMC recommends that you run this utility on a daily basis, so that the database optimizer has updated statistics.

Running the ctmdbopt Utility

This procedure describes how to run the ctmdbopt utility, which calculates database statistics.

Begin

Do one of the following:
- UNIX: Log in to a Control-M/Server account.
- Windows: Open a command prompt window where Control-M/Server is installed.
Enter the following command:

ctmdbopt