ccmdb update_statistics

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


Feedback