Leveraging SQL for IBM i Administration - Ash Giddings and Chuck Losinski

Db2 on IBM i is a fantastic platform for SQL. In fact, almost all the latest Db2 enhancements have been to further improve SQL performance and capabilities. That’s great news for developer and system administrator productivity…

But not all SQL requests—internal or external—are created equal. Some can even bring your system to its knees. It’s time to tame the SQL beast!

Join this live webinar where HelpSystems experts show you how to analyze and monitor SQL activity and leverage SQL for IBM i administration. You’ll learn how to:

• Use IBM i SQL-based services to gather data quickly
• Explore the SQL Plan Cache snapshot
• Tailor monitoring for QZDASOINIT and QZDASSINIT jobs
• Bring real-time visibility to the SQL statement and IP address of offending jobs
• Add user-defined SQL statements to Robot Monitor custom application analysis

You’ll also see a live demonstration of Robot Monitor software highlighting its real-time monitoring and notification capabilities. Our experts will be sure to leave extra time for Q&A.

Chuck Losinski

Director of Technical Solutions, HelpSystems

Chuck Losinski, Director of Technical Solutions for the Robot product line, has been with HelpSystems for nearly 20 years. He has over 30 years of experience in IT, including 25+ years on the IBM i platform.

Chuck's background covers a wide variety of technical responsibilities, involving system implementation, programming, operations, and support. He is certified as an IBM System Administrator and as a HelpSystems Robot Certified Specialist.

Chuck has helped numerous customers automate business applications from Infor, Oracle JD Edwards, HBOC, RxClaim, Infinium, Fiserv, Jack Henry, and more. Currently he is the co-president of the local IBM i user group, QUSER.

Ash Giddings

HelpSystems

Ash Giddings began his career on IBM Mainframe before moving onto midrange systems such as IBM i and AIX and then Windows and Linux. He has worked for some of the largest data centers in Europe and has advised large companies around the world on way to save costs and improve efficiencies.