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

Exhibitor Hall Map Here 
Simple
Expanded
Grid
By Venue
Intermediate [clear filter]
Monday, May 20
 

10:15am CDT

105: What's New in Db2 for i
EVALUATION
In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.4 and IBM i 7.5 over the most recent IBM i Technology Refreshes.

This session will include something for everyone and anyone who uses the IBM i.

Resources: https://www.ibm.com/support/pages/node/1119129 and http://ibm.biz/Db2foriSQLTutor

Learning Objectives:
Speakers
avatar for Scott Forstie

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 →

What's New in Db2 for i PowerUP May 2024 pdf
Monday May 20, 2024 10:15am - 11:15am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Database

10:15am CDT

143: What's new in PowerHA
EVALUATION
Learn through live demonstrations how to take advantage of all the exciting new enhancements in PowerHA with a focus around automation, simplification and integration.

Learning Objectives:
1. A brief review of PowerHA
2. Learn and see the exciting new features
3. A preview of what is to come in the future
Speakers
avatar for Brian Nordland

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 →

WhatsNewInPowerHA pdf
Monday May 20, 2024 10:15am - 11:15am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Intermediate
  • Digital Badge HA/DR
  • Audience Anyone interested in PowerHA, either those considering it or those who have had it and want to learn what is new

10:15am CDT

113: Real-Time Access to Integrated File System Data Across the Network
EVALUATION
The green screen isn't the only place where users can interact with IBM i file system data. Find out how and when to share your integrated file system to other platforms to let your users get more done with less effort. The latest updates to these file sharing methods will be included.

Learning Objectives:
- Understand the file sharing options on the IBM i and their differences
- Understand how to set up/use the file sharing options on the IBM i
- Understand how policy settings can affect IBM i NetServer functionality
Speakers
avatar for Margaret Fenlon

Margaret Fenlon

Software Engineer, IBM
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →

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

10:15am CDT

399: Introduction to the Changing World of Licensing Subscriptions and Conversions
EVALUATION
The IBM i platform is going through a multi-year transition that has seen simplification and consolidation of products within the License Program Product portfolio. Most recently we have also introduced the Subscription Conversion offerings on the P05 and P10 license tiers. Join me as I take you through the beginnings of this journey and where we are today with potentially a few hints at what may come in the future.
Speakers
avatar for Douglas Gibbs

Douglas Gibbs

IBM i Product Manager, Program Director, IBM
Douglas Gibbs is the offering manager for IBM Power Systems I/O and works closely with the overall Offering Management, Sales and Development teams regarding all manners of I/O. Douglas has worked in the IT Industry for more than 25 years and has been in a variety of positions at... Read More →

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

10:15am CDT

126: IBM i Networking and Servers Overview
EVALUATION
The IBM i OS network communications has changed a lot since the AS/400 primarily communicated to workstations and printers using Twinax and to other computer systems using specialized communications lines. In some ways things are more complex because our IBM i OS systems communicate to a lot of other devices in many different ways, but in other ways things are simpler today because nearly all network communications are built on top of the foundation of Ethernet and TCP/IP.

This session will take a look at these foundation Ethernet and TCP/IP and how they are built up within the IBM i OS. We will look at your communications adapters, Line Descriptions, and IP addresses, subnets, routes and more including the commands and interfaces used to manage these.

We will also look at some of the most commonly used networking servers like Telnet and FTP and cover their basics of configuration, management and even troubleshooting.

Learning Objectives:
Speakers
avatar for Wayne Bowers

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 →

NetworkServers PowerUp24 pdf
Monday May 20, 2024 10:15am - 11:15am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Networking
  • Session Level Intermediate
  • Award GOLD
  • Audience IBM i OS users to Administrators looking for a better basic understanding of networking on the IBM i OS.

11:30am CDT

177: Using DevOps to Quickly React to Business Needs: DevOps ROI
EVALUATION
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

Learning Objectives:
1. Learn about DevOps
2. Learn about the significant ROI benefits of ROI
3. Understand the DevOps steps needed
Speakers
avatar for Alan Ashley

Alan Ashley

Presales Consultant for DevOps for IBMi, Arcad Software
When it comes to describing someone, even yourself, it can be difficult. This time it's easy. I grew up on the AS400, through iSeries, and into the IBM i world. Started on a model B50 (I know it was a B model) where the disk drive needed two persons to replace and now in the DevSecOps... Read More →

Monday May 20, 2024 11:30am - 12:30pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Development, Operations, and C-level executives wishing to take advantage of DevOps ROI

11:30am CDT

214: Git and IBM i - How to Build Your Source
EVALUATION
Getting started with native source in Git isn't that hard and there are multiple development tools but what about getting your source changes to the IBM i? What about those special IBM I dependencies that need to be managed? We'll look at what a Build is and how the IBM i has different requirements then other platforms and how we can meet those requirements. We'll also discuss the open source tools that you can use to set up a Build for native source and how to automate it.

Learning Objectives:
Speakers
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →

Monday May 20, 2024 11:30am - 12:30pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  DevOps

11:30am CDT

404: NVME is your Friend
EVALUATION
Speakers
avatar for Daniel Sundt

Daniel Sundt

IBM i Product Manager, IBM
Dan Sundt is an IBM i product manager. He has the responsibility for the IBM i business, including defining and guiding future directions and strategies. He works with the IBM i sales, marketing, and development teams as well as customers and partners to ensure that the IBM i operating... Read More →
avatar for John Folkerts

John Folkerts

Power Systems IO Product Management, IBM
John Folkerts has recently taken on the role of Power Systems IO Product Manager.  John is responsible for direct attach storage, network adapters, fibre channel adapters, IO expansion and a variety of other areas.  His previous roles within IBM included hardware development of... Read More →

NVMe is your friend COMMON POWERUp 2024 V3 pdf
Monday May 20, 2024 11:30am - 12:30pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Hardware

11:30am CDT

130: Step-by-Step Guide to Creating Virtual i Partitions Hosted by IBM i
EVALUATION
IBM i has the capability of hosting an IBM i Logical Partition (LPAR) to provide virtual disk storage for other IBM i partition. IBM i has provided „hosted disk” for Windows servers and AIX or Linux partitions for several years, but the ability to host another IBM i LPAR is new. See the step by step process in creating hosted virtual partitions. Learn the requirements, the prerequisites, and all the steps needed to create this once your back in the office. This will be great for creating a virtual partition to test your 7.5 upgradeI

Learning Objectives:
1) Understand the relationship between all the components of a virtual LPAR. 2) How to create virtual storage. 3) How to use this knowledge back at your shop to build your own.
Speakers
avatar for Pete Massiello

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 →

Step By Step Guide to Creating Virtual i Partitions Hosted by IBM i 2024 pdf
Monday May 20, 2024 11:30am - 12:30pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management

2:45pm CDT

256: SQL Plan Cache Uncovered
EVALUATION
This session explains how the SQL Plan Cache is used by Db2 for i to support the execution of your SQL & non-SQL queries. In addition, you'll learn about the various Plan Cache related tools & services that you can leverage to identify and remedy query performance problems.

Learning Objectives:
Speakers
avatar for Kent Milligan

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 →

SQL Plan Cache Uncovered pdf
Monday May 20, 2024 2:45pm - 3:45pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database

2:45pm CDT

391: Analyzing Geospatial Data Using Db2 for i
EVALUATION
In everyday life when we asks questions like “Where is the nearest coffee shop” or “How far away is the airport” we are asking questions about geospatial data. Geospatial data is used to represent objects and events that occur on the surface of the earth. Geospatial analytics allows you to not only store geospatial data representing real location in your database, but to also compare and analyze geographic relationships and trends.

Learning Objectives:
This session will introduce the set of new user-defined geospatial data types, scalar functions, and table functions that make up Geospatial Analytics with Watson and provide many real-world examples of how to use them
Speakers
avatar for John Westcott

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 →

391 Analyzing Geospatial Data Using Db2 for i pdf
Monday May 20, 2024 2:45pm - 3:45pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Database developer designing applications

2:45pm CDT

235: Git Branch Management for IBM i Source; I Want JUST the Changes
EVALUATION
One of the challenges of managing IBM i source with Git is we don't want to Build ALL of our objects for a few changes like a Java project. We want just the changes specific to our project. How do we get JUST those changes and what impact does that have on branch management, merging and conflicts? I thought Git made concurrent development easier, why is this SO HARD?

Now that we at Arcad have been providing Git integration for a number of years we have experience on why a rebase or a fetch from master can have unintended consequences. Well what do we DO with stale branches that conflict with master if we can't fetch? Ho can we just avoid a conflict or resolve it with the least pain?

Learning Objectives:
1, Recognize how IBM i source and business requirements require different branch management.
2. Best workflow for IBM i shops with concurrent development
3. Most efficient way to resolve or avoid merge conflicts
Speakers
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →

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

2:45pm CDT

268: Using IBM and Db2 Services in (RPG) Programs … Can Make Life Much Easier!
EVALUATION
With the last releases and technology refreshes IBM provided a lot of new SQL Services.

A lot of these Services provide functionalities that are not directly available in RPG or can only be implemented in RPG by calling complex System APIs and by using pointer handling for accessing the data.

However, now we have SQL services that can write data into the IFS or can delete old spool files or even better can convert a spool file into a PDF-Document. Since the last Technology Refresh it is also possible to send eMails or to generate *.csv files directly with SQL and IBM Services.

This session will demonstrate how RPG Programs can be simplified by just using embedded SQL and IBM Services.

Learning Objectives:
In this session you’ll learn how specific SQL Services can be implemented with embedded SQL in RPG or Cobol and how the formerly complex source code can be reduced
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 →

POWERUP 2024 SYSTOOLS Services Birgitta Hauser pdf
POWERUP 2024 SYSTOOLS Services Birgitta Hauser sql
Monday May 20, 2024 2:45pm - 3:45pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Programmers, Managers and everybody who is interested in new Services and how this services can be used from within RPG (or Cobol).

2:45pm CDT

183: Anatomy of a Password
EVALUATION
Have you thought about the passwords you use on your systems? What rules or restrictions do you have in place? But more importantly, why?! Have you ever thought about what those rules actually do to your passwords? Do you think they are making you more secure or less secure? In this presentation, we will cover passwords in depth, in theory, and specific to IBM i. Can your IBM i password be hacked? Come and find out at this inquisitive session!

Learning Objectives:
1. Set modern password policy
2. Understand password protection tools
Speakers
avatar for Robert Andrews

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 →

