COMMON POWERUp 2025: Full Schedule

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!

arrow_back View All Dates

8:00am PDT

Intro to the SQL Procedural Language

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

Room 4

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

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

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

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

Database

9:15am PDT

SQL Plan Cache Uncovered

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

Room 4

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, the session will review Plan Cache related tools & services that can help you identify query performance problems.

Speakers

Kent Milligan

Senior Db2 for i Consultant, IBM

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

Database

11:15am PDT

AI Meets Node.js: Unlocking the Power of Large Language Models in JavaScript

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

Room 4

Artificial Intelligence and large language models (LLMs) are reshaping industries and sparking innovation like never before. While AI development has long been associated with Python, the growing demand to seamlessly integrate AI into the web applications that drive the digital world is changing the game. So, do we transform web developers into Python experts—or do we empower them to leverage AI with the tools they already know?

In this talk, we’ll take you on an exciting journey of exploring LLMs with Node.js and JavaScript. Discover how leading AI libraries like LangChain, Ollama, and LlamaIndex are bringing JavaScript into the AI fold as a first-class citizen. Learn how surprisingly easy it is to integrate powerful AI capabilities into your applications with Node.js, and walk away inspired to embark on your own AI journey—no Python required! Whether you’re an AI enthusiast or a JavaScript developer curious about the future, this session is your gateway to building smarter, AI-powered applications.

Speakers

Michael Dawson

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

Programming: General

1:30pm PDT

Stored Procedures for Hybrid Development

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

Room 4

Accessing business logic from Open Source application and off platform has evolved a great deal over the years. In this session we’ll look at some of the reasons for centralizing this business logic in the database via Db2 Stored procedures. We’ll look at RPG and SQL procedures and work through examples of how these are used from exhibit languages like PHP and Python.

Speakers

Mike Pavlak

Solution Architect, Perforce Software

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

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

Programmer Tools

3:00pm PDT

Forget ODBC! Here’s a New Db2 Connector

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

Room 4

Connecting to Db2 has never been easier or more efficient. Join us for an in-depth session on Mapepire, a powerful open-source library designed to simplify and enhance your Db2 database interactions. This library offers a more straightforward alternative to traditional JDBC or ODBC connections, ensuring developers can achieve optimal performance and scalability without the usual complexity. With support for multiple programming languages, including Java, JavaScript, Python, this versatile library meets the needs of diverse development environments. Attendees will gain insights into its architecture, see practical demonstrations, and learn best practices for integrating it into their projects.

Speakers

Sanjula Ganepola

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

Database

5:00pm PDT

Simon's top 10 SQL favorites

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

Room 4

IBM Champion Simon Hutchinson has written a lot about modern Db2 for i and SQL on his blog. In this session he will take you through his top 10 favorites. You will have to attend to learn what these cool SQL tricks and tips are! He always keeps this up to date with his favorites from every new release and Technology Refresh.

Speakers

Simon Hutchinson

Founder & 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 Americas, awarded... Read More →

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

Database