The ctmreindex utility accesses the Control-M/Server database, reads the data dictionary, reads the index definitions, and then reorganizes indexes. (UNIX only)
This utility is relevant only on Control-M/Server with a Sybase database.
The Control-M/Server Sybase database must be running so that the required index operations can be performed. However, this utility should be run only when database activity is low.
This utility enables Control-M/Server database queries to execute faster by ensuring that indexes are well-balanced. For more information about indexes, refer to Sybase manuals. To run the ctmreindex utility, see Running the ctmreindex utility.
Parent Topic |