Anatomy of a Password pdf
Monday May 20, 2024 2:45pm - 3:45pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Security

4:00pm CDT

109: Intro to FlashCopy & Cybersecurity Resiliency with Safeguarded Copy
EVALUATION
If you’re using external storage in your IBM i environment without taking advantage of FlashCopy, we have one question for you: Why not? Get an overview of how FlashCopy works, the types of FlashCopy options available, how FlashCopy can be used in environments with or without independent ASPs.

In addition, learn how IBM's Safeguarded Copy extends FlashCopy to provide another layer of cybersecurity resiliency.

Learning Objectives:
1. FlashCopy Overview
2. Advanced FlashCopy Concepts
3. Cybersecurity Resiliency with Safeguarded Copy
Speakers
avatar for Brian Nordland

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 →

Introduction to FlashCopy and Cybersecurity Resliliency with Safeguarded Copy pdf
Monday May 20, 2024 4:00pm - 5:00pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Intermediate
  • Digital Badge HA/DR
  • Audience Those looking at wanting point in time copies of their data to either reduce their backup window, querying, or development and test purposes

4:00pm CDT

148: Options for Consuming REST APIs from RPG
EVALUATION
REST APIs have become a major part of business programming. We live in a world where virtually everything is connected to the Internet, and REST APIs are how they communicate with each other. In this session, you will learn how to call (or "consume") REST APIs from good ol' RPG. In addition to showing you the basics of how APIs work, this session explains how to use several free tools to consume them. The tools will be compared so that you can determine which one would work best for you.

Learning Objectives:
1. Understand why/when REST APIs are used.
2. Understand how REST APIs work.
3. Preview Calling REST APIs from RPG with several free tools.
Speakers
avatar for Scott Klement

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 4:00pm - 5:00pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG

4:00pm CDT

274: Di WHY? Do it yourself IBM i security assessment
EVALUATION
For all IBM i do-it-yourselfers and tinkers, we'll temporarily set aside the question of "should I really be spending my time on this?" to show you how to run to your own security assessment. You'll leave with a checklist and some sample queries to get you started on your very own IBM i security audit.

Learning Objectives:
1. Provide a checklist of IBM i security audit tasks
2. Run sample queries to generate audit data
 3. Evaluate audit data to assess security risk
Speakers
avatar for Justin Loeber

Justin Loeber

IBM i Security, Kisco Systems
Justin Loeber is the owner and CEO of Kisco Systems, a developer of IBM i security and compliance software. Kisco's mission is to secure every IBM i by helping educate the IBM i community about security, continuously improving its products and delivering the best value in the market... Read More →

kisco diwhy sec assessment pu24 pdf
Monday May 20, 2024 4:00pm - 5:00pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience Anyone with responsibility or accountability for IT security, data integrity, compliance or business continuity.

4:00pm CDT

124: HMC, IBM I, FSP, BMC & Firmware: Putting All the Pieces Together
EVALUATION
Come to this session and dissect all the new components and concepts involved with partitioning your IBM Power Systems. Learn how all the pieces connect to each other, what you need to do to set them up, and how to manage and upgrade them. Get a handle on the various components of the Hardware Management Console (HMC), the Flexible Service Processor (FSP), and the Advanced Systems Management Interface (ASMI). Find out about the firmware in your machine, and how to make the required updates to it in an LPAR environment or on a standalone machine. Get tips for upgrading and setting up communications between the HMC and FSP as well as insight on where the ASMI fits in. Leave this session with up-to-date knowledge on these important hardware features of IBM PowerSystems & IBM i

Learning Objectives:
1) Understand how to upgrade & update your HMC.
2) Understand how to upgrade your FSP.
3) Learn how everything connects and interacts.
Speakers
avatar for Pete Massiello

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 →

Putting the pieces together HMC, FSP, firmware, ASMI, and OS 2024 pdf
Monday May 20, 2024 4:00pm - 5:00pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Award GOLD
  • Audience If you have an HMC at your location, this is the session to learn how to manage it.

5:15pm CDT

352: Simple Ways to Convert Your DDS Files into DDL Statements
EVALUATION
Modernization is more than putting a GUI front-end on your applications. Database modernization should also be included, converting from DDS files to DDL tables, index, & views. All of the tools needed to do this is included with your IBM i & Db2 for I at no additional charge. Why use a third party tool when you can do it for free? Will also include how you can de-create various SQL objects into statements.

Learning Objectives:
1. Learn what tools are available to convert DDS to DDL
2. See example of how to use them
3. Learn how to recover the SQL statement used to create various SQL objects
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →

Simon Hutchinson 352 Simple Ways to Convert Your DDS Files into DDL Statements pdf
Monday May 20, 2024 5:15pm - 5:35pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyone wanting to modernize their database from traditional DDS files to more modern DDL tables, indexes, & views.

5:15pm CDT

329: What Modern App Dev for IBM i Looks Like
EVALUATION
IBM i and VS Code is your one stop shop for everything in 2024. Whether you’re developing PHP, Node.js, Java, or RPGLE, the tools you need are ready to make your IBM i development environment and experience the best. We will build a web API from scratch, connect to Db2 for i, have the API call programs and deploy it - all in short time.

Learning Objectives:
How VS Code can be used for every angle of app development.
Speakers
avatar for Liam Allan

Liam Allan

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

Monday May 20, 2024 5:15pm - 5:35pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

5:15pm CDT

335: Shortcuts to Using the IBM i Audit Journal
EVALUATION
Learn some new ways to make use of the integrated IBM i audit journal.

In this session you will discover how much information about how your system is being used beyond looking at QHST. Discover what files are being access by which users, how commands are being executed, or just how many invalid signons happened last week.

Learning Objectives:
1. The top 5 must have values for you system security logging.
2. How to discover the most frequent journal entry taking up space in your receivers
3. How you can use Run SQL Scripts in ACS (Access Client Solutions) to quickly access the audit journal information.
Speakers
avatar for Amy Williams

Amy Williams

Sr Security Services Consultant, Fortra LLC
Amy Williams is a Senior Security Services Consultant who joined Fortra in 2015. She holds CISSP, CISA, and PCI-P certifications.Amy has worked on the IBM i platform for nearly 30 years and her experience includes application testing, system installation, system administration, and... Read More →

Shortcuts to Using the IBM i Audit Journal pdf
Monday May 20, 2024 5:15pm - 5:35pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience System administrators familiar with the IBM i Audit journal and need to improve ways of getting to the information

5:50pm CDT

354: RPG array magic
EVALUATION
Learn how the recent enhancements to RPG have added many new features & enhancements to the way you can use arrays. This will include all the new Built in Functions, Data Structure arrays, & dynamic arrays.

Learning Objectives:
1. Modern ways to code arrays to include the latest features, & what stops you from using them.
2. How Data Structure arrays simplify you getting information from the database.
3. The new Built in Functions for arrays that replace a lot of the complicated coding we use to do.
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →

Simon Hutchinson 354 RPG array magic pdf
Monday May 20, 2024 5:50pm - 6:10pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience RPG programmers looking to make their use of arrays easier & simpler for others to understand
 
Tuesday, May 21
 

8:00am CDT

112: Integrated File System Security Principles and Practices
EVALUATION
Are you confused about IBM i Integrated File System security? You're not alone! Come to this session and learn the principles and best practices of securing your file systems. This session will cover more than just setting permissions (authority) on your objects. Other topics include virus scanning, controlling remote access, object audit, and more.

Learning Objectives:
- Understand the semantics of integrated file system security
- Learn other methods of securing beyond permissions including virus scanning, and more
- Learn ways to manage and improve integrated file system security
Speakers
avatar for Margaret Fenlon

Margaret Fenlon

Software Engineer, IBM
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →

IntegratedfileSystemSecurityPrinciplesAndPractices 2024 pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  IFS
  • Session Level Intermediate
  • Audience IBM i system administrators and application developers who wish to learn more about integrated file system security. Most beneficial for those that have working knowledge of the IFS or have attended the introduction and/or advanced sessions.

8:00am CDT

100: IBM i OS and Power System Upgrade Testing
EVALUATION
Focusing on the unique needs of IBM i environments we look at the testing needed for system and OS upgrades/migrations. From strategic test management and planning to risk management and resource allocation. Concepts covered include how to identify testing points, determine risk, and implement responsible quality assurance. Updated to include templates and planning examples.

Learning Objectives:
  1. Understanding testing strategies, tactics, and design.
  2. Determine risks to system quality.
  3. Aligning testing with risk exposure.
  4. When to use risk based testing, static testing, behavioral testing, or structural testing for best results.
Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
I am a Quality Assurance, Project Management, and Professional Services expert.Named IBM Champion 2024I have twenty-five years of experience in the IBM i industry starting in application development, transitioning through quality assurance, and into management. My passion has been... Read More →

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience Audience: IT department personal who want to deliver solid testing for upgrades. Any system administrator who is concerned about the testing their system is subjected to. Consultants who are in the upgrade/hardware/admin sphere and want to enhance their testing offering. QA professionals who want understand what the technical team is testing and evaluating before hand off.

8:00am CDT

129: Elevate Your IBM i Game: Transforming Bad Habits into Best
EVALUATION
Best Practices is all about meeting IBM system compliance to achieve optimal results. Don’t let old myths or newly formed bad habits be the difference between success or a failure in service delivery. This session will examine V7R4/R5 System configurations, BRMS Backups, Disaster Recovery, and Security Management. Examine assumptions, technical gaps, blunders, and recommendations. Hear actual lessons learned so you do not make the same IBM i assumptions others have made. IT is not a game of chance

Learning Objectives:
Speakers
avatar for Richard Dolewski

Richard Dolewski

VP, Enterprise Solutions, Connectria
Richard is a recognized SME and award-winning industry speaker specializing in, Cloud Computing Architecture, Business Resiliency, Disaster Recovery Planning and Backup & Recovery Program Design. He leads organizations through the new era of technology, achieving the desired, successful... Read More →
JP

129 Elevate Your IBM i Game Transforming Bad Habits into Best PowerUp Dallas Final pdf
Tuesday May 21, 2024 8:00am - 9:00am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Systems Management

9:15am CDT

170: Deploy, Administer, and Restrict IBM i ACS: Get and Deploy IBM i ACS
EVALUATION
Deploy, Administer, and Restrict IBM i ACS Use the best practices and tools to be the most effective System Administrator possible. This module will extend your knowledge of IBM i Access Client Solutions (IBM i ACS) to more effectively deploy, administer and restrict the best IBM i access and administration client available.

