Loading…
Attending this event?
The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Add sessions to your personal schedule to register your attendance (Check-In).

Monday, April 24
 

9:00am MDT

ACSConfig.Properties Explained


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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Get ACS to Auto-Update
Managing software updates can be a time consuming and even frustrating endeavor of IT shops. IBM i Access Client Solutions is working to simplify things by adding function to enable Auto Update capability. In this session I will show you how easy it is to setup IBM i ACS for automatic updates.

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Getting to Know IBM i Access Client Solutions
IBM i Access Client Solutions is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. This future is already here as IBM i ACS is the only client supported on Windows 10 and later OS, and IBM i Access for Windows is being withdrawn from support on April 30, 2109. Though, this future is very bright as IBM i Access Client Solutions provides ease of deployment, and operational improvements in nearly every function the client provides. During this session we will make a survey of the IBM i Access Client Solutions functions and features that allow us to accomplish the tasks and processes we use IBM i Access for. Become familiar with IBM i Access Client Solutions!

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Client Connectivity
  • Session Level Beginner
  • Award BRONZE
  • Audience Users or Administrators of IBM i Access for Windows or Client Access

9:00am MDT

IBM i Access Client Solutions Deployment Guide
IBM i Access Client Solutions is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. Being a platform independent product the install or deployment of IBM i Access Client Solutions onto the workstation is approached via approaches and mechanisms unique to this product. This session will walk though the tooling and capabilities available to deploy IBM i Access Client Solutions and the best practice approaches to get this new client out and updated in your enterprise including the newer support to automatically update from an IBM i!

Learning Objectives:
1. Learn best practice approach to deploying and updating 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Client Connectivity
  • Session Level Intermediate
  • Award GOLD
  • Audience Systems or Network Administrators tasked with adminstrating the client workstation environment connecting to the IBM i OS

9:00am MDT

Introduction to Access Client Solutions (ACS)
Whether you're new to the IBM i or already advancing your career on this incredibly stable platform, join me in reviewing the many features of ACS. I have seen many great colleagues in my company who said, "ACS? Oh yeah, that's the emulator, right?" Yes, ACS is an emulator. But saying ACS is an emulator is like saying the swiss army knife is just a knife. No matter your job description, ACS has many tools that can help you work smarter.

Learning Objectives:
Learn some timesaving tools available with ACS.
Discover how to work smarter with ACS whether your a user, administrator or a fellow code monkey like me.
Learn how ACS can not only improve how you work, but improve how you collaborate with your coworkers.

Speakers
avatar for Gregory Simmons

Gregory Simmons

Software Engineer, PC Richard & Son
Gregory Simmons is a Software Engineer at P.C. Richard & Son.  He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered instructor with IBM’s Academic Initiative and an RPG and IBM i instructor at Scott Regional Technology Center, where... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Client Connectivity
  • Session Level Beginner
  • Audience If you sign on to an IBM i, this session has something for you! Users, Admins, code monkeys!

9:00am MDT

Scripting ACS Functions


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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Securing IBM ACS


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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Using ACS in Multiple System Environments


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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

ACS & Db2 for i – Explained
In this new session, you’ll hear the inside scoop about ACS from Scott & Wayne. Who is Scott?  The Db2 for i Business Architect who had a hand in building all the database tooling found in ACS. Who is Wayne?  Wayne is the IBM i ACS support team leader who you call to resolve any problem you encounter. At this session we will explore ACS and have a fun time understanding all the ACS has to offer.

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

Speakers
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 →
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Anyone who needs to interact with Db2 for i

9:00am MDT

Analyzing geospatial data using Db2 for i
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 Sarah Mackenzie

Sarah Mackenzie

IBM
Sarah has worked at IBM since 2013 and is a key developer working on the IBM i Development team in Rochester. She is specifically focused on Db2 for i and is responsible for helping to implementing many of the recent enhancements to Db2 for i, including RCAC and Temporal Tables. Sarah... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Database developer designing applications

9:00am MDT

Authority Collection made easy with SQL
Authority Collection is unique to IBM i, providing the insight into why IBM Security allowed or denied an operation.In this session, Scott will share his unique flair for using Authority Collection and SQL together, to answer questions about security.

Learning Objectives:

Speakers
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

Create or Replace … DDS Files with DDL Objects
With the latest releases and technology refreshes the SQL data definition language (DDL) for creating and maintaining database objects was enormously enhanced. DDS on the other hand is stabilized. But still a lot of applications even those with a modern graphical interface and where the latest goodies of the programming language are used in the source code are based on DDS described files. The excuse DDL enhancements cannot be used, because of the DDS description and the native I/O access of these files, does not count any more. With Reverse Engineering, the SQL code for DDS described objects can be retrieved. CREATE OR REPLACE statements allow DDS described files to be converted into SQL defined database objects, while the programs that use these files can stay untouched. With the CREATE OR REPLACE TABLE statement, files with fields based on field reference tables can be managed.

Learning Objectives:
In this session you will learn to convert DDS described files into SQL tables and SQL indexes without touching any program code. It will also be demonstrated how reference files can be used in composition with SQL tables and how (future) enhancements, for example adding columns on a specific position or changing data types and lengths can be managed.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Advanced
  • Award BRONZE
  • Audience Database Engineers, Database Administrators, Managers and Programmers who want to modernize their database and want to start with converting the existing DDS described files into SQL objects.

9:00am MDT

Create table, insert, update, delete
How to create simple tables and how to use insert, update and delete with exercises

Learning Objectives:
Learn how to create tables and use of insert, update and delete

Speakers
avatar for Sven Jansson

Sven Jansson

Senior developer, SEB


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience People that are new to SQL

9:00am MDT

Creating an Item Master File Data Layer with SQL PL Stored Procedures
This session will examine working examples of IBM SQL PL stored procedures, for maintaining and inquiring upon an item master file. We will also touch upon a number of additional SQL PL stored procedure master file access patterns, that were generated out of one of my employer's tool packages, so that you are better prepared to provide and understand alternate, hybrid or equivalent techniques to RLA if and when they arise. As a set, the stored procedures are probably best described as a simple data layer. We will add an RPG ILE trigger program to capture after images in an audit log file as the final piece of the data layer (which will work correctly to capture all changes even those made via a stored procedure call from the web or other external environment).

IBM SQL PL is standardized across all of the versions of Db2. The source code for the SQL PL stored procedures and ILE trigger program will be provided to conference attendees, as we seek to show how one might separate data access and update logic from the high-level language program, and facilitate broader ease of use and consistency of Db2 for i data across the enterprise (interactive, batch and/or remote web server)).

We'll hit inquiry, delete, add, update, record lock and several combinations of these for dealing with a single database row in a mission-critical master file. The update stored procedures include working examples of those that achieve the optimistic row locking technique even from a remote web server, so that accidental overlays are prevented in high volume, multi-user environments (without first soft locking a field in the record and/or checking it). The optimistic technique reviewed does require use of commit/rollback boundaries from within your high-level language program to fully rollback, however row/record locks are removed with rollback without requiring journaling. An important idea also is that this technique significantly reduces the situations that necessitate actual rollback of updates (like inability to allocate the record) and is more fine-tuned than techniques relying on use unique time stamps or isolation levels.

We won’t have time to get into the language syntax required to consume the stored procedures, so the source code of high-level languages calling the stored procedures won’t be covered in this session.

Learning Objectives:
1. See and understand standard Db2 for i SQL PL and stored procedure syntax that performs all of the DB access used within this data layer pattern example
2. Seek to show how one might separate data access and update logic from the high-level language program, and facilitate broader ease of use and consistency of Db2 for i data across the enterprise (interactive, batch and/or remote web server))
3. See differences in syntax and create steps for stored procedures using *LIBL and system naming

Speakers
avatar for Rex Smith

Rex Smith

Sr. Developer (ERP & Web), Tegratecs Development Corp.
Rex is a Sr. Developer at Tegratecs and enjoys developing business applications in traditional IBM i environments and in web environments.   Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs.  He is currently... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Developers looking to see and compare data update techniques between an SQL PL data layer and traditional record level access (RLA), and see examples what might be considered a hybrid between the two.

9:00am MDT

Data Sciency stuff for Dummies
Data Scientists have become more prevalent in I/T shops to provide deeper analytical insights about your data then query or BI tools can provide. What tools (like Machine Learning models) do these people use? What is Data Prep? What considerations should you care about as an IBM i Administrator or Developer?

Learning Objectives:
1. Overview of what kinds of things the data scientist does
2. Learn about how to integrate Db2 data with ML Models built by or used by Data Scientists
3. Understand the importance of data prep for training or feeding data into an ML model
4. Learn how to gain insights via ML Models WITHOUT having to be a data scientist!

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience I/T management, IBM i Administrators or Developers, and of course, if any Data Scientists are attending!

9:00am MDT

Data-Centric Thinking: Moving Business Logic into the Database
When talking about application modernization database most think about converting from DDS to DDL and redesigning the database … and yes, this might be the final goal.

But there is much more! We have to move from an application-centric thinking to a data centric thinking. In short, instead of coding everything in whatever programming language, we should move as much business logic as possible into the database. It may even include foreign data that is provided and accessed by Web-Services.

But …what does that mean? At first, using encapsulated (complex) SQL Statements wrapped in SQL Views or User Defined Table Functions, externalizing Data Access, adding constraints and triggers, Row And Column Access Control (RCAC) …

With all these techniques we cannot only reduce our source code to a minimum but also secure our data!

Learning Objectives:
Discover how to move business logic into the database, what methods are available and learn how the applications can be slowly transformed from application centric to data centric.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Advanced
  • Audience IT Managers, project leaders, programmers and database administrators who are currently working with an old “grown over time” databases and applications want to modernize their application with regard to the data (and database). Programmers who just want to reduce their source code.

9:00am MDT

Db2 SMP has been "Freed", What Should I Do?
The Db2 Symmetric Multiprocessing (SMP) feature which enables parallel processing of database requests was recently converted from a chargeable feature to a no charge/free feature. Come to this session to learn if you should be using Db2 SMP on your server and if so, the best practices for using the Db2 SMP feature.

Learning Objectives:
1. Learn when to use and not to use Db2 SMP. 2. Learn about the configuration settings available to control Db2 SMP

Speakers
avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Dimensional Modeling: The Star of the Show?
Can a data mart or warehouse or even an operational data store elevate your reporting and visualizations? Improve the performance of your reporting? Provide easily accessible information to the business and your users? Find out how even a small effort can yield big results.

Learning Objectives:
1. Basics concepts of data warehousing.
2 .How easy it is to create a functioning data warehouse.
3. How data warehousing improves the businesses agility in making informed intelligent decisions.

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

Expand Your Options using Query Management
Query Management may be one of the better-kept secrets on IBM i. It has been part of the operating system since version 3.0 of OS/400. Yet developers don't seem to know it exists, or what it can do for them. Query management objects give the IBM i developer the means to use the full power of SQL without having to purchase the SQL licensed product. It also provides reporting capabilities similar to those of Query for i, with some things that Query for i can't begin to do. Query Management (QM) objects can also be used with programs and commands to provide parameterized reporting and data presentation.

Learning Objectives:
1. Use CL commands to create Query Management objects
2. Use Query Manager to work with Query Management objects
3. Create commands that use Query Management objects

Speakers
VH

Vern Hamberg

Senior IT Developer, 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 IT Developer in the Pest Elimination division of Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for Db2... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Developers who need to quickly generate reports and may not want to write programs to do it, who want to enhance their ability to deliver data-centric information in their enterprise.

9:00am MDT

Exploring the IBM OmniFind Text Search Server
OmniFind Text Search Server on DB2 for IBM i provides complex text search capability on many different kinds of documents such as XML, HTML, PDF, MS EXCEL, MS Word and lotus documents. DB2 for IBM i integrates this powerful text search capability into the SQL language. Come and explore this new powerful Text search engine and learn how you might incorporate it into your applications.

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 the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

Get Running with the IBM Db2 for i .NET Provider
If your company is doing .NET programming alongside IBM i development, it is important to be conversant about accessing Db2 for i from any Microsoft or 3rd party OO language that uses the .NET Framework 2.0 through 4.8. This session will hit all of the main steps required for using this data provider (a component of the ACS Windows Application Package) in a c# web forms ASP.NET style project to run in any standard browser on your PC. We will use Visual Studio Community Edition 2022 as the IDE and to run the Db2 for i SQL. This session seeks to show that it is no big deal to get current Db2 for i data into many Microsoft programming environments with little, if any, advance reformatting or data extract steps.

The detailed example will show how to dynamically churn out a nicely formatted list inquiry on a standard browser web page, using the least amount of specifications. The SQL syntax is limited only by your version of Db2 for i. The provider allows Db2 for i stored procedure calls but that will not be covered in this session, we are trying to get from soup to nuts in the fastest manner possible. One of the ways we achieve this is by using a technique that populates an HTML grid (or table) inquiry directly from the SQL and the file(s) metadata.

Complete code of the c# version (c# code, HTML5, CSS3) and steps on how to implement will be offered to POWERUp 2023 attendees during hour of presentation or via email request. Presentation PDF and some other goodies will be available throughout the conference.

The examples respect native authorities (of the profile you decide to use at run time) and do not require elevated authorities other than admin when installing Visual Studio on your PC. The project can also be published to run on MS IIS Web Server once the provider is installed there (instructions for installing the .NET provider subset of ACS Windows Application Package included). However, obviously you would want to first evaluate use of user authentication, user authorization or data owner subsets before going live on a web server.

