COMMON POWERUp 2025

COMMON POWERUp 2025

Unlock the Power of IBM i at POWERUp 2025!

Join us in Disneyland, California, for POWERUp 2025, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!

10:00am PDT

What's New in Db2 for i

Monday May 19, 2025 10:00am - 11:00am PDT

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

Speakers

Scott Forstie

STSM, 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 →

Monday May 19, 2025 10:00am - 11:00am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

11:15am PDT

Specific Group Placeholder

Monday May 19, 2025 11:15am - 12:15pm PDT

Monday May 19, 2025 11:15am - 12:15pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

3:15pm PDT

Specific Group Placeholder

Monday May 19, 2025 3:15pm - 4:15pm PDT

Monday May 19, 2025 3:15pm - 4:15pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

4:30pm PDT

System Limits on IBM i

Monday May 19, 2025 4:30pm - 4:50pm PDT

IBM i is an operating system that was built from the ground up to satisfy the needs of business computing. Even with its robust capabilities, IBM i customers requested additional insight into the top consumption of the most important system resources. Their request came from a business requirement to achieve optimal operations and limit any risk or potential outage related to over consumption of system resources. The IBM i response to this requirement was to architect On-Demand tracking of IBM i System limits. Attend this session to understand the architecture of System Limits and the different components within the operating system that have been instrumented for tracking. Lastly, the session will include details for how customers can leverage and consume this new source of system health insight.

Relevant resources:
https://www.ibm.com/support/pages/tracking-important-system-limits

Speakers

Scott Forstie

STSM, 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 →

Monday May 19, 2025 4:30pm - 4:50pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Systems Management

5:05pm PDT

What is SYSTOOLS and how can you leverage it?

Monday May 19, 2025 5:05pm - 5:25pm PDT

Db2 for i provides useful tools and examples in the SYSTOOLS schema. Come to this session to learn what shiny gems lie within this unopened treasure chest. You need not be an SQL programmer to gain tremendous value from SQL tools!
https://www.ibm.com/docs/en/i/7.5?topic=optimization-systools

Speakers

Scott Forstie

STSM, 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 →

Monday May 19, 2025 5:05pm - 5:25pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Systems Management

8:00am PDT

Beyond the Code: How AI and RPG Code-Assistant Deliver Smarter Development

Tuesday May 20, 2025 8:00am - 9:00am PDT

Gain insights into code and data by effectively using information from AI tooling and RPG Code Assistant to accelerate application development. This session will explore AI's inner workings and workflows through real-world test cases and live demonstrations. We will offer a clear and engaging look at AI’s practical applications and how you can apply these learnings to your development journey.

Speakers

Lief Morin

Ray Everhart

Tuesday May 20, 2025 8:00am - 9:00am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Artificial Intelligence (AI)

9:15am PDT

Control all your IBM i applications and systems from your current monitoring solution, extremely easily!

Tuesday May 20, 2025 9:15am - 10:15am PDT

Not happy with the IBM i monitoring level of your existing tool such as Nagios, PRTG, SolarWinds, Zabbix, etc ?
Discover how “Control for i” adds instantly 180 ‘Plug & Play’ IBM i checks and how your tool is enhanced without any development required.
You will also acquire knowledge on how it is easy to automate answers to well-known messages.
Learn how you will become more proactive: with high accuracy probes you are alerted of problems before they become critical; this improves the service continuity and reduces emergency response costs).
Note: “Control for i” is compatible with 90% of most commonly used monitoring tools.

Learning Objectives:
How to enhance easily your enterprise monitoring solution integrating IBM i controls without any development.

Speakers

Pascal Ruckebusch

CTO and CEO, M81

Pascal Ruckebusch adopted IBM i at the exact beginning of AS/400, three decades ago, and never left it … Pascal's experience on IBM i covers system and application development, training and operations. Twice CTO of 2 major IBM business partners in France, his technical skills and... Read More →

Tuesday May 20, 2025 9:15am - 10:15am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Systems Management

10:45am PDT

ACS and Db2 for i Explained

Tuesday May 20, 2025 10:45am - 11:45am PDT

In this session, you’ll hear the inside scoop about IBM i ACS Db2 tooling from from Ryan (Db2 on i Developer) & Wayne (IBM i ACS Support)

