COMMON POWERUp 2024

Attending this event?

COMMON POWERUp 2024

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

Exhibitor Hall Map Here

10:15am CDT

292: IBM i Shops: Prepare for DevOps

DevOps is a long twisting road that has no destination. But even more harrowing can be the tasks needed to prepare before embarking on this life-changing adventure. In the session we will explore several aspects that should be explored before embarking down the DevOps Road, all based upon open source implementations which means there is no price of admission! We will cover concepts like preparing the code, developers, management and users. In additional we will review a basic open source road map for leveraging DevOps features in an IBM i environment.

Learning Objectives:
1) Learn the basics of DevOps.
2) Explore how best to prepare the environment for a DevOps journey.
3) Review open source tooling and references for educating the team on DevOps.

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

DevOps StartingV1.2 pdf

Monday May 20, 2024 10:15am - 11:15am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience All folks interested in exploring DevOps from the beginning.

10:15am CDT

121: What's New and Exciting in RPG

With each new release of the IBM i operating system and with Technology Refreshes, IBM has given us some new features in RPG. This session tells you about the new and exciting features of RPG and how you might like to use each feature in your own applications.

Learning Objectives:
1. IBM's strategy for releasing new RPG features
2. The new features available recently
3. What I find exciting about them

Speakers

Scott Klement

Development & Solutions Architect, Midrange Dynamics

Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Monday May 20, 2024 10:15am - 11:15am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Programming - RPG

Session Level Beginner
Audience RPG Developers

10:15am CDT

171: Foundations of IBM i Systems Admin: Reading Joblogs

Very few shops today have a dedicated system administrator; so the administrator hat ends up with the developer or other staff. So where do you start? We'll cover the basics of what you need to know to administer IBM i. In our favor, IBM has been busy over the past several releases improving the tools and options for administering our system!

Learning Objectives:
1) Understand the use of a joblog for finding errors and issues with jobs.
2) Learn the tools available for reading and searching joblogs.

Speakers

Larry Bolhuis

Cloud and Datacenter Engineer, IBM Champion, Service Express Inc.

Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988.After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of... Read More →

Foundations of IBM i Systems Admin Reading Joblogs pdf

Monday May 20, 2024 10:15am - 11:15am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner

10:15am CDT

181: Intro to IBM i Services (SQL) for Admins

This session is designed for IBM i system administrators. It covers real-world problems faced by system admins, and how to solve them using SQL (with some help from IBM i Services). Don't be intimidated by SQL. It isn't just for developers! You can copy and paste the examples provided in this session to get started easily. Attend this session and add a suite of new tools to your system admin toolbox!

"Learn how to use the “Run SQL Scripts” tool to:
1. Investigate active/queued/completed jobs
2. Retrieve system networking information,
3. Investigate object locks, and much more!"

Speakers

Steve Riedmueller

Certified IBM i Admin - Speaker, Mentor, and Advocate, John Wiley & Sons, Inc.

I am a COMMON Certified IBM i Administrator with over 20 years experience on IBM i, as well as a COMMON speaker, N2i mentor, and IBM i advocate.I've been working on the platform since 2001 as a system admin/engineer. I have experience with OS upgrades and patching, system security... Read More →

PU24 IBM i Services for Admins Intro pdf

PU24 IBM i Services Intro Scripts sql

Monday May 20, 2024 10:15am - 11:15am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience Traditional “green screen” administrators who want to start leveraging SQL.

10:15am CDT

123: IBM i Security from the Ground Up

Come to this session to learn the basics of IBM i Security. During this session Carol will cover the three building blocks of IBM i Security - Security-relevant System Values, User Profile Configuration and Object Security. Carol will also describe how (the order) the system checks security as well as program adoption. This session builds the foundation for other topics discussed during the rest of the conference. Emphasis will be placed on using modern interfaces (Navigator for i, IBM i Services, etc)

Learning Objectives:

Understand the functions provided by security-relevant system values
Know which attributes of the user profile contribute to the capabilities of the user and understand the best practices settings for these attributes
Understand the options available for setting authority on objects (files, programs, etc)
Know the order in which IBM i checks authority when a user accesses an object
See how you can create and manage user profiles, system values and permissions in New Navigator

Speakers

Carol Woodbury

IBM i Security SME and Senior Advisor, Kisco Systems

With over 30 years' experience in the area of IT security, Carol is known world-wide as an expert in the area of computer security. During her career, Carol has architected security solutions for Fortune 100 companies as well as small and medium-sized organizations. Carol is passionate... Read More →

IBM i Security From the Ground Up PowerUP 2024 pdf

Monday May 20, 2024 10:15am - 12:30pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience Any user that has little or no knowledge of IBM i Security or someone that needs a refresher of the details of IBM i security will benefit from this session.

11:30am CDT

137: BRMS - How It Can Save YOU!

Backing up your system can be critical for disaster recovery, data recovery, and audit. Managing it manually can be daunting and apt to failure. Learn how BRMS can save the day and automate many essential tasks (some that you may not be doing).

Learning Objectives:
What is BRMS
How can it help essential tasks:
Disaster Recovery
You deleted what?
Audit
First steps to make the move

Speakers

Jeffrey Carey

Sr. System Administrator, Ensono

