Resolving database issues
If you notice a slowdown in Surround SCM performance or if database errors are written to the server log, you can analyze databases to identify and repair issues.
You can analyze databases while users are connected to the Surround SCM Server without affecting performance. When analysis is complete, you can repair any issues identified either using Surround SCM or manually. You may consider repairing databases during off-peak hours, such as in the evening or over the weekend, because users cannot perform actions that write to the affected database.
You do not need to analyze databases on a regular basis. You should be familiar with database maintenance before attempting to repair any issues.
Selecting an analysis and repair tool
You can analyze and repair databases using the Surround SCM desktop client, CLI, or analyze utility.
- Desktop client—Use to analyze and repair active database connections on the server you are connected to.
- CLI—Use the analyzedb command from a command line to analyze and repair active database connections on the server you are connected to.
- Analyze utility—Use to analyze RDBMS databases not in use by a server and clear database server associations. You can also analyze and repair databases for active connections as you can in the desktop client or CLI.