We will explore IBM i ACS Db2 tools in a fun and interactive live demo environment where along the way you will hopefully have a better understanding of all ACS has to offer in the Db2 tooling space.

Speakers

Wayne Bowers

Software Engineer, IBM

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

Tuesday May 20, 2025 10:45am - 11:45am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

3:15pm PDT

Analyzing Geospatial Data Using Db2 for i

Tuesday May 20, 2025 3:15pm - 4:15pm PDT

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.

Speakers

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 →

Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

4:30pm PDT

SQL Merge: One-Statement for Data Modifications

Tuesday May 20, 2025 4:30pm - 4:50pm PDT

Have you ever needed to handle multiple cases when inserting, updating, or deleting records from a table? Don't you wish you could handle all of these cases in one single statement? Well, you can! In this session we will cover how and when to use the SQL Merge statement to make our code more concise and more efficient for data modifications

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Have you ever wanted to meet someone who started Hawaiian Shirt Fridays at their work place? If the answer is 'Yes!', then feel free to reach out with any questions you have regarding Hawaiian shirts... Or IBM i related topics. My main focuses are RDi, DB2, Modernization, and D... Read More →

Tuesday May 20, 2025 4:30pm - 4:50pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

5:05pm PDT

SQL Final Table - Retrieving Data Changes

Tuesday May 20, 2025 5:05pm - 5:25pm PDT

There are some SQL functionalities that go unnoticed regardless of skill level. One of these possible unknown functionalities is the Final Table statement. In this session we will cover how we can leverage the final table statement and when it may be best to do so.

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Have you ever wanted to meet someone who started Hawaiian Shirt Fridays at their work place? If the answer is 'Yes!', then feel free to reach out with any questions you have regarding Hawaiian shirts... Or IBM i related topics. My main focuses are RDi, DB2, Modernization, and D... Read More →

Tuesday May 20, 2025 5:05pm - 5:25pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

8:00am PDT

Fresche Group Placeholder

Wednesday May 21, 2025 8:00am - 9:00am PDT

Wednesday May 21, 2025 8:00am - 9:00am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

9:15am PDT

Web Services: A RESTful introduction

Wednesday May 21, 2025 9:15am - 10:15am PDT

We'll introduce the basics of web services, with a focus on HTTP, JSON, and RESTful principles. This session focuses on the basic principles and architecture of web services, and will also have some examples of how to consume and provide web services from IBM i.

Speakers

Patrick Behr

Software Developer / Architect, Seiden Group

Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Programming: General

10:45am PDT

Inject more security into Db2 for i

Wednesday May 21, 2025 10:45am - 11:45am PDT

In this new session, Scott will explore the many ways that “bad actors” can attempt to subvert the security on IBM i. Whether the topic is protecting against SQL Injection, closing doors to acquiring elevated privileges, or attempting to discover unprotected objects, this session will include techniques for evaluation and protection of your IBM i. Attend this session to take a big step towards discovering and eliminating attack vectors within Db2 for i!

Speakers

Scott Forstie

STSM, 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 →

Wednesday May 21, 2025 10:45am - 11:45am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

3:45pm PDT

Everything they never taught you!

Wednesday May 21, 2025 3:45pm - 4:45pm PDT

Ok, maybe we're setting the bar a little high by saying EVERYTHING, but did you ever feel like all the people around you seem to just KNOW things, things you don't? Sure, you're a wiz with SQL, and no one codes RPG like you do, but when it comes to people skills, to working in teams, to communicating well, to building your career... Well, they never taught you THAT! Come to this session to learn everything you've been missing out on.

Speakers

Steve Wolk

CTO, PC Richard & Son

Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Wednesday May 21, 2025 3:45pm - 4:45pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Developing Business Skills

5:00pm PDT

The Ninja Guide to Building Teams and Creating Engagement!

Wednesday May 21, 2025 5:00pm - 6:00pm PDT

Sure, Ninjas are cool, and they're fun to talk about. And more importantly, there's a leadership lesson there... Ninjas are always 100% ENGAGED! They equate their personal success with the success of their team, and of their mission. How productive would your teams be if they were always completely engaged, like Ninjas? Whether you're a leader looking to learn the secrets behind building strong teams and keeping them engaged, or a team member who wants to better understand team dynamics, you'll find this session illuminating.

