Use the ccmdb update_statistics regularly to update Informix® system tables so that your queries run more quickly. This command is run for you as part of the ccmdb check, ccmdb load, and ccmdb unpack commands.
Synopsis
ccmdb update_statistics database_path [/l|/low]
Uses
The user for this command is the Rational® Synergy administrator.
The command must be run from the database server machine or on a client with admin tools installed.
Options and arguments
- database_path
- Specifies the path to the database containing the system tables to be updated.
- /l|/low
- Causes the command to perform a quicker, less comprehensive system catalog table check and update. The default is to perform the most comprehensive table check and update, which runs more slowly.
Example
Perform a quick update of the Informix system tables to the \\bulldog\ccmdb\tstgonzo database.
> ccmdb update_statistics /low \\bulldog\ccmdb\tstgonzo