Viewing and Filtering the Adaptive Server Error Log

Apply filters and view the Adaptive Server error log.

1. In the Perspective Resources view, select a resource, then select Administration Console.
2. Click ASE Servers.
   You see a list of monitored servers.
3. Click the Name field of the server you want to manage.
   You see a list of options allowing you to start and stop the server, register the agent, and so on.
4. Click View Log.
   You see the error log of the Adaptive Server.
5. (Optional) In the Show messages matching field, enter a word or phrase to isolate all the lines of the log that contain it. For example, enter "memory" to find all log output pertaining to memory usage.
6. (Optional) Select the Settings option.
   You see the Server Log window.

   Note: User-defined regular expressions are valid only in the session in which they are defined. When the Sybase Control Server is restarted, you must redefine the regular expressions.
7. Specify how to retrieve log entries from the error log. You can retrieve all log entries, a specified number of log entries last accessed, all log entries from a specified time period, or all log entries matching a regular expression.
   The predefined regular expressions provided by the dialog are generally sufficient for filtering. They contain the most commonly accessed keywords in the error log such as Error, deadlock, warning, and so on.
   However, to define your own custom regular expression, click add, and specify a descriptive name and the regular expression clause. For example, to view lines of the log that refer to configuration, specify "All lines with configuration" for Name and "configuration" for Regular Expression.
8. Click OK.