ccmdb check

The ccmdb check command verifies the integrity of a database.

Synopsis

ccmdb check database_path|
For Informix
ccmdb check database_path| [-d|-c]

Uses

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.

For InformixPerform 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.

For InformixShut 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.

For InformixIt 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:
  • Use the ccmdb check -c option during the week without shutting down the database.
  • Use the ccmdb check option without any arguments on the weekend, after shutting down the database, to provide full checking on a weekly basis.

For InformixThe 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.

Options and arguments

database_path
Specifies the full or relative path to the database you are checking.
For Informix
-c
Performs all the checks except Informix database level checks.
For Informix
-d
Only performs Informix database level checks.

Example

Check the cheops database in the current directory.

$ ccmdb check cheops


Feedback