Analyzing and repairing databases

You can use the analyze utility to analyze and repair active databases on the Surround SCM Server and other RDBMS databases not currently in use. For example, you may want to analyze an inactive database for issues before restoring it.

The analyze utility analyzes any Surround SCM RDBMS database, but only repairs issues in databases in the current database format. If issues are found in databases in an earlier format, you must add older databases to the Surround SCM Server and upgrade the mainline branches before repairing issues. See the Surround SCM help for information about adding RDBMS connections and upgrading mainline branches.

1. Start the Surround SCM Analyze Utility. See Starting the analyze utility.

2. Connect to a Surround SCM Server that hosts the database to analyze or repair.

To analyze a database in use by Surround SCM, choose File > Connect to Server. See Connecting to databases in use.
To analyze an RDBMS database not in use, choose File > Connect Directly to RDBMS. See Connecting to databases not in use.

3. Select the RDBMS connection to analyze or select <all active connections> to analyze databases for all RDBMS connections with at least one active mainline branch.

If all mainline branches in an RDBMS connection are inactive or removed, the connection is skipped. You can analyze these connections individually before reactivating or restoring mainline branches.

4. Click Options to configure analysis and repair options. See Setting database analyze and repair options.

5. Click Analyze to analyze the selected database.

The analysis progress and results are displayed. You can copy and save the results for your database maintenance records or to help DBAs troubleshoot other issues. If issues are found, you should back up the database before repairing them. See the Surround SCM documentation for information about backing up databases.

To cancel an analysis or repair in progress, click Cancel Processing.

6. Click Repair to repair issues. This option is only available if repairable issues were found during an analysis.

The repair results are displayed. See Repairs for common database issues for information about how common issues are repaired.

If the force reindex repair option is enabled, click Repair to reindex database tables.

7. Close the analyze utility when you finish.