Jeff Carey is an IBM i professional with over 25 years of experience on the platform, specializing in system administration. He currently is a Senior System Administrator for Ensono, a company providing managed services for Mainframe, IBM i, Cloud, and hybrid IT, headquartered in... Read More →

Monday May 20, 2024 11:30am - 12:30pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102

High Availability Resilience

Session Level Beginner
Digital Badge HA/DR
Audience IT professionals who need to backup or restore data from IBM i systems.

11:30am CDT

196: Live Demo of the New IBM Navigator for i

The IBM Navigator has been around for a very long time, the good news, a brand new version has just been delivered that re-images Navigator from the ground up. Really, the only thing that the same is the Title. The User interaction, tables, data , architecture, is all completely new and is leveraging the very latest in modern technology. As the title says... we will explore many of the new aspects of the IBM Navigator via a live demo.

Learning Objectives:

Speakers

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM

Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →

Live Demo of the New IBM Navigator for i pdf

Monday May 20, 2024 11:30am - 12:30pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner

11:30am CDT

220: Introduction to Open Source on IBM i

Introductory and survey level discussion that looks at the installation of the Open Source solutions on IBM i. We'll also review many of the components available via open source and discuss the PASE environment. If you've been on the outside looking in at Open Source, this is the place to start.

Learning Objectives:
1. Understand how to install open source solution on IBM i
2. PASE basic understanding
3. Explore the solution in the open source packages.

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

GettingStartedOpenSourceV1.3 pdf

Monday May 20, 2024 11:30am - 12:30pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience All levels welcome

2:45pm CDT

419: Practical Examples of Using AI and IBM i

Abstract forthcoming

Speakers

Jesse Gorzinski

Business Architect, IBM

Jesse Gorzinski works for the IBM i development lab in Rochester, MN. He is a Senior Business Architect and Senior Technical Staff Member (STSM) responsible for open source technologies on the platform. Jesse, who was doing RPG programming at the age of 18, is an expert on application... Read More →

AI with IBM i pdf

Monday May 20, 2024 2:45pm - 3:45pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner

2:45pm CDT

293: What’s New with Open Source & IBM i

Open source solutions have been on the IBM i platform for many years but recently the number of solutions deployed here has blossomed. Join Mike as he explores the latest news regarding packages and solution features available in IBM i Open Source Package Management and beyond.

Learning Objectives:
1) Review updates to the popular languages like PHP, Python and Node.js.
2) Explore new(er) packages available via the ACS: Open Source Package Management.
3) See examples of how the community is contributing to IBM i open source.

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

OpenSource WhatsNewV1.3 pdf

Monday May 20, 2024 2:45pm - 3:45pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102

Programmer Tools

Session Level Beginner
Audience All folks interested in exploring or using open source on IBM i

2:45pm CDT

323: Introduction to the Navigator Performance Tasks

Navigator for i has a rich set of tools to help you understand the performance of your IBM i. This session will review these performance tasks; from traditional performance management tasks, to System Monitors for real-time monitoring, the Performance Data Investigator to understand your performance signature, and Graph History for long-term trending. Attend this session to learn about these features and how to use them.

Learn about why and how to use the following in Navigator:
- System Monitors
- Performance Data Investigator
- Graph History

Speakers

Dawn May

Owner, Dawn May Consulting, LLC

Dawn has been involved with COMMON for over 20 years and has been a consistent volunteer since 2008. She's been a member of the strategic education team, a subject matter expert, and a speaker. Now, as President of COMMON, she's focused on leading COMMON as the industry leader of... Read More →

Introduction to the Navigator Performance Tasks POWERUp2024 pdf

Monday May 20, 2024 2:45pm - 3:45pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner

4:00pm CDT

173: Getting Started with SQL Functions and Procedures

SQL includes a full-fledged programming language, SQL PL. Come learn about the programming constructs, including error handling, that this language contains. You will leave with all the knowledge you need to start writing your own SQL functions and procedures.

Learning Objectives:
1. Understand the difference between SQL procedures, scalar functions, and table functions.
2. Become familiar with the SQL statements used for writing SQL routine logic.

Speakers

Ryan Moeller

Software Engineer, IBM

Ryan Moeller is a software engineer working on Db2 for i, specifically on the SQL Query Engine (SQE) team. He joined the team in the Rochester, MN development lab in 2020. Ryan specializes in SQL, database development, and query performance analysis.

Getting Started with SQL Functions and Procedures pdf

Monday May 20, 2024 4:00pm - 5:00pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience Developers who want to start writing SQL-based solutions.

4:00pm CDT

355: Experience the Wonders of AI: Come Marvel with Me!

This session explores the fascinating world of AI, demonstrates its possibilities and how it can be used to improve our lives. We will discuss some of the latest available technologies and work with them in real time. This session is perfect for anyone looking to learn more about AI and the potential it has to offer.

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →

Monday May 20, 2024 4:00pm - 5:00pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner

5:15pm CDT

343: Make Your Web Apps Zoom with Nginx!

Nginx is one of the most underused open source packages on IBM i. It can add a layer of security and performance to web apps and APIs. Come see some tips and tricks to making your applications more durable and performant!

Learning Objectives:
Use Nginx to zoom zoom

Speakers

Jesse Gorzinski

Business Architect, IBM