Learning Objectives:
1. Be conversant with Microsoft developers at your company regarding this efficient way to access Db2 for i in real time.
• Be able to anticipate and, in most cases, easily enable delivery of modern language data types and values from your Db2 for i database without data staging prerequisites or physical file changes
• Be able to pass along info on how to source this provider from IBM, when and how to install and it and how to enable it within a Visual Studio project
• Get an introduction to how the provider interacts w/ .NET OO FW constructs & routines
• Be able to prove out via web inquiry prototype demonstration that Db2 for i can do it (and do it well) in these .NET FW environments
2. For developers who choose to implement this web page example out on their own PC:
• Use the included source code and instructions to prototype and demonstrate running dynamic SQL select statements against any authorized Db2 for i database file combination from a browser on your PC (c#, xhtml and css download inc

Speakers
avatar for Rex Smith

Rex Smith

Sr. Developer (ERP & Web), Tegratecs Development Corp.
Rex is a Sr. Developer at Tegratecs and enjoys developing business applications in traditional IBM i environments and in web environments.   Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs.  He is currently... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience IBM i developers who work in companies with .NET or ASP.NET programming that consumes or updates Db2 for i. IBM i developers who want to get a taste of web programming with an integrated GUI on their own time. Developers who would like to get a glimpse of OO programming syntax with an OO framework foundation.

9:00am MDT

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

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

Speakers
avatar for Susan Romano

Susan Romano

Technical Lead Db2 for i Development Team, IBM
Sue Romano is a technical leader on the Db2 for i development team and has worked on the SQL parser for almost 30 years. She is involved in designing and implementing SQL enhancements and defines new SQL services. Sue represents Db2 for i on IBM’s SQL Language Council, which ensures... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Developers who want to start writing SQL-based solutions.

9:00am MDT

Group By, Having and multi-dimensional Grouping
An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed … or did you know you can create all kinds of sub-totals and grand-total with an SQL GROUP BY?

Learning Objectives:
In this session you’ll learn the basic use of the GROUP BY and HAVING clauses as well as the use of multiple aggregate functions. You’ll also discover how NULL values can affect the result returned by aggregate functions. It will be demonstrated how easily all kinds of sub-totals and grand-totals can be built. You’ll also learn how to use the CASE clause for building pivot tables.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Programmers, Database Administrators and Engineers who quite often need to run queries or built reports that include sub-totals and grand totals. Everybody who is interested in what can be done with an SQL SELECT statement.

9:00am MDT

IBM i services for the developer
IBM i services provided by Db2 for i can be used to access system information that is useful for developers. In the past you may have considered using CL or coding to system APIs to access and work with some system information. Today there is a better option: SQL. In this session you will learn how to use SQL to work with data areas and data queues, discover how easy it is to review your program and service program attributes, and more.  http://ibm.biz/Db2foriServices

Learning Objectives:

Speakers
avatar for Susan Romano

Susan Romano

Technical Lead Db2 for i Development Team, IBM
Sue Romano is a technical leader on the Db2 for i development team and has worked on the SQL parser for almost 30 years. She is involved in designing and implementing SQL enhancements and defines new SQL services. Sue represents Db2 for i on IBM’s SQL Language Council, which ensures... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All

9:00am MDT

IBM i, the IOT, and Geospatial Analytics
Small devices that exists in the world have a location associated with them. These small devices can communicate information to the IBM i, including their location, using MQTT, a machine-to-machine connectivity protocol.

Learning Objectives:
In this session learn about MQTT, see examples of how a remote device can communicate location and other information to the IBM i, how that information can be stored in the database, and how geospatial functions can be used to analyze that information.

Speakers
avatar for Sarah Mackenzie

Sarah Mackenzie

IBM
Sarah has worked at IBM since 2013 and is a key developer working on the IBM i Development team in Rochester. She is specifically focused on Db2 for i and is responsible for helping to implementing many of the recent enhancements to Db2 for i, including RCAC and Temporal Tables. Sarah... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Database developer designing applications

9:00am MDT

Integrating JSON and Web services using SQL
Web services are a powerful tool for exchanging information between applications over the internet. For example, you can call a web service that provides real time data like the weather, solves a specific business need, or enhances your applications by adding AI through Watson web services. In order to take advantage of web services, you must first learn how to access a web service and parse the data that is returned.

Learning Objectives:
In this session, learn how to use SQL and http functions to call a web service from your application and then use JSON_TABLE to parse the data that is returned. This session will include working examples of how to integrate web services into your applications.

Speakers
avatar for Sarah Mackenzie

Sarah Mackenzie

IBM
Sarah has worked at IBM since 2013 and is a key developer working on the IBM i Development team in Rochester. She is specifically focused on Db2 for i and is responsible for helping to implementing many of the recent enhancements to Db2 for i, including RCAC and Temporal Tables. Sarah... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Database developer designing applications

9:00am MDT

Intermediate SQL: Unleash the POWER
You've probably used basic SQL - so maybe it's time to expand your SQL skills! The session presents SQL techniques for both interactive and embedded use that are steps beyond the simple WHERE clause... Techniques that, in a single statement, achieve what would take literally hundreds of lines of code.

This session evolves as our team finds new ways to avoid writing code!

Learning Objectives:
Learn how to use techniques like CTEs and self-joins to leverage your programming and analysis capabilities. Integrate SQL into RPG, CLLE, and bash scripting.
Learn optimization techniques you can use immediately

Speakers
avatar for Andrew Dekreon

Andrew Dekreon

Drew is currently the Applications Manager for enterprise sytems with a major transportation company and an adjunct professor at the University of Alaska. Drew began working with the platform when he took over responsibility for a System/38 in 1987 and has been actively developing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Award SILVER
  • Audience Programmers looking to move to a new level of expertise useful in both DB2 and non-i sql. Query users wanting to really be able to extract data from their systems

9:00am MDT

Learn how to use OR REPLACE with SQL DDL
The OR REPLACE clause can be found on many SQL Data Definition Language (DDL) statements. Come to this session to get a 20 minute brain blast on what you absolutely must understand for this topic.

Learning Objectives:
1. Understand what OR REPLACE does and when to consider using it.
2. Understand the most valuable aspects of using OR REPLACE.
3. Understand how you can shift to management of master source for your data model.

Speakers
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Anyone tasked with changing the data model or SQL constructs.

9:00am MDT

Modernization Case Study – Creating a Database Abstraction Layer
"By providing a layer of separation between your applications and your database, you have much more agility to respond to changing business requirements and you can reduce your maintenance burden at the same time. This case study will review three approaches that can be used to provide database abstraction and the strengths and weaknesses of each approach.

1. Evaluate three different approaches to database abstraction and their benefits
2. Walk step by step through the implementation of a Logical File database abstraction layer.
3. Review the reference architecture for a database I/O service program.
4. Best Practice design recommendations for new tables."



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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Developers

9:00am MDT

ODBC speed and security
IBM i provides a cross-platform ODBC driver for Db2 that allows developers to code “locally” on their PCs, then deploy the same code to IBM i for production. Alan will share best practices for using ODBC with open source languages, including Node.js, PHP, and Python, and R, as well as .NET. Special tips and hints help you avoid errors, connect securely, and get the best performance. Includes updates to installation, and real-life configuration of the ODBC prestart jobs.

Learning Objectives:
- Appreciate why developers should consider ODBC
- How to get excellent performance
- Troubleshooting
- Connection strings

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Developers

9:00am MDT

ODBC: A Better Way to Connect to Db2
ODBC is a technology that allows for platform- and database management system-agnostic calls to a database, as long as your have the correct driver installed. The IBM i Open-Source Software team has made the strategic decision to support ODBC as our first choice for database connectivity for Db2 for i. This session will cover how to set up ODBC on your IBM i, Windows, Mac, and Linux systems, and then how to use ODBC to connect to your IBM i machines from anywhere.

Learning Objectives:
1. Learn how to download and configure ODBC datasources
2. Learn how to connect with ODBC once datasource has been set up
3. Learn how ODBC allows development from non-IBM i systems and then move those some programs to IBM i with little to no changes

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Application developers who want to develop open-source software for IBM i from another system

9:00am MDT

OLAP (Online Analytical Processing) Functions – much more than running numbers!
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.

Learning Objectives:
In this session you will learn which OLAP functions are available and how they can be used for and how they can be exploited especially for statistical reports.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Advanced
  • Audience Manager, Programmers, Database Administrators and Engineers who need to generate and analyze complex statistics or everybody who is just interested in what is possible with OLAP functions.

9:00am MDT

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

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

Speakers
TD

Tom Davidson

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Programmers and DBAs that are trying to improve performance of their applications.

9:00am MDT

Performance Tuning, separation of work and memory sizing
When properly tuning your IBM i, you need to know the different profiles for database work, Interactive, batch, and data warehouse. You also need to know about how programs can increase waits on your system. The second part of this session will take you through how to do initial memory sizing on memory pools and what to look for as you tune your memory subsystems.

Learning Objectives:
1. Learn the database usage profiles of the 3 types of database work
2. Learn how to get initial sizing of your memory pools
3. Learn signs that your memory pools are missized and how to rectify the situation.

Speakers
TD

Tom Davidson

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Programmers and DBAs that are trying to improve performance of their applications.

9:00am MDT

Quick Start to Using MariaDB and PostgreSQL on IBM ii
As part of the open-source packages IBM has released for IBM i, the PostgreSQL and MariaDB databases are two gems that stand out. The software installs in minutes on IBM i via the Yum-based Open Source Package Management process that is part of IBM Access Client Solutions (ACS). This means that MySQL/MariaDB and PostgreSQL are now fully embraced as a valid IBM i database for storing data for your PHP, Python, Node and Java applications. No need to look elsewhere to host your open-source applications than IBM i using DB2 and open-source data natively.

Attend this session to see how to quickly get started installing and using MariaDB and PostgreSQL natively on IBM i. We’ll also cover some valid application development use cases.

Learning Objectives:
1. Learn the benefits of hosting MariaDB and PostgreSQL natively on IBM i
2. See how quickly MariaDB and PostgreSQL can be deployed on IBM i
3. Learn the development pattern for integrating MariaDB and PostgreSQL with your apps

Speakers
avatar for Richard Schoen

Richard Schoen

President, Mobigogo LLC
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Any RPG or Open-Source developer looking to host apps that require MariaDB or PostgreSQL natively on IBM i and integrate with the database.

9:00am MDT

Recent Db2 Enhancements: Greatest Hits
New features are added to the database twice a year. With this continual delivery of enhancements, it is easy to overlook some of the new additions. In this session, Sue will share some of her favorites from the last several years.

Learning Objectives:

Speakers
avatar for Susan Romano

Susan Romano

Technical Lead Db2 for i Development Team, IBM
Sue Romano is a technical leader on the Db2 for i development team and has worked on the SQL parser for almost 30 years. She is involved in designing and implementing SQL enhancements and defines new SQL services. Sue represents Db2 for i on IBM’s SQL Language Council, which ensures... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

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

Learning Objectives:
1. Learn about the importance of indexes on SQL performance
2. Learn how to use ACS tools to process Db2 Index Advice
3. Learn how to use ACS tooling to evaluate which indexes are providing value and which indexes are candidates to delete

Speakers
avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Database engineers and performance analysts as well as SQL programmers trying to improve performance

9:00am MDT

Run Away ODBC or Query/400 Queries Got you Down?
Pretty much on a weekly basis we get calls from clients concerned about the negative performance impacts and security exposure from query tools like Query/400, QMF, Showcase, Tableau and others - because they've experienced the "query from hell" eating up system resources. This session will cover aspects such as the new-ish Db2 Supervisor to control/audit long running queries, ACS' Plan Cache and index advice information along with modernizing those tools into a CONTROLLED Ad-Hoc query environment.

Learning Objectives:
1. Learn about the Db2 Supervisor to govern and/or audit long running queries
2. Gain insight into the tools you can use to monitor, tune, and prune queries
3. Hear about the value of moving to a CONTROLLED AD-HOC query solution and the benefits it provides around controlling performance and securing your data

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience System administrators, developers, and end users that run a lot of queries. Management too, of course!

9:00am MDT

Select with functions
How to use functions in SQL with exercises

Learning Objectives:
Learn how to use functions in a select query

Speakers
avatar for Sven Jansson

Sven Jansson

Senior developer, SEB


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience People that are new to SQL

9:00am MDT

Shallow Dive into Database Modernization
Do you still use DDS to create physical files? Do you create an "extension" file when you need to add a field to an existing file? Are you worried that moving to SQL is too difficult? This session is for you.

Do you need to prevent bad data from from getting into your system regardless of how it's being added? This session is for you. Do you need to mask sensitive data, or protect data from unauthorized users? This session is for you. If you love working really hard, enjoy cryptic column-oriented codes, or the thought of recompiling all your RPG programs gives you a thrill, then maybe this session isn't for you.

Learning Objectives:
1. Convert DDS physical files to SQL tables
2. Add audit fields that are automatically updated
3. Use constraints to ensure data integrity
4. Use Row And Column Access Control (RCAC) to control access to your data

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Any still using DDS, or not fully utilizing the awesome power of SQL

9:00am MDT

Sharing Data Between Partitions with the SQL Three-Part Name
By using Db2 for i’s three-part name it is possible to perform SQL statements on one partitions, initiated from another. This can be as simple as building tables, views, etc. on the remote partition and populating them with data. Or it can be as complex as you like. Become the “go to” guy who is able to gather data from multiple partitions and combine them into one set of results for reports, creating test databases, comparing the set up of two partitions, etc.

Learning Objectives:
1. Learn the syntax of the three-part name
2. Learn what you can, and cannot, do when using the three-part name and overcome the simple road blocks
3. See how to build a RPG program to show the jobs in message wait from multiple partitions all on one screen

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon’s experience with IBM midrange started in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA he has worked mostly in the western half of the country, and is currently IT manager responsible for the Power servers and IBM i for a large bank in Central Texas.Simon... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Developers who have some understanding of SQL who want to be combine data from multiple sources into one set of results

9:00am MDT

Simple steps to improving data security on IBM i
Db2 for i offers a wide range of security tools and features built into the database that allow you to better secure your data. You can easily and quickly take advantage of these tools to not only understand how your data is secured, but to better secure your data.

Learning Objectives:
During this session we will cover a wide range of security tools 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 working examples that you will be able to take home and use right away.

Speakers
avatar for Sarah Mackenzie

Sarah Mackenzie

IBM
Sarah has worked at IBM since 2013 and is a key developer working on the IBM i Development team in Rochester. She is specifically focused on Db2 for i and is responsible for helping to implementing many of the recent enhancements to Db2 for i, including RCAC and Temporal Tables. Sarah... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience The database engineer looking for security solutions.

9:00am MDT

Speed Dating with a Date Dimension Table
Simplify date processing in your applications and reporting world. Date attributes (month/year, day of year, current_date-30, is it a holiday, date prompts) are used everywhere in your line of business or business intelligence applications. A recent customer benchmark shared with us took a 20 second routine down to milliseconds through the date dimension table technique. Simplify and speed up date processing with the date dimension utility that IBM provides for you !

Learning Objectives:
1. How to simply work with problematic legacy date fields
2. Learn about methods to extend/enhance your applications and reports with additional date attributes.
3. Add weather information, seasons, or moon phases to your data!

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience RPG Developers, Business or Data Analysts, Query/400 report developers, I/T and Business Managers

9:00am MDT

SQL & Temp Tables - Good or Bad Combination?
Using SQL with temporary tables is easy, but that doesn't mean that you should be mixing the two together. Learn about the performance side effects of this combination and alternative solutions such as SQL common table expressions and views.

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 the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience Developers

9:00am MDT

SQL 101
Everyone 'should be' using SQL these days. With our strategy of creating IBM i services for accessing and managing the system, everyone has the opportunity to use SQL to do their job more efficiently. If you aren't sure how to start, this session will cover the basic building blocks for writing SQL statements. We will talk about the parts of a query, how SQL is used to create tables, and much more.



Speakers
avatar for Susan Romano

Susan Romano

Technical Lead Db2 for i Development Team, IBM
Sue Romano is a technical leader on the Db2 for i development team and has worked on the SQL parser for almost 30 years. She is involved in designing and implementing SQL enhancements and defines new SQL services. Sue represents Db2 for i on IBM’s SQL Language Council, which ensures... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

SQL 102
SQL is the industry standard way of interacting with a database. This session will explain how to change the data in your database. Some data definition topics, such as defining views, will be covered as well.

Learning Objectives:
1. Understand how INSERT, UPDATE, DELETE, and MERGE statements can be used to modify data in your database.
2. Learn how to encapsulate queries in a view.

Speakers
avatar for Susan Romano

Susan Romano

Technical Lead Db2 for i Development Team, IBM
Sue Romano is a technical leader on the Db2 for i development team and has worked on the SQL parser for almost 30 years. She is involved in designing and implementing SQL enhancements and defines new SQL services. Sue represents Db2 for i on IBM’s SQL Language Council, which ensures... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

SQL and IFS - Reading/Writng IFS Files with SQL
SQL is great for accessing data located in a relational database. But in a modern world it is also necessary to consume data that is located in the IFS (Integrated File System) or provided by web services. With each Technology Refresh IBM introduces and enhances Db2 for i Services. With Release 7.4 Technology Refresh 3 IBM provides new SQL Stored Procedures for reading data from and writing Data into the IFS.  In composition with other SQL Functions it is easy to scan through IFS files or decompose *.csv files or JSON files or XML documents located in the IFS.

Learning Objectives:
In this session you’ll learn how to write data to the IFS and how to read IFS files, by using no other programming language than SQL.
It will be also demonstrated how to access and decompose *.csv files located in the IFS without copying them into a physical file or SQL table.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Advanced
  • Audience Developers and users who are experienced in SQL Queries and want to know how to write data into the IFS or have to consume IFS data, or simply want to enhance their SQL know-how.

9:00am MDT

SQL Coding Tips and Techniques
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.

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 the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Developers

9:00am MDT

SQL Plan Cache Uncovered
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 the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database

9:00am MDT

SQL: Select the language
Session about the language SQL with some simplier Select querys with exercises

Learning Objectives:
To be able to write a simle Select query and to know what SQL is

Speakers
avatar for Sven Jansson

Sven Jansson

Senior developer, SEB


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience People that are new to SQL

9:00am MDT

Streaming/Replicating Db2i Data into "The Cloud"
Another part of the company is wanting to leverage a cloud based server for some requirement - advanced analytics, pricing applications, AI/ML project, micro-services, etc. They are coming to IBM i I/T folks to ask how they can get critical data that they need from Db2 for i. This session will answer that question for you, including a couple of approaches using open source Apache Kafka.

Learning Objectives:
1. Learn about Apache Kafka as the glue to stream data
2. Understand different approaches and the advantages/disadvantages of those approaches.
3. Enhance your knowledge of the data streaming into cloud services world

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Developers, System Admins, Business Analysts, I/T Management

9:00am MDT

String Manipulation and Regular Expressions with SQL
Today data get more and more exchanged between multiple platforms and interfaces, in JSON or XML or other text formats. SQL includes methods for consuming XML and JSON. But quite often the data is not in the format, so we can consume it directly. For example, the first and last name is returned as a single value separated with a comma and must be split.  On the other hand, data must sometimes be prepared in a specific way, for example a numeric value must be right adjusted padded with asterics and edited with group and decimal separators. And finally, it is necessary to check the passed data or to search character data if they match a specific format or include a specific sequence. For example, to find all column values that consist not only of digits. Did you know, you can do this directly with SQL? SQL includes a lot of scalar functions for string manipulation including regular expressions for scanning, preparing and converting

Learning Objectives:
Learn what scalar functions for string manipulation are available and how they can be used for concatenating, converting, splitting strings.
For more complex searches learn which regular expression functions are available and how they can be used.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Programmers and SQL users who need to convert or split strings or just want to use what is possible with SQL.

9:00am MDT

Temporal Tables – Looking Back Into Your Data’s Past
We all work in environments where data is changing, often rapidly. At times it would be nice to know what the data looked like an hour, a day, or even a week ago. With conventional files and tables this is hard, that might even involve restoring data from journals. SQL Temporal Tables alleviates all of that work. They allow you to view the data as it was at any time, and allows many people to view the data at different times all at the same time.

Learning Objectives:
1. Learn the syntax of how to create a Temporal Table
2. Learn how to view data from the Temporal Table for various times
3. Learn how to recover delete rows using the Temporal Table

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon’s experience with IBM midrange started in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA he has worked mostly in the western half of the country, and is currently IT manager responsible for the Power servers and IBM i for a large bank in Central Texas.Simon... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Any developer who wants to be able to display time sensitive data in a fast pace environment

9:00am MDT

The join and sub select union
A walk thru of the join, sub select and union with exercises

Learning Objectives:
Learn how to use join, sub select and union

Speakers
avatar for Sven Jansson

Sven Jansson

Senior developer, SEB


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Beginner
  • Audience People that are new to SQL

9:00am MDT

Top 10 Reasons to Build Your Own SQL Indexes
In todays world many of us use vendor supplied software. Many of us also are under the edict from manage to 'Not modify the Software'. Many CIOs do not necessairly understand that 'modify' means. This session will provide reasoning for developers, lower level managers can use to make the case for upper mananagement that creating indexes is not modifying the software, and can result in significant performance gains.

Learning Objectives:
1. Learn that adding indexes does not necessarily mean you are modifying packaged software.
2. Learn the most important reasons WHY you should add indexes to packaged software.

Speakers
TD

Tom Davidson

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Programmers and DBAs that are trying to improve performance of their applications.

9:00am MDT

Tricks with Spool Files using SQL
In the past few releases and TRs IBM has introduced a number of SQL views and table functions that allow anyone to do things to spool files that they would have had to use APIs or complex programming. Become the superstar at your company with the knowledge on how to do all of this with just a few SQL statements.

Learning Objectives:
1. How to find the biggest/oldest spool files on your systems.
2. How to delete old spool files.
3. How to extract data from a spool file into spreadsheet format
4. How to build views over spool files, even when they are not there
5. How to copy one spool file to PDF
6. How to copy many spool files to PDF

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon’s experience with IBM midrange started in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA he has worked mostly in the western half of the country, and is currently IT manager responsible for the Power servers and IBM i for a large bank in Central Texas.Simon... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience Any IBM i programmer looking for a simple way to handle output from spool files with using APIs or 3rd party tools

9:00am MDT

Using SQL to Overcome Challenges when Consuming XML (Case Study)
In this new world of mobile data collection by our field specialists, we ran head-on into special characters as well as emojis. This case study tells the tale of overcoming the hurdles we were stumbling over to deal with them.

Learning Objectives:
1. Learn what issues can be raised when using mobile devices to collect information from the field
2. Learn how XML support in Db2 for i was used to resolve these issues

Speakers
VH

Vern Hamberg

Senior IT Developer, 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 IT Developer in the Pest Elimination division of Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for Db2... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level All
  • Audience Developers who need to process XML files and web services and others who need to know what can be done with XML support in SQL for IBM i

9:00am MDT

Visualizing Data With SQL and Web Query
You're doing more and more with SQL to define a data set for various purposes. Many times that purpose is for reporting to your stakeholders in the business. This session will show how you leverage SQL to define the data set, but use Db2 Web Query to take that SQL and build charts/graphs and dashboards in a jiffy over that SQL result set. Incorporating Db2 SQL and web query simplifies the delivery of requests for information!

Learning Objectives:
1. Learn how to speed up the pace to respond to business requests for information using SQL and web query.
2. Experience detailed examples of building charts with SQL in minutes using Db2 Web Query
3. Expand your use of the power of SQL.

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Intermediate
  • Audience IBM i developers, business analysts, BI/DW team personnel, System Administrators

9:00am MDT

What is SYSTOOLS and how can you leverage it?
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!

Learning Objectives:
1. Understand what is SYSTOOLS?
2. Quick training in how to discover and use the tools within SYSTOOLS.
3. Understand how ACS can help you use SYSTOOLS.

Speakers
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Database
  • Session Level Advanced
  • Audience Anyone using an IBM i

9:00am MDT

Accelerate Your Excel!
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.

Learning Objectives:
Learning Objectives: After participating in this session, attendees should have the skills and techniques to:
- Understand the benefits of using Excel
- Use spreadsheets to improve your own productivity as well as that of your company
- Pull data from your IBM i directly into a spreadsheet in a variety of ways

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Developing Business Skills
  • Session Level All
  • Award BRONZE
  • Audience Anyone who has ever had to work with a spreadsheet will benefit from the skills gained during this session. We will start with the basics, but even experienced Excel users will find useful information in this session.

9:00am MDT

How to Become a Speaker at COMMON
You have a wealth of experience and expertise. Have you thought about sharing your know-how by speaking at COMMON? Speaking at COMMON is fun and a great way to get involved with other members as well as the organization at large. Come join this Question and Answer discussion with members of the Volunteer Excellence Committee. Let's talk about your questions, ideas for sessions or whatever is on your mind. We will share experiences about what it is like to speak at COMMON, successful speaking techniques, preparation steps, etc. You may be the next outstanding speaker at COMMON!

Learning Objectives:

Speakers
avatar for Kim Greene

Kim Greene

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Developing Business Skills
  • Session Level All
  • Audience Anyone looking to speak at a COMMON education offering.

9:00am MDT

Software is Everyone's Business
An open discussion about the value of custom code and how it gives businesses their proprietary advantages. Identifying why simply relying on canned software and worse yet, forcing your business to comply with inflexible code is a mistake.

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles 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 →
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

What Are Soft Skills, and Why They Are Important?
You have the skill to get the job done correctly. You have the skills to learn anything new in half the time it takes others. You even have the skills to write a program in 3 different languages, but can you step in front of a conference room and talk about how you did it? Can your coworkers depend on you to complete your portion of the task? Can you adapt to a sudden change in someone’s behavior or your work environment and still excel?

There are two sets of skills that are crucial to our success. Hard Skills and Soft Skills. One will get you hired, the other will give you value.

Learning Objectives:
This session is Soft Skills 101. Learn the difference between the two, why it is important, and how you can strengthen your soft skills.

Speakers
NK

Nilofur Khan

Sales and Marketing Development Specialist, iTech Solutions | A Service Express Company
Nilofur Khan is the Sales Development Specialist at iTech Solutions. With over 15 years of experience in Healthcare and Customer Service, she brings many new skills to the plate. Although new to the platform, Nilofur has never turned down an opportunity to be proactive and learn in... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Developing Business Skills
  • Session Level All
  • Audience Everyone

9:00am MDT

A Beginner’s Guide to DevOps and CI/CD Pipelines on IBM i
Embracing agile development is essential to keep pace with evolving business requirements and your company's expectations for your IT team. Join us to learn about techniques and tools that we and our customers use to innovate in a rapidly evolving technology landscape.

Learning Objectives:
1. By utilizing CI/CD pipelines you can integrate your efforts with development across your enterprise, while drawing attention to the value of the IBM i platform.
2. DevOps empowers modern development teams to deal with constant change, while improving quality and reducing downtime.

Speakers
avatar for Donna Westmoreland

Donna Westmoreland

CTO, Midrange Dynamics North America
Experience gained from leading major projects, including application modernization, at 100s of corporations has given Donna a well-rounded view of development needs, audit requirements, and testing principles.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps

9:00am MDT

Automation on IBM i, Ansible versus Jenkins: How can these open source tools help me and which one do I use?
Most companies are using open source tools for automation on other platforms, now we have the opportunity to leverage these tools even more on the IBM i due to recent advances by IBM. What can these tools do for me right now and which one should I use? Let’s talk about what these tools do and common use cases. Most importantly WHY I would choose one tool or another for a use case and HOW I would use it?

Learning Objectives:
same as above

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All

9:00am MDT

Best testing practices for breaking up the monolith
Most companies are on a modernization journey which involves activities around integration with data or logic of existing applications. In order for your business to stay competitive, you need to release more code, in less time, without sacrificing quality. To do this you need to guarantee that the deployment of each iteration will not affect or disrupt day to day business.

Learning Objectives:
• Understand why establishing a testing baseline is non-negotiable
• How introduction of shift-left testing increases quality
• How to implement and automate successful testing strategies

Speakers
avatar for Jeroen van Dun

Jeroen van Dun

Product Manager, Rocket Software


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All
  • Audience Quality Assurance engineers, Developers and Operations looking to sleep at night when they deploy a new version into production :)

9:00am MDT

DevOps is not a 4-letter Word
SCM and Containers and Pipelines and Private cloud oh my! DevOps can sound confusing and even overwhelming, but fear not! It really isn’t all that hard… This session will center on an easy, non-technical demonstration where we’ll compare and contrast what you’re doing today with “best practices” in DevOps. From there, we’ll give you some quick and easy baby steps to get you started on the DevOps path.

Learning Objectives:
1. Learn DevOps terminology 2. DevOps ROI 3. Compare and Contrast with existing development/operations 4. Baby steps to start on the DevOps path

Speakers
avatar for Andrew Clark

Andrew Clark

DevOps Manager, Arcad Software
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level Intermediate
  • Audience Existing developer and operations personnel who want to implement or learn more about DevOps, and C-level decision-makers that need to understand DevOps better and how to cost-justify their decisions

9:00am MDT

Get Started with GIT and Version Control: Automating DevOps for the IBM i with Jenkins
Increase software development agility and standardize on a version control that is platform agnostic. Building IBM i source from Git

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All

9:00am MDT

GIT - The good, the bad, the ugly
Ever heard of GIT? Why should I use it? What are the benefits? Version control at its best!

Learning Objectives:
Version control is important. No blocking checkouts. Experiment with your code. Isolate long running feature development from the rest of your code.

Speakers
avatar for Guido Faecke

Guido Faecke

Professional Services Consultant, Zend by Perforce
Guido Faecke has been working with IBM midrange systems since 1989. In the year 2000 he discovered PHP and is writing software in PHP ever since. While contributing to several Open-Source projects, he promotes best practices and good coding standards every chance he gets. His current... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All
  • Audience Developers, IT Managers

9:00am MDT

Git branch management for IBM i source; I want JUST the changes
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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps

9:00am MDT

How to introduce modern development tools successfully
According to Help System’s 2022 Survey, modernising applications accounts for two of the top 5 concerns of IBM i customers. Business must react quickly to new and fast-changing requirements or lose their competitive advantage.

Our customers tell us that the drive to produce higher quality code in less time is forcing them to rethink their development strategies. The prediction that there will be almost no RPG skills available by 2030 is leaving IT managers quaking in their boots. The acknowledged solution to this problem includes standardising on a common development toolset across all platforms. This is not new, and IBM i development teams have been talking about it for years. With new supporting technologies from DevOps solution vendors, the time has come to stop talking and start acting! But how do you move past the conversation?

Learning Objectives:
• How other IBM i customers are approaching this challenge
• How to evolve your development process into the future whilst still running your business
• How are existing DevOps vendors supporting new technologies?

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All
  • Audience IT managers and developers looking for actionable advice on how to introduce modern development tools in their organisation

9:00am MDT

