ccmdb repair

The ccmdb repair command repairs database indexes.

Synopsis

ccmdb repair database_path -i|-repair_index table_name|index_name|''[-y]

ccmdb repair database_path -t|-repair_table table_name [-y]

Uses

Use the ccmdb repair command to repair indexes and tables corrupted at the Informix® level.

In the rare event that a database has been corrupted, contact IBM® Rational® Software Support.

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

You must be user ccm_root to run this command.

Options and arguments

database_path
Specifies the path to the database you are repairing.
-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 the 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. To repair the table data, rename the table, create the table, copy to the new table, and delete the old table.
-y
Executes the command without displaying confirmation messages.

Example

Based on the results of ccmdb check, fix an index corruption in the attrib table in the /vol/tom/ccmdb/primo database.

$ ccmdb repair /vol/tom/ccmdb/primo -repair_index attrib


Feedback