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