IBM i Data Integration with Hyperscalers
Applications outside of the IBM i have a need for utilizing IBM i Systems of Record (SoR) in order to connect to the data and files located in those environment. Many IBM i application owners have investigated software utilization decreases in order to read, move, or transform data for IBM i cost savings initiatives.

Learning Objectives:
Hybrid IT with IBM i
DevOps

Speakers
avatar for Richard Baird

Richard Baird

VP, CTO & Engineering Lead, Core Enterprise and zCloud, Kyndryl
Since September 2021, Richard has been Vice President and CTO for Kyndryl’s Core Enterprise and zCloud Practice focusing on IBM Z and IBM i technologies and how Kyndryl’s customers can expand their adoption of new technologies on these platforms, including integrating with Hyperscalers... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All
  • Audience All IBM i people

9:00am MDT

Leverage safe innovation with DevOps pipeline in IBM i
This usecase shows a partnership between client and Kyndryl to compose a capability to support DevOps toolset, as well as shift Ops to the left to operate application pipelines on behalf of the client. On IBM i environment we will segregate roles and responsibilities while convert current build and deploy pipeline. The main goal is to implement necessary solutions to support Continuous Delivery (CD) and assure DevOps toolset and pipelines for transitioned applications are properly built, tested, deployed, monitored, and supported after conversion. Kyndryl provided experts toward DevOps to launch the client into the Journey to work in conjunction with the development team. .

Learning Objectives:
DevOps Implementation
CI/CD
IBM i Examples

Speakers
avatar for Richard Baird

Richard Baird

VP, CTO & Engineering Lead, Core Enterprise and zCloud, Kyndryl
Since September 2021, Richard has been Vice President and CTO for Kyndryl’s Core Enterprise and zCloud Practice focusing on IBM Z and IBM i technologies and how Kyndryl’s customers can expand their adoption of new technologies on these platforms, including integrating with Hyperscalers... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All
  • Audience All IBM i people

9:00am MDT

Merlin and VS Code: Powerful Options for Next Gen Apps
What exactly is all of this hype around Merlin, VS Code and Next Gen Apps? Are you confused about what exactly "Next Gen Apps" really means, how your existing development fits into this new paradigm, and if you should consider embracing one of these new tools? Compare and contrast your development environment(s): SEU, RDi, VS Code and Merlin (and others??) and see what your different options are - then consider each package's inherent strengths and weaknesses as you start to move down the Next Gen path.

Learning Objectives:
1. Learn what NextGen Apps actually are
2. Learn about Merlin
3. Learn about VS Code and all of its "different flavors"
4. Compare and contrast Merlin v VS Code
5. Live demo of both tools

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow
avatar for Andrew Clark

Andrew Clark

DevOps Manager, Arcad Software
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level Intermediate
  • Audience Existing developer and operations personnel who want to implement or learn more about Merlin and DevOps, and C-level decision-makers that need to understand Merlin and VS Code better and whether either makes sense in their environment

9:00am MDT

Merlin, DevOps, Git, and Modern Development for IBM i
Application Modernization on IBM i has been a topic of discussion for years. Moving forward into the modern world can be a daunting task. Merlin was created to help. Leveraging Git, a Modern secure browser based IDE, Pipelines, Merlin is a ecosystem provided by IBM to help our IBM i application developers move toward a modern development world. This session will review what is 'Modern', how Merlin helps, we will include some live demos to help you understand the value and benefits.

Learning Objectives:

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level All

9:00am MDT

Next Gen Apps: Cloud - What Makes Sense on IBM i
You've probably heard about "Cloud-Ready" Next Gen Apps, but do you really understand what that means? "Cloud" means many different things to many different people, and some Cloud methodologies don't fit well into typical IBM i development; but there are also unquestioned advantages to Cloud-enablement that you can take advantage of today!

This session will help you understand all of the cloud-related terms like "Public Cloud", "Hybrid Cloud", "Containers", "Virtual Machines", IaaS/PaaS/XaaS etc. and clarify on-prem vs distributed advantages and disadvantages.

Learning Objectives:
1. Learn what NextGen Apps actually are
2. Learn what "the Cloud" actually is
3. Understand Cloud terminology
4. Understand advantages (and disadvantages) to different cloud methodologies

Speakers
avatar for Andrew Clark

Andrew Clark

DevOps Manager, Arcad Software
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level Intermediate
  • Audience Developers and operations personnel who want to implement or learn more about the Cloud, and C-level decision-makers that need to understand Cloud and Next Gen Apps better and how to cost-justify their decisions

9:00am MDT

Next Gen Apps: Getting your Code Ready
You've probably heard about Next Gen Apps, but do you really understand what that means? Doing Next Gen Apps RIGHT means that your code is "automation-ready": split into modular, easily-maintained pieces of code. Not only will you see immediate returns in lower testing times, fewer defects, better code-quality and higher ROI, but you can also much more easily expose your business functions to new user interfaces and APIs - all without being "locked in" to any specific product or framework.

This session will help you understand how to move your existing code base down the Next Gen path, on the way to becoming an Elite Performer in DevOps methodology.

Learning Objectives:
1. Learn what NextGen Apps actually are
2. Learn how to modularize your code
3. Learn how to expose business functions
4. Learn about testing automation
5. Learn about code quality
6. Learn how Next Gen fits into DevOps
7. Live demo showing actual process, tools and methodology

Speakers
avatar for Andrew Clark

Andrew Clark

DevOps Manager, Arcad Software
Andrew Clark has been working on Enterprise platforms for more than 30 years, starting his career as an intern at IBM working on the secret "Mankato Project” with RS/6000, mainframe, and pre-release versions of OS/400; advancing from testing to a Team Leader on the QQ (Query) team... Read More →
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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  DevOps
  • Session Level Advanced
  • Audience Developers and operations personnel who want to implement or learn more about Next Gen Apps, and C-level decision-makers that need to understand Next Gen Apps better and how to cost-justify their decisions

9:00am MDT

How Fast is Your Power System?
IBM regularly publishes 'feeds and speeds' of their latest hardware offerings using measurements that are sometimes hard to understand or comprehend. In this session we will explain the speeds of various parts of the hardware using an adjusted time scale we mere humans can better understand. If we change the scale and assume the fastest Power instruction takes 1/10 of a second, how long would it take to read a page from a spinning disk? How long would it take for a L2 cache miss? We'll take a look at the relative speeds of various hardware operations to get a better appreciation of the blindingly fast computer hardware that we all use everyday.

Learning Objectives:
After attending this session, you will:
1. Understand the relative speed differences of different hardware operations -- simple instructions, memory access, DASD access, and network access.
2. You will understand better how to optimize your software, so that you can focus on improving the areas where the most benefit can be realized.

Speakers
avatar for John Vriezen

John Vriezen

Principal Technology Architect, Precisely
I have been working with the IBM i platform for 35+ years, initially at IBM Rochester for 9 years, working  on DB2 and the Storage Management.  Then onto ShowCase Corp. working on Essbase OLAP engine for IBM i.  Currently I with Precisely, (formerly Syncsort, Vision Solutions... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Hardware
  • Session Level All
  • Audience If you want to better understand how the speeds of different computer operations compare to one another, this session is for you.

9:00am MDT

Modernize your Storage for IBM i
Storage requirements are growing and so are storage options. IBM i continues to evolve and adopt emerging storage technologies. Solid state drives/flash have been around for years, but these IBM offerings are changing. Have you heard about NVMe (Non Volatile Memory express)? SAN storage is offered in several forms and can provide extended capabilities. This session will focus on the latest with IBM i and storage options like NVMe.

Learning Objectives:

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... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Hardware
  • Session Level Intermediate
  • Audience Any IBM i customer on older hardware looking to upgrade their infrastructure, specifically related to storage

9:00am MDT

Power10 for the COMMON Audience
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.

Learning Objectives:

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... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Hardware
  • Session Level Intermediate
  • Audience Any IBM i customer on older hardware looking to upgrade their infrastructure

9:00am MDT

Upgrading your Hardware for IBM i: An opportunity for a big save or a big mistake.
Particularities of each of the models for the IBM Power Servers, specially for the IBM i, and their use cases. The tools you can use to perform capacity planning and what you need to consider. Licensing and the opportunities to save by gowing to a lower P-Group. When you can and can't transfer licenses.Things to consider when doing a ROI analysis. The opportunities for workload consolidation, having different Operating Systems on the same Frame, for saving on Hardware whilst imrpoving availability by using virtualization.

Learning Objectives:
1.- Know what IBM Power Server fits their needs.
2.- Know licensing particularities for the IBM
3.- Understand the opportunities to consolidate workloads, reduce costs and improve availability by using virtualization.

Speakers
avatar for Alejandro Lazzaro

Alejandro Lazzaro

Sr. IBM i Consultant, Fortra


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Hardware
  • Session Level All
  • Audience Decision makers, Solution Architects, System Administrators planning for a future hardware upgrade or dealing with a workload increase or consolidation plans.

9:00am MDT

What? I Can Create a Private Cloud with IBM Power Servers?
Back in 2019 IBM introduced Power Enterprise Pools 2.0 on the Power9 model E980, offering customers the flexibility to tailor system configurations with a mix of purchased and pay-for-use consumption of processors and software. This was expanded in 2020 to scale-out systems which are frequently used by IBM i customers. In 2021 and 2022, systems based on the latest Power10 processor were introduced and new consumption capabilities added. If you are interested in dynamic, flexible consumption or cloud-like economics with on-prem servers, attend this session.

Learning Objectives:

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... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Hardware
  • Session Level Intermediate
  • Audience IBM i customers on older hardware looking to upgrade their infrastructure, and interested in new consumption models

9:00am MDT

Ace in the Hole - Safeguarded Copy
Cyberattacks are becoming more frequent with each year that passes. You need to have a plan in place in the event that your system becomes compromised. The plan needs to include a solution for recovering the system quickly with minimal data loss. Enter Safeguarded Copy. Learn about how you can get frequent, immutable, full copies of your system to restore from in little time.

Learning Objectives:
1. Learn what Safeguarded Copy is.
2. Learn the value of using SafeGuarded Copy.
3. Get a quick overview of how to implement it.

Speakers
avatar for Steven McIver

Steven McIver

IBM i Certified Administrator, iTech Solutions
Steven is a certified IBM i System Administrator who has been working in IT for over 14 years. He was recognized as an IBM Fresh Face for his work on IBM i infrastructure in his early career. His main focus has been supporting IBM i and IBM Power Systems, and also specializes in VIOS... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience Anyone involved with Business Continuity, System Administrators, Storage Administrators, and those specializing in Security.

9:00am MDT

Are traditional licenses impeding your journey to the cloud?
The increased use of cloud servers within hybrid operations have left organizations that leverage IBM i software with traditional licensing mechanisms vulnerable to a loss of licensing, data and software availability. Even on premises, technology with physical serial numbers lack the flexibility to move from server to server while maintaining licensing.

Learning Objectives:
• Understand the difference between the license types LPP and VSN and what use cases they cover
• Which technologies are available to move LPARs to other servers (LPM, SRR)
• Is your IBM i system vulnerable for losing licenses or not
• Best practices to avoid losing your licensed state


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience IT managers looking to move workloads to the cloud

9:00am MDT

Benefits of Continuous Availability with Db2 Mirror for i
Discover how Db2 Mirror for i is a continuous availability solution that can improve your business continuity. Also learn about some of the new and unique features of Db2 Mirror.

Learning Objectives:
1. Learn about how Db2 Mirror can be used to eliminate outages or load balance workloads
2. Learn about the newest features of Db2 Mirror

Speakers
avatar for Shauna Rollings

Shauna Rollings

IBM i Performance Tools & High Availability Development, IBM
Shauna joined the IBM i development team in 2008. She has developed and supported IBM i performance data collector tools throughout her entire IBM career. From the very beginning of the Db2 Mirror for i project, she has also been the technical team lead for the Db2 Mirror Configuration... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience System Administrators or Business Executives looking for an RTO and RPO of zero.

9:00am MDT

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

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

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

Speakers
avatar for Brian Nordland

Brian Nordland

Technical Product Manager and Associate Software Development Manager, Fortra
Brian Nordland is the technical product manager for PowerHA and Robot HA at Fortra. Brian has spoken at events, webinars, and user groups—including COMMON—since 2014. He is a co-inventor on multiple patent applications and co-author on technical publications in high availability... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level Beginner
  • Award BRONZE
  • Audience Those looking to implement or enhance their HA or DR plans for IBM i that want an overview of various hardware replication technologies

9:00am MDT

Ensure your DR Plan Works in a Disaster
Do you have a disaster recovery plan? Are you really prepared? The difference in surviving in business depends on how well you prepare for the unexpected. This session breaks down the components of Disaster Recovery Planning as it relates building an effective Plan for the recovery of your Data Center. Testing your plan is essential as we examine critical points of failure, assumptions, technical gaps, and blunders.

Learning Objectives:
DR methodology proven in actual Computer room and FEMA disasters
Effective DR run books and testing for success

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience

9:00am MDT

I'm interested in deploying IBM Db2 Mirror for i - now what?
The IBM Db2 Mirror for i product provides synchronous replication of Db2 for i, which makes your database highly available between two nodes. Having a highly available database allows you to deploy applications in such a way that there is zero downtown required to do system maintenance that has traditionally been disruptive. In this session, you will learn about some of the considerations and planning that must be done before deploying Db2 Mirror.

Learning Objectives:
- You will learn about the types of objects that can be replicated by Db2 Mirror and about tools available to you to begin analyzing the object types used by your existing applications.
- You will learn about active-active and active-passive application topologies that work well in a Db2 Mirror environment.
- You will learn about the hardware and software required for deploying Db2 Mirror.

Speakers
avatar for Shauna Rollings

Shauna Rollings

IBM i Performance Tools & High Availability Development, IBM
Shauna joined the IBM i development team in 2008. She has developed and supported IBM i performance data collector tools throughout her entire IBM career. From the very beginning of the Db2 Mirror for i project, she has also been the technical team lead for the Db2 Mirror Configuration... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience System Administrators, Application Developers, or Business Executives looking for an RTO and RPO of zero.

9:00am MDT

Journaling for Logical Replication, Hardware Replication or No Replication at All?
In this session, we will discuss journaling and its role in logical replication, hardware replication and also its benefit to availability when you not using any type of replication. You might think you don't need journaling if you are not replicating, not using commitment control, and not using other advanced DB2 Features, but that's not the case. We will answer questions such as:
What is journaling doing at its core?
What are the benefits for journaling when I'm not replicating to a second system?
Why do I need to journal for Hardware Replication?
Why should I journal if I want to use Flash Copy?
What is remote journaling and how is it used for Logical Replication?
What are the journaling implications for DB2 Mirror combined with long distance logical replication?
How can I improve journaling performance, disk consumption and remote journaling bandwidth?

Learning Objectives:
1. Understand the basic IBM i DB2 journaling technology's purpose
2. Understand why journaling is useful or required for several different use case scenarios.
3. Learn some basic journal performance tips.

Speakers
avatar for John Vriezen

John Vriezen

Principal Technology Architect, Precisely
I have been working with the IBM i platform for 35+ years, initially at IBM Rochester for 9 years, working  on DB2 and the Storage Management.  Then onto ShowCase Corp. working on Essbase OLAP engine for IBM i.  Currently I with Precisely, (formerly Syncsort, Vision Solutions... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience IBM i system and database administrators will benefit by attending this session on general IBM i journaling technology and use cases.

9:00am MDT

Live Demo: Managing PowerHA Solutions
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

Technical Product Manager and Associate Software Development Manager, Fortra
Brian Nordland is the technical product manager for PowerHA and Robot HA at Fortra. Brian has spoken at events, webinars, and user groups—including COMMON—since 2014. He is a co-inventor on multiple patent applications and co-author on technical publications in high availability... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level Intermediate
  • Audience Those wanting to see PowerHA in action from a day to day management perspective to see just how easy it can be.

9:00am MDT

Logical Replication in the Cloud
Overview of Logical Replication, going in the Cloud is not your end point. Into the Cloud and resiliency is what you should strive for. At this point in time, Logical Replication is your best answer to real time replication for your DR/HA and possibly your remote backups in the Cloud. If implemented and managed properly, Logical Replication in the Cloud will keep your systems synchronized and available when 24/7/365.

Learning Objectives:
Understand that implementing and ongoing management of the solution are two different things. Your environment changes, so you should revisit and or modify your DR/HA plans often. Test at least once or better yet twice year. Common mistakes and misunderstandings, the solution(s) do not manage themselves. Partial use of applications may not be a True DR solution. Tolerance, how do you get your companies system(s) back to fully operational:
RPO
RTO

Speakers
avatar for David Contreras

David Contreras

IBM Power Systems Specialist, Meridian IT
My over 35 years of experience range from Senior System Architect, Systems Analyst, Senior System Engineer, Project Manager, Technical Manager and I.T Specialist. I have the ability to work effectively with different levels of staff from executive to technical. I have traveled extensively... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience All who are planning or responsible for Backup/DR/HA for their company.

9:00am MDT

The Power of Ready – Lessons learned from Actual Disasters
Case Study of 3 DR Events:
Can your IBM i survive a sudden, unplanned event? Learn from multiple computer room and regional disasters, and experience from over 400 recovery tests to know your DR Solution works in an actual Disaster.

People, Technology and Geography are common critical points of failure.

Learning Objectives:
Impact on People
Picking the right Technology
Location, Location and Separation .

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Turn up the Power: External Disk and Hardware Replication on i... A Case Study!
Your IBM i does a great job of managing internal disk, so why upgrade to external storage using a SAN? Your replication software may require some extra time and attention, but it gets the job done - so why change? Turns out there are lots of reasons to change both! This won't be a nuts and bolts how-to session. Rather it will be a case study of the decisions made by one large appliance and electronics retailer to implement these technologies, including the considerations, decisions, trade-offs, and benefits. You may not leave this session knowing how to do it, but you'll understand why you might want to, and you'll be ready to ask many of the right questions to get you there.

Some of the topics we'll discuss will include:_
- HA vs DR
- RPO (Recovery Point Objective) and RTO (Recovery Time Objective)
- iASP's
- Tool-kits
- Backups
- Flash Copy
- Recovery Scenarios

You'll leave this session better prepared to:
1. Determine if external storage is right for your environment
2. Understand the trade-offs involved with external storage and hardware replication
3. Know what questions to ask along the way!

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience Anyone who is curious about using external storage and hardware replication with their IBM i is encouraged to attend!

9:00am MDT

What IBM i Professionals can learn from NASA
The NASA moonshot initiative in the 1960s and 1970s was groundbreaking in the use of information technology and advanced developments. Correspondingly testing and quality assurance was mandatory, extensive, and equally inventive. Using examples from history we will discuss current issues such as disaster recovery (the Apollo One fire), test coverage (Apollo 13), specifications and prototypes (the development of the LM), user ability and experience (Apollo 14), and further education development (Apollo 17).

Learning Objectives:
Explore disaster recovery, High Availability, testing, and implementation of quality assurance in a unique and informative way.

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level All
  • Audience Testers and Developers interested in furthering QA knowledge. Anyone who was interested in the Mercury/Gemini/Apollo program in the 1960s.

9:00am MDT

What's new in PowerHA
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

Technical Product Manager and Associate Software Development Manager, Fortra
Brian Nordland is the technical product manager for PowerHA and Robot HA at Fortra. Brian has spoken at events, webinars, and user groups—including COMMON—since 2014. He is a co-inventor on multiple patent applications and co-author on technical publications in high availability... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  High Availability Resilience
  • Session Level Intermediate
  • Audience Anyone interested in PowerHA, either those considering it or those who have had it and want to learn what is new

9:00am MDT

Integrated File System Security Principles and Practices
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

Integrated File System through SQL Services
You may be familiar with some of the SQL Services. Did you know that many can be used with integrated file system objects? This presentation will show you a number of ways to manage integrated file system objects through the use of SQL Services. Many examples will be shown so that you can get an idea of how these services could be used in your environment.

Learning Objectives:
1. Understand which SQL services can be used with IFS objects
2. Learn ways these services could be applicable in your environment

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IFS
  • Session Level All
  • Audience Anyone from administrators to application developers that want to understand their integrated file system.

9:00am MDT

Integrated File System: Real Life
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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:00am MDT

Introduction to the Integrated File System
The integrated file system is a mystery to many. Concepts and terminology are different than 'native IBM i' and will be covered. Also, did you know the integrated file system is not just one file system? Details on each of the different file systems will be discussed as well as the basic ways you can access the integrated file systems.

Learning Objectives:
1. Understand the basic concepts of the integrated file system
2. Understand the different file systems
3. Learn some ways objects within the integrated file system can be accessed

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IFS
  • Session Level Beginner
  • Audience Users that are new to the IBM i, and/or to the integrated file system. IBM i developers and/or system administrators may also benefit if they have no (or limited knowledge) of the integrated file system and how it fits in the system.

9:00am MDT

Real-Time Access to Integrated File System Data Across the Network
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IFS

9:00am MDT

Strategies to Improve IFS Application Performance
This presentation will cover various best practices in using the integrated file system and integrated file system APIs to improve the performance of your applications.

Learning Objectives:
Learn what features are available that can help with application performance and apply them to new and existing applications which use the integrated file system.

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IFS
  • Session Level Intermediate
  • Audience Application developers

9:00am MDT

The Secrets to Making the Most of Online Meetings
Now that virtual meetings have become the new normal for so many of us, it's vital that we learn to make the most of this approach to getting things done. Whether you use Zoom, Teams, Webex, or another product, come to this session to learn the secrets to supercharging your online meeting productivity and getting results!

Learning Objectives:
In just 20 minutes, you'll learn:
- How to plan your meeting for success
- How to run your meeting for maximum productivity
- The best ways to take meeting notes
- When and how to end your meeting
- Tips and tricks to maximize your use of technology and supercharge your work from home environment

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Leadership and Management
  • Session Level All
  • Audience Anyone who coordinates or attends online meetings

9:00am MDT

The Secrets to Negotiating and Resolving Workplace Conflict
Do you dread the thought of negotiating on your own behalf? Are you unsure of the best ways to handle conflict in the workplace? If you answered yes to either of these questions, then you need to attend this session! We'll cover time-tested techniques for negotiations and conflict resolution that could change your life!

Learning Objectives:
In just 20 minutes, you'll:
- Learn to consider the value of an argument vs the cost
- Find common ground to smooth the negotiation
- Understand that all new ideas are great, and that we all make mistakes
- Show respect and build a reserve of good will to allow everyone to leave the negotiation with their head held high

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Leadership and Management
  • Session Level All
  • Audience We can all benefit from the techniques presented in this session!

9:00am MDT

Why Do We Continue to Have this Discussion
Security is on the top of everyone's mind ... yet few improvements ever seem to be implemented. Why is that and what can be done to move 'Improve Security' to the top of everyone's To Do list? Carol Woodbury explains the barriers she's seen and experienced throughout her career and offers suggestions to eliminate them.

Learning Objectives:
Understand why there's hesitation in implementing security enhancements in organizations.
Understand how to overcome the barriers preventing improving your organization's security posture.

Speakers
avatar for Carol Woodbury

Carol Woodbury

President, CTO, Co-Founder, DXR Security
With over 25 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Leadership and Management
  • Session Level All
  • Audience Anyone in IT management

9:00am MDT

Automation and My Vision For the Future
The world is changing. You can see it if you look around you... computers understand your voice, cars drive themselves, and so much more! What will things look like in 10 or 20 years? How will the world change? And, most importantly, how can we be ready for it?

Learning Objectives:
1. Understand how automation is already changing the world.
2. Think about how it will change things over time.
3. Be inspired to become a part of it!

Speakers
avatar for Scott Klement

Scott Klement

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All

9:00am MDT

Best Practices for Open Source Package Management and Security
Free open source software (FOSS) is "free as a puppy." We should know that the "free" indicates freedom, not zero cost! Adoption of open source software also brings its share of responsibilities. Failure to properly care for your open source stack can be costly. Incorrect use can also be costly.  

In this session, we will look at best practices surrounding the use of open source software, which involves proper management of user authorities, support, CVE mitigation, and more.



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 →
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All
  • Audience Those responsible for setting the IT strategy, particularly around the use of open source software

9:00am MDT

IBM i 7.5 Plus Favorite Features
In this session several key IBM i architects and development leaders will review the highlights of the latest IBM i 7.5 release along with the Latest TR releases. Many of our favorites new features will be covered by this team from the IBM i lab in Rochester

Learning Objectives:

Speakers
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All

9:00am MDT

IBM i Latest & Greatest - 7.5 and TRs Overview
In this session, Steve Will, IBM i Chief Architect, will give an overview of the latest features of IBM i, including the most recent announcements. Db2, Application Development tools, Db2 Mirror, Open Source, Security features, ACS, Navigator – it’s all in there!

Learning Objectives:
1. Learn the biggest recent features from IBM i
2. Get pointers to what other sessions can give you the details on specific big items.

Speakers
avatar for Steven Will

Steven Will

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All
  • Audience Everyone in the IBM i community

9:00am MDT

IBM i Strategy, Roadmap & Innovation
Where is IBM i going? How is IBM investing in this integrated platform? In this presentation, Steve Will, the IBM i CTI & Chief Architect, and Alison Butterill, Product Manager for IBM i, will discuss the current state of the IBM i operating system, the underlying business, and the growing community of IBM i users. They will show the IBM i strategy that delivers value to IBM i clients and to IBM, they'll highlight key enhancements which strengthen IBM i’s place in your IT plans, and they'll discuss the future roadmaps for the platform.

Learning Objectives:
1. Understand the current IBM i strategy and the IBM i market
2. Understand the future direction of IBM i, and how that is helping clients today
3. Learn several client examples of innovative technology solving business problems using IBM i today.

Speakers
avatar for Alison Butterill

Alison Butterill

WW Program Director, Product Management, IBM i, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →
avatar for Steven Will

Steven Will

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All
  • Audience Any IBM i user or executive whose business uses IBM i, who needs to understand where IBM i is headed, and how it can be used today to innovate for the future.

9:00am MDT

Modernize without Vendor tools
As you may have discovered, there are many paths to modernization and digital transformation. The marketplace has many commercial tools that all bring unique value. Alternatively, one can leverage open source technologies to write reactive web interfaces, expose REST APIs, monitor the system, secure applications, or automate daily processes. This session will explore the FOSS (free open source software) option for modernization paths.

Learning Objectives:

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All
  • Audience IT strategists

9:00am MDT

What is IBM Power Systems Virtual Server and why should i as IBM i user being interested
After this session you will know what IBM Power Systems Virtual Server is and what capabilities it has and what benefits it brings to IBM i users.  Beside the explanation of what PowerVS is you will hear, based on reference stories, why other IBM i users have chosen for PowerVS and how they benefit of using this solution. For people familiar with PowerVS, in this session also the new features, like Shared Processor pool and Global Replication Service, that have been implemented during the past year will be covered

Learning Objectives:
1: know what IBM Power Systems Virtual Server is
2:know the capabilities of IBM Power Systems Virtual Server
3:know about reference of customer who are using IBM Power Systems Virtual Server

Speakers
avatar for tonny bastiaans

tonny bastiaans

WW Product Manager for IBM Power, IBM
Tonny Bastiaans is World Wide Product manager Power System at IBM. Started more than 20 years ago as an engineer on RS6000 systems (the predecessor of Power). He moved via several roles to his current role. With his technical background he is bridging the gap between technic and business... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  IT Strategy
  • Session Level All
  • Audience IBM i administrators, it architects, Power infrastructure administrators who wants to know about IBM Power Systems Virtual Server

9:00am MDT

What’s New in the Domino Low-Code Collaboration Platform
With a new release of HCL Domino coming out every year, the number of new features and enhancements is staggering! Come to this session to learn details about the new cool features that are part of this amazing low-code platform. You will also get a glimpse into where the product is going.

Learning Objectives:

Speakers
avatar for Kim Greene

Kim Greene

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

How Many JDE instances can you have on 1 LPAR
See how a customer has utilized the versatility of the IBM i to support multiple versions of JDE through out the years.

Learning Objectives:
1. Be able to identify how multiple versions can be run on an IBM i lpar.
2. Be able to identify the different levels of code being run.
3. Learn what other configurations have to be in place before running multiple versions on the same lpar.

Speakers
MM

Michael McClure

ICT ERP Team Lead, Mueller, Inc.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Middleware (other), Systems Management
  • Session Level Beginner
  • Audience System Admins and CNC personnel looking for different ways to get more out of their machine.

9:00am MDT

IBM HTTP Server (Powered by Apache) Overview
Learn about what the HTTP server is and how it can work for you. Get to know the fantastic features of the latest IBM HTTP Server for i (powered by Apache) version 2.4. Quickly and easily get your HTTP server up and running using the IBM Web Administration for i GUI interface. This session will introduce the HTTP Server on i, some of the key differences on i, some of the areas that are tightly integrated into the IBM i operating system. We will also take a look at the key important topic of security and how to configure the HTTP server securely and the different options available. In addition, the very latest new features will be covered, as there are many new additions in the latest Apache 2.4 version.

The user will have a basic understanding of the IBM HTTP Server. They will be equipped to deploy a Web site in a secure manner. By the end of this session, attendees will understand:

• Key design points and basic configuration that every Web server requires
• How to get your web site up and running using the graphical integration wizards provided by IBM Web Administration for i
• New features for IBM HTTP Server for i (powered by Apache ) version 2.4, such as SNI, OCSP, ECDSA cipher, TLS1.2, new authentication mechanism, remote IP, HTTP server subsystem definition, etc.
o The basics of web security and securing the HTTP server

Speakers
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Middleware (other)

9:00am MDT

LoopBack: The Easiest APIs You've Ever Made
LoopBack is an open-source Node.js framework that allows you to create REST API endpoints with ease. This session will cover the LoopBack connector that allows you to connect to IBM i and create API endpoints from either existing database schemas and tables. We will also look at the API generator that allows you to create REST API endpoints in the terminal, then migrate your endpoints to Db2 for i. I will also demonstrate how to secure LoopBack API endpoints with both an SSL certificate and with an authentication schema. After the session I'm sure you will agree that LoopBack is the easiest way to make API endpoints on IBM i!

Learning Objectives:
1. Learn what LoopBack is
2. Learn how to make API endpoints with LoopBack
3. Learn how to secure LoopBack API endpoints

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Middleware (other), Programming - Frameworks
  • Session Level All
  • Audience This session will be beneficial for developers who are looking for an easy way to connect their IBM i applications with the database through REST API endpoints.

9:00am MDT

IBM i Network Monitoring, Diagnostics and Troubleshooting
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

IBM i Networking and Servers Overview
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.


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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

Surviving a Ransomware Attack
A few years ago the company was hit with a ransomware attack. This is the tale of how it happened and how we continue to recover.

Learning Objectives:
1. How 1 particular attack happened to a company with an IBM i.
2. What happened in the immediate aftermath.
3. How we continue to improve our systems to prevent future attacks.
4. How we continue to educate our users about threats.

Speakers
MM

Michael McClure

ICT ERP Team Lead, Mueller, Inc.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Networking
  • Session Level All
  • Audience Anyone interested in a real life story of surviving a ransomware attack.

9:00am MDT

Build Your Brand, Build Your Career
This session will be focused on N2i attendees, teaching them how to stand out their career.

Learning Objectives:
1. Gain an understanding as to why a personal brand is important to career growth.
2. Learn basic steps for creating a personal brand.
3. Gain creative ideas to help establish a positive reputation within the IBM i world.

Speakers
avatar for Anna Marrah

Anna Marrah

Anna has a background in marketing, communications, sales, and membership promotion. She became acquainted with the IBM i community when she began working for COMMON as their Marketing Manager in 2018. During her time at COMMON, she spearheaded the revival of the IBM i professionals... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level Beginner
  • Audience Professionals in the IBM i space who are within the first 5-10 years of their career as well as seasoned professionals who are job hunting.

9:00am MDT

Everything they never taught you!
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.

Attend this session to learn to:
* Collaborate more effectively with other team members
* Resolve conflict with coworkers
* Improve your relationship with your boss
* Negotiate to get what you want
* Effectively market yourself in your current position
* Communicate better with everyone
* Understand EVERYTHING THEY NEVER TAUGHT YOU!

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Award GOLD
  • Audience Anyone who must work with other people will benefit from this session!

9:00am MDT

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

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

Speakers
avatar for Kim Greene

Kim Greene

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Get out of Your Comfort Zone!
Staying in your comfort zone can and most likely hindered your career. Have you tried seeing what happens when you tried something outside of your comfort zone? would you be willing to try? This session will highlight some of the reasons why you should get out of your comfort zone and try something new. You will probably be surprised by the consequences of getting out of your comfort zone.

Learning Objectives:
1. Get comfortable with trying something new
2. trying something new and seeing the results.
3. being comfortable with trying something new again.

Speakers
avatar for Rochelle Petty

Rochelle Petty

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

Marina Schwenk

Software Developer, Everbrite
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 works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Everyone

9:00am MDT

Give me an Hour and I'll Give you a Week
"Hey, do you have a minute?" We're asked that question many times every day, and while we say yes, the sad answer is... NO! Our lives and our careers are busier than ever. Feel like you're barely keeping your head above water at work? You're not alone. We struggle to keep up with the demands of our careers while retaining some semblance of balance between work and personal time. Come to this session and learn the life hacks you need to supercharge your productivity! By the end of the session you'll have the tools to save over 168 hours - that's one full week - every year! What will you do with all that extra time?

You'll leave this session knowing how to:
- Focus on the right things at the right times
- Understand the difference between urgent and important
- Better manage the constant interruptions
- Always have the information you need at your fingertips
- Avoid time wasted due to losing valuable data
- Automate repetitive tasks
- Use technology to your advantage

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Everyone who would like to be more productive!

9:00am MDT

How to Achieve and Maintain High Quality Work
We have been told to work smarter, not harder. But how do we go about doing so? This session will provide concrete steps you can take to ensure you are producing high quality work in the most efficient way possible. Learning these skills will not only lead to increased productivity but also significant personal satisfaction.

Come to this session to learn:
1) Essential elements for producing high quality work
2) How to positively handle interruptions
3) Understanding the different types of and how to spend your time in the most constructive type of “busyness”

