ccmdb|repair database_path /i|/repair_index table_name|index_name|"" [/y] ccmdb|repair database_path /t|/repair_table table_name [/y]
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.
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.