Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html
Thursday, May 23 • 8:00am - 9:00am
269: SQL Error Logging Facility (SELF)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →


Thursday May 23, 2024 8:00am - 9:00am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Programmers and Analysts who have to detect where and which (SQL) problems occur or simply want to have an overview about how often a specific SQLCODE occurs.