Speakers
avatar for Kim Greene

Kim Greene

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

How to Communicate with your System Admin
In this light-hearted session we will explore ways to improve efficiency between developers, users, management, and your friendly neighborhood IBM i system administrator. Come and participate in an open forum discussion where we all try to learn how to achieve perfect harmony (or at least frustrate each other less).

Learning Objectives:
Learn how to coexist peacefully with your IBM i system administrator! "Bridge the gap" and improve understanding and efficiency between developers, users, manager, and system administrators.

Speakers
avatar for Steve Riedmueller

Steve Riedmueller

IBM i Tech Lead, John Wiley & Sons, Inc.
I have worked on the IBM i platform as a System Administrator/Engineer since 2001, starting out on OS400 V4R5.  I'm passionate about leveraging IBM i SQL Services for system administration.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Developers, users, managers, and system administrators.

9:00am MDT

How to Remain Relevant in a changing IT Environment”
Education in today’s IT and Business Environment challenges both the Company and the employee. What skills are needed to provide for today’s (and tomorrow’s) business needs? How does the company and the employee deal with these challenges? How to decide; what to learn, how to learn and when to learn, when planning for future needs. These challenges differ depending on where a person is in their careers path. Jim discusses these challenges and more in this presentation. Great presentation for managers and employees!

• The question of being relevant?
• How to know… your relevancy
• Uh Oh… I’m not relevant (what to do)
• Business vs IT Skills – the Balance
• The Specialist vs the generalist – Let’s hire a consultant

Learning Objectives:
1. Internalize the need to continue learning in Information Technology
2. Understand how your current skills can be leveraged into new skills
3. Have a better understanding of how to approach today's educational opportunities

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Explains to IBM i Professionals why education is important to them and how to efficiently gain needed education

9:00am MDT

IBM i Explained
Even if you are working with IBM i today, there are most likely areas that you are not so familiar with. What does object based operating system means, what is actually Singel Level Storage and why does the system almost never goes down?

Learning Objectives:
Learn the fundamentals of the greatest operating system on earth

Speakers
avatar for Torbjörn Appehl

Torbjörn Appehl

ISV Advisor, Built on Power
I've been working with IBM i and It's predecessors since 1997. Today I have my own company Built on Power, focusing on helping IBM and their Independent Software Vendors (ISV) to fully take advantage of all technologies available on the platform. IBM Champion since 2016, producing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level Beginner
  • Audience All people getting in contact with IBM i in one way or another

9:00am MDT

IBM Power Explained
IBM Power servers are not just another off the shelf server like the rest on the market. It has it’s own unique architecture, built from the very bottom up from the same vendor. IBM.  We will go through the different characteristics and compare it to x86 servers from Intel or AMD for example.  IBM Power is built for business applications in mind. Not for a personal computer.

Learning Objectives:
Learn the concept of IBM Power based servers

Speakers
avatar for Torbjörn Appehl

Torbjörn Appehl

ISV Advisor, Built on Power
I've been working with IBM i and It's predecessors since 1997. Today I have my own company Built on Power, focusing on helping IBM and their Independent Software Vendors (ISV) to fully take advantage of all technologies available on the platform. IBM Champion since 2016, producing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level Beginner
  • Audience All kinds of people.

9:00am MDT

N2i Employer Panel
This panel of IT managers and business owners will offer invaluable insight to N2i attendees on what skills they need and how to present themselves when talking to potential employers.

Learning Objectives:

Speakers
avatar for Anna Marrah

Anna Marrah

Anna has a background in marketing, communications, sales, and membership promotion. She became acquainted with the IBM i community when she began working for COMMON as their Marketing Manager in 2018. During her time at COMMON, she spearheaded the revival of the IBM i professionals... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

N2i Meeting of the Minds
The N2i strategy team will meet N2i attendees where they are at and discuss challenges they face and opportunities on the platform. This offers a great opportunity for community-driven conversation as well as network and group growth.

Learning Objectives:

Speakers
avatar for Anna Marrah

Anna Marrah

Anna has a background in marketing, communications, sales, and membership promotion. She became acquainted with the IBM i community when she began working for COMMON as their Marketing Manager in 2018. During her time at COMMON, she spearheaded the revival of the IBM i professionals... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Strategic IT - The Art of Advancing your Career Beyond the Technical
What are your career goals? Sure, we're all great with technology, but to continue growing in our careers requires that we do the unthinkable... we actually have to TALK to each other. And even worse... we have to TALK to the business people in our companies! Why? WHY? Why would we possibly want to TALK to PEOPLE? The answer to that question is that today more than ever, technology IS the business. So it makes sense that IT can help or hurt a business more than ever. It's critical that we align our IT efforts, goals, and strategies with those of the business - and all of that requires good communication. Would you like to have a seat at the table, to be taken seriously as a businessperson, and to have a voice in the decisions our companies make? Then attend this session to partner with your business and communicate for success.

During this session, you'll learn the business and communications skills needed to truly partner with the business and elevate your career. These will include:
1. Speaking the language of the business
2. Thinking like a businessman
3. Demonstrating strong leadership
4. Selling fellow business leaders on the value proposition of IT investments
5. Always being prepared
6. Earning influence
7. Preparing for and navigating board meetings_
8. Difficult conversations
9. Always keeping your cool
10. Aligning IT with business goals

Speakers
avatar for Gregory Simmons

Gregory Simmons

Software Engineer, PC Richard & Son
Gregory Simmons is a Software Engineer at P.C. Richard & Son.  He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered instructor with IBM’s Academic Initiative and an RPG and IBM i instructor at Scott Regional Technology Center, where... Read More →
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience All IT professionals who aspire to grow, become better communicators, and enhance their career!

9:00am MDT

Strive for Excellence
We all come from different backgrounds. Some of us might have heard or lived under the mindset of “Failure is not an option” or “You have to keep pushing to reach your goals” and that was the only way we knew to strive for excellence. While this session will help you hit the same goals but, give you tools to avoid the burnout that many of us failed to avoid.

Learning Objectives:

Speakers
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
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 works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Success as an 'I'
Many technology workers are capital 'I's, or "Introverts". The simplest definition of an introvert is a person who prefers time alone and finds solitude is essential to recharge. When in social situations, introverts tend to prefer smaller, quieter groups as opposed to large, loud environments. Introverts may also be shy, but shyness and introversion are two different things.

How, as an introvert, can you work your way up in your career if you prefer to work alone? How can you manage the demands of interaction with others in leadership positions?

In this session, Dawn will share her experiences being both shy as well as an "I". She will provide tips for success as an introvert as well as how to overcome shyness.



Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM.A former IBMer, Dawn is now an independent... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Technologies unique to IBM i and Power (and competitors really want)
IBM i and IBM Power has unique and very innovative technologies that solves problems and issues the rest of the IT-world still struggles with. Many tried to copy technologies such as Microsoft in a number of failed projects.

Learning Objectives:
Learn about unique IBM technologies that we take for granted but the rest of the IT-world would love to have

Speakers
avatar for Torbjörn Appehl

Torbjörn Appehl

ISV Advisor, Built on Power
I've been working with IBM i and It's predecessors since 1997. Today I have my own company Built on Power, focusing on helping IBM and their Independent Software Vendors (ISV) to fully take advantage of all technologies available on the platform. IBM Champion since 2016, producing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level Beginner
  • Audience All interested in IBM technologies

9:00am MDT

The N2i Advantage
Finding new to IBM i professionals can be a challenge for most customers but, not impossible. These professionals know where and how you can find new IBM I professionals.

Come listen to how they got started on the platform, what they are currently doing and what they are doing to help the next generation get started on the platform and how be successful.

Learning Objectives:
1) Find out what resources are available to you as an employer/employees
2) Bring awareness to the n2i committee and show what an advantage being a part of the committee can be to your career.

Speakers
avatar for Rochelle Petty

Rochelle Petty

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

Marina Schwenk

Software Developer, Everbrite
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 works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Anyone

9:00am MDT

Twenty iPhone tips that will change your life
As an Apple device owner, you've likely been pounding on the tempered glass of your various iPhone models for well over a decade now. You might easily spend up to several hours a day interacting with the device while you're on the go, perhaps even using it occasionally to interact with your IBM i system.

Hence, small time-saving tips you can apply in your daily interaction with your smartphone could quickly add up to quite a few hours over the course of the year. Likewise, any tricks you can use to more quickly and/or conveniently make the device do what you need it to do could help alleviate some of the minor frustrations we encounter while navigating today's information-heavy world. Apple has introduced so many new features over the course of 16 major OS releases that it's likely there are a number of iPhone "hidden gems" you have yet to discover.

For instance:
* Have you ever been frustrated trying to position your cursor in just the right position to insert characters or fix a typo in a text message or email?
* Have you experienced eye fatigue or even sleep deprivation as a result of interacting with your bright iPhone screen in a dark room, even on its darkest setting?
* Are you finding it difficult to read the small text in apps that don't support pinching as a way to zoom into the interface?
* Do you have trouble using one hand to reach all areas of the screen because your finger or thumb can only reach so far while holding the phone?

In this short 20 minute session, we'll demonstrate 20 highly useful (and relatively unknown) iPhone tips and techniques you can put to immediate use to improve your interaction with that trusty digital companion in your pocket. Sorry Android users, this is an Apple iPhone-specific session — though you're welcome to come see what you're missing!



Speakers
avatar for Richard Milone

Richard Milone

CNX
Richard Milone has worked as an application developer on the IBM i platform and its predecessors of various names for over 25 years. Richard served as Director of IT for Packaging Resources until co-founding CNX Corporation in Chicago in 1996, where his initial focus was on ERP enhancements... Read More →
avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation
Robert's blood runs "deep green" after having launched his IT career in 1992 as a developer in the 5250-heavy AS/400 world, specializing in the development of shop floor applications for manufacturing and distribution sites. In subsequent years the platform — and the platform's... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience iPhone users who would like to see a collection of somewhat obscure OS tips that may improve their user experience

9:00am MDT

Upgrade your TODAY!
We all want to upgrade our computer, car, house, phone... The list goes on and on. But how about upgrading our TODAY, so we get the most out of each new day? How much more productive would TODAY be if we could focus on the right things? How would you like to give your TODAY a processor upgrade, and get more done TODAY? How about a memory upgrade, so forgotten tasks don't fall through the cracks TODAY, and all the information you need will be at your fingertips TODAY? What does each new TODAY mean to you, and how do you make the most of it? Attend this session to upgrade your TODAY, and make TODAY matter!