Part I: Get and Deploy IBM i ACS
Part II: Administer and Restrict IBM i ACS
Part III: Ask Me Anything

Learning Objectives:
1. Where and how to obtain IBM i ACS client 2. IBM i ACS Deployment Guide
Speakers
avatar for Wayne Bowers

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 →

ACS GetDeploy PowerUp24 pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Client Connectivity
  • Session Level Intermediate
  • Digital Badge ACS
  • Audience IBM i IT responsible for Deploying and Administering IBM i ACS.

9:15am CDT

233: Moving into Git (for RPGLE, COBOL, and more)
EVALUATION
The future of writing ILE languages is with git. Whether you've not heard of git, or you're an expert, we'll cover the basic concepts of git, how to get your ILE source code into git, how to develop and compile code from repositories, and many other concepts.

Learning Objectives:
1. Learn what tools are available to move source code
2. Understand where your source code repository can live
3. Get the gist on general git concepts
Speakers
avatar for Liam Allan

Liam Allan

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

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

9:15am CDT

337: Breaches, Ransomware and Recovery, Oh My!
EVALUATION
Your organization has been breached. Ransomware has run rampant throughout your organization. Have you planned for this eventuality? Does your incident response plan include IBM i? During this session will discuss the steps you’ll want to take now to reduce risk to IBM i and to ensure that you can recover should your system be affected. Real-life incidents and scenarios will be discussed so that you can learn from others’ mistakes.

Learning Objectives:
1 Understand the steps you can take to secure your system to reduce the risk of data loss or being infected with ransomware
2. Learn about the backup technologies that will support both disaster recovery as well as recovery from ransomware
Speakers
avatar for Richard Dolewski

Richard Dolewski

VP, Enterprise Solutions, Connectria
Richard is a recognized SME and award-winning industry speaker specializing in, Cloud Computing Architecture, Business Resiliency, Disaster Recovery Planning and Backup & Recovery Program Design. He leads organizations through the new era of technology, achieving the desired, successful... Read More →
avatar for Carol Woodbury

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 →

337 Breaches Ransomware Recovery Oh My PowerUp Dallas Final pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Security

9:15am CDT

166: Understand your IBM i Performance Signature
EVALUATION
IBM i often runs well with little or no focus on the performance of the system. But what if something unexpected does occur? If you understand the performance signature of your system when it is running well, it becomes much easier to identify problems if something goes wrong. This session will show you how to use the Performance Data Investigator to understand your day-to-day performance signature, as well as Graph History to understand long-term trends over weeks, months, and years.

Learning Objectives:
1. Learn how to interpret performance charts in PDI
2. Understand what wait metrics mean
3. Learn how to review historical performance data
Speakers
avatar for Dawn May

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 →

Understand Your IBM i Performance Signature POWERUp2024 pdf
Tuesday May 21, 2024 9:15am - 10:15am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management

9:15am CDT

195: No Limits Modern Excel Reports Using RPG-The Whole Story
EVALUATION
Our businesses often want reports delivered in Excel format. While there are several ways to create these spreadsheets using RPG, they all have some drawbacks. Writing to the current XLSX format for Excel spreadsheets may seem a formidable challenge, but we will see that the prospect of success is better than it might seem at first. And we will see how to use tools such as CGIDEV2 to accomplish the task of creating these modern, highly-functional spreadsheets.

The first part of this session looks at what you need to get started with this approach. It also looks at the advantages of using CGIDEV2 to create Excel files.

The second part digs deeper into adding more features of Excel to your spreadsheets, optimization, and troubleshooting - what to do with that "unreadable content" message!

Learning Objectives:
1. Understand the internal structure of modern Excel (XLSX) files
2. Begin to get hold of the workings of CGIDEV2 and XML
3. Understand how to design and implement an Excel (XLSX) application
4. Get some idea of just what CAN be done to make even more useful spreadsheets
5. Learn what to do when...
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior software engineer for the Pest Elimination division of Ecolab. He serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

OPEN LAB Fast Modern Excel (XLSX) Workbook Creation Using RPG pdf
OPEN LAB Fast Modern Excel (XLSX) Workbook Creation Using RPG docx
Shared Strings Table Resources zip
DIY XLSX Lab setup zip
No Limits Modern Excel Reports Using RPG The Whole Story 2up pdf
Tuesday May 21, 2024 9:15am - 11:30am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Developers (and their managers) who are asked to create spreadsheets will see a way to get high functionality and good run-time performance.

10:30am CDT

169: Deploy, Administer, and Restrict IBM i ACS: Administer and Restrict IBM i ACS
EVALUATION
Deploy, Administer, and Restrict IBM i ACS Use the best practices and tools to be the most effective System Administrator possible. This module will extend your knowledge of IBM i Access Client Solutions (IBM i ACS) to more effectively deploy, administer and restrict the best IBM i access and administration client available.

Learning Objectives:
1) How to use items like AcsConfig.properties, Restrictions, Function Usage to Administer IBM i Access Client Solutions
Speakers
avatar for Wayne Bowers

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 →

ACS AdminRestrict PowerUp24 pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Client Connectivity
  • Session Level Intermediate
  • Digital Badge ACS
  • Audience IBM i IT responsible for Deploying and Administering IBM i ACS.

10:30am CDT

262: Accelerate Your SQL Queries with SMP
EVALUATION
With Symmetric Multiprocessing (SMP) now available as a no-charge feature in IBM i, you've gained access to a powerful feature that can significantly improve the speed of query execution. However, SMP must be approached carefully, as improper usage may produce lackluster results. This session will cover the inner workings of SMP, when to utilize SMP, and tools for controlling system-wide SMP usage.

Learning Objectives:
1.) Understand how the SQL Query Engine utilizes SMP to accelerate query execution
2.) Understand what workloads benefit most from SMP
3.) Understand the controls available to the Database Engineer to control SMP
Speakers
avatar for Ryan Moeller

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.

Accelerate Your SQL Queries with SMP pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Award GOLD
  • Audience Database engineers, programmers, application developers

10:30am CDT

264: Partitioned Table Functionality
EVALUATION
Did you know that partitioned table functionality is now included in IBM I 7.5? Attend and learn what partitioned tables are and the benefits of using them to organize your data. Q&A will follow a live demo.

Learning Objectives:
participants will be able to use partition tables in their own IBM i shops.
Speakers
avatar for Sven Jansson

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 →

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

10:30am CDT

350: Maximizing the benefits of embedding SQL in your RPG code
EVALUATION
Many people are now integrating SQL into RPG programs & procedures. Simon will give practical examples of how you can optimize the performance of your statements & simply diagnose the feedback returned from Db2. Will include mentions of how using Views enhances this optimization process.

Learning Objectives:
1. SQL I/O methods to get data from the database faster
2. Better method to capture errors, or what happened with your SQL statements
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →

Simon Hutchinson 350 Maximizing the benefits of embedding SQL in your RPG code pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Any RPG programmer looking to modernize their skills by using embedded SQL within in their work in a manner that will increase the performance of their programs & procedures.

10:30am CDT

117: Managing IBM i PTFs
EVALUATION
What are PTFs? Why do I need them?  How do I get them? Which ones do I need? Does my technology really need a refresh? In this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place. We'll help you determine what PTF strategy is the one for you and your system.

Learning Objectives:
1. What PTFs, and PTF Groups are and why you need them.
2. How to get PTFs and load them onto IBM i.
3. The use of Virtual Image Catalogs and Virtual DVD drives to save time and problems in the PTF process.
4. How to determine which PTFs you need for your system.
Speakers
avatar for Larry Bolhuis

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 →

Managing IBM i Fix Information [PTFs} pdf
Tuesday May 21, 2024 10:30am - 11:30am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Award SILVER
  • Audience This session is for you if you are the person in charge of administering IBM i.

2:45pm CDT

304: Run Away Queries Got You Down?
EVALUATION
Having negative performance impacts from query tools like Query/400, QMF, Showcase, Tableau and others because of the "query from heck" eating up system resources? Is your system open to security exposures from wide-open ODBC type connections? This session will cover options including using the new-ish Db2 Query Supervisor to control and/or audit long-running queries.

Learning Objectives:
1. Learn about the Db2 Supervisor to control and/or audit long running queries.
2. Gain insight into the tools you can use to monitor, tune, and prune queries.
Speakers
avatar for John Westcott

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 →

304 Run Away Queries Got You Down pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyone concened with managing system performance

2:45pm CDT

279: IBM HA/DR Solutions for IBM i
EVALUATION
The IBM i HA/DR portfolio covers the spectrum from storage-based solutions to IP based Geographic Mirroring for both on premise and/or in PowerVS. The solution portfolio enables automated fail-over, provides off-line backups and ransomware protection while greatly reducing both CAPX and OPEX compared to the legacy logical replication tools. We’ll cover the options, how they work and how you should position them as well as the latest enhancements. We’ll also discuss Pools 2.0, the CBU and migrating to PowerHA 7.5 from a previous release, GRS in PowerVS and upcoming roadmap.

Learning Objectives:
1. for current PowerHA/FSR/VM Recovery Manager customers, learn what's new and what's coming, on premise and in PowerVS
2. for IT Admins and business partners relatively new to hardware based based HA/DR, learn the basics, what are the outcomes expected from each approach, how does this solution portfolio compare to legacy software replication tools
3. On premise verses PowerVS or Hybrid
4. Be able to make the case to your management on the how and why you want to do this.
Speakers
avatar for Steven Finnes

Steven Finnes

Product Manager, IBM
Steve has spent several years in IBM with positions spanning basic research to product development, product offering and marketing. He is the product offering manager for IBM Power Systems with responsibility for PowerHA for AIX, PowerHA for IBM i and the CBU.

IBM I HADR PowerUp 2024 pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

2:45pm CDT

176: Service Programs and Unit Testing – The Perfect Pair
EVALUATION
Do you have monolithic programs that you have to start breaking up into manageable pieces? Have you been tasked to start unit testing and don’t know where to start? This session is meant for you.

Learning Objectives:
We will work through the benefits to modernizing your code and why you want to adopt unit testing.
We will work through breaking apart monolithic programs and how to write their respective unit tests.
We will discuss some best practices in unit testing and how you can take some of those best practices and apply them to your everyday development processes.
Speakers
avatar for Marina Schwenk

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 2:45pm - 3:45pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Program Testing
  • Session Level Intermediate
  • Audience Application Developers, testers

2:45pm CDT