Jesse Gorzinski works for the IBM i development lab in Rochester, MN. He is a Senior Business Architect and Senior Technical Staff Member (STSM) responsible for open source technologies on the platform. Jesse, who was doing RPG programming at the age of 18, is an expert on application... Read More →

Monday May 20, 2024 5:15pm - 5:35pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102

Programming - Frameworks

Session Level Beginner

5:15pm CDT

257: Lets Learn The Acronyms

SQLRPGLE? DR? RPGLE? BRMS? What in the world does all of these mean? This session is to help newcomers understand a good chunk of the IBM I acronyms and give them a jump start in their career.

Learning Objectives:
1) Give newcomers a leg up in discussions with others on the platform that use these acronyms so they can understand what they mean.
2) Make sure newcomers understand the acronyms of the platform they are coming onto.

Speakers

Marina Schwenk

Innovative Software Solutions

Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →

Shelly Petty

Application Support, Everbrite LLC

I am a Junior Full Stack Developer at Everbrite LLC. We run our production applications on the IBMi Power Server. Primary languages are CL, RPG, DB2 SQL and Java, and the UI: HTML, CSS, JavaScript, Drupple, React, and Sencha.My position is a fast paced job and it includes Help Desk... Read More →

Monday May 20, 2024 5:15pm - 5:35pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner
Audience Anyone that is new to the platform or who just wants a better understanding of what all of the acryonyms mean.

5:50pm CDT

345: Use WildFly to Serve Your Java Web Apps

WildFly is an open source Java application server that is gaining some popularity. Come see what it looks like to build and deploy web applications quickly and easily using this powerful middleware developed/maintained by Red Hat.

Learning Objectives:
Deploy a new application in WildFly. Undewrstand a developer workflow for debugging/updating applications.

Speakers

Adam Shedivy

Software Developer, IBM

Adam is a software Developer working on enhancing client and open source integration on IBM i.

Monday May 20, 2024 5:50pm - 6:10pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102

Programming - Frameworks

Session Level Beginner
Audience Application Developers

5:50pm CDT

388: Understanding the Various Ways to Save Your IBM i

Understand the different ways to save your system, using BRMS, Flash Copy, or traditional native commands. Tips will be given along the way on best practices, using the console, and ensuring you have what it takes to recover.

Learning Objectives:
1) What each Save command does
2) How to run a full system save
3) What can Flash Copy do for you?

Speakers

Pete Massiello

IBM i Advisor, Massiello Holding Corp.

Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →

Basics of A Full System Save Pete 2024 pdf

Monday May 20, 2024 5:50pm - 6:10pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience Anyone responsible for backing up their system.

8:00am CDT

180: Revving up SQL Performance with Indexes

One of the most important things needed to improve SQL performance is to have the proper indexing over tables, especially as table grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them.

Learning Objectives:
1. Learn about the importance of indexes on SQL performance
2. Learn how to use ACS tools to process Db2 Index Advice
3. Learn a methodology for identifying and ordering the key definition for new indexes.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

Revving Up SQL Performance With Indexes pdf

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience Database engineers and performance analysts as well as SQL programmers trying to improve performance

8:00am CDT

108: Choosing the right HA/DR solution

The High Availability and Disaster Recovery landscape is continually evolving with new technologies both on-premis and in the cloud dedicated to ensuring your business stays running. Navigating through these technologies requires and understanding of business needs, and outage protection goals.

Throughout this session we will discuss the types of outages, and the technologies available to protect against those types of outages in order to help you make decisions to map out your HA and DR journey. This session will give a brief overview of a number of technologies including: Db2 Mirror, Live Partition Mobility, Logical/Software based Replication, Full System Replication, and PowerHA technologies.

Learning Objectives:
1. Learn the importance of considering your recovery point objective and recovery time objective for different types of outages
2. Learn how different technologies can help achieve various RPO and RTO targets.
3. Learn how the technologies can be combined to form solutions with several examples of common solutions

Speakers

Brian Nordland

Director of Development, Fortra

In addition to his role as Director of Development for Power Development at Fortra, Brian Nordland serves as the technical product manager for PowerHA and Robot HA. Brian has spoken at events, webinars, and user groups—including COMMON—since 2014. He is a co-inventor on multiple... Read More →

Choosing the right HADR solution pdf

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102

High Availability Resilience

Session Level Beginner
Award BRONZE
Digital Badge HA/DR
Audience Those looking to implement or enhance their HA or DR plans for IBM i that want an overview of various hardware replication technologies

8:00am CDT

275: Kick the Old IDE Habit With Code for i

SEU and PDM are no longer viable. Does RDi feel slow and clumsy? Or perhaps your manager won't pay for RDi, or won't let the team use it? VSCode with the Code for i plugin is an amazing solution, and Scott even prefers it over RDi. Why not learn how to get started?

Learning Objectives:
1. Learn how to set up VSCode with Code for i
2. Learn how to use it to connect to IBM i systems
3. Use it to edit, compile and read programs, including RPG.

Speakers

Scott Klement

Development & Solutions Architect, Midrange Dynamics

Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102

Programmer Tools

Session Level Beginner

8:00am CDT

150: IBM i Security: What’s New for IBM i 7.4 and 7.5

Security improvements continue to be high priority to help mitigate vulnerabilities. Come see the various security related features included with IBM i that you can use to help improve the health of your environment.