In this session you'll learn:
- The value of each day and how to live TODAY to the fullest with no regrets
- How to spend each TODAY wisely by focusing on the right things, supercharging our productivity
- Ways to use tools and develop systems to be organized TODAY, supplementing our limited memories

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Everyone who wants to make the most of all their TODAY's should attend this session!

9:00am MDT

Want them to want you? Be the ideal employee by unleashing your inner child!
In today's hyper-competitive world, we're all striving to be the best employees we can be. We want to impress our boss, finish that big project on-time and under-budget, and earn that big promotion with a hefty raise. But how? What if I told you that the secrets to being the ideal employee aren't secrets after all? That you've known them for a very long time... since kindergarten! Remember when you learned to always be kind, play fair, and say thank you? Those life lessons still apply today! Come to this fun and lively session to learn how to apply these and many other timeless bits of wisdom you learned as a child, to make you the ultimate employee!

Learning Objectives:
1. Improve your relationship with your boss
2. Attain your goals and improve your work performance
3. Earn the respect of your coworkers and build good will

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Personal Development
  • Session Level All
  • Audience Everyone who has a job, works with other people, and was once a child will love this session!

9:00am MDT

Agile Testing and Concepts
Iterative development models are being used more frequently. We will discuss the concepts of Rapid Application Development focusing on agile methodology. Topics include the manifesto and how it relates to teams and practices. From there we will explore testing advantages and challenges and how to be productive. Test automation is a core concept in most agile implementations so we will cover how tools apply and can be used.

Learning Objectives:
Understand Iterative Life Cycles
Define incremental development models and Iterative development model
Understand Basic Agile concepts and the manifesto
Determine the best types of testing for specific applications in a RAD environment

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Program Testing
  • Session Level All
  • Audience Audience: Developers and Testers who want to further their quality assurance knowledge base and how QA applies in Agile Software Lifecycle Development.

9:00am MDT

Basics of QA and Testing for IBM i Professionals
Quality Assurance in software development is known to be an important factor for IT teams and goals. Regardless if testing is done by developers or testers it is crucial. We will talk about concepts and practices defined as the foundation of testing by ISTQB methodology. This will covering topics such as defects and ramifications, how testing is part of the larger quality assurance model, the definitions of error, defect, fault, and failure. We will discuss the difference between debugging and testing, the objectives of testing, and how testing changes at different parts of development and in different development lifecycles.

Learning Objectives:
Describe how a defect in software can cause harm to a company. Distinguish between the cause of a defect and its effects. Give reasons why testing is necessary by giving examples. Describe why testing is part of quality assurance with examples of how testing contributes to higher quality. Explain and compare the terms error, defect, fault, failure, and the corresponding terms mistake and bug. Recall the common objectives of testing.

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Program Testing
  • Session Level All
  • Award SILVER
  • Audience Testers interested in the ISTQB methods and doctrine. Developers who want to test more efficiently and work with QA/Testers more effectively.

9:00am MDT

Next Gen : Automating your Test Environment, the RIGHT Way
In order to perform testing the right way, you need to automate. This is beyond just scripts that run, but building out the entire test landscape. With Next Gen Apps, the ability to spin up, load, test, and remove is key. Whether this is in the cloud or on premise, automating the creation of your test environments and data is critical to a successful DevOps implementation?

So what's involved : Cloud service provider (or on prem), a subset of production data that is protecting PII data, pipeline of tests, producing a record of those tests, and much much more.

Learning Objectives:
1) Discover how test data management plays a role in testing
2) Understand how and why test cases need to be managed
3) Learning the right way to test your Next Gen App.

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 →
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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Program Testing
  • Session Level Intermediate
  • Audience Are you a Project Manager, developer, or a QA specialist, see how learning how to test the right way can benefit application development but the companies bottom line.

9:00am MDT

Service programs and Unit Testing – The Perfect Pair
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

Software Developer, Everbrite
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 works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Program Testing
  • Session Level Intermediate
  • Audience Application Developers, testers

9:00am MDT

Why is automated testing so important in Next Generation Applications?
The business need for faster deployment of changes and new functionality can only be met by building Next Generation Applications that can be automatically tested in a DevOps pipeline.  This session focuses on what you need to know to begin to implement automatic testing.

Learning Objectives:
1. Testing Types & Methods
2. The Testing process
3. Interfacing with the Pipeline

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Program Testing
  • Session Level Beginner
  • Audience Anyone who is interested in preserving the value of their IBM i Investment through modernization

9:00am MDT

An RPGer's Take on VS Code for IBM i
These days RDi and Merlin aren't the only options for IBM i developers looking for an SEU alternative. If those IBM products aren't your cup of tea or are beyond your budget, there's a new free tool that you may find intriguing.

In this session, Susan will introduce you to her explorations of the open source extension to Visual Code Studio called Code for IBM i. Come to see how to make the transition from the green screen to a powerful, expandable and more productive free alternative. Join Susan to see what all the hype is about and explore another modern way to develop RPG/CL/COBOL code for IBM i applications.

Learning Objectives:
1. Understand what Code for IBM i offers RPG/COBOL/CL programmers
2. Learn how to make a transition from green screen editors to a modern IDE

Speakers
avatar for Susan Gantner

Susan Gantner

Partner400
Susan's career has spanned over 30 years in the field of application development. She began as a programmer developing applications for corporations in Atlanta, Georgia, working with a variety of hardware and software platforms. She joined IBM in 1985 and quickly developed a close... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level Intermediate
  • Audience IBM i traditional language (RPG, COBOL, CL, etc) developers looking to enhance productivity with a modern IDE

9:00am MDT

Are You Coding Efficiently? Microsoft VS compared to RDi
Take a deep dive into the advantages and disadvantages of using Microsoft Visual Studio and Rational Developer for i for your IBM i environment. Learn the differences between the two tools and instances on when to use one tool versus the other.

Learning Objectives:
1. Compare and contrast two similar tools, break down the pros and cons of each
2. Learn ideas and advantages for how to improve development efficiency using modern toolsets
3. Learn from a real use case about when Microsoft VS used in tandem with existing RPG development

Speakers
avatar for Bill Onion

Bill Onion

Managing Director, Briteskies
I'm a life-long IBM i Fan! Basically born and raised on this awesome platform.Now, I'm leading the Briteskies team as we help companies to: - Leverage their investment in IBM i by extending the life of there RBP-based applications - Integrate their IBM i systems with 3rd party application... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level All
  • Audience Modern language developers, System Admins, RPG developers

9:00am MDT

Building and Sharing RDi Templates to Improve Developer Productivity
In order for developers to improve productivity by reusing code created by others, a plan for encouraging reuse must be put in place. RDi provides the ability to share Templates and snippets between developers. This session explores how to capitalize on that capability.

1. Improving developer productivity with Templates & Snippets
2. Creating Templates & Snippets
3. Sharing Templates and Snippets with other Developers



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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools

9:00am MDT

Hidden Gems in RDi
As a long-time RDi user, Susan will cover some of her favorite RDi features. Many of these features are often overlooked by new - and even experienced - RDi users.

A few examples include:
- How RDi answers the question "Where am I?"
- Why Object Table can be your best friend
- Under-utilized RPG editor navigation features
- Customization tips _And many more.

If you're an RDi user, join Susan to see if you may have missed something useful - and bring your own favorite hidden gems to share. If you're not an RDi user, you may find some good reasons to give it a try.

Learning Objectives:
1. Learn to utilize more features of RDi
2. Become a more productive developer

Speakers
avatar for Susan Gantner

Susan Gantner

Partner400
Susan's career has spanned over 30 years in the field of application development. She began as a programmer developing applications for corporations in Atlanta, Georgia, working with a variety of hardware and software platforms. She joined IBM in 1985 and quickly developed a close... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level Intermediate
  • Audience Users - or potential users - of RDi (Rational Developer for i)

9:00am MDT

Introduction to RDi's Code Coverage Tool
This session will take the mystery out of using Code Coverage. Learn how this tool can help you adequately test your code and help QA with their goal of improving code quality. We cover setup, running and reporting.

Learning Objectives:
1. Understand what this tool can do to help you improve your coding efforts.
2. Demonstrate how this tool can help your Quality Control staff track testing of new modified code.
3. Show more productivity and help make a case for purchasing RDi

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level All
  • Audience Managers, Quality Control personnel and any level developer

9:00am MDT

Introduction to VS Code for IBM i
Maybe you've used VS Code before, maybe you haven't - but have you used it for your IBM i development? Visual Studio Code can be used for all your RPGLE, COBOL, CL, etc, and this will cover installation, writing code, developer tools, creating programs, and much more.

Learning Objectives:
1. Learning about what VS Code
2. How does it work with IBM i
3. Writing/compiling ILE languages inside of VS Code

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level Beginner
  • Audience Developers

9:00am MDT

Modern IDE Comparison for IBM i
In this session we review the IDEs available for developing IBM i native applications. We will look at the pros and cons for each solution. While we all may have our favorite, we all want to see our development community using Modern development tools.

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

One Order of Code Factoring With a Side of RDi
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 Charles Guarino

Charles Guarino

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

RPG and CL Speak Open Source
I come from the world of the traditional RPG developer. And I arrive bearing open-source peace offerings for my fellow IBM i travelers. When I started my IBM i development journey back in the eighties I was constantly developing custom RPG programs and CL command utilities to help get work done easier. After 30+ years the journey continues to discover the perfect integration for IBM i.

Even though there is no perfect integration technology, in this session you’ll learn about useful ways to integrate between traditional languages such as RPG and CL and the open-source stack available on IBM i, allowing you to do many of the things you thought were impossible with RPG.

Our RPG and CL integration examples will primarily focus on Python. However, this integration approach is relevant for any of the open-source languages or applications, including Python, Bash Scripts, QShell/PASE commands, Java, PHP, Node.JS and others.

By attending this session and adopting the techniques learned in this session your RPG and CL utility toolbox has just tripled in size. You won’t want to miss this inspiring open-source technical session.

Learning Objectives:
1. Learn the benefits of Integrating open-source apps with RPG and CL
2. Learn the development pattern for using open-source with RPG and CL
3. Adopt and utilize the provided RPG/CL/Open-Source examples right away in your own shop

Speakers
avatar for Richard Schoen

Richard Schoen

President, Mobigogo LLC
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level Intermediate
  • Audience Any RPG, CL or Open-Source developer looking to expand their usage of RPG and CL to quickly integrate the ability to take advantage of open-source apps and utilities written in bash, PHP, Python, Node, Java and more.

9:00am MDT

RPGLE and Git the right way
Understanding how to use git with VS Code or Merlin IDE, writing RPGLE/COBOL/etc locally, deploying and building to IBM i. You'll also see the available git and IDE tools to make your development life so much simpler.

Learning Objectives:
1. Available tools in your IDE to make writing code locally much simpler
2. What git tools are available to make you a better developer
3. Benefits of moving source code into git

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools

9:00am MDT

Solving Critical Business Problems with Innovation
An introduction to web services, client side(AxisC Transport) and server side (IWS) with a focus on real life examples.

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level All
  • Audience Architects and developers who are interested in creating web services to solve real life business critical problems. This session will showcase the technical details of hosting web services and invoking web services but will also showcase real life examples of direct service side/client side implementation of web services on the IBMi.

9:00am MDT

Using RDi to Refactor RPG Code
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

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools

9:00am MDT

What's Going on with My Code: Debugging 101 with Rdi
Gain accelerated insight of your code with the latest in debugging technologies.

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

What's Up with Merlin?
IBM i Merlin was announced and released in 2022. Much has changed since the first appearance of this DevSecOps toolchain for modern IBM i development. Catch up on Merlin!

Learning Objectives:
1. Basic architecture of Merlin
2. Basic administration and usage of Merlin
3. Recent developments in Merlin

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, and 2023 Champion.A consulting programmer with over 30 years' experience in open source specializing in open source based IBM i modernization... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level All
  • Audience Anyone considering adopting Merlin or merely curious as to how it all works and what has changed since 2022.

9:00am MDT

What's up with the RDi Debugger?
For many users getting started with the RDi debugger is intimidating. In this short session, we'll help the attendee understand the power of the debugger and feel comfortable with the features of the tool!

Learning Objectives:
1. Letting go of the 5250 debugger
2. Getting started with RDi debugging
3. Batch and interactive debugging
4. Service Entry Points (SEP)
5. How to debug different type of programs
6. Understand break-points and Monitor Expressions
7. Tips and Tricks!

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programmer Tools
  • Session Level All
  • Audience Attendees who are new to RDi or those that have had trouble "Quitting" The 5250 debugger

9:00am MDT

Why it's High Time for Rdi: The Basics of RDi
Beginners session on using RDi

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Integrate anything with anything using Apache Camel
Want to "have your cake and eat it too?" That's what you get when you combine the power of RPG and Db2 workloads with the many benefits of open source technologies. In this session, you will explore (in a high-level, language-agnostic fashion) the various techniques for integrating the two worlds.

Learning Objectives:

Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

React: Intro to building a front end interface using Hooks
This is an introduction to the React front-end framework. We will set up a development environment and incrementally build an application as we learn about React hooks.

Learning Objectives:
1. How to get started with React
2. How to create web pages with React
3. Manage state with React hooks
4. Serve React app from IBM i

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

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

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

Speakers
avatar for Scott Klement

Scott Klement

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Frameworks
  • Session Level Beginner
  • Audience Programmers looking to combine RPG with newer open source techniques.

9:00am MDT

What is the angle on Angular?
Angular is a TypeScript-based open-source web application framework led by the Angular Team at Google. Angular focuses on modular components and wide platform support. It is a popular framework with a long learning curve but once mastered, can accelerate your ongoing development.

This session will focus on the principles that define Angular and walk through how to get started with the framework.

Learning Objectives:
1. Learn the design and rationale for Angular
2. Learn where Angular may fit in your development efforts
3. Develop a simple Angular application

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently IT Generalist at Bible Study Fellowship International. Pete is a developer with broad experience across multiple languages andplatforms, including over 27 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Cloud Penetration Tester,GIAC Secure... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Frameworks
  • Session Level Beginner
  • Audience Developers interested in knowing more about Angular and where it can be used.

9:00am MDT

Alan's Favorite Tips for Open Source on IBM i
Open source delivers new interfaces and functionality for your IBM i applications—and broadens the talent pool for your development team. Python, PHP, and Node.js are among the most popular open source tools on IBM i, for good reason. Combined with today’s ODBC database connectivity, API standards, and RPG/ COBOL integration, they are a powerful way to extend traditional applications to the web, mobile devices, and APIs.

Join Alan Seiden to learn his favorite tips for making your open source stack as reliable as your traditional IBM i applications. He’ll share ways to ensure smooth operation of:
1. Python, PHP, Node.js_
2. ODBC
3. Apache_
4. Connections to RPG and COBOL
5. And how to manage the rapid pace of updates!

Learning Objectives:
1. Tips from the trenches and managing and using open source
2. Best practices for the various languages
3. How to use them in practice and get speed and security

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level All
  • Audience Developers

9:00am MDT

API examples using RPG, Node.js, PHP, and Python
We help keep IBM i a critical part of IT when we learn how to connect to other systems flexibly and securely using APIs. Because IBM i API options abound, you can use your favorite languages and tools. This talk shows many ways to send and receive data safely, using IBM i business logic, with code examples using various free tools and languages, including RPG, PHP, Python, and Node.js.

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

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Beginner
  • Audience Developers or managers who wish to build or call APIs

9:00am MDT

Calling Rest APIs from your Native RPG/COBOL Apps
Rest Apis continue to be a normal part of an application ecosystem. Calling Rest Apis from your RPG or COBOL application should also be normal. With the latest HTTP Functions it now can be. These new interfaces provide the ability to easily call Rest Apis from your native ILE application leveraging ILE based technology. No Java required. This session will introduce you to these functions and help you get on the road to interacting with Rest Apis.

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Command Jeopardy
The IBM i operating system includes hundreds of commands that we use every day. Everything you type on a command line is a command! But did you know that you can create commands of your very own? Commands that can save you valuable time? Commands that can be used as building blocks to make program development more efficient? Come to this session to learn how - and to have some fun! We'll start with the basics for those who've never created a command, and then proceed through more advanced topics such as validation using DEP & QUAL, error handling, help text in panel groups, and more. We'll look at a number of useful examples of custom commands, and you'll even leave with free source code you can use as is, or leverage as a starting point for your own commands. We'll reinforce the concepts we learn by playing Command Jeopardy... for prizes! Learn some great techniques, have some fun, and maybe leave with a prize!

After participating in this session, attendees should have the skills and tools to:
- Develop your own custom commands
- Add validation using DEP and QUAL
- Properly handle error conditions
- Write RTVxxx commands with optional parameters
- Have fun and possibly win prizes playing Command Jeopardy!

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level All
  • Audience Anyone who would like to better understand how to create their own commands will benefit from this session. If you're excited at the idea of creating your own tools to make life easier, enjoy a good game show, and like winning prizes, then please join us!

9:00am MDT

Hidden Gems of IBM i
The IBM i team has been delivering new function two times per year since 2010. New releases and technology refreshes deliver a broad range of function and sometimes the smallest line items can be easily missed. The IBM i team has reviewed the past releases/refreshes and have assembled some of their favorite hidden gems; things that you might have missed but should know. Everyone will leave with something new that will help them in their day to day work.

Learning Objectives:
1. Learn about some of the very useful but lesser known functions of IBM i.

Speakers
avatar for Alison Butterill

Alison Butterill

WW Program Director, Product Management, IBM i, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General

9:00am MDT

How Refactoring Helps Bulletproof Your Application
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 Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →
avatar for Scott Klement

Scott Klement

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Intermediate
  • Audience Programmers who want fewer headaches.

9:00am MDT

IBM i Next Gen Apps - Why and How?
IBM i applications run businesses around the world. They have tremendous value today, and need to be prepared to use today’s latest technology to solve business problems for tomorrow. How should those applications grow into their Next Gen versions? In this session, Steve Will, IBM i CTO and Chief Architect, will discuss what this means, and talk about approaches and technology which can help clients and IBM i software developers move into that Next Generation Future.

Learning Objectives:
1. Understand the market forces driving a need to a "next gen" version of IBM i applications
2. Learn the value of incorporating Next Gen concepts, and how that approach is far more successful than re-platforming.
3. Understand the patterns, approaches, and tools available to move applications to the Next Generation.

Speakers
avatar for Steven Will

Steven Will

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level All
  • Audience Application developers and Executives of companies using IBM i, who need to protect the value of their existing business applications, but also move them forward.

9:00am MDT

Impress Your Boss with Open Source
Open source brings ready-made solutions that can run on your IBM i, usually at no charge. Create APIs, graphics, PDFs, content management for the web, not to mention web languages that allow you to address new business needs. What’s more, these open source technologies work well with RPG.

In this business-oriented talk, learn how companies are staying ahead of the curve with open source on their IBM i. See how RPG provides the solid business logic to provide business advantage, while open source brings interfaces and capabilities up to date. Be prepared to be wowed by many examples.

Learning Objectives:
1. Get ideas for solutions you can install and use immediately
2. How to integrate open source solutions with RPG, COBOL, and CL

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Beginner
  • Audience Developers and IT managers

9:00am MDT

Kafka and JavaScript for High Performance, Resilient IBM i APIs
Whether you are just starting to look at implementing an API strategy or you are deeply into deploying APIs around your IBM i applications, you need to consider the power, performance, reliability and security of using Kafka and JavaScript. These popular technologies will ensure that you can handle high volumes of API traffic while providing your users with rapid response times. In this session, we will introduce best practices in high performance API architecture using Kafka and JavaScript in conjunction with your RPG/COBOL/DB2 applications and we will discuss how to optimize your IBM i API environment.

Learning Objectives:
1. Learn best practices for implementing high performance, secure, reliable IBM i APIs
2. Learn how to use Kafka to optimize API performance and reliability
3. Learn how to use JavaScript to simplify and optimize API development

Speakers
avatar for Daniel Magid

Daniel Magid

Eradani
At Eradani, we have experts in APIs and Open Source for IBM i. Eradani Connect makes it easy to generate high performance, highly secure APIs for connecting new technology to your IBM i. We know how to use modern languages like JavaScript, Java, Python and PHP to help customers create... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level All
  • Audience Application developers and application architects

9:00am MDT

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

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

Speakers
avatar for Rochelle Petty

Rochelle Petty

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

Marina Schwenk

Software Developer, Everbrite
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 works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Beginner
  • Audience Anyone that is new to the platform or who just wants a better understanding of what all of the acryonyms mean.

9:00am MDT

Performance Profiling for Open Source
Users love fast applications. Find and eliminate any slow code in your Node, PHP, and Python applications using free, open source performance profiling tools that you can download and use immediately.

Learning Objectives:
1. Know when to employ perfomance profiling techniques to resolve performance bottlenecks.
2. Understand how to do so in the key open source langages on IBM i
3. Tips on effective profilng

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Intermediate
  • Audience Developers and system administrators who use IBM i

9:00am MDT

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

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

Speakers
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Beginner
  • Audience Programmers and utility folks interested in enabling data through controled mechanisms.

9:00am MDT

Recent additions to modern CL language
The CL programming language is under appreciated and is used by many as just a JCL. In the past few releases a lot has been added to CL that gives the IBM I programmer an alternative to doing everything with RPG or Cobol. (This will include any additions to CL that will come in TRs between now & the conference)

Learning Objectives:
1. Learn Simon’s favorite additions to CL, and the releases they can be used with
2. See examples of each one.

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon’s experience with IBM midrange started in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA he has worked mostly in the western half of the country, and is currently IT manager responsible for the Power servers and IBM i for a large bank in Central Texas.Simon... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Intermediate
  • Audience Any IBM i programmer looking for an often simpler way to program something than use RPG

9:00am MDT

Refactoring Your CL programs
CL is an underappreciated language in the IBM i world. Many hang on to the ways and methods they code CL from when they were first learning how to use IBM i. Like all languages CL has evolved over many releases to become something more than it ever was, to a point where any modernization project ought to include refactoring your CL programs. Join me as I walk through examples of CL code from our past and how it can be refactored into a format that a modern developer would easily understand.

