Administrator Guide : Troubleshooting and support : Troubleshooting a problem
  
Troubleshooting a problem
Troubleshooting is a systematic approach to solving a problem. The goal of troubleshooting is to determine why something does not work as expected and how to resolve the problem.
The first step in the troubleshooting process is to describe the problem completely. Problem descriptions help you and solidDB® Support know where to start to find the cause of the problem. This step includes asking yourself basic questions:
What are the symptoms of the problem?
Where does the problem occur?
When does the problem occur?
Under which conditions does the problem occur?
Can the problem be reproduced?
The answers to these questions typically lead to a good description of the problem, which can then lead you a problem resolution.
What are the symptoms of the problem?
When starting to describe a problem, the most obvious question is “What is the problem?”. This question might seem straightforward; however, you can break it down into several more-focused questions that create a more descriptive picture of the problem. These questions can include:
Who or what is reporting the problem?
What are the error codes and messages?
How does the system fail? For example, is it a loop, hang, crash, performance degradation, or incorrect result?
Where does the problem occur?
Determining where the problem originates is not always easy, but it is one of the most important steps in resolving a problem. Many layers of technology can exist between the reporting and failing components. Networks, disks, and drivers are only a few of the components to consider when you are investigating problems.
The following questions help you to focus on where the problem occurs to isolate the problem layer:
Is the problem specific to one platform or operating system, or is it common across multiple platforms or operating systems?
Is the current environment and configuration supported?
Is the application running locally on the database server or on a remote server?
If one layer reports the problem, the problem does not necessarily originate in that layer. Part of identifying where a problem originates is understanding the environment in which it exists. Take some time to completely describe the problem environment, including the operating system and version, all corresponding software and versions, and hardware information. Confirm that you are running within an environment that is a supported configuration; many problems can be traced back to incompatible levels of software that are not intended to run together or have not been fully tested together.
When does the problem occur?
Develop a detailed timeline of events leading up to a failure, especially for those cases that are one-time occurrences. You can most easily develop a timeline by working backward: Start at the time an error was reported (as precisely as possible, even down to the millisecond), and work backward through the available logs and information. Typically, you need to look only as far as the first suspicious event that you find in a diagnostic log.
To develop a detailed timeline of events, answer these questions:
Does the problem occur only at a certain time of day or night?
How often does the problem occur?
What sequence of events leads up to the time that the problem is reported?
Does the problem occur after an environment change, such as upgrading or installing software or hardware?
Responding to these types of questions can give you a frame of reference in which to investigate the problem.
Under which conditions does the problem occur?
Knowing which systems and applications are running at the time that a problem occurs is an important part of troubleshooting. These questions about your environment can help you to identify the root cause of the problem:
Does the problem always occur when the same task is being performed?
Does a certain sequence of events need to occur for the problem to surface?
Do any other applications fail at the same time?
Answering these types of questions can help you explain the environment in which the problem occurs and correlate any dependencies. Remember that just because multiple problems might have occurred around the same time, the problems are not necessarily related.
Can the problem be reproduced?
From a troubleshooting standpoint, the ideal problem is one that can be reproduced. Typically, when a problem can be reproduced you have a larger set of tools or procedures at your disposal to help you investigate. Consequently, problems that you can reproduce are often easier to debug and solve. However, problems that you can reproduce can have a disadvantage: If the problem is of significant business impact, you do not want it to recur. If possible, re-create the problem in a test or development environment, which typically offers you more flexibility and control during your investigation
Can the problem be re-created on a test system?
Are multiple users or applications encountering the same type of problem?
Can the problem be re-created by running a single command, a set of commands, or a particular application?
See also
Tools for troubleshooting
Tracing SQL statements
SQL Info facility
Analyzing SQL Trace facility output
Comparison of the Monitor facility and the SQL Trace facility
Using stack trace facility
Tracing communication between client and server
Troubleshooting SMA
Troubleshooting database file size (file write fails)
Troubleshooting MME.ImdbMemoryLimit
Troubleshooting solidDB® Data Dictionary (soldd)
Troubleshooting and support