153: Overloading in RPG
EVALUATION
One of the coolest new features in ILE RPG is the ability to overload your prototypes! With overloading, you can accept differing parameter types while keeping the same routine name. Overloading can be used with programs, but the biggest value comes when using it with subprocedures.

Learning Objectives:
- What is overloading? Why use it?
- Technical details of parameters, candidates, etc
- Full examples you can use yourself
Speakers
avatar for Scott Klement

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 2:45pm - 3:45pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG

2:45pm CDT

162: Where to Start with Open Source Package Management
EVALUATION
As more and more development teams embrace Open Source technologies on the IBM i OS it will be important that Systems Administrators know the basics of managing these packages on the IBM i OS. This session will predominantly look at the Open Source Package Management capabilities included with IBM i Access Client Solutions as the go to environment for those who are not themselves using the Open Source packages.

Learning Objectives:
As a Systems Administrator become familiar with Open Source Package Management on the IBM i OS.
Speakers
avatar for Wayne Bowers

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 →

OSPM Start PowerUp24 pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience IBM i System Administrators who need to manage making Open Source technology packages avaialble on the IBM i.

2:45pm CDT

119: Selecting Your Power Virtualization Environment
EVALUATION
When virtualizing IBM POWER Systems you have two primary choices for the hosting environment, VIOS and IBM i. Each of these offers strengths and each has weaknesses. In this session we'll go over more than 35 comparison points putting the two hosting choices side by side. Well cover technical capabilities as well as usability and visual items. We'll look at costs and requirements for each host.

Come and select your choice for a hosting partition or confirm that you've gone down the right track.

Learning Objectives:
What requirements would lead you to select VIOS as your hosting environment
What requirements would lead you to select IBM i as your hosting environment
What are the costs or need-to-knows for each of the two hosts.
Speakers
avatar for Larry Bolhuis

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 →

Slecting your Power Hosting Environment pdf
Tuesday May 21, 2024 2:45pm - 3:45pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Virtualization
  • Session Level Intermediate
  • Audience Any IBM i system administrator, especially those with virtualization in their future.

4:00pm CDT

266: Under the Hood: A Deep Dive into the SQL Query Engine 
EVALUATION
The SQL Query Engine (SQE) powers (nearly) every query that executes on your system. Since its introduction, SQE has been continually improved to create more efficient access plans, but these inner workings are rarely understood. In this session, Ryan will give audience members a rare peek under the hood of the engine that powers Db2 for i.
Speakers
avatar for Ryan Moeller

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.

Under the Hood A Deep Dive Into the SQL Query Engine pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Database engineers, database administrators, application developers

4:00pm CDT

303: Temporal Tables: Time Travel Is Cool
EVALUATION
Learn how to time travel within your data! How many programs are already doing some type of temporal logic? Would moving to a more data-centric approach reduce your development effort delivering faster and better results? This session explains how to temporalize your existing database, how to manage temporal database, and how to perform temporal analysis.

Learning Objectives:
How to temporalize your existing database.
How to manage temporal databases.
How to perform temporal analysis.
Speakers
avatar for John Westcott

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 →

303 Temporal Tables Time Travel Is Cool pdf
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyone interested in creating a temporal database or performing temporal analysis

4:00pm CDT

330: Automated Build Systems for IBM i Environments
EVALUATION
We have been working on open source tools to make managing your IBM source code and building objects easy for when your source code is in git. In this, we will show how objects get built from a git repository (when developing locally and from an automated build), teach how build systems detect dependencies in your code, what build tools are available (GitHub Actions, GitLab CICD, etc) to work with IBM i, and eventually how you can start using these tools.

Learning Objectives:
* Show how objects get built from a git repository
* Teach how build systems detect dependencies in your code
* How you can start using these tools
Speakers
avatar for Liam Allan

Liam Allan

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

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

4:00pm CDT

380: IBM i DevOps and Azure DevOps, Making It Work
EVALUATION
Managing IBM i native code with Azure Devops has huge opportunities for efficiency when managing business applications that span both platforms. If your company is Azure Devops everywhere but IBM i development this session will detail how you can hook these two platforms together for synchronous development and deployment with Azure pipelines. An added benefit is it makes the database directly available to .Net developers but you can still have a gatekeeper before the DB2 changes are deployed. Hear about how our experience of implementing our solution with Azure Devops at multiple customers.

Learning Objectives:
1. Planning workflow for IBM native code in the context of Azure devops
2. Integrating with Azure Devops pipelines for automation
Speakers
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Developers and managers who are interested in managing their native code with Azure Devops

4:00pm CDT

258: Power10 for the COMMON User
EVALUATION
Did you know that the entire IBM Power server family has now been refreshed with Power10 processor technology? Starting in September, 2021, IBM introduced the Power10 E1080 enterprise system and in July, 2022, IBM introduced the rest of the product family which includes the S1014, S1022/S1022s and S1024. IBM i customers need to know the capabilities and positioning of the entire Power server family, so attend this session to hear about the latest and greatest.
Speakers
avatar for Daniel Sundt

Daniel Sundt

IBM i Product Manager, IBM
Dan Sundt is an IBM i product manager. He has the responsibility for the IBM i business, including defining and guiding future directions and strategies. He works with the IBM i sales, marketing, and development teams as well as customers and partners to ensure that the IBM i operating... Read More →

Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Hardware
  • Session Level Intermediate
  • Audience Any IBM i customer on older hardware looking to upgrade their infrastructure

4:00pm CDT

201: IBM i Security Cocktail, with an SQL chaser
EVALUATION
In round 2 of this award-winning session, be prepared to hear Scott Forstie and Carol Woodbury shake up the world of IBM i Security once again, mixing up new SQL concoctions to bedazzle the otherwise boring world of IBM i Security. This menu includes examples of using SQL to find vulnerabilities in your code (aka penetration testing) as well as new (but practical!) ways to use SQL services. Even the most ardent security skeptic will be surprised at how just a sip of SQL can freshen up old IBM i Security processes. Before you know it, you’ll be sipping on the delightful features of SQL and rushing to pour out your current processes that have reached their ‘consume by’ date. A note of caution, however. You may leave a bit shaken (but not stirred) once again!

Learning Objectives:
1. Foundational knowledge of IBM i security
2. Why and how SQL is useful to the Security Officer and beyond
3. Have an idea of where to start and how
Speakers
avatar for Scott Forstie

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 →
avatar for Carol Woodbury

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 Cocktail with an SQL Chaser Round 2 PowerUp 2024 zip
Tuesday May 21, 2024 4:00pm - 5:00pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Award BRONZE
  • Digital Badge SQL
  • Audience Anyone tasked with understanding, improving, or auditing security on IBM i.

5:15pm CDT

185: Test Driven Development Using Python
EVALUATION
User Acceptance Testing should not be the only testing tool in your arsenal. Building a solid Python application is easy if you automate the boring testing process. In this session we’ll explore how easy testing can be in Python and how to get it done with several examples.

Learning Objectives:
1) Explore benefits of test Driven Development.
2) Work through a basic framework for architecting TDD.
3) Build an example case from scratch using Python and the unittest module.
Speakers
avatar for Mike Pavlak

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 →

Python TDD 2.0 pdf
Tuesday May 21, 2024 5:15pm - 5:35pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - Python
  • Session Level Intermediate
  • Audience Developers and syste architects looking to explore Python or TDD architecture

5:50pm CDT

260: Geospatial Analytics - What About Performance?
EVALUATION
Like any new offering, the Geospatial Analytics support features cool technology with lots of bells and whistles. When integrating a new technology like this into your applications, it's easy to focus just on the functional implementation and to overlook the performance considerations.

Learning Objectives:
In this session, learn how to streamline a Geospatial Analytics solution by leveraging the Geohash functionality and other advanced features.
Speakers
avatar for Kent Milligan

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 →

Geospatial Analytics What About Performance pdf
Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Database developer designing applications

5:50pm CDT

217: Use Value Stream Mapping to Improve Business Response
EVALUATION
When you are rolling out new applications, new features, tracking tickets, or enhancements how do you view this data? Sure, you can use a spreadsheet, maybe even view progress in each tool, or use a simple database, but why not use a dashboard with value stream mapping to pull 'live' information right into your preferred dashboard. This can pull everything together into an easy to use and comprehend visual reference. Stop by and find out how Value Stream Mapping can work for you.

Learning Objectives:
1) Find the delays in your pipeline.
2) Visualize how to find the hotspots.
Speakers
avatar for Alan Ashley

Alan Ashley

Presales Consultant for DevOps for IBMi, Arcad Software
When it comes to describing someone, even yourself, it can be difficult. This time it's easy. I grew up on the AS400, through iSeries, and into the IBM i world. Started on a model B50 (I know it was a B model) where the disk drive needed two persons to replace and now in the DevSecOps... Read More →

Tuesday May 21, 2024 5:50pm - 6:10pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Are you an application owner or project manager, then finding the delays is paramount in the DevOps cycle. VSM is the answer.
 
Wednesday, May 22
 

8:00am CDT

349: Looking at Your Data From a Different View Point
EVALUATION
Simon will explain how building SQL Views should become a part of your development strategy. He will give examples of the common ways he builds and uses Views to make his own and that of his team easier and simpler. Why do the hard work yourself when something else can do it for you?

Learning Objectives:
1. Why use Views
2. How to create a View
3. Deformalize your data for easy access
4. Create new derived & calculated data within the View
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →

Simon Hutchinson 349 Looking at Your Data From a Different View Point pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience People interested in modernizing their database, people who want to make their programming simpler & easier to understand

8:00am CDT

184: Live Demo: Deploying PowerHA and Independent ASPs
EVALUATION
See how to go from a single system, to a fully deployed PowerHA environment using IBM FlashSystems Global Mirror technology. We begin the journey by creating an Independent Auxiliary Storage Pool (IASP) along with techniques for migrating your application into the IASP. We will be doing a live role swap by the end of the hour.

Learning Objectives:
1. Learn how to deploy PowerHA with IBM FlashSystems Global Mirror
2. See how to synchronize security and configuration related objects across the environment
3. Understand how to migrate data and applications to an Independent Auxiliary Storage Pool (IASP)
Speakers
avatar for Brian Nordland

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 →

Deploying PowerHA pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Intermediate
  • Digital Badge HA/DR
  • Audience Anyone looking to implement PowerHA

8:00am CDT

240: How Do I Improve Software Quality?
EVALUATION
Every programmer wants to do the best job. How do you test your program and ensure that you aren't missing anything? From the simplest bug fix to large complex projects, there are key concepts that you can use to ensure that your program is properly tested.

