Loading…
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!
Type: Database clear filter
Monday, May 19
 

10:00am PDT

What's New in Db2 for i
Monday May 19, 2025 10:00am - 11:00am PDT
Room 3
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
avatar for Scott Forstie

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

SQL 101 Bullet Train
Monday May 19, 2025 11:15am - 12:15pm PDT
Room 4
Hang on as we go from 0 to 300 MPH with SQL.  We'll start out slow by covering the basics of creating tables, inserting, and selecting data.  We pick up speed as we discuss Constraints, Join Types, and SQL Views.  We will be going at full speed when we learn how to leverage Functions, Procedures, and Db2 Services!  We will bring it all back to the station as we use all our SQL skills to build an example project that combines everything we've learned along the way.
Speakers
avatar for Patrick Behr

Patrick Behr

Software Developer / Architect, Seiden Group
Monday May 19, 2025 11:15am - 12:15pm PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
  Database

3:15pm PDT

Revving up SQL Performance with Indexes
Monday May 19, 2025 3:15pm - 4:15pm PDT
Room 4
One of the most important things needed to improve SQL performance is to have the proper indexing over tables, especially as table grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them. 
 
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 →
Monday May 19, 2025 3:15pm - 4:15pm PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
  Database

4:30pm PDT

How many indexes is too many?
Monday May 19, 2025 4:30pm - 4:50pm PDT
Room 4
The creation of indexes can have a positive impact on query performance. However, an index also has a cost since it has to be maintained every time rows in the associated table are inserted, deleted and updated. This session will the discuss indexing tradeoffs including the review of a benchmark test created to quantify the positive & negative impacts of indexes. In addition, you will learn about tooling that can be used to identify your most valuable and least valuable indexes.






 



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 →
Monday May 19, 2025 4:30pm - 4:50pm PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
  Database
 
Tuesday, May 20
 

8:00am PDT

SQL Coding Tips and Techniques
Tuesday May 20, 2025 8:00am - 9:00am PDT
Room 4
SQL is a very powerful language for processing data. There are many ways to write SQL statements to get the desired results. However, not all queries are created equal. This session will compare different ways to approach a problem from an SQL perspective in terms of code maintenance and performance. Taking the right approach for writing SQL helps Db2 for i help you.
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 →
Tuesday May 20, 2025 8:00am - 9:00am PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
  Database

9:15am PDT

ILE Concepts - and Analyzing ILE Objects with IBM i/Db2 Services
Tuesday May 20, 2025 9:15am - 10:15am PDT
Room 2
Programs, Modules, Service Programs, Internal and exported Functions and Procedures, Binding Directories ... in short ILE Concepts are necessary for a modular and modern programming in RPG and other ILE messages. But ... sometimes still a mess.
Once the Concepts are understood and used, programs can easily be created by putting "puzzle pieces" pieces together, i.e. calling functions and procedures.
But how to analyze our ILE Objects, i.e. where are our procedures/functions located, which modules are bound to what (service-)programs etc?
The good news is, IBM provided in the last releases and technology refreshes a lot of powerful IBM and Db2 Services.
Among these services are also all kinds of Services for analyzing and managing ILE Objects.
This session combines an introduction into the ILE Concepts and shows what services are available for analyzing the ILE Objects (modules, programs, service programs, modules …)
 
Speakers
avatar for Birgitta Hauser

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 →
Tuesday May 20, 2025 9:15am - 10:15am PDT
Room 2 1150 Magic Way, Anaheim, CA 92802
  Database

10:45am PDT

ACS and Db2 for i Explained
Tuesday May 20, 2025 10:45am - 11:45am PDT
Room 3
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
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 →
Tuesday May 20, 2025 10:45am - 11:45am PDT
Room 3 1150 Magic Way, Anaheim, CA 92802
  Database

10:45am PDT

Database Modernization – An Evolution Not Revolution
Tuesday May 20, 2025 10:45am - 11:45am PDT
Room 13
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.
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 →
Tuesday May 20, 2025 10:45am - 11:45am PDT
Room 13 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
Room 3
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
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 →
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802
  Database

3:15pm PDT

Commitment Control – Transaction Control
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Room 13
In applications multiple steps have to be consolidated and executed as a unit (Transaction), That means either all steps or none of the steps must be performed. Example: An order has to be completely delivered or not at all.
No problem if everything is okay, but what if there is suddenly not enough inventory for one position?
Everything has to be reset … and this can become tricky, because multiple programs were executed, multiple rows in different tables were updated and may be even constraints or triggers were activated.
The solution is Commitment Control. Even though Commitment Control is not new, it is only rarely used in (traditional) IBM i applications. … but it is essential for keeping data consistent, especially when using techniques such as referential integrities and triggers.
… and it is even for traditional applications important.
… so, it is time to start!     
Speakers
avatar for Birgitta Hauser

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 →
Tuesday May 20, 2025 3:15pm - 4:15pm PDT
Room 13 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
Room 3
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
avatar for Mike Zaringhalam

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

4:30pm PDT