Learning Objectives:
Discuss new enhancements in IBM i 7.4 and 7.5 related to improved security by default, system values, password levels, TLS 1.3, Authority Collection, Digital Certificate Manager, SST Profiles, and more.

Speakers

Robert Andrews

Principal Security Consultant, IBM

Robert Andrews is a Principal Security Consultant, Senior Technical Staff Member (STSM), and the Team Lead for the IBM i Security and Authentication Technology Expert Labs team in Rochester, MN. He is an IBM certified Thought Leader and The Open Group certified Distinguished Technical... Read More →

WhatsNewIBMiSecurity7475 pdf

Tuesday May 21, 2024 8:00am - 9:00am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Award GOLD
Audience System and security administrators

9:15am CDT

190: How Journaling Works with DB2

From its humble beginning journaling local database changes to physical files on the System/38, IBM i journaling technology has evolved to include SQL tables, the integrated file system (IFS), and even remote journaling. In fact, many IT teams have been using IBM i journaling technology for audits, replication, problem determination, removal of bad updates, and high availability for years!

This session will take you through the process of how journal works against data base files and IFS. You will learn about the various commands for creating and working with journals and journal entries.

You’ll learn:
• How to start journaling of PF/SQL/IFS
• Why before and after images are important
• How to use remove journal changes
• What remote journaling is

Learning Objectives:
You’ll learn:
• How to start journaling of PF/SQL/IFS
• Why before and after images are important
• How to use remove journal changes
• What remote journaling is

Speakers

Tom Huntington

EVP of Technical Solutions, Fortra

Tom Huntington is Executive Vice President of Technical Solutions at Fortra, and has been with the company for over 35 years. He helps manage the worldwide Fortra software engineer team that works to integrate and promote our automation and security solutions to partners and customers... Read More →

Common PowerUp2024 Journaling DB2 Handouts pdf

Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102

High Availability Resilience

Session Level Beginner
Digital Badge HA/DR
Audience DB administrators and developers

9:15am CDT

377: The IBM i Box of Chocolates - with Q&A

You know what Forrest Gump's mother said about a box of chocolates. Well, in this presentation by Steve Will, IBM i CTO and Chief Architect, you never know what you're going to get - but we're pretty sure you're going to like every piece!
Steve will spend a few minutes talking about a few morsels from the IBM i box of chocolates – including the state of the IBM i operating system, its plans, its technology and its community – and of course, AI!
And then he'll open the floor for questions.

Learning Objectives:
1. Current hot topics

Speakers

Steve Will

IBM i CTO & Chief Architect, IBM

Steve is the CTO and Chief Architect for the IBM i Operating System. Spending the past fourteen years of his IBM career in this position, he has become an award-winning speaker, author of the influential blog "You and i," (https://bit.ly/You-and-i-blog) and is one of the most sought-after voices at customer briefings and events. Steve has worked on IBM i and its predecessors since before the creation of the AS/400, and is currently responsible for setting the strategy of the IBM i operating system, as well as deciding which enhancements will be implemented. In his role, he talks to clients and pa... Read More →

IBM i Box of Chocolates 2024 POWERUp Preview pdf

Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner

10:30am CDT

152: Programming Standards and Guidelines

We have all unfortunately seen really bad code or really bad practices. Have you ever wanted to take that code and throw it against the wall and start over? This session will give you the steps and guidelines that will help you start the discussion so you and your colleagues can implement standards and guidelines and start the process of cleaning up your code or the code you have inherited.

Learning Objectives:
1. We will look over various different recommended programming standards and guidelines.
2. we will look at bad code vs new code and make recommendations that you can take back and implement in your shop.
3. We will learn why its important to have standards and guidelines and how you can start the standards discussions at your shop.

Speakers

Marina Schwenk

Innovative Software Solutions

Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →

Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner
Audience Developers

10:30am CDT

387: Basics of System Admin for Programmers

Are you a programmer who is now responsible for the administration of your IBM i system? Do you know what you need to successfully manage the system? What commands do I need to know? In this session, we will cover the basics of System Administration that you need to know to manage your IBM i. Learn what you need to know to do the daily care and feeding of your system.

Learning Objectives:
1) Understand how to check your system messages to know that everything is ok.
2) Make sure that you are saving the right stuff.
3) Basics of security
4) What are PTFs, and how to manage PTFs

Speakers

Pete Massiello

IBM i Advisor, Massiello Holding Corp.

Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →

Basics of System Admin for Programmers pdf

Tuesday May 21, 2024 10:30am - 11:30am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner
Audience Programmers who are now responsible for the administration of their systems.

2:45pm CDT

300: Audit Journaling with Navigator for i

Understand how Navigator for i can make ease the use of audit journaling on the IBM i. Learn how Navigator simplifies configuring auditing to just a few button clicks. See how Navigator can make consuming and analyzing audit entries easier. Learn about what is planned to improve the performance of analyzing audit entries.

Learning Objectives:
1. Understand how to configure an IBM i for auditing
2. Understand how to analyze the generated audit entries
3. Learn how to maximize the performance of analyzing audit entries

Speakers

Ann Wilkerson

Software Developer, IBM

Ann Wilkerson is the technical team lead for Navigator for i and a developer for IBM i Services.

Audit Journaling with Navigator for i pdf

Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience System administrators responsible for configuring auditing and for reporting on audit entry data

4:00pm CDT

