6. Troubleshooting Ingres : Determine the Problem Area : Check the Error Log Files
 
Share this page                  
Check the Error Log Files
Checking for error logs is the first step for determining the nature of the problem. To check for error logs, follow these steps:
1. Check the log files for error messages. Examine errlog.log first.
2. If indicated, check optional log files for error messages.
3. Identify the errors associated with your problem.
All errors are time stamped. Find the most recent error message associated with your problem. Read back up the log file from there to the first error relating to that problem. Many error messages cascade from that initial error. This initial error is usually the most important in identifying the problem even though it is not the error that users report.
For example, the following error message merely notifies you that a DBMS server has exited for one of many possible reasons:
E_SC0221_SERVER_ERROR_MAX
You must look in the errlog.log for associated DBMS server errors such as “E_DM9300_DM0P_CLOSE_PAGE Buffer still fixed,” a fatal error message. Search the error log for additional errors occurring around the time of the error that was displayed.