Event Date
September 11, 2024
Time
5:00 PM - 9:00 PM
About Event
Join us for an in-depth learning experience with Steve Riedmueller, a seasoned expert in IBM i system administration. This event features two sessions designed to equip system administrators with practical SQL skills to solve real-world problems and enhance system management.
The introductory session, "Intro to IBM i Services (SQL) for Admins," is perfect for traditional "green screen" administrators who want to start leveraging SQL. It covers how to use the “Run SQL Scripts” tool to investigate active, queued, and completed jobs, retrieve system networking information, investigate object locks, and more. Don’t be intimidated by SQL; it’s a powerful tool that you can easily start using with the examples provided.
The advanced session, "Advanced IBM i Services (SQL) for Admins," builds on the introductory session and dives deeper into the capabilities of IBM i Services. You’ll learn how to join data from multiple IBM i Services to create "SuperTools," use the QCMDEXC() scalar function, and create your own User Defined Functions (UDFs). This session is ideal for administrators with some SQL experience who want to take their skills to the next level.
Schedule
Intro to IBM i Services (SQL)
Learn to solve real-world system admin problems using SQL and IBM i Services.
5:00 PM
Networking & Cocktail Hour
Connect and enjoy our open bar.
6:00 PM
Dinner & Q&A
Interactive session over dinner.
7:00 PM
Advanced IBM i Services (SQL)
Dive deeper into IBM i Services with advanced techniques for monitoring, automation, and custom tools creation.
8:00 PM
Session Ends
Wrapping up with gratitude
9:00 PM
What Will You Learn?
Intro to IBM i Services (SQL)
Learn how to use SQL to solve real-world system admin problems, investigate jobs, retrieve networking information, and more with practical examples.
Advanced IBM i Services (SQL)
Explore advanced use cases for IBM i Services, including joining data to create "SuperTools," using the QCMDEXC() function, and creating User Defined Functions (UDFs).
Enhanced SQL Skills
Develop your SQL skills to monitor systems, automate tasks, and efficiently manage IBM i environments, moving beyond basic queries to more complex solutions.
Keynote Speaker
Steve Riedmueller
IBM i (AS400) Tech Lead at Wiley
Steve has been working on the IBM i platform in a System Administration/Engineering role since 2001. He has developed an expertise in system security, performance, communications, and various IBM and 3rd-party software packages including WAS, MQ, Apache, OnDemand, LANSA, Zend, Synon, and more. Steve holds a B.S. from Rutgers University. In recent years Steve has become a COMMON and WMCPA speaker, an N2i mentor, and taken a leadership role in the N2i committee. In the world of IBM i technology, Steve is passionate about process improvement. He enjoys leveraging IBM i SQL Services for administration/operations tasks such as security and performance, as well as automation. In his free time Steve enjoys StarCraft 2, weight lifting, and RVing.