Learning Objectives:
1. Learn how to use true structured programming in the CL language.
2. Learn how to integrate CL into Service Programs.
3. See examples of refactored CL code & learn how much easier it is to support & maintain."

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon’s experience with IBM midrange started in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA he has worked mostly in the western half of the country, and is currently IT manager responsible for the Power servers and IBM i for a large bank in Central Texas.Simon... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

RPG Using SQL to Call REST APIs
This session will cover, at a high level, a number of techniques for integrating Db2 and RPG workloads with almost anything. There will be particular emphasis on the recently-announced HTTP functions in Db2. These functions enable HTTP requests to be made through simple SQL. The new functions are leaner, faster, and easier to use than their SYSTOOLS predecessors!

Learning Objectives:

Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

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

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

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

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

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

Speakers
avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation
Robert's blood runs "deep green" after having launched his IT career in 1992 as a developer in the 5250-heavy AS/400 world, specializing in the development of shop floor applications for manufacturing and distribution sites. In subsequent years the platform — and the platform's... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level Beginner
  • Audience Developers who could benefit from pulling external information (i.e., commodity prices) into their user applications on IBM i

9:00am MDT

Web and API Language Shootout
Alan will compare several open source languages commonly used for APIs and web development and the role of RPG alongside them. Languages include Node.js (javascript), PHP, and Python. The session contains concrete information about each as well as a lively discussion.

Learning Objectives:
1 Learn what makes each of these languages unique
2 Understand where each language would be best
3 Learn about web and API architecture

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - General
  • Session Level All
  • Audience Developers and managers

9:00am MDT

Fully-Utilizing Node's NPM Tooling


Learning Objectives:

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Node.js and IBM i: Integrating Open-Source Software with your Current Technology Stack
You've heard a lot about Node.js, and know how to download packages, write interesting applications, and even connect to Db2 for i. But you are still a little hazy on how to integrate Node.js with all of the RPG, C, COBOL, and CL programs you have running on your system. This talk will focus on interacting with ILE programs from Node.js, including sending data to programs as parameters, getting results back in Node.js, and leveraging the power of Node.js to use the results in a novel way. By the end of the talk, you should have a better sense of how Node.js can interact with traditional IBM i programs and where to find answers to questions you have about Node.js and IBM i.

Learning Objectives:
1. What options are available to integrating Node.js with IBM i programs, commands, and workflows
2. How to interact with Node.js and IBM i from the same system
3. How to remotely interact with IBM i from Node.js on another system

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Node
  • Session Level Intermediate
  • Audience This session is useful for CIOs who think that Node.js and IBM i programs are not compatible and application developers who want to use Node.js with the ILE programs they already have written.

9:00am MDT

The Basics of Node.js: Getting Started with Node.js
Node.js is one of the fastest-growing language runtimes in development history. By allowing the popular JavaScript language to run on the server side, it brings immeasurable value in terms of developer productivity, performance, and scalability. This presentation covers what Node.js is, why one would want to use Node.js, and finally, how to download and get started with Node.js on IBM i.

Learning Objectives:
1. Learn what Node.js is and where it sits on the technology stack
2. Learn the basics of how Node.js works from a technical standpoint
3. Learn how Node.js can integrate with IBM i and provide a great replacement for PHP or other web technologies

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Node
  • Session Level Beginner
  • Audience The audience for this presentation is any developer or system architect interested in alternatives to PHP or for using JavaScript for their back-end processing.

9:00am MDT

30 PHP Tips in 60 Minutes
Inspired by longtime presenters at the Summit, this discussion looks at the most popular tweaks, hacks and just plain good practices the for IBM i PHP community to enjoy. Sometimes you just need a shopping list of things to watch out for and many of the tips that are scattered throughout these presentations are consolidated in a single place. Performance, security and best practices and more will be discussed.

Learning Objectives:
Common tips useful to all PHP shops
Common mistakes to overcome with PHP in most shops

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - PHP
  • Session Level All
  • Award BRONZE
  • Audience PHP developers and IBM i System Administrators where they are running PHP workload

9:00am MDT

Develop PHP with your IBM i, not on it
Utilize modern techniques to develop your PHP applications on your PC, before handing them over to the IBM i for testing. Always wanted to write your software at Starbucks or your favorite park?

Learning Objectives:
Become somewhat independent of your IBM i while developing your PHP application. Try new features without disrupting your team members.

Speakers
avatar for Guido Faecke

Guido Faecke

Professional Services Consultant, Zend by Perforce
Guido Faecke has been working with IBM midrange systems since 1989. In the year 2000 he discovered PHP and is writing software in PHP ever since. While contributing to several Open-Source projects, he promotes best practices and good coding standards every chance he gets. His current... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - PHP
  • Session Level All
  • Audience PHP developers, IT Managers

9:00am MDT

Separate HTML from PHP
You will gain a new perspective on how to separate PHP from HTML. Your application doesn't need to be written all in one. Take advantage of API's and Javascript. Utilize front-end frameworks live VueJS

Learning Objectives:
Divide the load. Use different team members to achieve your goal.

Speakers
avatar for Guido Faecke

Guido Faecke

Professional Services Consultant, Zend by Perforce
Guido Faecke has been working with IBM midrange systems since 1989. In the year 2000 he discovered PHP and is writing software in PHP ever since. While contributing to several Open-Source projects, he promotes best practices and good coding standards every chance he gets. His current... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - PHP, Programming - Frameworks
  • Session Level Intermediate
  • Audience PHP/Javascript developers, IT Managers

9:00am MDT

Spring cleaning your PHP code
Clean up your PHP apps by removing unused code, make your code more stable, introduce PSR level cleanliness. Refactor duplication. Get ready for the next version.

Learning Objectives:
Improve code quality and be ready for your next PHP upgrade

Speakers
avatar for Guido Faecke

Guido Faecke

Professional Services Consultant, Zend by Perforce
Guido Faecke has been working with IBM midrange systems since 1989. In the year 2000 he discovered PHP and is writing software in PHP ever since. While contributing to several Open-Source projects, he promotes best practices and good coding standards every chance he gets. His current... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - PHP
  • Session Level All
  • Audience PHP developers, IT Managers

9:00am MDT

What’s new and exciting in PHP for 2023
PHP is moving fast these days. PHP 7.4 is out of support by the community, while PHP 8.1 and 8.2 include features that help developers reduce bugs and enjoy writing high quality code. In this fast-paced session, Alan will share his favorite new features in PHP 8.1 and 8.2, and how to prepare for them. Alan will also show tips on upgrading from older releases and will go over recent security enhancements.

Learning Objectives:
1. Power of PHP in today's market with IBM i
2. Why and how to get on a regular upgrade cycle with PHP
3. Features and benefits of PHP 8.1 and 8.2 for security, performance, and ease of programming

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - PHP
  • Session Level Intermediate
  • Audience Developers using or considering PHP, including those on older versions and needing to upgrade

9:00am MDT

30 Python Tips in 60 Minutes
Python has been a round for a while and even on IBM i. In this session we'll explore many of the various Python tips I've run across over the last few years. come on, come all!

Learning Objectives:

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Practical Uses for Python on IBM i
Python is more than just another scripting language. There plenty of daily uses for Python on IBM i including simple web apps, IFS manipulations and much more. In this session we'll explore some uses for Python that you can put to use immediately upon returning to the office.

Learning Objectives:
1. Learn to use Python for IFS manipulation.
2. See Python modules that impact day to day operations.

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Python APIs aka: REST with Flask
Gluing applications together in the 21st century relies on loosely coupled services. Python has several methods for provisioning and consuming web services. In this session we will explore several approaches to leveraging APIs or Web Services including some of the powerful modules in the python world that make this process incredibly simple.

Learning Objectives:
1) Review of Python fundamentals.
2) Explore modules used with services
3) Review several examples of services consumption and provisioning

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Python
  • Session Level Intermediate
  • Audience Developers, managers and system architects looking to integrate web services and IBM i

9:00am MDT

Python Productivity: Python Fundamentals
With no background we will start with the fundamentals of the Python language, installation and execution with the goal of mastering Python modules to access systems & Db2 to accomplish tasks such as creating pdfs, spreadsheets and a wiki natively on IBM i.

Learning Objectives:

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Python
  • Session Level Beginner
  • Audience programmers and folks interested in learning how Python can change their lives!

9:00am MDT

Test Driven Development using Python
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - Python
  • Session Level Intermediate
  • Audience Developers and syste architects looking to explore Python or TDD architecture

9:00am MDT

An RPG Web App Server – Who Knew ?
If you’ve ever done web app development on IBM i you probably know that you can use RPG to write CGI based web applications and services. However these apps require you to use an external web server such as Apache to host the application and there is complexity in debugging these apps. You can also use IWS to host RPG-based web services, but it requires a special Java server to make those services available to the outside world which can make life unnecessary complex.

What if there was a way to create fully self-contained web applications and web services with RPG? This session will cover how to quickly get started creating your own self-contained, RPG-based web applications and web API servers. You will learn a pattern for creating simple RPG-based web apps. You will learn how to expose DB2 data and existing RPG logic as web services. And you will learn how to interact with and debug your new services from RPG as well as other open-source languages, external web applications and services.

Attend this session to see how quickly your RPG application business logic can be modernized and used in web apps and web services without re-engineering your entire RPG code base.

Learning Objectives:
1. Use RPG as a web application server
2. Use RPG as a REST web API server
3. Eliminate the need to use an Apache web server
4. Re-purpose your existing RPG business logic easily with web apps and services

Speakers
avatar for Richard Schoen

Richard Schoen

President, Mobigogo LLC
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience Any RPG developer looking to modernize their RPG code and easily make business logic available in web apps and services without resorting to open-source languages.

9:00am MDT

Basics of Modern RPG Language: How Other Companies Have Moved Their Business into the 21st Century on IBM i
This session provides case studies of How Other Companies Have Moved Their Business into the 21st Century on IBM i

Learning Objectives:
1. Internalize the reasons that writing modern RPG code will improve productivity.
2. Understand that, properly written RPG code doesn't care about the UI
3. Understand that... it's NOT that hard and it might even be fun!

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level All
  • Audience Managers and developers will benefit from this presention

9:00am MDT

Case Study: Reducing I/O in your RPG program with SQL
Do you work in a sea of legacy RPG programs? Have you slowly started embedding SQL into your RPG programs, but struggle with taking full advantage of what SQL has to offer? I struggled with this, and still do. Join me as I walk through a real life case study where I reduced my RPG program from hundreds of thousands of I/O to one.

Learning Objectives:
Learn one code monkey's approach to incrementally increasing the SQL statement to include all the data needed to process.

Speakers
avatar for Gregory Simmons

Gregory Simmons

Software Engineer, PC Richard & Son
Gregory Simmons is a Software Engineer at P.C. Richard & Son.  He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered instructor with IBM’s Academic Initiative and an RPG and IBM i instructor at Scott Regional Technology Center, where... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG

9:00am MDT

Developing an Weather Application for your IBM i
I know, I know... we don't need another Weather Application. This is a fun session where I can show you how to put the pieces together, using an API, JSON_TABLE function, RPG, PHP into a store procedure. This will give you ideas on things you can do to impress your users and boss!

Learning Objectives:
1. Internalize how API"s can be used in your shop.
2. Understand how easily these pieces fit together.

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level All
  • Audience Manager or any type of developer

9:00am MDT

Handling JSON With DATA-INTO and DATA-GEN in ILE RPG
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

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG

9:00am MDT

How Do I Improve Software Quality?
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 Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →
avatar for Scott Klement

Scott Klement

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience Software developers who want to improve their quality.

9:00am MDT

ILE: Procedures, Modules & SRVPGMs by Example
For RPGers, ILE brings with it procedures, modules, service programs, binding directories and binder language - it can get confusing!

In this interactive session, Susan will take her life in her hands by walking through a live step by step demonstration of some of those topics. In the process, we'll discover some of the problems that can occur - how they show themselves and how to fix or avoid them.

Our roadmap includes the following steps:
- Creating a (very) simple RPG procedure in a module
- How (and why) to put that module into a service program
- Using a binding directory to simplify creating programs that use our procedure
- Add a new procedure to the same module and service program
- Guidelines for testing procedures in service programs
- How to maintain the service program over time and avoid signature violations

To get the most from this session, it would be helpful if you're already familiar with the basic syntax of RPG procedures (aka subprocedures) and if you know a bit about what modules and service programs are.

Learning Objectives:
1. Understand the value of service programs
2. Understand how ILE entities interact with each other
3. Avoiding common pitfalls and frustrations with developing and maintaining ILE applications

Speakers
avatar for Susan Gantner

Susan Gantner

Partner400
Susan's career has spanned over 30 years in the field of application development. She began as a programmer developing applications for corporations in Atlanta, Georgia, working with a variety of hardware and software platforms. She joined IBM in 1985 and quickly developed a close... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience RPG developers who want to understand more about how service programs work

9:00am MDT

Introduction to Merlin and IBM i Developer
A deep dive into the IDE that comes with Merlin: IBM i Developer. We’ll look at what it takes to use the IDE, setting up a Workspace, writing + compiling code, and how it integrates with git.

Learning Objectives:
1. Using Merlin IDE for the first time
2. Understanding git for ILE code
3. Managing projects through Merlin IDE

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG

9:00am MDT

IoT: Open My Garage Door with RPG
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

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience Experienced RPG developers who are interested in physical computing, IoT, automation, etc.

9:00am MDT

No Limits Modern Excel Reports Using RPG
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.


Learning Objectives:
1. Understand the internal structure of modern Excel (XLSX) files
2. Identify various reporting scenarios, such as multiple sheets, static informational sheets, etc.
3. Understand how to design and implement an Excel (XLSX) application

Speakers
VH

Vern Hamberg

Senior IT Developer, 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 IT Developer in the Pest Elimination division of Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for Db2... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience Developers who want to extend existing skills into writing modern business documents. Perhaps managers and administrators who want to know what is possible by leveraging existing knowledge.

9:00am MDT

Procedure driven RPG
This session is a deep dive into coding procedures in RPG. We will start with an introduction to procedures, review how they differ from subroutines, then look at some hidden gems of procedures. Finally, we will examine my RPG program of choice, linear-main programs.

Learning Objectives:
1. Learn the basics of coding procedures in RPG
2. Examine the differences between subroutines and procedures
3. Learn about Linear-Main RPG programs

Speakers
avatar for Gregory Simmons

Gregory Simmons

Software Engineer, PC Richard & Son
Gregory Simmons is a Software Engineer at P.C. Richard & Son.  He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered instructor with IBM’s Academic Initiative and an RPG and IBM i instructor at Scott Regional Technology Center, where... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Beginner
  • Audience All RPGers, whether you're well seasoned or new to the language will find interesting tips, tricks and hidden gems with procedures in RPG.

9:00am MDT

Processing JSON with DB2 and RPG
IBM has done some great things that allow DB2 to process JSON objects. This session shows you “Tips and Tricks” to make your life easier when you start working with JSON data. After a short discussion of the HTTP functions that have been added to QSYS2 and how they can be used with the JSON_TABLE Function, Jim shows the attendee how to work with the QSYS2.HTTP_GET and JSON_TABLE Functions to consume an API returning a JSON object. If you have tried using these functions many have problems writing the correct SQL/JSON path expressions to extract the data and represent it in a relational table. Jim will help the attendee understand this process with solid examples.

Learning Objectives:
1. Improve developers understanding of SQL/JSON path expressions with DB2 and JSON
2. Improve developers understanding of how to use HTTP functions in QSYS2
3. Improve developers understanding of how to use JSON_TABLE function

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Jim Buck’s career in IT has spanned more than 35+ years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Beginner
  • Audience IBM i Developers wanting to get started with or improve their programming skills using SQ/JSON/RPG and API’s

9:00am MDT

Providing Web Services on IBM i
Web services have become a critical-to-know technology in business programming. This session shows you how to create them in ILE RPG on IBM i using software that is included at no charge with the operating system. Both the Integrated Web Services tool from IBM, and writing your own web service by hand with XML-INTO and DATA-INTO will be discussed.

Learning Objectives:
1. Understand what a web service is, and why they are useful
2. Understand the types of web services and their terminology
3. Demonstrate how to create a web service in RPG with Integrated Web Services
4. Demonstrate how to create a web service in RPG without a web service tool

Speakers
avatar for Scott Klement

Scott Klement

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG

9:00am MDT

Quick Look: Overloading in RPG
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

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Recent additions to modern RPG language
Over the past ten years RPG has transformed itself into a modern free form language. In recent the recent releases, 7.4 and 7.5, there have been additions there have been enhancements made that have passed many people by. Simon will demonstrate his favorite additions. (This will be updated with the RPG enhancements included in TRs before the conference).

Learning Objectives:
1. Learn Simon’s favorite additions to RPG, and the releases they can be used with
2. See examples of each one.

Speakers
avatar for Simon Hutchinson

Simon Hutchinson

Author, RPGPGM.COM
Simon’s experience with IBM midrange started in the United Kingdom, in a pre-AS/400 world. Since immigrating to the USA he has worked mostly in the western half of the country, and is currently IT manager responsible for the Power servers and IBM i for a large bank in Central Texas.Simon... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience All RPG programmers who have an interest in keeping their skills up to date

9:00am MDT

RPG and External Database Integration
Chances are that your organization may have the need for RPG applications to share and exchange data with databases other than DB2. Maybe your order management or ecommerce system is on a web server running SQL Server, PostgreSQL or MySQL/MariaDB. Or maybe you need to create SQLite files to expose data to a mobile application.

In today’s world you may be replicating data files and uploading and downloading data on a scheduled basis. Wouldn’t it be a better idea to use the data real-time where it lives instead of making multiple copies? Using live data also greatly improves performance when communicating between multiple systems.

This session will provide an introduction to how you can utilize RPG and open-source technology to interact in real-time with other databases. No more syncing or importing/exporting data on a scheduled basis. Use live data where it lives without replication.

Attend this session to learn how to cross the divide and immediately extend you RPG applications into the open database database world. No matter what external database platform you want to talk to, you’ll benefit from this session.

Learning Objectives:
1. Learn the benefits of Integrating external databases with RPG
2. Learn the development pattern for integrating external databases with RPG
3. Adopt and utilize the provided RPG examples right away in your own shop

Speakers
avatar for Richard Schoen

Richard Schoen

President, Mobigogo LLC
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience Any RPG, CL or Open-Source developer looking to expand their usage of RPG and CL to quickly integrate the ability to take advantage of external databases to use live data where it lives.

9:00am MDT

RPG Tips and Tricks
We’ll talk about many examples of how to write modern RPGLE correctly, as well as what not to do. From this fairly technical talk, you’ll walk away with new methods on development and coding standards.

Learning Objectives:
1. Learn how to not write bad code
2. Learn how to write good code
3. Pick up some new best practices when writing RPGLE

Speakers
avatar for Liam Allan

Liam Allan

Advisory Software Engineer, IBM
Visual Studio Code fellow


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG

9:00am MDT

SQL for the RPG Programmer “How To”: SQL Access to Data and ACS Tools
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
VH

Vern Hamberg

Senior IT Developer, 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 IT Developer in the Pest Elimination division of Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for Db2... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience RPG developers who want to see the ever-expanding opportunities SQL offers in their applications

9:00am MDT

SQL for the RPG Programmer “How To”: Working with SQL Services
SQL is THE recommended interface from applications into your data. This session focuses on how using SQL services extends what you can do in these application.

Learning Objectives:
1. Learn what SQL services are and where to get more information
2. Focus on SQL services that are most useful for developers

Speakers
VH

Vern Hamberg

Senior IT Developer, 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 IT Developer in the Pest Elimination division of Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs for Db2... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience RPG developers and architects who want to see how to get even greater benefit from SQL in their applications

9:00am MDT

The New World of RPG Arrays
Have you noticed a common thread in many of the features added to RPG in the last few years? RPG's enhanced support for arrays has been a dominant theme in many recent announcements.

We've had new ways to define them, including data structure arrays and varying dimension arrays. There also new ways to utilize them, such as the For-Each operation and new built-ins like %Split, %ConcatArr and %List, along with the new operator IN. And that's just the start!_

In this session, Susan will explore ways to put this new array support to work with code examples and use cases where they come in handy.

Learning Objectives:
1. Keep up to date with new powerful RPG language features.
2. Understand ways to take advantage use the new array support in RPG.

Speakers
avatar for Susan Gantner

Susan Gantner

Partner400
Susan's career has spanned over 30 years in the field of application development. She began as a programmer developing applications for corporations in Atlanta, Georgia, working with a variety of hardware and software platforms. She joined IBM in 1985 and quickly developed a close... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Intermediate
  • Audience Experienced ILE RPG developers

9:00am MDT

What the heck is Binder Source and why do I care?
Discover what binder source is, what it's used for, and why you definitely want to use it with your service programs. We'll talk about binding, signatures and signature violations, and how to change service programs without having to recompile all your programs.

Learning Objectives:
1. Learn about binding
2. Learn about signatures and signature violations_
3. How to change service programs without recompiles

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level All
  • Audience RPG programmers who use (or want to use) service programs

9:00am MDT

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

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

Speakers
avatar for Scott Klement

Scott Klement

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 April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level Beginner
  • Audience RPG Developers

9:00am MDT