357: Beyond the Buzz: Practical AI Implementations in IT

AI can be used in many different ways, from creating robots to helping with medical diagnoses. From automating mundane tasks to improving decision making and predictive analytics.

AI can also be used to automate mundane tasks, such as data entry or customer service.

See how AI can help businesses save time and money, as well as improve customer service.

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner

4:00pm CDT

301: Navigator for i - A Developer's Guide

Do you think that Navigator for i is just for system administrators? Think again! Navigator for i is a powerful tool for all IBM i users, including developers. In this session, you will get an overview of how Navigator for i works and learn about specific functions that developers can use to make their lives easier.

Learning Objectives:
1. Understand how to configure Navigator for i
2. Understand what functions Navigator for i provides to developers
3. Understand how Navigator for i interfaces with other IBM products

Speakers

Ann Wilkerson

Software Developer, IBM

Ann Wilkerson is the technical team lead for Navigator for i and a developer for IBM i Services.

Navigator for i A Developer's Perspective pdf

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience IBM i developers with any level of comfort with Navigator for i

5:15pm CDT

251: Performance Tuning, QAQQINI what you care about and how to use it

This session hits the highlights of the file that defines your SQL environment. Did you know that you can have more than one? This session will hit the most important entries of this file. What values you want to use, and how to use it.

Learning Objectives:
1. Learn the most important entries in the file that defines your SQL environment
2. Learn how to use more than the one provided by IBM for your different workloads

Speakers

Tom Davidson

Sr Consultant, Cleindori Consulting

I'm a 40 year veteran of the IBM i (System/38,AS/400, iSeries, IBM i). My background is in Manufacturing and Performance. I specialize is tuning older systems to extend their life.I am also a JDE CNC (18 years), and my second specialty is JDE/IBM i/Weblogic.

QAQQINI What it is and how to use it pdf

Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience Programmers and DBAs that are trying to improve performance of their applications.

5:15pm CDT

261: Fostering Positive Relationships

Positive healthy relationships are vital to success in everything you do: whether it is excelling in your career, creating a vibrant and energetic work environment, or having a happy and rewarding personal life. Learning how to interact with others in a way that is respectful and constructive is essential.

Learning Objectives:
Come to this session to learn:
1) How to connect with others in a positive and proactive way
2) The impact of creating respectful and nurturing relationships
3) How to create long-term relationships that will accelerate your career
4) Tools and techniques to foster positive relationships

Speakers

Kim Greene

President, Kim Greene Consulting, Inc.

Kim Greene is president of Kim Greene Consulting, Inc. specializing in providing consulting services for the HCL Collaboration Solutions portfolio for IBM i, Windows, and Linux. Kim has over 20 years of experience with IBM Domino and 25 years of experience with the AS/400, iSeries... Read More →

Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Personal Development

Session Level Beginner
Audience All IT professionals

5:15pm CDT

418: State of Code for IBM i – An Open Discussion

Welcome to our open forum discussion on the latest developments and future plans for Code for IBM i and its extensions. Join us to gain insights into our ongoing projects, current priorities, and upcoming features. This is your chance to engage directly with our development teams, including the core team, database team, and debug team. Whether you're curious about implementing VS Code, enhancing security measures, or contributing (be it code, documentation, videos, &c.), we invite you to bring your questions and ideas to the table. Let's collaborate and shape the future of Code for IBM i together.

Speakers

Jesse Gorzinski

Business Architect, IBM

Jesse Gorzinski works for the IBM i development lab in Rochester, MN. He is a Senior Business Architect and Senior Technical Staff Member (STSM) responsible for open source technologies on the platform. Jesse, who was doing RPG programming at the age of 18, is an expert on application... Read More →

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM

Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →

Scott Forstie

Db2 for i Architect, IBM

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →

Liam Allan

Software Advocate, IBM

I am a developer and open-source advocate. Ask me about Node.js, VS Code, app deployment and CICD :)

Adam Shedivy

Software Developer, IBM

Adam is a software Developer working on enhancing client and open source integration on IBM i.

Tuesday May 21, 2024 5:15pm - 6:15pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102

Programmer Tools

Session Level Beginner

5:50pm CDT

222: UNIXCMD: Integrating RPG with Open Source

Applications in the PASE environment (Java, Ruby, PHP, Python, Node.js and more) have taken the IBM i community by storm. Naturally, you'll want to integrate them with your traditional RPG and CL programs... but it's not as easy as it sounds! The model of calling Unix-based programs is very different from the traditional model. The Open Source (free!) UNIXCMD project makes it easy. With UNIXCMD, you can read and write commands the same way you access files.

Learning Objectives:
1. Understand the difference between Unix and IBM i calling models
2. Understand how to use UNIXCMD to bridge the two models.
3. Some examples to get you started

Speakers

Scott Klement

Development & Solutions Architect, Midrange Dynamics

Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102

Programming - Frameworks

Session Level Beginner
Audience Programmers looking to combine RPG with newer open source techniques.

5:50pm CDT

223: Quick Spreadsheets through PHP and Python

Each language supports modules for extending basic features. In this session we'll explore this technique for creating REAL spreadsheets for both Python and PHP.

Learning Objectives:
1. Create REAL Spreadsheets using XLSXWriter in Python.
2. Create REAL Spreadsheets using PHPSpreadsheet in PHP.

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

