Performing database integrity checks

Use the ccmdb check command to verify the integrity of the database metadata. The command checks both at the RDBMS level and at the semantic level.

Your database might never fail an integrity check. However, if a failure does occur, know about it immediately so that you can correct it to avoid data loss. Run the ccmdb check program daily on each database and after rebooting the system from a hardware failure or operating system stop.

When you run the ccmdb backup command, a ccmdb check is performed automatically before the backup.

You must be working as the CM administrator to perform this command. You must run this command on the machine where the database server resides.

Windows

Procedure

To perform database integrity checks for Windows®:

  1. Check the database.

    > ccmdb check database_path

    The command reports any problems that are found. If a problem is found, call IBM® Rational Software Support.

  2. Log off from the Rational Synergy administrator.

UNIX

Procedure

To perform database integrity checks for UNIX®:

  1. Log on to the database server.
  2. Set user to ccm_root.
    $ su - ccm_root
    Password: *****

    If you did not set up CCM_HOME and PATH for user informix during installation, set these environment variables now. See Setting environment variables for UNIX.

  3. Check the database.

    $ ccmdb check database_path

    The command reports any problems that are found. If a problem is found, see Repairing databases.

  4. Exit from user ccm_root.

Feedback