Why Procedures are Better Than Subroutines
Discover the super powers that procedures have(and subroutines don't) and how they can help you create more reliable and more easily maintained programs. We'll talk about the benefits of input parameters: local variables, and return values, error handling with on-exit, and increased functionality with recursion.

Learning Objectives:
1. The benefits of using procedures
2. How to create a procedure
3. How to get the most benefit out of procedures

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Programming - RPG
  • Session Level All
  • Audience RPG programmers

9:00am MDT

Anatomy of a Password
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

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for IBM i Security and Authentication Technology Services in Rochester, MN.  He is an Executive Security Consultant / STSM and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2, journaling, and DDM/DRDA... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience IBM i Admins or Security team members

9:00am MDT

Authority Collection – A utility to lock down access to sensitive objects
This presentation will introduce a the Authority Collection utility initially introduced in IBM i 7.3 and then enhanced for IBM i 7.4. This support will help ensure that object authority is set to the most secure value while still allowing an application to run successfully. This presentation is a must see for security administrators and application developers.

Learning Objectives:
1. Learn about the authority collection support in 7.3 and how it was enhanced in 7.4 to help system administrators lock down security on sensitive data files and objects.

Speakers
avatar for Thom Haze

Thom Haze

Software Engineer, IBM
Thom is the lead software developer for IBM Digital Certificate Manager for i (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Award SILVER
  • Audience This session will help anyone who has the responsibility of locking down security on an IBM i partition.

9:00am MDT

Breaches, Ransomware and Recovery, Oh My!
The unthinkable has happened and your organization has been breached. Or someone clicked on the wrong link and ransomware has run rampant throughout your organization. Does your incident response plan include IBM i? During this session Richard Dolewski and Carol Woodbury will discuss the steps you’ll want to take now to reduce risk to IBM i and to ensure that you can recover your Business. 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 and best practices to support both disaster recovery of your Business as well as keep you protected from ransomware
3. Understand the key components of an incident response and where IBM i fits into the continuity of your Business.

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

President, CTO, Co-Founder, DXR Security
With over 25 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience IT Managemnet responsbile for Security, Disaster Recovery

9:00am MDT

Configuring Single Sign-on for IBM i
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 Thom Haze

Thom Haze

Software Engineer, IBM
Thom is the lead software developer for IBM Digital Certificate Manager for i (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience IBM i System Administrators, Windows Administrators, and Network Administrators

9:00am MDT

Disk-Level Encryption is not enough
AS companies look to leverage encryption as part of their security landscape, it can be tempting to just implement disk-level encryption. As security requirements continue to grow and compliance regulations are taken into account for the IBM i environment, administrators are finding they need to implement encryption at the field level versus disk level encryption.

Learning Objectives:
• What are the use cases for disk level and field level encryption?
• How do I satisfy PCI compliance auditors requirements for encryption?
• What types of fields should be encrypted?
• What is an IBM I Field Procedures?

Speakers
avatar for Bill Peedle

Bill Peedle

Principal Sales Engineer, Precisely


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience Security professional responsible for Power Systems running IBM i

9:00am MDT

Feeling insecure? How to secure web applications on IBM i
Is secure web development an oxymoron? How can you possibly defend against so many attack vectors? If you can't eliminate the threat, can you at least minimize the exposure? This session will focus on the top 10 exploits, all of which can be launched against the IBM i. We look at not only securing the system and attached devices but also how to develop defensible web applications that are hosted on your IBM i.

Learning Objectives:
1. Learn the top 10 exploits against Internet exposed systems
2. Learn how to mitigate these exploits

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently IT Generalist at Bible Study Fellowship International. Pete is a developer with broad experience across multiple languages andplatforms, including over 27 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Cloud Penetration Tester,GIAC Secure... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Beginner
  • Audience Developers and system admins needing a broad understanding of the threats and how best to mitigate them

9:00am MDT

Getting the Most out of the Audit Journal
The IBM i Audit Journal is not just for compliance! In fact, the greatest value is helping administrators debug authority failures, assisting investigators to determine if the system has been breached and as an early warning sign that your organization has been compromised. During this session, Carol will show examples of using the audit journal for these scenarios and will highlight the latest IBM Services and Navigator for i interfaces that make getting information out of the audit journal easy and straightforward.

Learning Objectives:
Understand how to use CL commands, IBM i Services and Navigator for i to get information out of the audit journal and analyze it

Show examples of using the audit journal to:
- debug an authority failure
- determine how a profile is used
- determine whether the system was used during a breach
- Understand how to use the audit journal as an 'early warning' system of a network breach

Speakers
avatar for Carol Woodbury

Carol Woodbury

President, CTO, Co-Founder, DXR Security
With over 25 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Beginner
  • Audience System or Security Administrators that want additional tools to simplify IBM i security administration

9:00am MDT

How to Keep Your IBM i System Safe
As attackers become more sophisticated, cyber security has become an arms race and it is imperative that security professionals and system admins continuously improve their strategies to combat the rise of ransomware. Between educating employees, mitigating risk through system security assessments, and taking advantage of tools like SIEM solutions and third party options, companies can arm themselves against intruders. Rob will share his experience working as a security consultant, the various security blunders he’s caught (before attackers have!) ranging from poor physical locks on servers, to poor network practices, and insider attacks performed by disgruntled employees. He’ll also advise on the top 5 things you can (and should!) be doing to secure your system from the inside out, and back in again.

Learning Objectives:
1. A walk-thru of the top IBM i security flaws we come across
2. Learn best practices for threat remediation on IBM i
3. Identify strategies for how to build your cybersecurity barrier through a proactive approach using IBM i specific tools

Speakers
avatar for Robert Nettgen

Robert Nettgen

Senior Consultant, Briteskies
Robert Nettgen wanted a career in radio broadcasting, but saw that profession declining and found better pay working in IT.  A PC developer in the ‘80’s, Rob started administering AS/400s in the early ‘90s for a Radio/TV group owner.  In 1999 Rob accepted a job as IT director... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience System admins, Managers and Directors of IT departments responsible for information security.

9:00am MDT

How to set up your IBM I system and applications with a layered security defense using MFA
While the IBM i is more securable than distributed systems, it is still vulnerable to potential security risks. This is especially true as you modernize the applications through API creation to engage the data and applications that live on the system. In this session, we’ll discuss how you can build out a layered defense against security threats, including integrating IBM i with your existing enterprise SSO architecture.

Learning Objectives:
*Why IBM i specific security is critical and how to convince the business it should be part of the security policy
*How to set up MFA for IBM i using Rocket MFA
*How to integrate Rocket MFA into your applications like terminal emulation, and your SSO infrastructure

Speakers
avatar for Hrithik Govardhan

Hrithik Govardhan

Software Lead, Rocket Software
Long time Rocketeer working in the Security/MFA/Cloud spaces on Power and Z.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience Those who want to ensure data and applications on the IBM i are secure by layering on MFA.

9:00am MDT

IBM i Security cocktail, with an SQL chaser
Be prepared to hear ideas and concepts that will make your head spin as Scott Forstie and Carol Woodbury shake up the world of IBM i Security, mixing the dull foundational concepts of IBM i Security with the vibrant and rich features of SQL. Before you know it, you’ll be sipping on the refreshing features of SQL and pouring 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.)

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

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →
avatar for Carol Woodbury

Carol Woodbury

President, CTO, Co-Founder, DXR Security
With over 25 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience Anyone tasked with understanding, improving, or auditing security on IBM i.

9:00am MDT

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

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

Speakers
avatar for Carol Woodbury

Carol Woodbury

President, CTO, Co-Founder, DXR Security
With over 25 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Beginner
  • Audience Any user that has little or no knowledge of IBM i Security or someone that needs a refresher of the details of IBM i security will benefit from this session.

9:00am MDT

IBM i Security: G.O.A.T or more of a donkey?
IBM i security may be legendary, but do you know that there is a very good chance that YOUR server is highly vulnerable to exploitation?

Certified auditor and long-time author of the wildly popular "State of IBM i Security" study, Robin Tatam, will whirl through startling information about what we do right and where we go wrong. Along with the updated 2023 results, this session provides useful tips in several common problem areas.

Learn what steps your own organization must take to address these overlooked and dangerous security exposures—including some that are often missed by professional auditors!

Learning Objectives:
1. Learn about this famous study
2. Hear the new revelations for 2023
3. Learn specific tips for avoiding commonly-made mistakes made by others

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience Security is a responsibility for everyone and this session will explain the highs and lows that are relevant regardless of whether you administer or code applications or audit - or should audit - the machine

9:00am MDT

IBM i Security: What’s New for IBM i 7.4 and 7.5
Security improvements continue to be high priority to help mitigate vulnerabilities. Come see the various security related features included with IBM i that you can use to help improve the health of your environment.

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

Speakers
avatar for Thom Haze

Thom Haze

Software Engineer, IBM
Thom is the lead software developer for IBM Digital Certificate Manager for i (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Beginner
  • Audience System and security administrators

9:00am MDT

Ladies & Gentlemen: Introducing Object Level Security
We've all heard the names of the moving components: *ALLOBJ, private, *PUBLIC, authorization lists and adoption; but it's a rarity to find people that truly understand the full and accurate purpose of these elements and how to combine them into a security plan. This rapid-fire session provides valuable insight as it introduces the pro's and con's of this 'gold standard' in IBM i security.

Learning Objectives:
1. Define key security concepts in object level security 2. Understand how OLS complements other security initiatives 3. Learn that OLS is far less scary that it looks in the movies.

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience Administrators and programmers who wish to know more about the security of IBM i

9:00am MDT

Multi-Factor Authentication for IBM I
Best practices recommend using more than one factor to secure logins and other critical processes. Using industry standard algorithms, two factor authentication now comes to IBM i. This quick session covers four of the latest tools to help secure your IBM i!

Learning Objectives:
1. Understand how to use more than just a password for authentication
2. Learn what integration options exist for IBM i MFA

Speakers
avatar for Robert Andrews

Robert Andrews

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for IBM i Security and Authentication Technology Services in Rochester, MN.  He is an Executive Security Consultant / STSM and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2, journaling, and DDM/DRDA... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience IBM i Admins or Security team members

9:00am MDT

Ransomware and IBM i
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

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for IBM i Security and Authentication Technology Services in Rochester, MN.  He is an Executive Security Consultant / STSM and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2, journaling, and DDM/DRDA... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience IBM i Admins or Security team members

9:00am MDT

Securing Network Applications with Digital Certificates
Network communications require encryption. This session provides the foundation to configure and manage network security on IBM i using Digital Certificates assigned to Application Definitions to establish industry standard Transport Layer Security (TLS) encryption.

Learning Objectives:
1. Understand the cryptography related to Transport Layer Security.
2. Use the latest Digital Certificate Manager web application to create certificates.
3. Assign the certificates to application definitions and perform verification tests to ensure required TLS protocols and cipher suites are selected.

Speakers
avatar for Thom Haze

Thom Haze

Software Engineer, IBM
Thom is the lead software developer for IBM Digital Certificate Manager for i (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience System administrators that need to manage security on their system will benefit from understanding Digital Certificate Manager.

9:00am MDT

Security Testing
Security concerns are of utmost importance and testing our environments has never been more important. Using information from traditional QA resources this session looks at attack vectors, test protocols, organization, and approaches.

Learning Objectives:
Identify risk vectors that need testing.
Determine the testing approaches that would be the most useful.
Organize the effort and documentation in response to your efforts, and for reuse.

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience Any IT professional who has any concern or responsibilty for information security.

9:00am MDT

SQL for the Security Officer
The pressures and expectations for the security officer have never been higher.  Come to this session to learn how to use SQL to accomplish critical security tasks, including the ability to easily automate security policies. You do not have to be an SQL expert to gain something from this session. I will give you examples that you can take back and use.

In the session, I will explain how the examples work and you'll leave with the skills necessary to be a better and more productive IBM i security officer.

Learning Objectives:
1. Learn how SQL can be used to administer security on IBM i.
2. Discover how to use fully functional SQL examples to improve security on IBM i.
3. Understand how SQL can be used as a tool to train your next IBM i Security officer.

Speakers
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security

9:00am MDT

Strategies for Securing REST APIs
So you've used your favorite open-source package to create REST APIs, have deployed those APIs as part of microservices, and have all of those microservices set up to do load balancing. But you've neglected on thing: Security! This talk will focus on different strategies that developers can use to secure their API endpoints, such as using API keys and various token-based authentication methods. We will also cover the use of secure protocols like TLS and HTTPS, and the importance of logging for identifying potential attacks on your network. We will finish with a concrete example of securing REST APIs created with LoopBack, a Node.js Typescript framework for building APIs and microservices.

Learning Objectives:
1. Learn how to use API keys or tokens to secure API endpoints
2. Learn the importance of using secure protocols like TLS and HTTPS
3. Learn about different authentication strategies for protecting endpoints

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience This sessions is useful for developers and security administrators who are interested in REST APIs or want to learn how to secure their current REST APIs.

9:00am MDT

The Cyber Security News Report - A Fun Look At Current Information Security News Stories
You know that cyber security is a real issue - even if your boss doesn’t get it. Time to stress less about it and enjoy a fun look at real, Information and Cyber Security stories in the news. These are a sampling of current security news stories from the last 3 months. As he did at last year’s POWERUp and NAViGATE events, Robert Nettgen will read a sampling of these stories in a dramatic, over the top, radio announcer style. While usually not mentioned by name, it’s a safe bet that some of these companies in the news have an IBM i server hiding in the data center. A list of the stories will be shared, so if your boss thinks this stuff is overblown and not a real risk, feel free to share some of these stories - or even the whole list.

Learning Objectives:
1. Gain a deeper understanding about the seriousness of cybersecurity
2. Learn from others' cybersecurity mistakes and how to avoid them in your own systems

Speakers
avatar for Robert Nettgen

Robert Nettgen

Senior Consultant, Briteskies
Robert Nettgen wanted a career in radio broadcasting, but saw that profession declining and found better pay working in IT.  A PC developer in the ‘80’s, Rob started administering AS/400s in the early ‘90s for a Radio/TV group owner.  In 1999 Rob accepted a job as IT director... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience CISOs, System admins, Managers and Directors of IT departments, and anyone else responsible for information security.

9:00am MDT

Welcome to IBM i Security Auditing
Journaling is a powerful feature for both data recovery and security auditing. Come join me as we focus on the security auditing aspect, where you will learn how it works, how to enable it, and how to use it.

Learning Objectives:
1. What is journaling?
2. Different types of journaling.
3. How to start using security auditing.
4. How to review the audit journal.

Speakers
avatar for Steven McIver

Steven McIver

IBM i Certified Administrator, iTech Solutions
Steven is a certified IBM i System Administrator who has been working in IT for over 14 years. He was recognized as an IBM Fresh Face for his work on IBM i infrastructure in his early career. His main focus has been supporting IBM i and IBM Power Systems, and also specializes in VIOS... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Beginner
  • Audience IBM i System Administrators and Security Professionals will find this information very useful.

9:00am MDT

What does a full featured security strategy look like?
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 John Vriezen

John Vriezen

Principal Technology Architect, Precisely
I have been working with the IBM i platform for 35+ years, initially at IBM Rochester for 9 years, working  on DB2 and the Storage Management.  Then onto ShowCase Corp. working on Essbase OLAP engine for IBM i.  Currently I with Precisely, (formerly Syncsort, Vision Solutions... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level Intermediate
  • Audience IBM i professionals who must address Security requirements for their IBM i systems will benefit from this session.

9:00am MDT

Zero Trust Security for IBMi
While Zero Trust is still one of the strongest trends driving the cyber security industry, there remains much buzzword confusion around the topic. No one product or solution can get an enterprise to Zero Trust. It is a security methodology, not a product.

Learning Objectives:
• A basic introduction to Zero Trust for the larger enterprise
• The unique opportunities within the IBM i for implementing the Zero Trust framework
• How to integrate your IBM i strategy with your organization’s larger Zero Trust initiative.
• Best Practices for implementing Zero Trust on the IBM i

Speakers
avatar for Bill Hammond

Bill Hammond

Director, Product Marketing, Precisely


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Security
  • Session Level All
  • Audience Professionals responsible for security of Power Systems running IBM i

9:00am MDT

20 Tips in 20 Minutes
In my work with real-world environments, I have found a number of very common configuration settings that are not optimal for today's environment. Whether it be system values, job descriptions, memory pools, many shops have configuration settings at the system default value, or settings that were done years ago.

This session is a fast-paced session covering 20 configuration tips in 20 minutes.

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM.A former IBMer, Dawn is now an independent... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All

9:00am MDT

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

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

Speakers
avatar for Sarah Jacob

Sarah Jacob

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience System Admins who are new to the position or to IBM i in general.

9:00am MDT

Advanced IBM i Services (SQL) for Admins
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.

Learn how to:
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

IBM i Tech Lead, John Wiley & Sons, Inc.
I have worked on the IBM i platform as a System Administrator/Engineer since 2001, starting out on OS400 V4R5.  I'm passionate about leveraging IBM i SQL Services for system administration.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience Administrators with some SQL experience who want to take their knowledge and skills to the next level.

9:00am MDT

Analyzing Open Source Applications with IBM i Performance Tools
Many IBM i administrators think of open source software running on IBM i as an impenetrable black box. But that is not the case. IBM i has been aptly handling multi-threaded, SQL centric open source style applications for decades. The performance tools you know and love will help you peer into open source workloads more than you think. Come and learn how to use your existing skills and tools to analyze the latest Node.js, PHP, etc. applications running on your IBM i partition.

Learning Objectives:
1. Learn how open source applications differ from traditional IBM i workloads.
2. Learn how to use existing tools and skills to analyze open source applications on IBM i.

Speakers
avatar for Eric Barsness

Eric Barsness

Executive Consultant, IBM
Eric Barsness is an Executive Consultant and IBM Master Inventor in IBM System Lab Services. Eric specializes in IBM i performance and scalability and leads the IBM i performance team in Lab Services. Eric has been improving the performance of IBM i, Db2, and customer applications... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience IBM i administrators who want to understand and manage open source workloads on their IBM i partitions.

9:00am MDT

Ansible and AWX with IBM i
Have you been curious how you can integrate IBM i with Ansible? Do you want to manage IBM i and other systems from one interface? Do you want to automate your workflows to free up time to be more productive? With Ansible, you can manage your systems and deploy applications all from one place. We will cover the basics of Ansible, how to set Ansible up on IBM i, and how to automate IBM i workflows with playbooks. These integrations will include executing commands, configuring systems and applications, managing fixes, and deploying applications. We will also cover and demo the AWX Project, the Red Hat open-source community project that gives a modern user interface for managing your Ansible playbooks and systems. By the end of the session, you should be able to understand how Ansible fits into your wider technology infrastructure, and how it can make working with IBM i easier than ever before

Learning Objectives:
1. Learn how to create an Ansible instance to manage IBM i systems
2. Learn how to manage IBM i with Ansible
3. Learn how AWX can simplify managing your workflows

Speakers
avatar for Mark Irish

Mark Irish

Software Engineer, IBM
I am a software engineer at IBM working on open-source software enablement for the IBM i. I am particularly knowledgeable about Node.js and Machine Learning software libraries. Feel free to talk to me about your open-source questions and tell me what open-source software you'd like... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience This session will benefit system administrators looking to automate system management and developers looking to automate application deployment.

9:00am MDT

Basics of Tapes and BRMS
Stepping into the world of tape backups and BRMS can be quite a challenge. While the backup process can be automated, it is important to know how each piece works, so you can be confident in making configuration changes.

Learning Objectives:
1 – Learn the basics of tape backups
2 – Learn how to get tapes enrolled in BRMS
3 – Learn about BRMS control groups
4 - Learn the considerations for doing full system backups with BRMS
5 – Learn how to do restores using BRMS

Speakers
avatar for Steven McIver

Steven McIver

IBM i Certified Administrator, iTech Solutions
Steven is a certified IBM i System Administrator who has been working in IT for over 14 years. He was recognized as an IBM Fresh Face for his work on IBM i infrastructure in his early career. His main focus has been supporting IBM i and IBM Power Systems, and also specializes in VIOS... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience IBM i System Administrators and Operators will find this information very useful.

9:00am MDT

Best practices for collecting performance data with Collection Services
IBM i performance data collection using Collection Services is enabled by default, but you may still be using default configuration settings. In this session, you will learn why you may want to adjust the Collection Services configuration settings for your performance analysis or trending needs.

Learning Objectives:
1. How to use Navigator for i to configure Collection Services
2. Recommendations for changing default configuration settings

Speakers
avatar for Shauna Rollings

Shauna Rollings

IBM i Performance Tools & High Availability Development, IBM
Shauna joined the IBM i development team in 2008. She has developed and supported IBM i performance data collector tools throughout her entire IBM career. From the very beginning of the Db2 Mirror for i project, she has also been the technical team lead for the Db2 Mirror Configuration... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All

9:00am MDT

Breaking Bad IBM i Habits – Best Practices for Success
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 Operating System, Configurations, Backups, Disaster Recovery, and Security Management best practices. We will discuss technical gaps, blunders, and recommendations. Hear actual lessons learned so you don’t make the same IBM i assumptions others have made.

Learning Objectives:
IT is not a game of chance.
Configuration management to produce optimal results

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management

9:00am MDT

BRMS Advanced Topic
Ths session will discuss some of the advanced topics in using BRMS for your back up and recovery. Featured topics will be tape management, Library management, back up lists, Control group controls, and BRMS Policies and how they affect the overall operation of BRMS. Discussion on how back up lists work with a Domino, Zend Server and/or WebSphere back up and recovery will be included. Recovering from a BRMS back up can be extreamly easy, but it can also present some opportunities for trouble. This session will discuss some of the landmines in a BRMS recovery and how to avoid them.

Learning Objectives:
More fully understand the science and art of tape management in BRMS
Utilize back up lists including how BRMS backs up Domino and WAS
Learn how to make a BRMS recovery simple and as easy as possible

Speakers
avatar for James Oberholtzer

James Oberholtzer

Chief Technical Architect, Agile Technology Architects
Jim started his career in 1980 working in positions of increasing responsibility including Vice President – Technology, at the United States Bowling Congress (USBC). Today, Jim is the Chief Technical Architect for Agile Technology Architects, LLC a consulting firm that assists companies... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Advanced
  • Award SILVER
  • Audience BRMS users who know the basics but want to expand beyond that.

9:00am MDT

Building Dashboards and Reports over IBM i Services
IBM i Services provide SQL interfaces into IBM i system/object/security information. Wouldn't it be nice to have an easy way to build reports or dashboards, create trending reports or consolidate data from multiple systems into a single view? Of course it would! And that's exactly what this session will show you with Web Query.

Learning Objectives:
1. Create dashboards over IBM i Systems and object metrics in a flash
2. Schedule important reports like "how close are we getting to system or database limits" to regularly monitor and avoid potential catastrophe
3. Enhance the value of IBM i Services to monitor key performance or object size metrics.

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience Developers, System Admins

9:00am MDT

Case Studies on Critical Performance Failures: Common Performance Issues and Their Resolution
There are many common performance problems that can impact almost any shop. This session will review real-world performance issues, covering the details of the issue, the impact to the business, and the analysis that was done to identify and resolve the problem.

Understanding these common problems can help you prevent them from happening in your shop. Attend this session to learn how to avoid common performance pitfalls.

Learning Objectives:
1. Learn about common performance issues
2. Learn how to identify and resolve them
3. Prevent them from happening to you

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM.A former IBMer, Dawn is now an independent... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management

9:00am MDT

Clean Up Your IBM i Disk
How much disk storage do you have on your system? The most common answer is 'not enough!' Attend this session and find out where all that space went, what you can clean up, and what should be left alone. Learn about reporting, automating, and managing your disk space in IBM i. Develop a deeper understanding of the tools IBM has built into IBM i and how to leverage them to help keep your system clean. Especially learn how to leverage SQL to find consumers of disk QUICKLY! Walk away with a solid understanding of how to clean up your disk space both QSYS and the IFS.

Learning Objectives:

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Cloud and Datacenter Engineer, 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Cool things in Navigator to be a RockStar System Administrator
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

President, iTech Solutions
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown

9:00am MDT

Daily Care and Feeding of IBM i
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, 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

Discovering your IBM i Data - For System Administrators issues
There’s plenty information on IBM i that is so valuable for the daily tasks. Many commands, APIs, and lately SQL functions, gather information from your IBM i, into database tables. While other System functions register data on different tables all the time.

Throughout my life I spent a lot of time working around this information. 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators who need to find and exploit System Information

9:00am MDT

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

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

Speakers
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience System administrators of IBM i

9:00am MDT

Everything You Need to Know About the IBM i Administration Runtime Expert
Business-critical applications must be up and running reliably without failure. When something unexpected occurs, you must identify the cause and correct it quickly. The relentless push to do more with less is only going to intensify while the tolerance for failure keeps dropping. Yet identifying points of failure can be tricky as complexities scale.

IBM i offers a product at no additional charge that helps ascertain application and infrastructure health. The IBM Administration Runtime Expert for i (ARE) can be used to define attributes of a healthy environment and use those defined attributes to validate that the environment is as expected.

This session will everything you need to know to get started with ARE:
- Overview of what ARE is and example use cases
- Prerequisites, installation, and logging into the ARE console
- Creating and editing templates
- Setting up system groups, verification options, and verifying systems
- Understanding the reports

Learning Objectives:
1. Learn how to acquire the IBM ARE product, where it needs to be installed, and how to log in and get started
2. Learn how to create templates that define the attributes to verify
3. Learn how to set up system groups for verification
4. Learn how to review the reports from a validation

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM.A former IBMer, Dawn is now an independent... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience This session is geared for any system administrator that wants an easy way to ensure attributes are not changed on a single partition, or across a set of partitions.

9:00am MDT

HMC, IBM I, FSP, & Firmware: Putting All the Pieces Together
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

President, iTech Solutions
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

IBM i 7.5 and Power10 on i Performance Update
IBM i 7.5 comes with a plethora of new performance metrics, performance tooling updates, and access to performance features at no-charge that previously were chargeable. Additionally, Power10 provides substantial capacity gains. Come and hear about these improvements, and learn which ones you have access to even prior to upgrading to IBM i 7.5.

Learning Objectives:
1. Learn about performance tooling and metric changes new in IBM i 7.5
2. Learn about the benefits of Power10 from a performance perspective.

Speakers
avatar for Eric Barsness

Eric Barsness

Executive Consultant, IBM
Eric Barsness is an Executive Consultant and IBM Master Inventor in IBM System Lab Services. Eric specializes in IBM i performance and scalability and leads the IBM i performance team in Lab Services. Eric has been improving the performance of IBM i, Db2, and customer applications... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience IBM i administrators who want to take advantage of IBM i 7.5 and/or Power10.

9:00am MDT

IBM i Automation Tips for Experts
Develop automation yourself without market products. Use the Best functionalities offered by IBM i to automate monitoring activities,

Learning Objectives:
Automation
SQL Services

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Advanced
  • Audience IBM i Technical Specialist

9:00am MDT

IBM i Event Monitoring with Manzan
In this session, we will explore a new tool for monitoring the system. Manzan provides a gateway to making IBM i watch facilities easily consumable by user applications, external resources, and/or open source technologies. Identified use cases include:

Monitoring system events for Kafka, ELK, SMS, FluentD, Grafana Loki, or AI
More comprehensive integration with syslog facilities
Queryable system events
Consolidated auditing/reporting activity
In short, this project aims to make IBM i more integrated with infrastructure monitoring of a heterogeneous IT infrastructure, whether on-prem or cloud.


Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System administrators looking for a way to monitor for various system events

9:00am MDT

IBM i Navigator an Administrators View
IBM Navigator for i is the web based interface for accessing, managing, and monitoring your IBM i. A brand new versions has been released. This session will look at how to get started, how to best leverage this interface for one users or an entire company. We will look at some of the administrative features added to New Nav to help with rolling this out to many users. This include how to set up TLS for you connections and how to limit select users from working with areas within the interface.

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All

9:00am MDT

IBM i OS and Power System Upgrade Testing
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:
Understanding testing strategies, tactics, and design.
Determine risks to system quality.
Aligning testing with risk exposure._
When to use risk based testing, static testing, behavioral testing, or structural testing for best results.

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

IBM i System Admin's job role today
What does this job role mean today ? During this session, we will cover all areas and different activities this key skill has to manage (upgrades, patching, security, backup, High availability, HW and SW management, external storage, …)

Learning Objectives:
All System Admin solutions to better manage IBM i partitions

Speakers

Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience All IBM i people

9:00am MDT

Image Catalogs: How They Changed My Life!
Stop working nights! Stay home on the weekend! Are you currently using image catalogs and virtual optical drives in IBM i? If not, find out why you should be! If you are, find out how to use them better! Upgrades can become a breeze, PTFs can easily be distributed across systems, and Linux software can be downloaded right from the web to IBM i! Starting in V5R1, IBM introduced the capability of creating virtual optical devices and media. See the impact this seemingly simple technology can have on the routine tasks you perform as an IBM i administrator.

Learning Objectives:
Configure virtual optical support on IBM i
Use virtual optical for PTF's and upgrades
Use virtual optical to install third party software and non-IBM i software

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience System administrators and all users of IBM i

9:00am MDT

Installing and Configuring NVMe
Learn what you need to know about Non-Volatile Memory express (NVMe) which is the best new technology for IBM i users in decades. Understand why it is so good, and then how to configure it.

Learning Objectives:
1) Why NVMe
2) How to setup a system using NVMe
3) Sizing for NVMe.

Speakers
avatar for Pete Massiello

Pete Massiello

President, iTech Solutions
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience Anyone looking at new hardware, or needing to drastically improve performance.

9:00am MDT

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

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

Speakers
avatar for Steve Riedmueller

Steve Riedmueller

IBM i Tech Lead, John Wiley & Sons, Inc.
I have worked on the IBM i platform as a System Administrator/Engineer since 2001, starting out on OS400 V4R5.  I'm passionate about leveraging IBM i SQL Services for system administration.


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience Traditional “green screen” administrators who want to start leveraging SQL.

9:00am MDT

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

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

Speakers
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience All levels welcome

9:00am MDT

iSee with Scott and Tim
In this session Scott and Tim will show, ie live demo how to solve real problems that we get asked, using ACS and the power of SQL.

Learning Objectives:

Speakers
avatar for Scott Forstie

Scott Forstie

Business Architect, Db2 for IBM, 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 Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All

9:00am MDT

JD Edwards on IBMi, techniques for success
Developing for JD Edwards can be a trying experience, but it's not actually necessary for delve into OMW for working with the system. In this session I'll review our experience with techniques and resources for working with JDE from the "outside": using native sql, rpgle, and cllent Administration:

Using JDE on IBMi platform presents some special challenges. We'll share our experiences with keeping JDE happy and healthy on our i.

Learning Objectives:
Learn about resources available to developers
Learn to integrate external programs to the E1 user pages
Pick up tips for optimizing and keeping a JDE installation healthy
Share experiences with other JDE on i shops.

Speakers
avatar for Andrew Dekreon

Andrew Dekreon

Drew is currently the Applications Manager for enterprise sytems with a major transportation company and an adjunct professor at the University of Alaska. Drew began working with the platform when he took over responsibility for a System/38 in 1987 and has been actively developing... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience developers and system administrators with a JDE on i installation.

9:00am MDT

Leveraging IBM i (SQL) Services for Performance Management
For system administrators figuring out how to call system management or performance related APIs on IBM i can be a challenge. Luckily for you, many of those APIs have equivalent IBM i Services that can easily be invoked using simple SQL statements. Learn how to take advantage of these services for everyday performance management tasks.

Learning Objectives:
1. Learn which IBM i Services are most useful for performance 2. See examples of how Services can be combined to do more advanced tasks quickly and easily

Speakers
avatar for Eric Barsness

Eric Barsness

Executive Consultant, IBM
Eric Barsness is an Executive Consultant and IBM Master Inventor in IBM System Lab Services. Eric specializes in IBM i performance and scalability and leads the IBM i performance team in Lab Services. Eric has been improving the performance of IBM i, Db2, and customer applications... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System administrators interested in managing their partitions more efficiently using IBM i Services

9:00am MDT

Manage your jobs with Service Commander for IBM i
IBM i can run all kinds of workloads, from RPG to COBOL to Node.js and PHP. Especially with more and more open source tools being run, it can be hard to keep track of. How can you manage it all? Service Commander is the answer. This tool can greatly simplify the task of managing the many jobs that run on your system. Even further, it has a feature to help your open source applications perform better at scale!

Learning Objectives:

Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System administrators looking for an easier way to manage all the various jobs running on IBM i.

9:00am MDT

Managing IBM i PTFs
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, 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Award SILVER
  • Audience This session is for you if you are the person in charge of administering IBM i.

9:00am MDT

Managing Startup and Shutdown of your IBM i
In days gone by the IBM Supplied program QSTRUP combined with a couple options on CHGIPLA was good enough for most IBM i shops. It started what seemed to be needed and anything else we stumbled through after each IPL. When it was time to shut down a PWRDWNSYS or ENDSBS command took down whatever was running. We were happy.

Today though we often see dozens of subsytems running many web servers, other needed batch jobs and services. We see monitors and queue processing jobs and many writers. For security purposes we should be starting only the TCP servers that we need, not all of them. Likely we should not start IPV6 and start things in sequence as well. Further considerations may be needed in an HA environment. These include not starting jobs until iASPS are available and starting different IP interfaces and services depending on production or backup mode of the server. We may want to handle special startup modes while doing PTFs, backups or other system maintenance. In this session we will work with customizing that startup. We'll discuss staring PASE jobs with QSH, web server jobs and more. We'll discuss prestart jobs and autostart jobs. And finally we will also work with sequencing the shutdown of the system. As part of this we'll discuss some simple ways to know what needs to be shut down and smoothly handling that.

Learning Objectives:
1) Learn how to control which startup program will run on your IBM i.
2) Examine the various servers to start and how to control them.
2) Learn options for starting different services.
3) Consider ways to control the startup of your server in different operting modes.
4) Understanding an orderly shutdown of your IBM i server.

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Cloud and Datacenter Engineer, 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Advanced
  • Award GOLD
  • Audience IBM i System Administrators