SpreadsheetPHP Python1.2 pdf

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner
Audience Programmers and utility folks interested in enabling data through controled mechanisms.

5:50pm CDT

213: Web Services: The Basics of Pulling External Data into Your IBM i Applications

Obtaining information from external systems or data servers has come a long way since the introduction of EDI in the 1980s! Today, publicly available Web Service APIs offer a much more flexible and easier-to-integrate method for pulling pertinent global data into your IBM i applications. Whether it be commodity prices, financial data, current weather information, demographic statistics or whatever else you can think of, there is no shortage of information available on the internet that could complement certain areas of your company's business, thus adding valuable real-time information to your various user applications.

In this session we'll put this concept to work in a hands-on fashion. The presenter will use real-world API examples to demonstrate how developers, using Native IBM i DB2 SQL, can quickly access these valuable web service repositories and pull data into an RPG program or UI tool for their users. Attendees will see two simple 5250-based interactive examples in action, with source code they can try on their own systems.

Learning Objectives:
1> Understand the basic structure of a REST API, and how it differs from SOAP.
2> See how to find a public web service API and understand its inputs and outputs.
3> Learn how to structure and execute an SQL statement to pull data from the web service.

Speakers

Robert Swanson

Senior Partner, CNX Corporation

Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →

Use Native Functionality to get Public Data pdf

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Programming - UI

Session Level Beginner
Audience Developers who could benefit from pulling external information (i.e., commodity prices) into their user applications on IBM i

5:50pm CDT

319: Insights into Database Performance with the Performance Data Investigator

While the SQL Performance Center is the "go to" tool for understanding database performance, you can also gain insights into database performance with the Performance Data Investigator (PDI). PDI has charts that allow you to visualize database performance data in graphical form. In addition, Collection Services collects SQL job-level performance metrics. Attend this short session to learn about how to use PDI to graphically view your database performance metrics and get some tips on what those metrics mean.

Learning Objectives:
1. Learn how to use the IBM i performance tasks to view database-related metrics
2. Learn how IBM i performance data can be helpful in determining if a potential performance problem is related to the database.
3. Learn how to gain insights into the plan cache with PDI

Speakers

Dawn May

Owner, Dawn May Consulting, LLC

Dawn has been involved with COMMON for over 20 years and has been a consistent volunteer since 2008. She's been a member of the strategic education team, a subject matter expert, and a speaker. Now, as President of COMMON, she's focused on leading COMMON as the industry leader of... Read More →

Insights into DB Performance with PDI POWERUp2024 pdf

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience Administrators who want greater insight into Db2 performance by using the Performance Data Investigator.

9:15am CDT

228: ACS & Db2 for i – Explained

In this new session, you’ll hear the inside scoop about ACS from Ryan & Wayne.

At this session we will explore ACS and have a fun time understanding all the ACS has to offer.

Learning Objectives:
1. Discover the database and SQL feature-rich options within ACS
2. Gain best practices by hearing and seeing two experts discuss and demonstrate ACS

Speakers

Wayne Bowers

Software Engineer, IBM

Wayne Bowers has been with IBM since 1997, where he works with the IBM i Global Support Center in Rochester MN. He is an Advisory Software Engineer specializing in the support of the IBM i Access (aka Client Access) products, Console, the TCP Telnet communications server, and the... Read More →

Ryan Moeller

Software Engineer, IBM

Ryan Moeller is a software engineer working on Db2 for i, specifically on the SQL Query Engine (SQE) team. He joined the team in the Rochester, MN development lab in 2020. Ryan specializes in SQL, database development, and query performance analysis.

ACS and Db2 for i Explained pdf

Wednesday May 22, 2024 9:15am - 10:15am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience Anyone who needs to interact with Db2 for i

10:30am CDT

356: AI Ethics: Balancing Innovation and Responsibility

As AI technology advances and its use becomes more widespread, the debate of ethical concerns becomes more prominent.

On one side of the debate, some argue that AI should be used to improve the lives of people and make difficult decisions with fewer mistakes.

On the other side, some argue that AI should not be used to make decisions that affect people’s lives, as it could lead to biased results or decisions that are not in the best interest of society.

Either way, as the debate continues, the importance of ethical considerations when creating and using AI will become increasingly important

Speakers

Charlie Guarino

CEO & IBM Champion, Central Park Data Systems

Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner

10:30am CDT

160: A Day in the Life of a Systems Admin

What tasks do you need to complete every day, every week, and on a regular basis to successfully administer your IBM i? This session will take you through the base tasks that every System Admin should be doing to monitor and administer the system to its best efficiency.

Learning Objectives:
1. Learn what to monitor regularly to ensure optimization
2. Learn what tasks to complete regularly to keep the system on track.
3. Learn how to streamline your administration tasks efficiently

Speakers

Sarah Jacob

VP of Customer Experience, Agile Technology Architects

Sarah Jacob is the Vice President of Customer Experience at Agile Technology Architects. She is a Subject Matter Expert in Power Systems Administration and a volunteer for COMMON. Sarah specializes in Backup and Recovery planning and recovery testing. Additionally, she acts as primary... Read More →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience System Admins who are new to the position or to IBM i in general.

1:30pm CDT

290: How to Use SQL in RPG