The simplicity of audit columns
Tuesday May 20, 2025 4:30pm - 4:50pm PDT
Room 4
Simon will explain the simplicity of using Db2 audit columns for providing audit columns to your DDL tables & DDS files. He will give examples of how to create system maintained columns or add them to existing tables & files. Then show how they can be hidden from common users.
Speakers
avatar for Simon Hutchinson

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 →
Tuesday May 20, 2025 4:30pm - 4:50pm PDT
Room 4 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
Room 3
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
avatar for Mike Zaringhalam

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
 
Wednesday, May 21
 

9:15am PDT

Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions
Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 7

Take your SQL skills to the next level with this session on Lateral joins, Window functions, and Pivoting. Discover how LATERAL joins simplify complex queries, learn new insights with Window Functions, and master the art of pivoting data for dynamic reporting. Whether you're an SQL pro or beginner, join us to unlock the full potential of these powerful tools and techniques (and get free code).
Speakers
avatar for Mike Zaringhalam

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 →
Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 7 1150 Magic Way, Anaheim, CA 92802
  Database

9:15am PDT

Run Away Queries Got You Down
Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 5
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.
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 →
Wednesday May 21, 2025 9:15am - 10:15am PDT
Room 5 1150 Magic Way, Anaheim, CA 92802
  Database

10:45am PDT

API Enable Your Database
Wednesday May 21, 2025 10:45am - 11:45am PDT
Room 5
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 DATBASE with SQL, not using RPG or Service program.
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 →
Wednesday May 21, 2025 10:45am - 11:45am PDT
Room 5 1150 Magic Way, Anaheim, CA 92802
  Database

10:45am PDT

Inject more security into Db2 for i
Wednesday May 21, 2025 10:45am - 11:45am PDT
Room 3
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
avatar for Scott Forstie

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

Stepping through SQL Performance
Wednesday May 21, 2025 3:45pm - 4:45pm PDT
Room 5
Every SQL statement has a predefined steps that it must go through before it can complete you data base requests.  Each step taken can positively or negatively impact SQL performance - especially on transactional applications that are running the same set of SQL statements over and over again. This session will explain each step needed to run an SQL statement and the structures that Db2 creates that can impact performance. In addition, this session will review application design and settings that can impact the performance of the required steps.
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 →
Wednesday May 21, 2025 3:45pm - 4:45pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802
  Database
 
Thursday, May 22
 

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
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 →
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
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 →
Thursday May 22, 2025 9:15am - 10:15am PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
  Database

11:15am PDT

OLAP (Online Analytical Processing) Functions – much more than running numbers!
Thursday May 22, 2025 11:15am - 12:15pm PDT
Room 3
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
avatar for Birgitta Hauser

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
Room 3
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 →
Thursday May 22, 2025 1:30pm - 2:30pm PDT
Room 3 1150 Magic Way, Anaheim, CA 92802
  Database

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
SG
Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 4 1150 Magic Way, Anaheim, CA 92802
  Database

3:00pm PDT

ListAgg and Split – Grouping, Aggregating and Dividing again
Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 5
Almost everybody working with SQL knows the GROUP BY specification for accumulating identical information. Those queries are quite often combined with aggregate functions such as SUM() or AVG().
With the multi-dimensional grouping it is possible to also add all kinds of sub-totals as well as a grand total to the queries.
In composition with CASE clauses it is possible to accumulate information and return the data in different columns, for example monthly or quarterly sales per customer. Pivot tables can be easily created … as long as the number of output columns is fixed.
Sometimes, however, we have to accumulate information that is located in multiple rows in a single row, for example all items in an order. Unfortunately, the number of output columns (i.e. Items) may differ. However, with the LISTAGG aggregate function a string containing the different information separated by a comma (or any individual separation string) can be built.
As far as good … but how to split a string with multiple information separated by a comma or any other individual separation string? No problem with the SPLIT service! … in composition with other services even *.csv files located in the IFS can be decomposed
 
Speakers
avatar for Birgitta Hauser

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 3:00pm - 4:00pm PDT
Room 5 1150 Magic Way, Anaheim, CA 92802
  Database

3:00pm PDT

Visual Explain - IBM's SQL Performance Show-&-Tell
Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 10
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.
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior iSeries Developer, OneMain Financial
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 iSeries Developer at OneMain Financial. He serves on the COMMON Strategic Education Team (SET), is one of the SMEs for Db2, and has served on the COMMON Americas... Read More →
Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 10 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
avatar for Simon Hutchinson

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
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Monday, May 19
Tuesday, May 20
Wednesday, May 21
Thursday, May 22
Room 1
Room 10
Room 11
Room 12
Room 13
Room 14
Room 2
Room 3
Room 4
Room 5
Room 6
Room 7
Room 8
Room 9
  • Artificial Intelligence (AI)
  • Client Connectivity
  • Database
  • Developing Business Skills
  • DevOps
  • Hardware
  • High Availability Resilience
  • Integrated File System (IFS)
  • IT Leadership & Management
  • IT Strategy
  • Networking
  • Personal Development
  • Program Testing
  • Programmer Tools
  • Programming: Frameworks
  • Programming: General
  • Programming: PHP
  • Programming: Python
  • Programming: RPG
  • Security
  • Storage Technologies
  • Systems Management
  • Technologies Integrated with IBM i
  • Virtualization
  • Popular