9:00am MDT

Mission: Possible! Journaling Forensics 101 (with Free Tools)
Learn to think like a spy! Many shops use journaling for a variety of reasons, but may not be familiar with how to use these journals for forensic purposes. Mining your journals for the who, what, when, where, how - and sometimes even why - can be very useful, not to mention fun! Come join us for a lighthearted and entertaining "Mission: Impossible" themed look at one of the most useful things you can do with your journals. This session will introduce journaling concepts and share tuning tips to optimize your journal environment for forensics. After reviewing the "old fashioned" way to dig into your journals, we will demonstrate how much easier this is with the right tools. The DMPJRN and CVTJRNDTA commands used in this presentation will be made available as a free download to all attendees, including source code!

*** As a bonus, this session now includes examples using the new Journaling SQL Table Functions!

After participating in this session, attendees should have the skills and tools to:
- Optimize your journal environment to maximize the forensic information available to you
- Understand what your journals are trying to tell you, and how to interrogate them to get the answers you need
- Dump your journals quickly and easily using the free software made available
- Be able to interpret the content of your journals to determine what really happened to your data
- Use the techniques demonstrated in the provided source code to develop your own tools
- Save the world from evil-doers

Speakers
avatar for Steve Wolk

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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Award SILVER
  • Audience Anyone who would like to understand how to maximize their journaling environment to make use of forensic data. If you've ever needed to figure out how something happened, if you like playing detective, if you enjoy building tools, then please join us!

9:00am MDT

New insights for Audit Journal entries with IBM Navigator for i
With the new Audit Journal component of IBM Navigator for i, it is much easier to gain helpful insights to your system security through audit journal entries. This short session will cover looking at the summary daily and weekly views for multiple audit journal entries and the detail view for a single-entry type. You will learn how to configure auditing with the helpful Navigator web interface. The session will also cover using the new audit journal detail entry data mart - both how to generate the data mart, and the authority required to view it.

Learning Objectives:
1. Learn how IBM Navigator for i can help you work with your audit journal entries
2. Learn how to configure auditing with the GUI interface
3. Set up the audit journal data mart for faster viewing of weeks of audit journal detail information

Speakers
avatar for Lora Powell

Lora Powell

Advisory Software Engineer, IBM
I have been at IBM since 1989, where I spent the first 20 years of my career on compiler development. Since 2009 I have found my niche with IBM i Performance Tools. I now enjoy being a developer and team lead for Performance Data Investigator (PDI).


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All

9:00am MDT

Optimizing IBM i Work Management
This session will introduce IBM i Work Management to the developer and other new system administrators. We will explore how the system is configured and manged using IBM i Navigator for i, and the traditional character based interface. As delivered your IBM i installation work, but it is not optimized for your environment. All too often the performance of your system is impacted by poor work management practices. Learn how to take the first steps to optimizing your IBM i Work Management.

Learning Objectives:
Learn what objects are used in most work management configurations and how to modify them
Learn how to optimize your environment, your applications
Learn how to monitor your system to keep it in tip top shape

Speakers
avatar for Sarah Jacob

Sarah Jacob

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

Steven McIver

IBM i Certified Administrator, iTech Solutions
Steven is a certified IBM i System Administrator who has been working in IT for over 14 years. He was recognized as an IBM Fresh Face for his work on IBM i infrastructure in his early career. His main focus has been supporting IBM i and IBM Power Systems, and also specializes in VIOS... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience Developers or new system administrators

9:00am MDT

Performance Based Workload Management on IBM i
We've all experienced the pain of an untuned, ad-hoc query or poorly written, untested application causing wide-spread pain on a partition. Learn how you can manage and mitigate unruly workloads on IBM i using monitors, watches, workload groups, and more.

Learning Objectives:
1. Learn about the types of activity that can cause performance problems on a partition.
2. Learn what can be done to mitigate the impact of that activity.

Speakers
avatar for Eric Barsness

Eric Barsness

Executive Consultant, IBM
Eric Barsness is an Executive Consultant and IBM Master Inventor in IBM System Lab Services. Eric specializes in IBM i performance and scalability and leads the IBM i performance team in Lab Services. Eric has been improving the performance of IBM i, Db2, and customer applications... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System administrators who want to better manage the activity on their IBM i partitions.

9:00am MDT

Real-time Monitoring and Alerting with Prometheus
Looking for new ways to monitor your IBM i system and applications? In this session, we will discuss a new tool that can export metrics into Prometheus, an open source timeseries database and monitoring tool. With data in Prometheus format, you will be able to leverage a sophisticated alerting system as well as the Grafana visualization engine. You can also tie into other popular monitoring tools like Turbonomic, AppDynamics, Nagios, Instana, DataDog, Splunk, and more!

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 →
avatar for Jesse Gorzinski

Jesse Gorzinski

Business Architect, IBM
Jesse Gorzinski is a tinkerer, programmer, hacker, and an award-winning speaker. In his role as business architect at IBM, Jesse has helped build an open source ecosystem on the IBM i platform. He has helped countless numbers of small businesses and enterprise clients deploy open... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System Admins looking for an efficient way to monitor their infrastruture

9:00am MDT

Set up a shared NFS drive to deploy PTFs and upgrades with image catalogs. Save time, save space! Make your admin life easier.
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience System Administrators who need to update and upgrade multiple systems, especially multiple LPARs on singe physical system.

9:00am MDT

System Administrator Survival Guide - Commands to Know
The IBM i command line contains tons of commands for administrating your system. These commands will make your day-to-day management easier and could even help you save the day! Come and learn the IBM i commands that every IBM i admin needs to know

Learning Objectives:
1. Learn how to use the command line to prompt and get help information
2. Learn commands used for system management, troubleshooting problems, security, printers, and more!

Speakers
avatar for Steven McIver

Steven McIver

IBM i Certified Administrator, iTech Solutions
Steven is a certified IBM i System Administrator who has been working in IT for over 14 years. He was recognized as an IBM Fresh Face for his work on IBM i infrastructure in his early career. His main focus has been supporting IBM i and IBM Power Systems, and also specializes in VIOS... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Beginner
  • Audience IBM i System Administrators and Operators will find this information very useful.

9:00am MDT

Take Control of Your IBM i Prestart Server Jobs
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 May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM.A former IBMer, Dawn is now an independent... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  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.

9:00am MDT

Understand your IBM i Performance Signature
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 May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM.A former IBMer, Dawn is now an independent... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management

9:00am MDT

Using SQL Services in Everyday Life
There has been a significant strategic shift in how IBM i exposes data and how you can access and leverage that data. No longer are CL command and APIs the best way. Today, its all about SQL. You may go, great… I know nothing about SQL… no worries, neither do I! This sessions is about equipping you with some useful activities, and resources so that even if you are a novice, you can be successful with SQL Services to manage your IBM i today.

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All

9:00am MDT

Using System Monitors in IBM Navigator for i
Learn how to create and work with System Monitors in IBM Navigator for i. Also learn how to use the Performance Data Investigator (PDI) visualization tool to view System Monitor data.

Learning Objectives:
1. How to create a System Monitor
2. How to view system monitor data

Speakers
avatar for Shauna Rollings

Shauna Rollings

IBM i Performance Tools & High Availability Development, IBM
Shauna joined the IBM i development team in 2008. She has developed and supported IBM i performance data collector tools throughout her entire IBM career. From the very beginning of the Db2 Mirror for i project, she has also been the technical team lead for the Db2 Mirror Configuration... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System Administrators looking to take advantage of the performance monitoring capabilities of IBM i.

9:00am MDT

Using the latest features of Performance Data Investigator in IBM Navigator for i
Whether you are already a user of Performance Data Investigator (PDI) and want an update on the latest enhancements, or you want to get started with PDI, this session is for you. You will learn how to use the perspectives provided with this powerful graphical visualization tool to gain analyst-level insights on the performance of your system. Topics covered are: getting started with the Health Indicators package, how to filter and drill-down for the most efficient results, and using the graph interval and top contributors' fields of the context panel. Stop by to find out how the latest Navigator for i has made this tool better than ever!

Learning Objectives:
1. Use PDI perspectives to analyze performance data
2. What insights are provided by the Health Indicators package
3. How to filter and drilldown to subsequent charts
4. Using the fields provided in the context panel.

Speakers
avatar for Lora Powell

Lora Powell

Advisory Software Engineer, IBM
I have been at IBM since 1989, where I spent the first 20 years of my career on compiler development. Since 2009 I have found my niche with IBM i Performance Tools. I now enjoy being a developer and team lead for Performance Data Investigator (PDI).


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience System Managers and Performance Analysis of IBM i will benefit to learn how to utilize the Collection Services performance data available on their IBM i.

9:00am MDT

What You Need to Know to Successfully Upgrade to IBM i 7.5 or 7.4
When doing an upgrade to IBM i, there is more work involved in the planning of the upgrade than in the actual upgrade itself. When you have done the planning, the actual upgrade is simple. We will cover planning tips, pre-requisites, and then post-installation requirements. Your upgrade isn’t complete until this last step is done.

Learning Objectives:
What you need to check for when preparing your system for an upgrade. What PTFs that are required before the upgrade to avoid problems, and the steps you need to complete a successful upgrade.

Speakers
avatar for Pete Massiello

Pete Massiello

President, iTech Solutions
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level All
  • Audience Anyone wanting to upgrade to IBM i 7.4 or 7.5

9:00am MDT

Where to Start with Open Source Package Management
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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience IBM i System Administrators who need to manage making Open Source technology packages avaialble on the IBM i.

9:00am MDT

Yum and RPM tricks to keep your open source software humming
Yum is how open source software gets installed these days. Alan's presentation will make you a Yum and RPM master, ensuring your packges stay updated, sharing tricks to handle slow connections, how to find out what versions you have, troubleshooting PATH issues, coexisting with older open source packages, going back to an older version of a package, viewing a package's change log, and a lot more. Never be stumped by a Yum issue again!

Learning Objectives:
1. Tricks to upgrade, downgrade, learn what's in a package, and a lot more.
2. How to handle slow connections, an IBM i not connected to the internet, and much more, to prepare for any situation.

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
How to modernize without throwing away years of work. IBM i, open source, APIs, web, PHP, Node.js, Python, RPG, ERPs


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Systems Management
  • Session Level Intermediate
  • Audience Admins and developers considering or using open source on IBM i

9:00am MDT

Journey to the Cloud 101
I will slightly modify my "Journey to the Cloud" presentation from my COMMON Spring 2022 presentation.



Speakers
avatar for David Contreras

David Contreras

IBM Power Systems Specialist, Meridian IT
My over 35 years of experience range from Senior System Architect, Systems Analyst, Senior System Engineer, Project Manager, Technical Manager and I.T Specialist. I have the ability to work effectively with different levels of staff from executive to technical. I have traveled extensively... Read More →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Virtualization
  • Session Level All

9:00am MDT

Selecting your POWER Systems hosting environment
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, 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 →


Monday April 24, 2023 9:00am - 10:00am MDT
Sheraton Denver Downtown
  Virtualization
  • Session Level Intermediate
  • Audience Any IBM i system administrator, especially those with virtualization in their future.
 
Filter sessions
Apply filters to sessions.