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. To run the ctmdbopt command, see Running the ctmdbopt utility.
Parent Topic |