SQL Error Logging Facility (SELF)
Have you ever been faced with “strange” SQL Errors or SQL Errors that were not trapped but simply ignored? How to find those problems?
SQL Performance Monitors can help, at least if you know where to start, i.e. which job, which program caused the problems. But SQL Performance Monitors come with significant overheads, just by gathering everything.
SELF is an additional tool for finding understanding and fixing SQL Errors and Warnings. SELF can be started without modifying any programs and can safely run in production.
This session will show what are the components of SELF and how to use them.
Learning Objectives:
In this session you’ll get detailed information about SELF, i.e. which Global Variables can be set, which views and functions are available and where the information is logged.