In this session, I will walk through how to use SQL in your RPG modules/programs. We will talk about static and dynamic concepts, how to write SQL in an RPG module/program, use of host variables, and more.

Learning Objectives:
1. To start using SQL in RPG modules/programs
2. Have examples and then be able to try at home

Speakers

Sven Jansson

Senior developer, Apper Systems AB

I have worked on the IBM i platform since 1995. My technical roles include developer, analyst, database specialist, application security, and communications. I also worked on IBMz for a few years, and I serve on the COMMON Sweden board. I'm a curious person who always wants to learn... Read More →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Programming - RPG

Session Level Beginner
Digital Badge SQL
Audience Developers

2:45pm CDT

224: Build a Phenomenal Web App on IBM i in Under 10 Minutes — No Coding Required!

Just released! Valence 6.3, the latest incarnation of the popular web and mobile framework for IBM i, includes a browser-based low-code development utility called Nitro App Builder (NAB), through which anyone with a solid understanding of their IBM i database can create dazzling web or mobile apps, including dashboards and data grids with download-to-Excel functionality, all in a matter of minutes! Running entirely on IBM i, the NAB tool can also be used to create intricate file maintenance apps, through which users can adjust content in one or more physical files — you control which fields they can see and/or edit.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML Living Standard and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.
The bottom line: With Valence, whether you're a seasoned RPG developer or a super user with intimate knowledge of your system's physical files, you can crank out highly functional web and mobile apps on IBM i in no time — no prior experience in web or mobile development required. Come to this quick demo session to see the latest release of the Valence framework, and how easy it is to quickly build and deploy such an app on your system.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML Living Standard and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.

The bottom line: With Valence, whether you're a seasoned RPG developer or a super user with intimate knowledge of your system's physical files, you can crank out highly functional web and mobile apps on IBM i in no time — no prior experience in web or mobile development required. Come to this quick demo session to see the latest release of the Valence framework, and how easy it is to quickly build and deploy such an app on your system.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML Living Standard or JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.

The bottom line: With Valence, whether you're a seasoned developer or a database-savvy user, you can crank out highly functional web or mobile apps on IBM i in no time — no prior experience in web or mobile development required! Join us in this quick demo session to see this latest release of the Valence framework, and how easy it is to build and deploy such an app on your system.

Speakers

Robert Swanson

Senior Partner, CNX Corporation

Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →

Valence Demo pdf

Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Programming - Frameworks

Session Level Beginner

2:45pm CDT

280: 35 Tricks & Treats

Celebrating 35 years of IBM I, this presentation will cover 35+ tricks and treats discovered over the year, including Operating System, Built in commands, licensed packages, 3rd party packages, IBM and 3rd party hardware and appliances. Many of these tricks and treats were learned at COMMON over the years and many have helped justify the cost of a COMMON conference with the value of the knowledge gained.

Learning Objectives:
1. Remember some older concepts and technologies.
2. Learn a few legacy tips still relevant today.
3. Learn new technologies and tips to help move forward with IBM i.

Speakers

Rob Mineo

IBM i Senior Administrator/SME, (Independent)

I started my IT career in 1984. I started working on an IBM SYSTEM/38 in 1986, and upgraded to the AS/400 in 1989. I worked for STERIS Corporation from 1991 until I semi-retired in 2022. Since then, I have worked as an Independent IBM i Administrator. My career started as a programmer... Read More →

Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience IBM i Administrators

5:15pm CDT

346: Database Features in VSCode

Come explore the new Db2 capabilities in VSCode! These features, geared toward the database developer, enable full-stack development on IBM i. Come to this session for a demo and discussion of how to use these new features and why they may be beneficial to your workflows

Learning Objectives:
Understand the new Db2 features in VSCode.

Speakers

Scott Forstie

Db2 for i Architect, IBM

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →

Adam Shedivy

Software Developer, IBM

Adam is a software Developer working on enhancing client and open source integration on IBM i.

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Digital Badge VS Code
Audience Application Developers or IT Planners

5:15pm CDT

288: Build a Web Application on IBM i

There are plenty of options when it comes to building and hosting an web application on IBM i so we'll take a look at a simple approach using current technologies. In this session we'll walk through building a CRUD application using open source tools. We'll create the solution, deploy the solution, secure it and then access it from the Internet. You'll be able to see all the pieces together to help you architect your next killer web app.

Learning Objectives:
1. Learn the common components of modern web applications
2. Put that knowledge to work building a CRUD web app.
3. Learn how to configure the HTTP Server for IBM i or Apache to serve your app.
4. Learn how to secure that application in your IBM i environment.

Speakers

Pete Helgren

Technical Program Manager, Bible Study Fellowship

Currently Technical Program Manager at Bible Study Fellowship. Pete is a developer with broad experience across multiple languages and platforms, including over 29 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Cloud Penetration Tester, GIAC Secure... Read More →

Build a web app iCrudApp pdf

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner
Audience Folks who want to get started with web application development in a simple and direct way

8:00am CDT

204: The Magic of Rest APIs on IBM i

Rest APIs are a key technology in the world of Modern Applications these days. The IBM i operating system has integrated support for easily creating Rest APIs over existing ILE programs and service programs, as well as being able to wrapper SQL statements. In Addition, you can leverage the integrated support to call Rest APIs from your native RPG / COBOL ILE code. This session will leverage live demos to show both side of the Rest API conversation on IBM i.

