ccmdb update_statistics database_path [-l|-low]
Use the ccmdb update_statistics regularly to update Informix system tables so that your queries execute more quickly. This command is run for you as part of the ccmdb check, ccmdb load, and ccmdb unpack commands.
You must be user ccm_root to run this command.
The ccmdb update_statistics command uses the UPDATE STATISTICS statement. Contact IBM® Rational® Software Support for more information about using this command.
Perform a quick update of the Informix system tables.
$ ccm update_statistics -low