Speakers

Steve Wolk

CTO, PC Richard & Son

Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Wednesday May 21, 2025 5:00pm - 6:00pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Developing Business Skills

8:00am PDT

You're Fired! ... Now What?

Thursday May 22, 2025 8:00am - 9:00am PDT

Some of us are lucky enough to have a single job for our entire career, but for most, we will at some point change jobs - either by our choice or our employer's choice. It just makes sense to be prepared for that reality, in case it happens. The irony is that many of the things you can do today to make yourself more employable in the event you ever do find yourself fired also may just make it far less likely that you ever will be fired!

Speakers

Steve Wolk

CTO, PC Richard & Son

Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Thursday May 22, 2025 8:00am - 9:00am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Personal Development

9:15am PDT

How to shift even more left in testing

Thursday May 22, 2025 9:15am - 10:15am PDT

Everyone knows that the sooner you find a bug in your application, the less expensive it will be to fix, with bugs in your production environment being catastrophically expensive. Despite this knowledge, we traditionally underperform in this area. Why? Because testing is complex and time-consuming. Join our presentation to learn the techniques to take your testing to the next level, making it easier, faster, and more effective.

Speakers

Jeroen Van Dun

IBM Champion & Product Manager, Rocket Software

Thursday May 22, 2025 9:15am - 10:15am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Program Testing

11:15am PDT

OLAP (Online Analytical Processing) Functions – much more than running numbers!

Thursday May 22, 2025 11:15am - 12:15pm PDT

The first OLAP Functions were already introduced with Release 6.1, for building running numbers and ranks, in a specific sequence and even with the ability to restart numbering at a predefined level. At release 7.3 a bunch of additional OLAP functions and enhancements for existing OLAP functions are introduced. With these enhancements it is possible to easily build running totals or averages with or without level breaks. Data cannot only be accumulated over all rows, but also within a specific range. It is easy to access and compare the first, previous, next or last occurrence of the data within a partition. This session will give you an overview over the available OLAP functions and how they can be exploited.

Speakers

Birgitta Hauser

Database and Software Architect, IBM Champion, Birgitta Hauser - Modernization - Education - Consulting

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 →

Thursday May 22, 2025 11:15am - 12:15pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

1:30pm PDT

Simple Steps to Improving Data Security on IBM i

Thursday May 22, 2025 1:30pm - 2:30pm PDT

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

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 →

Thursday May 22, 2025 1:30pm - 2:30pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Database

3:00pm PDT

Accelerate your Excel!

Thursday May 22, 2025 3:00pm - 4:00pm PDT

Are you intimidated by spreadsheets? Do you use Excel for the basics, but know you could be so much more productive with it if only you knew how? Do you cringe when other business people within your company ask for data in spreadsheet form? Excel is a wonderful tool, especially when paired with the IBM i! It's incredibly powerful, and can save you lots of time. This session will begin with the basics and then progress through more advanced Excel topics such as functions, pivot tables, and array formulas. Using real life examples, you'll see how these new skills will help you in your career. Finally, we'll review powerful methods of pulling data from your IBM i directly into Excel spreadsheets! You'll even leave with sample code you can leverage within Excel to give you one click access to run an SQL statement from your desktop, and have the results returned in a spreadsheet. After each of the 25 topics covered, we’ll review by playing Excel Bingo, for prizes! Learn some great new Excel skills, have some fun, and maybe leave with a prize!

Speakers

Steve Wolk

CTO, PC Richard & Son

Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Developing Business Skills

5:00pm PDT

AI Throughout Your Day!

Thursday May 22, 2025 5:00pm - 6:00pm PDT

Tired of all the hype surrounding AI? Would you like to be more productive using AI - today – but you’re not sure where to start? Or maybe you’ve scratched the surface with AI, but want to learn more? Either way, this is the session for you! Here we skip the theory and dive straight into real-world applications that boost productivity and streamline daily tasks using AI based tools. Join us for this session and leave with tangible skills to supercharge your productivity, while producing better results, with less effort!

Speakers

Steve Wolk

CTO, PC Richard & Son

Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →

Thursday May 22, 2025 5:00pm - 6:00pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802

Personal Development