February 13, 2024 - Morning Sessions

Managing your IBM i made EASY with SQL 

Scott Forstie |  February 13, 2024  |  8:30 a.m. - 12:00 p.m. CT

SQL is for more than just doing database things. With the invention of IBM i Services, there are many options for accessing and managing your IBM i. This workshop will look to explore the many already existing examples shipped in Access Client Solutions. We will learn how to modify and enhance these to take your system management capabilities to the next level. Additionally, there are many examples that Scott has created to help IBM i clients accomplish modern system management.   

Come with your laptop loaded with the LATEST level for ACSThis will get you rolling on the road to managing your environment. 
Download ACS here 

1. Get comfortable using SQL to see IBM i operating system data 
2. Learn how to use SQL to capture systems management data 
3. Learn how to use SQL to create spreadsheets, send emails, send emails with spreadsheets, and much more 
4. Learn how to use SQL to automate systems management topics 

Look at Your Data from a Different View Point 

Simon Hutchinson |  February 13, 2024  |  8:30 a.m. - 12:00 p.m. CT

Application modernization is more than adding a GUI. These projects must include the modernization of the database too. Part of the database modernization is the use of SQL Views. Views allow for data from different sources, selected, reformatted, gathered and presented in a simple/easy to use formEven if you are not changing the front-end of the application nor the database the use of Views will boost your productivity working with your existing application. Views should also be used to simplify the data you get from Db2 for i. Coming to an understanding of Views can be a real “light bulb” moment that changes the way you work. 


1. Creating Views over existing Db2 for i Views and Table functions 
2. Moving from normalized to de-normalized data 
3. Joining files/tables together in View 
4. Performing calculations within View 
5. Views to gather data from multiple LPAR 
6. Views to create a formatted file/table from a spool file 

February 13, 2024 - Afternoon Sessions

Guided Tour of IBM Navigator for i 

Lora Powell |  February 13, 2024  |  1:00 p.m. - 4:30 p.m. CT

IBM Navigator for i is a fabulous web tool for IBM i multi-systems management. Come along with us on a guided tour and learn what you can do without the green-screen! We will demo the more than 10 components and many functions that can be performed with new Navigator today. We will focus on the latest enhancements and dive into detail on areas such as Security – Audit Journal configuration and insights with visualization. There will be a sneak preview of the soon-to-be-available audit journal detail entry Data Mart. You will have the ears of two of the key team members. We will give you opportunity to ask questions and give feedback. 

1. Learn the features available for multi-system management. 
2. Get up to date on the enriched functionality in many components. 
3. Master the configuration for Audit Journal and insightful visualization. 

Best Practices of Security with a DCM Deep Dive 

Robert Andrews & Thom Haze |  February 13, 2024  |  1:00 p.m. - 4:30 p.m. CT

Understand all the different areas of security one needs to consider — not just on IBM i — and prevent common mistakes and data loss or intrusionThis session will cover security best practices in objects, users, and system settingsMany of the built in IBM i Security features will be covered at a high levelBut something everyone should be using is TLS encryptionThat is why after we cover the basics system-wide, we are going to take a deep dive into TLS certificates and the tool used to manage them – Digital Certificate Manager, or DCMDon’t miss it! 

February 14, 2024 - Morning Sessions

System Administration Boot Camp 

Pete Massiello & Steve Pitcher |  February 14, 2024  |  8:30 a.m. - 12:00 p.m. CT

In this boot camp for IBM i System Administrators, Steve and Pete will cover the following topics: 
System Administration: What you need to know 
System Cleanup 
IPLs & PTFs: What you need to know 
Smarter Hardware and Operating System Upgrades 
File Sharing 
To HMC or Not HMC 
To Cloud or On-Prem 
Internal vs External Storage 
Tape vs. VTL vs. RDX 
Backup and Restores 
Encryption for Disk and Tape 
Getting to know the new Navigator for I 
High Availability 
Question and Answer 

This session will cover what you need to know and understand to manage and administer your systemFrom Back ups, PTFs, Encryption options, Internal/External storage, Consoles, Hardware options. 

DevOps A-Z 

Andrew Clark |  February 14, 2024  |  8:30 a.m. - 12:00 p.m. CT

Learn how to use DevOps to make your Development, Testing and Deployment steps truly agile - all while reducing risk and realizing immediate and significant ROI; then actually walk through all of the steps necessary to implement a DevOps pipeline for your application. 


1. Learn about DevOps 
2. Learn about the significant ROI benefits of DevOps 
3. Understand the DevOps steps needed 

Introduction to PHP for IBM i 

Mike Pavlak |  February 14, 2024  |  8:30 a.m. - 12:00 p.m. CT

While other technologies are gaining ground, PHP is still far and away in the leadership position of web centric languagesThe workshop will focus on the fundamentals of PHP and exhibit a simple use case for an applicationThen we’ll decompose the application with a LOT of nifty tools and featuresWe will begin in the procedural realm of PHP which is very similar in nature to RPG Free and then move into a high level discussion of the Object Oriented world of this most prestigious languageLike many web languages, the power is in the modules that can be added as needed so we’ll focus aggressively on how to leverage OPC (Other Peoples Code) to make your development experience that much more productive.   We’ll also focus on the PHP release cycle and how your shop can manage this without it becoming a nightmare.   


1) Understand how to install and manage PHP & open source tools on IBM i      
2) Explore the syntax of PHP as well as the development/execution model of scripts on IBM i 
3) See how to enhance PHP via modular componentry, Db2 and extensions.    

February 14, 2024 - Afternoon Sessions

Keeping up to date: The ins and outs of PTFs and Upgrades 

Jeff Carey | February 14, 2024  |  1:00 p.m. - 4:30 p.m. CT

You've been picked to keep your IBM i system up to date as far as operating system software goesWhat do you doWhat's the best way to handle, PTFs, OS upgrades and managing it all? 


1. How to approach system OS maintenance 
2. Compare various methods of applying PTFs 
3. Making your next upgrade smooth 
4. What if something doesn't work? 

Working with Unicode data in RPG using the new CHARCOUNT NATURAL support 

Barbara Morris | February 14, 2024  |  1:00 p.m. - 4:30 p.m. CT

This session will discuss the Unicode character set in general, and then focus on how Unicode data is processed in RPG, with special attention to the new CHARCOUNT NATURAL support. 


1. Understand some of the issues associated with Unicode data 
2. Understand how to use RPG's CHARCOUNT NATURAL support, which is especially important when working with UTF-8 data