This session is co-presented by expert developer, Scott Klement, and expert tester, Yvonne Enselman so that you can see things from both a developer and tester's perspective.

Learning Objectives:
1. What are the key points in the development process where testing should be considered?
2. How developers can identify the need for support from a tester or project manager.
3. How to minimize risk from software errors.
Speakers
avatar for Scott Klement

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 →
avatar for Yvonne Enselman

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
I am a Quality Assurance, Project Management, and Professional Services expert.Named IBM Champion 2024I have twenty-five years of experience in the IBM i industry starting in application development, transitioning through quality assurance, and into management. My passion has been... Read More →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Software developers who want to improve their quality.

8:00am CDT

149: Discovering your IBM i Data – For Security Administrators Issues
EVALUATION
There’s plenty information on IBM i that is so valuable for the daily tasks. Many commands, APIs, and SQL functions, let you gather information from your IBM i. You can exploit it online, or build your own database tables with it.

I like to dig into this info. There is always something new to discover. Particularly related to security administration activities: analyzing user profiles, object ownership and authorities, authority lists, program adoptions, exit programs implemented, exploiting audit journal entries, analyzing Db2 activities, and the list goes on and on. All this information is as valuable to IT System Managers, as it is enterprise information to Business executives. You need to understand, evaluate, and take advantage of this knowledge.

In this session we will review the different types of system information you can find on IBM i, that are important for Security Administrators. We’ll also analyze different case studies of how to interpret and prepare the info for future exploitation.

Learning Objectives:
Identify different kinds of Information available in your IBM i
Analyze different ways of obtaining and/or finding this information in your systems.
Prepare information for better use with modern tools.
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience Security Administrators and Security Auditors who need to find and exploit System Information related to Security

8:00am CDT

118: Daily Care and Feeding of IBM i
EVALUATION
IBM i and IBM Power Systems combine to deliver a fabulously reliable environment. The operating system has rich work management capability and strong error reporting. Despite that you shouldn't ignore it or you will eventually find yourself dealing with something serious. In this session we'll cover the things you need to watch and understand allowing you to deal with them before they become serious issues.

Learning Objectives:
1) Learn where to look and what to look for to know how your system is running.
2) Learn what to configure for automatic reporting of errors and problem.
3) Learn the points at which you need to begin to apply effort well before issues occur.
4) Be able to tell management: "Yes our IBM i is running well!"
Speakers
avatar for Larry Bolhuis

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 →

Daily Care and Feeding of IBM i pdf
Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Award GOLD
  • Audience This session is focused on the Developer who is suddenly handed the Admin hat and needs to know what the daily tasks of an Admin are.

8:00am CDT

211: Set up a Shared NFS Drive to Deploy PTFs and Upgrades with Image Catalogs
EVALUATION
Upgrading and PTFs is easy with Image Catalogs, but doing the same process on multiple LPARs can take a lot of redundant time and space. Learn how to use the mature and established support of NFS to create a single image catalog that multiple LPARs can use.

Learning Objectives:
1. Brief discussion of image catalogs and NFS
2. How to set up NFS with real world examples
3. Networking requirements and guidelines
Speakers
avatar for Jeffrey Carey

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 →

Wednesday May 22, 2024 8:00am - 9:00am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators who need to update and upgrade multiple systems, especially multiple LPARs on singe physical system.

8:00am CDT

271: IMGCLG, IFS, & FTP: Your BFFs for Getting your Data to the Cloud.
EVALUATION
Getting your production data to the cloud has many challenges, including method, additional storage, backup time, and transfer recovery time. There are 3rd party packages which will help with these but come at a cost. This session will cover methods using native IBM i functions to accomplish this. In addition, identify ways to significantly reduce the transfer time. Real life example how a 350GB full system backup transfer taking 61 hours was reduced to 9 hours. Tricks to reduce the time even more and minimize additional storage requirements.

Learning Objectives:
1. Learn different tools and methods of getting you data to the cloud, including Image Catalogs and FTP.
2. Using native IBM i tools, understand different ways to reduce the data and time needed to get your data to the cloud.
Speakers
avatar for Rob Mineo

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 8:00am - 9:00am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators and anyone responsible for getting IBM i data to the cloud or transferring data between systems.

9:15am CDT

328: End-to-End Development: Modern IBM i Development Stack
EVALUATION
In this talk, we’ll look at everything from development tools, build systems, to deployment methods. Finally there is a complete open source stack from IBM to use git and easily deploy ILE code (RPG, COBOL, you name it!) and this will cover them. We will look at the end-to-end lifecycle for IBM i applications when stored in git - all the way from the developers, to the end users machine automatically.

Learning Objectives:
* Understanding what a modern development lifecycle looks like
* How modern lifecycles look when running on IBM i
* Seeing the available open-source tools to accomplish automated deployments
Speakers
avatar for Liam Allan

Liam Allan

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

Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  DevOps
  • Session Level Intermediate
  • Audience Customers who want to use git, automate builds and automate deployments

9:15am CDT

147: The Power of Ready - Lessons Learned from Actual Disasters
EVALUATION
Our businesses today demand up-time, and reliability to move product and deliver services. Can your IBM i survive a sudden, unplanned event? Learn from multiple computer room, Cloud, and regional disasters, to know your DR Solution works in an actual Disaster. People, Technology and Geography are common critical points of failure. Lets keep our mistakes Original !

Learning Objectives:
Speakers
avatar for Richard Dolewski

Richard Dolewski

VP, Enterprise Solutions, Connectria
Richard is a recognized SME and award-winning industry speaker specializing in, Cloud Computing Architecture, Business Resiliency, Disaster Recovery Planning and Backup & Recovery Program Design. He leads organizations through the new era of technology, achieving the desired, successful... Read More →

272 Power of Ready PowerUp Dallas Final pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

9:15am CDT

218: Using RDi to Refactor RPG Code
EVALUATION
The best way to protect your investment in the IBM i is by transforming your applications into a "Next Generation" architecture. This session demonstrates how RDi accelerates this process and provides an agile approach to modernizing/refactoring RPG Code

Learning Objectives:
Best Practices and examples for the following will be covered:
1) How to use the refactoring capabilities of RDi
2) Moving from Fixed to Free Format RPG
3) How to extract business logic into procedures using RDi
4) Implementing a Database Abstraction Layer"
Speakers
avatar for Ray Everhart

Ray Everhart

Senior IBM i Analyst and X-Analysis Product Manager, Fresche
For over 30 years, Ray has helped companies understand, develop and manage their RPG, COBOL and CA 2E application environments. He also specializes in helping clients enhance and modernize their systems to meet evolving business demands and take advantage of digital transformation... Read More →

Wednesday May 22, 2024 9:15am - 10:15am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

9:15am CDT

131: Cool things in Navigator to be a RockStar System Administrator
EVALUATION
IBM Navigator for i is a powerful new tool to better manage your i environment. Get expert advice for installation and set up to make sure you get this powerful tool up and running at peak efficiency. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Learn ways to protect your system from intrusions, as well as close security holes such as FTP. See how this tool can help you select and install Logical files on your system to improve performance. Learn about the enhancements to this valuable tool in the latest release, while we see how this tool provides tips and techniques for better and more easily managing your IBM i.

Learning Objectives:
1) Learn how to close down various TCP/IP servers like FTP from intruders. 2) How to use the Index Advisor to improve performance. 3) Identify if someone is trying to access your IBM i with Intrusion Detection. 4) Performance Management graphs.
Speakers
avatar for Pete Massiello

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 →

Cool things in Navigator for IBM I to be a Rock Star System Administrator 2024 pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management

9:15am CDT

353: Using SQL to Help Keep Your System Clean
EVALUATION
Have you recently taken over responsibility for a LPAR? Or are you concerned there is too much “rubbish” on your systems? Use these techniques to identify the most common wastes of space you have, & plan your cleanup efforts.

Learning Objectives:
1. How to identify the big three “wasters” of space
2. Simple ways to clean this up
3. How to monitor that this does not happen again
Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon Hutchinson has been writing his highly acclaimed IBM i blog, RPGPGM.COM, for eleven years sharing his knowledge, experience, and giving many detailed examples of the latest RPG, SQL, and CL. His work has led him to be recognized by IBM as an IBM Champion for Power and IBM i Community Advocate. He is a subject matter expert for COMMON North America and... Read More →

Simon Hutchinson 353 Using SQL to Help Keep Your System Clean pdf
Wednesday May 22, 2024 9:15am - 10:15am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Digital Badge SQL
  • Audience Any system admin or anyone who is responsible for a LPAR looking to increase the amount of available space, & reduce the amount of old & unneeded “stuff” taking up that space.

10:30am CDT

392: API Enable Your Database
EVALUATION
How important is delivering business data to your users and customers? I’d bet it’s among the top concerns of any development effort. How do you deliver data in the modern world? Rest API are one of the most common methods. We’ll explore, though live demos, how to expose data in a safe and secure manner using Integrated Web Services (IWS). Our focus will be on directly leveraging the database, not using RPG or Service program.

Learning Objectives:
1. How to exose data using Select, Insert, Update, and Delete statements
2. How to expose data using SQL Stored Procedures
Speakers
avatar for John Westcott

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 →

392 API Enable Your Database pdf
Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience SQL developers delivering data to any part of the business

10:30am CDT

338: DB2 Mirror - Logistics for 400K trucks - Driving Business Outcomes
EVALUATION
Transflo generates over 3.2M downloads to equip over 400,000 truck drivers 7 x 24 with all the features they need for their workday. Near zero downtime was the only way to keep the fleets connected and moving around the clock. This CASE Study will present through the eyes of the customer a roadmap : IBM lab DB2 Assessment, building a reference architecture, implementation, testing failover and day to day management for DB2 Mirror.

Learn how Transflo leveraged an IBM Cloud On Net solution by staying on IBM Power Technology connected to AWS and Azure. The solution enabled Transflo to scale easily, reach best-in-class system availability.

Learning Objectives:
1. Gain insight into the critical step for a successful DB2 Mirror Implementation
2. Explore operational testing with DB2 Mirror
3. Stay-up-to-date with the latest new features available for DB2 Mirror
Speakers
avatar for Richard Dolewski

Richard Dolewski

VP, Enterprise Solutions, Connectria
Richard is a recognized SME and award-winning industry speaker specializing in, Cloud Computing Architecture, Business Resiliency, Disaster Recovery Planning and Backup & Recovery Program Design. He leads organizations through the new era of technology, achieving the desired, successful... Read More →
avatar for Scott Forstie

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 →

