Analyzing and repairing databases

If issues occur in the server database or databases for active RDBMS connections, you can analyze and repair the databases to fix the issues.

If you need to analyze and repair issues in databases not currently in use by a Surround SCM Server, use the analyze utility. See the Analyze Utility help for information.

You can analyze databases at any time without affecting Surround SCM performance. If the analysis indicates issues, you can repair them from Surround SCM. When repairing, Surround SCM is locked to prevent users from writing to the database, but users can still perform read-only actions. Some repairs may make branches temporarily unavailable while mainline branches are reloaded in the cache. You may consider repairing databases during off-peak hours, such as in the evening or over the weekend.

More advanced issues may require manual repair by your DBA.

1. Choose Tools > Administration > Analyze/Repair Database.

The Analyze Database dialog box opens.

2. 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.

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

4. 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 Backing up Surround SCM databases.

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

5. 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.

6. Click Close when you finish.