Speakers

Tim Rowe

Business Architect Application Development & Systems Management for IBM i, IBM

Tim Rowe is the Business Architect responsible for Application Development and Systems Management for the IBM i operating system. His responsibilities include helping to make sure that the IBM i has what is needed to be successful both today and into the future. He sends much of his... Read More →

John Westcott

Db2 for i Consultant and Team Lead, IBM

John Westcott is the Db2 for i Team Lead in IBM Technology Expert Labs. John is highyly skilled in SQL, RPG, Data Analytics, Rest API, and both database and application modernization. John has over 35 years of experience on IBM i and it's past family of names. John has a storied career... Read More →

1 Magic of Rest APIs on IBM i pdf

Thursday May 23, 2024 8:00am - 9:00am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner

8:00am CDT

245: Don't Lock Yourself Out! Securing Admin Servers

Securing web based tools is increasingly important, even on your own network. Is your network team wanting to close all non-secure ports? IBM continues to provide function via the ADMIN servers, but by default they are not secure. Knowing what these servers do and setting them up securely is important, but care must be taken as some of them control your ability to secure them, so it is possible to lock yourself out!

Learning Objectives:
What are the Admin servers and why do I need them?
How to secure them and why it is important.
Avoiding pitfalls.

Speakers

Jeffrey Carey

Sr. System Administrator, Ensono

Jeff Carey is an IBM i professional with over 25 years of experience on the platform, specializing in system administration. He currently is a Senior System Administrator for Ensono, a company providing managed services for Mainframe, IBM i, Cloud, and hybrid IT, headquartered in... Read More →

Thursday May 23, 2024 8:00am - 9:00am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102

Systems Management

Session Level Beginner
Audience System administrators of IBM i

10:30am CDT

253: API examples using RPG, Node.js, PHP, and Python

APIs allow IBM i to connect with other systems safely and securely, using the languages you already know. You will feel empowered to provide and consume APIs with the many examples given here, in RPG, PHP, Python, and Node.js (javascript), along with secure techniques and free tools that make API development easier.

Learning Objectives:
1. Understand basics of APIs and why they are helpful and secure
2. Learn several RPG techniques to create and call APIs
3. Learn several open source language ways to create and call APIs, using PHP, Python, and Node.js

Speakers

Alan Seiden

Principal, IBM Champion, Seiden Group

How to modernize and create something new while leveraging your valuable business logic.APIs, IBM i, open source, web, PHP, Node.js, Python, RPG, ERPs

Thursday May 23, 2024 10:30am - 11:30am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Programming - General

Session Level Beginner
Audience Developers or managers who wish to build or call APIs

10:30am CDT

255: 30 Python Tips in 60 Minutes

Python on IBM i has been around for a while now. In this session we explore many of the various tips I’ve run across over the last few years. These tips apply to both Python and/or the IBM i environment running the Python scripts. Tips include best practices, IFS features, pathing and MUCH more.

Learning Objectives:
1) Little bit of everything to help the Python developer
2) Standards based code development and linting.
3) Features that improve Python performance

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

Python30TipsV1.0 pdf

Thursday May 23, 2024 10:30am - 11:30am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102

Programming - Python

Session Level Beginner
Audience Early players in the Python space

1:30pm CDT

263: What is Open AI and Why Should You Care?

Open AI and specifically Online GPT has captured the latest in IT headlines. In this session we will discuss the history of Open AI, how it has matured and the goals of the team behind the technology. We'll also explore (speculate) on its impact to education, finance and most assuredly, Information Technology. We'll wrap up with a live demo of the Copilot application and how it might add productivity to the typical IBm i shop, but at what cost?

Learning Objectives:

Speakers

Mike Pavlak

Solution Architect, Perforce Software

Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →

Thursday May 23, 2024 1:30pm - 2:30pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Award SILVER

1:30pm CDT

227: Tame the IFS with SQL Services

In this session, you will discover how SQL and IBM i (SQL) Services can be used to bring order to the IFS. Whether you aim to further secure, manage, or utilize the IFS, SQL can help get the job done. The Db2 for i team has made consistent and noteworthy investments to bring SQL capabilities that can be used with the IFS. Come to this session to see, understand, and be ready to use SQL with the IFS.

Learning Objectives:
Learning Objectives:
1. Understand what's possible with SQL and the IFS
2. Learn how to use SQL with the IFS
3. Gain awareness of the pitfalls and gotchas when using SQL

Speakers

Scott Forstie

Db2 for i Architect, IBM

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry events... Read More →

Thursday May 23, 2024 1:30pm - 2:30pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102

Session Level Beginner
Audience Anyone using or managing the IFS on the IBM i

2:45pm CDT

429: SQLRPGLE the Better File Access

We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process with embedded sql. How to handle sql exceptions. And finally, how can you leverage SQL to replace your current record level access.

Learning Objectives:
Overview of embedding sql in your RPG programs. How to streamline sql procedures with the use of a SQL utility service program. how to modernize your current record level access to use embedded sql

Speakers

Marina Schwenk

Innovative Software Solutions

Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina worked for over nine years as a Senior Programmer Analyst/IBM i admin at Everbrite... Read More →

Thursday May 23, 2024 2:45pm - 3:45pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102

Programming - RPG

Session Level Beginner