338 DB2 Mirror – Logistics for 400K Trucks Final pdf
Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience

10:30am CDT

216: Test Data Management : Are You Compliant?
EVALUATION
When it comes to testing, training, or even disaster testing, often real data is used. This may be the entire set of tables of production or a subset, but it's real data. Real private personal information. With the European GDPR or the CCPA out of California, protecting this data is now more than keeping a hacker away. It's about protecting the bottom line and away from fines. This is where you need to use anonymization to mask your data so that it's usable and masked.

Learning Objectives:
1) Are you compliant with PII policies?
2) Is your data exposed in non-production environments.
3) Do you know the difference in anonymization and pseudoanonymization.
4) Data Extraction
5) Using temporary environments
Speakers
avatar for Alan Ashley

Alan Ashley

Presales Consultant for DevOps for IBMi, Arcad Software
When it comes to describing someone, even yourself, it can be difficult. This time it's easy. I grew up on the AS400, through iSeries, and into the IBM i world. Started on a model B50 (I know it was a B model) where the disk drive needed two persons to replace and now in the DevSecOps... Read More →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience If you are an application owner, security admin, or an auditor, then understanding the possible expose in non-production environments is key. This session will cover those questions and answers to protect those environments.

10:30am CDT

389: Fortify and Conquer: Secure Coding Strategies for IBM i Developers
EVALUATION
Embark on an exploration of IBM i security challenges as we navigate the dangerous landscape of common vulnerabilities on IBM i. Don't miss the chance to fortify your coding skills and conquer the challenges of secure IBM i development!

In this session tailored for ILE developers (including RPG and CL developers), we'll dissect real-world examples of security pitfalls in our sample software, exploring issues like object authority, adopted authority, and library list vulnerabilities. Discover actionable solutions that empower you to reinforce your IBM i code so it is ready to face threats lurking in the wild.

Learning Objectives:
1. Learn from correcting real-world examples of vulnerabilities in a set of sample applications.
2. Understand the basics of creating more secure software on IBM i.
Speakers
avatar for Brian Nordland

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 →

Wednesday May 22, 2024 10:30am - 11:30am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience IBM i software developers

1:30pm CDT

302: Database Modernization An Evolution not a Revolution
EVALUATION
Modernizing applications and neglecting the database? Think converting from DDS to DDL is enough database modernization? It may be enough, although there’s more to the database than the way it’s defined. This session explores database modernization techniques from an evolution perspective for continuous change. And, how that type of database modernization compliments application modernization.

Learning Objectives:
Speakers
avatar for John Westcott

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 →

302 Database Modernization – An Evolution not Revolution pdf
Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Anyonme intereted in database moderization

1:30pm CDT

107: Why Wait? Discover the Power of IBM i Wait Accounting
EVALUATION
IBM i wait accounting is a powerful capability to determine what your jobs are doing when they are not using the CPU. This session will review wait accounting and how Collection Services data can provide insight into your wait times. It will then focus on how to use Job Watcher, the power of the data it provides, and how to leverage Performance Data Investigator (PDI) to analyze the data.

The presentation will work through example scenarios, showing performance graphs and describing what those graphs tell you. These examples will reinforce how you can use Job Watcher data in combination with PDI to analyze your performance data and resolve issues in your own environment

This session will reveal the power of IBM i wait accounting and the insight it can provide so you can optimize the performance of your applications and system environment.

Learning Objectives:
You will learn about IBM i Wait Accounting and how to use wait information and Job Watcher to improve the performance of your system and/or applications.
Speakers
avatar for Dawn May

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 →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience Systems administrators responsible for managing their IBM i partitions, and in particular, managing performance. Application developers interested in using wait accounting to optimize the performance of their applications.

1:30pm CDT

134: Discovering your IBM i Data - For System Administrators issues
EVALUATION
There’s plenty information on IBM i that is so valuable for the daily tasks. Many commands, APIs, and SQL functions, let you gather information from your IBM i. You can exploit it online, or build your own database tables with it..

I like to dig into this info. There is always something new to discover. Particularly related to system administration activities: analyzing object sizing, resolving lock conflicts, obtaining job statistics, documenting TCPIP configurations, checking backup activities, investigating PTFs installed, and the list goes on and on.. All this information is as valuable to IT System Managers, as it is enterprise information to Business executives. You need to understand, evaluate, and take advantage of this knowledge.

In this session we will review the different types of system information you can find on IBM i, that are important for System Administrators. We'll see how to interpret and prepare the info for future exploitation.

Learning Objectives:
Identify different kinds of Information available in your IBM i.
Analyze different ways of obtaining and/or finding this information in your systems.
Prepare information for better use with modern tools.
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators and Technical Advisors who need to find and exploit System Information

2:45pm CDT

187: Streamline your SQL Routines
EVALUATION
The SQL procedural language makes it easy to create your business logic in stored procedures, triggers, and user-defined functions. Each of these routines have options that performance, but most programmers usually take the default option values without giving any thought to their impact. Learn about these overlooked performance options and other procedural language coding best practices.

Learning Objectives:
Speakers
avatar for Kent Milligan

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 →

Streamline SQL Routines pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience Developers, data base engineers, performance analysts

2:45pm CDT

267: Open Source WALSTIB
EVALUATION
The floodgates of Open Source via PASE on IBM i opened up about a decade ago. Where were we, where have we been, where are we now, where are we going, and how did we find ourselves in this handbasket? Presentation and open discussion of What A Long, Strange Trip It's Been.

Learning Objectives:
1. What has been the impact of open source becoming prevalent on IBM i PASE?
2. What have we learned to do, and what have we learned not to do?
3. What should we do next?
Speakers
avatar for Jack Woehr

Jack Woehr

Senior Engineer, Absolute Performance, Inc.
Author of Ublu, an open source remote language for IBM i. A Quantum Computing enthusiast, Jack is an IBM Qiskit Advocate, 2021 IBM Champion, 2022 IBM Champion, 2023 IBM Champion, and 2024 IBM Champion.A consulting programmer with over 30 years' experience in open source specializing in open source based IBM i modernization... Read More →

OpenSourceWALSTIB pdf
Wednesday May 22, 2024 2:45pm - 3:45pm CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools
  • Session Level Intermediate
  • Audience Open source users who with enough experience to make some judgement calls.

2:45pm CDT

395: Building APIs with Jakarta (Java)
EVALUATION
Speakers
avatar for Adam Shedivy

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 2:45pm - 3:45pm CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Programming - General

2:45pm CDT

142: Take Control of Your IBM i Prestart Server Jobs
EVALUATION
Prestart jobs are used to service requests from clients in the network. There are many uses of prestart jobs on IBM i, the most common is the database server. Prestart jobs present many challenges for how to understand what is happening on the system, what work requests these jobs are handling, and generally how to manage them. This session will review all the key characteristics of prestart jobs, provide many tips to better understand what is happening on your system, and review how you can use subsystem configuration to better manage your prestart jobs.

Learning Objectives:
The attendee will learn how to better manage prestart server jobs. The topics are many, but will include managing job logs and output, using Watches to debug intermittent problems, determining what the job is doing, including the SQL statement the job is running, how to determine the rate at which prestart jobs are being used and reused, subsystem configuration for prestart jobs, and much more.
Speakers
avatar for Dawn May

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 →

Wednesday May 22, 2024 2:45pm - 5:00pm CDT
Meeting Room 201B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators in environments with a lot of remote database access that uses either the QZDASOINIT or QSQSRVR jobs.

4:00pm CDT

393: Visual Explain - IBM's SQL Performance Show-&-Tell
EVALUATION
For many years now IBM have positioned SQL as the primary interface to the database on IBM i. At the same time, new capabilities are being added only to SQL, not to the native database interface.

We need a different tool to understand and analyze query implementation plans and feedback from the optimizer – the SQL component that determines the most effective way to deliver the data we ask for in SQL statements. Visual Explain is just such a tool, and it both shows us graphically what plan the optimizer has chosen, as well as tells us details about each step along the way. It can also give us suggestions on ways to improve performance of our queries.

Learning Objectives:
1. A brief description of optimization with SQL
2. The several ways of invoking Visual Explain
3. The various panes of the Visual Explain window
4. Some features of Visual Explain for managing how it behaves
5. Examples of improved performance after using suggested changes
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior software engineer for the Pest Elimination division of Ecolab. He serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Database

4:00pm CDT

241: How Refactoring Helps Bulletproof Your Application
EVALUATION
Do you (or does your manager) doubt the value of refactoring your code into a modular design? This session goes in-depth about how you save time and create higher quality programs by refactoring into small, independent routines. We will discuss how this improves your ability to test and maintain your application over time, saving you tons of time in the long run.

This session is co-presented by expert developer, Scott Klement, and expert tester, Yvonne Enselman to help you see it from both perspectives.

Scott and Yvonne are the coolest people you'll ever meet. If you don't come to this session, you'll be very very sad.

Learning Objectives:
1. How refactoring into a modular design saves you time in maintenance.
2. How refactoring into a modular designed simplifies and expedites the testing process.
3. How much better your life will be.
Speakers
avatar for Scott Klement

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 →
avatar for Yvonne Enselman

Yvonne Enselman

Principal Architect for Quality Assurance on IBM i, Yvonne Enselman Professional Services
I am a Quality Assurance, Project Management, and Professional Services expert.Named IBM Champion 2024I have twenty-five years of experience in the IBM i industry starting in application development, transitioning through quality assurance, and into management. My passion has been... Read More →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Intermediate
  • Audience Programmers who want fewer headaches.

4:00pm CDT

221: PHP Today and Tomorrow
EVALUATION
PHP has come a LONG way since it's inception as a quick and dirty web scripting solution. PHP also stands the test of time more than many other technologies given is wide adoption and adaptable roadmap. In this session we'll catch you to current PHP features and standard and get a glimpse into the future of the web scripting language that runs more than 75% of the known web.

Learning Objectives:
1. Review some the latest features of PHP.
2. Explore where PHP is headed
Speakers
avatar for Mike Pavlak

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 →

PHPPastPresentFutureV6.3 pdf
Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 103A 1508 Houston St, Fort Worth, TX 76102
  Programming - PHP
  • Session Level Intermediate
  • Audience Experienced PHP developers and those looking to compare other languages to PHP

5:15pm CDT

178: Handling JSON With DATA-INTO and DATA-GEN in ILE RPG
EVALUATION
Two of the most significant features added to ILE RPG recently are the DATA-INTO and DATA-GEN opcodes. The most common use case is to read and/or create JSON files.

