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