Use the ccmdb check command to verify the integrity of a database.
The command reports any problems that are found. If a problem is found, call IBM® Rational® Software Support.
Databases rarely fail an integrity check. However, if failure does occur, detect it quickly so that you can correct the problem immediately. Therefore, run the ccmdb check program daily, on each database, and after rebooting the system following a hardware failure or operating system stop.
You can perform checks at the Rational Synergy level using the /c flag, at the Informix® level using the /d flag, or at both levels. If no option is specified, both checks are run.
Shut down the database before checking it at the Informix level using the /d flag (or with no option). If records are locked by users while the Informix level check is running, the command can give false failures.
It is not necessary to shut down the database before checking it at the Rational Synergy level using the /c flag. To extend the availability of your database:
During checks, the ccmdb check program locks the Informix database. This locking prevents users from changing data in the database while a check is being performed. Users receive a message that the database is locked when they try to start a new session while a check is in progress.
You must run this command on the database server as the CM administrator.
For more information, see Performing database integrity checks.