ccmdb repair

This topic contains information about the ccmdb repair command.

Synopsis

ccmdb|repair database_path /i|/repair_index table_name|index_name|"" [/y]
ccmdb|repair database_path /t|/repair_table table_name [/y]

Description and uses

The ccmdb repair command repairs indexes and tables at the Informix® level in a Rational® Synergy database.

For more information, see Performing database integrity checks.

Ensure that all Rational Synergy sessions are shut down before running the ccmdb repair command. If any sessions are running when you start the command, you receive an Informix error. For information about shutting down a database, see ccmdb shutdown.

The user for this command is the Rational Synergy administrator.

Back up your current database before running this command.

Options and arguments

database_path

Specifies the path to the database to be protected.

/i|/repair_index table_name|index_name|''

Indicates that you want to re-create an index. If /repair_index is specified with a table name, all indexes in the table are repaired. If an index name is specified, only the specified index is repaired. If "" is specified, all indexes in the database are repaired.

The possible tables are as follows: acckeys, attrib, bind, bsite, compver, control, relate, and release.

/t|/repair_table table_name

Indicates that you want to repair table data for table_name. Do so by renaming the table, creating the table, copying to the new table, and then deleting the old table.

/y

Runs the command without displaying confirmation messages.

Example

Assume that ccmdb check reports an index corruption in the attrib table. Fix the inconsistency by running the following command:

> ccmdb repair \\bulldog\ccmdb\primo /repair_index attrib


Feedback