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, contact IBM® Rational® Software Support.
Databases rarely fail an integrity check, but 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 crash.
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 might give false failures.
The ccmdb check program locks the Informix database during checks. 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 attempt to start a new session while a check is in progress.
You must run this command on the database server, as user ccm_root.
For more information, see Performing database integrity checks.