Since JSON has become crucial to IBM i businesses, these are must-know features!

Learning Objectives:
1, Learn the basics of the JSON format.
2. Learn about DATA-INTO and how to use it.
3. Learn about DATA-GEN and how to use it.
Speakers
avatar for Scott Klement

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 →

Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG

5:15pm CDT

403: SQL for System and Storage Management
EVALUATION
Speakers
avatar for Ryan Moeller

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.
avatar for Ann Wilkerson

Ann Wilkerson

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

SQL for Storage and Systems Management pdf
Wednesday May 22, 2024 5:15pm - 6:15pm CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Systems Management
 
Thursday, May 23
 

8:00am CDT

269: SQL Error Logging Facility (SELF)
EVALUATION
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 →

POWERUp SELF SQL Error Logging Facility Birgitta Hauser pdf
POWERUp SELF SQL Error Logging Facility Birgitta Hauser sql
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.

8:00am CDT

136: IBM i Network Monitoring, Diagnostics and Troubleshooting
EVALUATION
The IBM i OS network communications has changed a lot since the AS/400 primarily communicated to workstations and printers using Twinax and to other computer systems using specialized communications lines. In some ways things are more complex because our IBM i OS systems communicate to a lot of other devices in many different ways, but in other ways things are simpler today because nearly all network communications are built on top of the foundation of Ethernet and TCP/IP. Your IBM i OS Networking health is very important and is it how most of your data and applications are accessed. This session will take a look at approaches to monitoring this IBM i OS Networking health and it's interaction with the network, how to collection diagnostic data and how to troubleshoot problems.

Learning Objectives:
Speakers
avatar for Wayne Bowers

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 →

NetworkDiag PowerUp24 pdf
Thursday May 23, 2024 8:00am - 9:00am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Networking
  • Session Level Intermediate
  • Award GOLD
  • Audience IBM i OS and Network Engineers looking to better address networking questions from and IBM i OS perspective.

8:00am CDT

135: Optimizing Batch Processing with SQL
EVALUATION
Native file processing has been used for years, showing to be a very strong yet simple way of accessing, analyzing, and maintaining data in IBM i. Time has passed since the appearance of SQL in the platform, and it is still looked by many traditional developers as “too modern, complex, not that easy”. I’ve been working on batch processing optimization, and found that the replacement of traditional file processing with SQL processing has many performance advantages. Also permits the use of many features that can replace part of program logic.

In this session we’ll walk thru some case studies, and show you how SQL can help in optimization issues.

Learning Objectives:
1- Identify potential programs that need to be optimized
2- Learn the basics of replacing native file processing with SQL
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Thursday May 23, 2024 8:00am - 9:00am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Programming - General
  • Session Level Intermediate
  • Digital Badge SQL
  • Audience Development people who have performance issues in native long running programs

8:00am CDT

202: IoT: Open My Garage Door with RPG
EVALUATION
IoT is a big deal in IT today. Since RPG can call and host REST APIs, you can integrate it with IoT devices. For my first project, I decided to see if I could use RPG's "open" and "close" opcodes to open and close my garage door -- and it worked!

In this session I will show you how I integrated my RPG program with the Raspberry Pi, and talk about how the Raspberry Pi and similar devices can play a big part in the future of business applications.

Learning Objectives:
1. Learn the basic concept of Raspberry Pi (and other single-board computers)
2. Learn why physical computing and IoT are important.
3. Learn about integrating IoT with RPG programs.
Speakers
avatar for Scott Klement

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 →

Thursday May 23, 2024 8:00am - 9:00am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience Experienced RPG developers who are interested in physical computing, IoT, automation, etc.

8:00am CDT

252: What Does a Full-Featured Security Strategy Look Like?
EVALUATION
In this session, you will learn about the many aspects that an IBM i Security suite product will cover. This includes multi factor authentication (MFA), auditing and SEIM features, access control, authority elevation, and more.

Learning Objectives:
1. You will know what to look for when you consider adding a security product to your IBM I IT infrastructure.
2. You will learn how to take a holistic approach to IBM i Security
3. You will understand all the components to be considered for a comprehensive, effective security strategy for IBM i
Speakers
avatar for Boris Breslav

Boris Breslav

Principle Technology Architect, Precisely
Boris is a Principle Technology Architect for the Assure Security product at Precisely where he's helping to architect security solutions for IBM i. Boris started his career in IT security in the year 2000 as a Windows and IBM i developer in a start-up named Bsafe (later known as... Read More →

What Does a Full Featured Security Strategy Look Like COMMON 2024 pdf
Thursday May 23, 2024 8:00am - 9:00am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience IBM i professionals who must address Security requirements for their IBM i systems will benefit from this session.

9:15am CDT

242: Fun with JSON Publishing: Letting SQL Do the Dirty Work
EVALUATION
If you've ever been tasked as a developer with creating complex responses for an internal or external web service, you've likely explored multiple avenues for generating JSON from your IBM i programs. From constructing responses manually in your RPG code, to using various publicly available toolkits like YAJL, RPG NextGen, etc., there are a myriad of ways to create JSON strings with all the requisite curlies, commas, colons, quotes and hard brackets.

If you're on IBM i OS 7.2 or higher, there's yet another avenue you can explore in which you let SQL do the JSON construction work for you. The biggest benefit of this approach becomes most apparent when your JSON response requires arrays, and especially nested subarrays. Coding such responses can be a bit tedious when done on a record-by-record basis in your program, whereas by using some nifty functions you can can let SQL assemble your JSON response automatically.

In this session we'll review the basics of JSON publishing functions such as JSON_Object, JSON_Array, JSON_ObjectAgg and JSON_ArrayAgg. We'll explore some practical use examples for publishing your business data in JSON, letting SQL do all the dirty work.

Learning Objectives:
1. Learn the syntax of the most commonly used SQL JSON publishing functions
2. Understand the differences between a standard SQL select statement and an SQL statement constructing a JSON response
3. See how to integrate these SQL functions into an RPG program
Speakers
avatar for Robert Swanson

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 →

JSON Publishing Let SQL do the Dirty Work pdf
Thursday May 23, 2024 9:15am - 10:15am CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Digital Badge SQL
  • Audience Developers looking to create intricate JSON responses for web services or various JavaScript frameworks.

9:15am CDT

110: Live Demo: Managing PowerHA Solutions
EVALUATION
PowerHA provides complete high availability (HA) solutions for IBM i customers with both internal storage and external storage environments. This interactive demo session will explain the concepts required to manage PowerHA environments, as well as give live demonstrations of the key management tasks used in a PowerHA environment.

Learning Objectives:
1. Learn the basic concepts required to configure a PowerHA environment.
2. Understand how to manage a PowerHA environment and see it in action
3. See tools within PowerHA that help your environment stay secure
Speakers
avatar for Brian Nordland

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 →

ManagingPowerHA pdf
Thursday May 23, 2024 9:15am - 10:15am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  High Availability Resilience
  • Session Level Intermediate
  • Digital Badge HA/DR
  • Audience Those wanting to see PowerHA in action from a day to day management perspective to see just how easy it can be.

9:15am CDT

111: Integrated File System: Real Life
EVALUATION
The integrated file system has become more integrated into every day processing for many customers over the years. The other integrated file system sessions discuss technical details of what it is and the different functional support provided. This session will discuss real life scenarios of file system usage and some common problems experienced by customers.

Learning Objectives:
Understand some of the common problems experienced with the file systems and solutions to those problems
Speakers
avatar for Margaret Fenlon

Margaret Fenlon

Software Engineer, IBM
Margaret started working for IBM in 1983 on the S/36. From 1986-1994 she worked in various areas of what is now the IBM i including Authorization Management support of POSIX and the integrated file system. She worked on the port of SAP R/3 from 1994-1997. In 1998 Margaret joined the... Read More →

IntegratedFileSystemRealLife 2024 pdf
Thursday May 23, 2024 9:15am - 10:15am CDT
Room 202 C-D 1508 Houston St, Fort Worth, TX 76102
  IFS
  • Session Level Intermediate
  • Audience System administrators and application developers that have experience with the integrated file system or have attended the other integrated file system sessions.

9:15am CDT

424: Creating New Tests for Existing Applications
If you’ve ever been asked to create tests for an application that has been in production for years, but has few to no documented requirements, this session will give you a methodology for approaching the challenge.

Learning Objectives:
  • What needs to be in your test environment
  • What data drives the application logic
  • How to leverage Tribal Knowledge for requirements
  • Measuring your test coverage
  • What resources are available to provide application understanding
Speakers
avatar for Ray Everhart

Ray Everhart

Senior IBM i Analyst and X-Analysis Product Manager, Fresche
For over 30 years, Ray has helped companies understand, develop and manage their RPG, COBOL and CA 2E application environments. He also specializes in helping clients enhance and modernize their systems to meet evolving business demands and take advantage of digital transformation... Read More →

Thursday May 23, 2024 9:15am - 10:15am CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Program Testing
  • Session Level Intermediate
  • Audience Developers and Quality Assurance Professionals

9:15am CDT

125: Expand and Simplify RPG Using MI Functions
EVALUATION
There are many MI functions that can safely be used in RPG programs. These functions give us the ability to do things we could not do easily or at all in what RPG gives us.

Learning Objectives:
1. How to read the MI documentation
2. How to prototype MI functions
3. Some useful examples of MI functions for everyday development
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior software engineer for the Pest Elimination division of Ecolab. He serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

Expand and Simplify RPG Using MI Functions 2up pdf
Thursday May 23, 2024 9:15am - 10:15am CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG

9:15am CDT

381: Breaking Up a Monolith
EVALUATION
Every RPG shop has them. Most developers avoid them like the plague. Large monolithic programs are a significant source of technical debt in all RPG shops. They limit your agility which in turn is detrimental to your business. So, once you are ready to deal with the issue, where do you start? There is no one answer, but there are steps you can take to begin dismantling and repurposing the code within these behemoths.

Learning Objectives:
1. Discuss steps to refactoring monolithic RPG programs
2. Learn common pitfalls to avoid
3. Learn how to organize extracted procedures for ease of use
Speakers
avatar for Brian May

Brian May

Vice President of Product Management, Profound Logic
Professional IT Leader, Speaker and WriterSpecialties:Team Building, Development and RetentionTechnical SalesSolutions ArchitectureSoftware DevelopmentEnterprise Systems Manufacturing ProcessesApparel IndustryAccounting Principles

Breaking A Monolith pdf
Thursday May 23, 2024 9:15am - 10:15am CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience RPG developers and managers wanting to eliminate monolithic code from their applications.

