ccmdb update_statistics

This topic contains information about the ccmdb update_statistics command.

Synopsis

ccmdb update_statistics database_path [-l|-low]

Description and uses

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.

Options and arguments

database_path

Specifies the path to the database for which to update the system tables.

-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 executes more slowly.

Example

Perform a quick update of the Informix system tables.

$ ccm update_statistics -low


Feedback