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 database level.

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

To run this command, you must log on as the Oracle user who has write privileges for the appropriate tasks. For more information, see Setting up user privileges for UNIX on Oracle.

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 table data, rename the table, create the table, copy to the new table, and then 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