9:15am CDT

141: Configuring Single Sign-on for IBM i
EVALUATION
IBM i has the capability to participate in a single sign on environment. What is single sign on? Single sign on is an authentication process where a user can access various applications in the network using one set of login credentials. This presentation will describe the Kerberos protocol and how to map a domain user ID to an IBM i user profile to safely authenticate the user to an enabled network application without passwords being sent across the network.

Learning Objectives:
Learn about the Kerberos protocol and how to configure IBM i to take advantage of the protocol and enable single sign-on.
Speakers
avatar for Robert Andrews

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 →

Single Sign On Overview for IBM i pdf
Thursday May 23, 2024 9:15am - 10:15am CDT
Meeting Room 101 1508 Houston St, Fort Worth, TX 76102
  Security
  • Session Level Intermediate
  • Audience IBM i System Administrators, Windows Administrators, and Network Administrators

10:30am CDT

422: From Quick Wins to Full Transformation Success: Navigating Application Modernization and UI Enhancement
EVALUATION
Application modernization, customization and enhancement includes two main components: Presto and code transformation. The transformation process involves identifying programs to be updated, using a product to convert the existing code. However, this initial transformation is not the final step; additional refinement and "massaging" of the code, referred to as "delivery," is needed.

The backend development ensures the application's functionality, but there is also a focus on the frontend design, such as button colors, fonts, and dealing with constraints from the transformed code, particularly from an RPG or COBOL background. We will cover what is achievable with the user interface (UI), highlighting the possibilities and constraints.

This conversation will highlight the importance of long-term planning from quick wins to full transformation, ensuring that the transition is smooth for end users.


Speakers
avatar for Chris Koppe

Chris Koppe

SVP Strategy Services, Fresche Solutions
Chris Koppe is responsible for developing client transformation strategies at Fresche Solutions. He has led the development of legacy management strategies for hundreds of companies, across a variety of platforms, languages, databases, and technologies. This insight has allowed Chris... Read More →
avatar for Scott Gingerysty

Scott Gingerysty

Team Lead, Web Application Services, Fresche Solutions
I am a Senior Web Developer/Team Lead and Application Modernization expert at Fresche. I am passionate about IBM i application modernization. Since 2013, I have added new life into business-critical RPG applications using web technology. Whether it is a new development, augmenting... Read More →

Thursday May 23, 2024 10:30am - 11:30am CDT
Meeting Room 203B 1508 Houston St, Fort Worth, TX 76102
  Programming - UI

10:30am CDT

236: Advanced IBM i Services (SQL) for Admins
EVALUATION
In this followup session to "Intro to IBM i Services (SQL) for Admins" we dig deeper into the capabilities of IBM i Services. This session will cover more complex and powerful use cases for monitoring, automation, and system administration.

Learning Objectives:
1. Join data from multiple IBM i Services to create ""SuperTools""
2. Use QCMDEXC() scalar function (what's that??)
3. Create your own User Defined Function (UDF)"
Speakers
avatar for Steve Riedmueller

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 Advanced pdf
PU24 IBM i Services Advanced Scripts zip
Thursday May 23, 2024 10:30am - 11:30am CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Systems Management
  • Session Level Intermediate
  • Audience Administrators with some SQL experience who want to take their knowledge and skills to the next level.

10:30am CDT

405: Power Virtualization & HMC
EVALUATION
Speakers
avatar for Bob Kovacs

Bob Kovacs

IBM Power Product Manager - Virtualization, IBM

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

1:30pm CDT

259: Simple Steps to Improving Data Security on IBM i
EVALUATION
Db2 for i offers a wide range of built in security capabilities allowing you to better secure your data. Learn how to quickly utilize these capabilities to not only understand how to secure your data, but to better secure your data. And, to ensure compliance via auditing.

Learning Objectives:
During this session we will cover a wide range of security and compliance methods including row permissions and column masks used to control access to data and enforce separation of duties, authority collection used to determine the lowest level of security needed by a user, audit journals used to audit the effectiveness of your security solutions, and IBM i services which can be used to quickly accomplish security tasks, including automating security policies. This session will include many examples that you will be able to take home and use right away.
Speakers
avatar for John Westcott

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 →

259 Simple Steps to Improving Data Security on IBM i pdf
Thursday May 23, 2024 1:30pm - 2:30pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Intermediate
  • Audience The database engineer looking for security and compliance options.

1:30pm CDT

154: Discovering your IBM i Data – For Development Issues
EVALUATION
There’s plenty information on IBM i that is so valuable for the daily tasks. Many commands, APIs, and SQL functions, let you gather information from your IBM i. You can exploit it online or build your own database tables with it.

I like to dig into this info. There is always something new to discover. Particularly related to developer activities: analyzing program definitions and relationships, file and field definitions, object and source cross references, SQL definitions, triggers and constrains implemented, and the list goes on and on. All this information is as valuable to IT System Managers, as it is enterprise information to Business executives. You need to understand, evaluate, and take advantage of this knowledge.

In this session we will review the different types of system information you can find on IBM i, that are important for Developers. We’ll also analyze different case studies of how to interpret and prepare the info for future exploitation.

Learning Objectives:
1. Identify different kinds of Information available in your IBM i.
2. Analyze different ways of obtaining and/or finding this information in your systems.
3. Prepare information for better use with modern tools.
Speakers
avatar for Cecilia Howlin

Cecilia Howlin

Owner, PYRAMIS S.R.L.
Cecilia Howlin has been working on this platform from the very beginning. On her first job at IBM Argentina, she learned S/38. And never left the platform, since she thinks it never appeared other operating system as good as this one.She usually worked on technical issues, like installing... Read More →

Thursday May 23, 2024 1:30pm - 2:30pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools
  • Session Level Intermediate
  • Audience Especially valuable for IT Developers. It may also be of interest to Security Auditors, and Technical Advisors

1:30pm CDT

159: One Order of Code Factoring With a Side of RDi
EVALUATION
Sloppy code, beautiful code. They both produce the same results, so who cares how it looks? If you have heard this before, or are living with this scenario, this is a MUST ATTEND session. Learn about code refactoring (aka "modernization") and see how to rejuvenate old code into maintainable, flexible and scalable components.

Learning Objectives:
Speakers
avatar for Charlie Guarino

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 →

Thursday May 23, 2024 1:30pm - 2:30pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programmer Tools

1:30pm CDT

238: Ransomware and IBM i
EVALUATION
Today, there are no known ransomware viruses that run directly on IBM i. However, that does not mean that the IBM i is not at risk. In this practical session, you will learn how to keep your IBM i system safe from Ransomware attacks. Don't miss this critical session!

Learning Objectives:
1. Understanding ransomware and how it can effect the IBM i
2. Know how to secure the IBM i from ransomware attacks
3. Link to resources for further details
Speakers
avatar for Robert Andrews

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 →

Ransomware and IBM i pdf
Thursday May 23, 2024 1:30pm - 2:30pm CDT
Meeting Room 201A 1508 Houston St, Fort Worth, TX 76102
  Security

2:45pm CDT

174: SQL for the RPG Programmer “How To”: SQL Access to Data and ACS Tools
EVALUATION
SQL is THE recommended interface from applications into your data. It is imperative to understand how to embed SQL or otherwise interface to SQL from RPG. We also need tools to enhance our use of SQL in our applications.

Learning Objectives:
1. Learn the basics of embedding SQL in RPG
2. Discover how RDi and ACS cooperate to enhance using SQL in our applications
3. Examine features in ACS that can have an impact on RPG development
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a senior software engineer for the Pest Elimination division of Ecolab. He serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for... Read More →

SQL for the RPG Programmer “How To” SQL Access to Data and ACS Tools 2up pdf
Thursday May 23, 2024 2:45pm - 3:45pm CDT
Meeting Room 204A 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
  • Session Level Intermediate
  • Audience RPG developers who want to see the ever-expanding opportunities SQL offers in their applications

4:00pm CDT

400: Exploring Licensing on the IBM i Platform
EVALUATION
Can I transfer this license? Is this license part of group SWMA? Can I move this license?
We receive a variety of licensing questions on a regular basis and we’d like to share some of the most recent questions and our responses in addition to an overview of some to licensing terms and definitions we have as part of the platform.
Speakers
avatar for Douglas Gibbs

Douglas Gibbs

IBM i Product Manager, Program Director, IBM
Douglas Gibbs is the offering manager for IBM Power Systems I/O and works closely with the overall Offering Management, Sales and Development teams regarding all manners of I/O. Douglas has worked in the IT Industry for more than 25 years and has been in a variety of positions at... Read More →

Thursday May 23, 2024 4:00pm - 5:00pm CDT
Meeting Room 203C 1508 Houston St, Fort Worth, TX 76102
  IT Strategy

4:00pm CDT

291: Simplify Your Life with SQL Services
EVALUATION
There are so many services in SQL on our platform. They can make your life a bit simpler. I will show a few services and show how they are done within SQL.

Learning Objectives:
will leave with new ideas about how they can try new services when they get home.
Speakers
avatar for Sven Jansson

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 →

Thursday May 23, 2024 4:00pm - 5:00pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Programming - RPG
 
Filter sessions
Apply filters to sessions.
Monday, May 20
Tuesday, May 21
Wednesday, May 22
Thursday, May 23
Ballroom B, 2nd Floor
Billy Bob's Honky Tonk
Exhibit Hall A, First Floor
Meeting Room 101
Meeting Room 102
Meeting Room 103A
Meeting Room 201A
Meeting Room 201B
Meeting Room 201C
Meeting Room 203A
Meeting Room 203B
Meeting Room 203C
Meeting Room 204A
Meeting Room 204B
Room 202 A-B
Room 202 C-D
  • AI
  • Client Connectivity
  • Database
  • Developing Business Skills
  • DevOps
  • Hardware
  • High Availability Resilience
  • IFS
  • IT Leadership and Management
  • IT Strategy
  • Middleware (other)
  • Networking
  • Personal Development
  • Program Testing
  • Programmer Tools
  • Programming - Frameworks
  • Programming - General
  • Programming - PHP
  • Programming - Python
  • Programming - RPG
  • Programming - UI
  • Security
  • Systems Management
  • Virtualization
  • Session Level
  • Advanced
  • All
  • Beginner
  • Intermediate
  • Award
  • BRONZE
  • GOLD
  • SILVER
  • Digital Badge
  • ACS
  • HA/DR
  • IT Strategy
  • SQL
  • VS Code
  • Popular