ccmdb check

This topic contains information about the ccmdb check command.

Synopsis

ccmdb ch|check [database_path] [/c] [/d]

Description and uses

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.

Options and arguments

database_path

Specifies the full or relative path to the database you are checking.

/c

Performs all the checks except Informix database level checks.

/d

Only performs Informix database level checks.

Example

Check the project1 database.

> ccmdb check \\data\ccmdb\project1


Feedback