Troubleshooting Ingres

This chapter describes procedures and techniques for troubleshooting the Ingres installations. Using these procedures will help you to solve the problems yourself, or, to accurately define the problem if it is still necessary to call technical support.

Process of Troubleshooting

Troubleshooting is a process of defining and correcting a problem that occurs in an otherwise functioning Ingres installation and includes narrowing down the problem to a well-defined point, identifying the cause of failure, and eliminating it. When troubleshooting, you:

1. Determine the nature of the problem
2. Isolate the problem to a defined area
3. Eliminate the cause, using the following techniques:
   • Correcting user errors
   • Changing the Ingres installation environment
   • Changing the user environment
   • Changing the operating system environment
   • Changing the system configuration
   • Restarting the system if needed

Troubleshooting Tools

VDBA provides a set of system administration tools. It allows you to perform system administrator functions—including configuring, performance monitoring, backup and recovery, and remote database optimization—using a GUI interface. For instructions on performing these functions, see the VDBA online help.

Command line instructions are also available. For information on Ingres commands, see the Command Reference Guide.