Loading…

Log in to bookmark your favorites and sync them to your phone or calendar.

Monday, October 4
 

8:00am CDT

Morning Yoga, Sponsored by Midrange Dynamics
Join us first thing for gentle morning stretching at your desk. Simple for those who have never tried yoga with modifications for those who have, this is a wonderful way to start your day.

Speakers
avatar for Jennifer Hollister

Jennifer Hollister

Yoga Teacher, Jennifer Hollister Yoga
An E-RYT Yoga Teacher, Trauma Based Yoga Therapist and Trauma Psychotherapist, Jennifer has an extensive background in mental and physical health for over 20 years.Jennifer teaches a variety of yoga styles in addition to Yoga Therapy, stress relief and meditation classes. She offers... Read More →


Monday October 4, 2021 8:00am - 8:25am CDT
Breakout 10 Online

8:30am CDT

Opening Session
Hear about the week ahead and the latest updates from COMMON

Monday October 4, 2021 8:30am - 9:30am CDT
Breakout 1 Online

9:45am CDT

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. _x000D_ 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._x000D_ 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) … _x000D_ With all these techniques we cannot only reduce our source code to a minimum but also secure our data! _x000D_

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


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 5 Online

9:45am CDT

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_x000D_ 2. Learn how to connect with ODBC once datasource has been set up_x000D_ 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 October 4, 2021 9:45am - 10:45am CDT
Breakout 2 Online

9:45am CDT

⭐ Smarter IBM i Applications Made Easy with AI
Did you know that Machine Learning & data science technologies are available for modernizing & augmenting your IBM i applications with predictive capabilities , taking benefits of your business data residing on your favorite platform? In this session, you will learn how to build powerful machine learning models with free open source libraries on IBM i , or using the leading edge Auto ML technology brought by H2O Driverless AI

Speakers
avatar for Benoit Marolleau

Benoit Marolleau

Architect, IBM
Benoit Marolleau is Cloud Architect at the IBM Montpellier Systems Center for EMEA. focusing on Hybrid Cloud & Power solutions architecture for business critical applications: app modernization, Open Source, Red Hat & Cloud solutions, AI, DevOps & IBM Cloud, with a constant motivation... Read More →


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 9 Online

9:45am CDT

HA/DR for Power
We will discuss the IBM Power solutions for high availability and disaster recover. This will address both AIX and IBM i

Learning Objectives:
1. what are the IBM offerings that address HA/DR for AIX and i_x000D_ 2. the basics on how they work_x000D_ 3. which one should you be using_x000D_

Speakers
avatar for Steven Finnes

Steven Finnes

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


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 3 Online

9:45am CDT

⭐ Backup IBM i Using ICC and Spectrum Protect
Speakers
avatar for Ludovic Menard

Ludovic Menard

IBM i consultant, IBM
Ludovic is an IBM i consultant in IBM Lab Services. Ludo does  benchmark of performance and proof of concept. He works in Montpellier France and he does workshops around Db2 Mirror for i, Backup IBM i with ICC product. He knows Ansible for i and also he does performance audit.Ludo... Read More →


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 11 Online

9:45am CDT

IBM i Marketplace Survey Results and Stories
Does your C-level management team ask you why you use IBM i? Do you wonder how IBM i is used by your colleagues?_x000D_ _x000D_ IBM i Marketplace Study author, IBM Power Champion and HelpSystems Executive Vice President of Technical Solutions Tom Huntington will unveil information that can help you understand and benchmark your IBM i environment with other customers on the platform. _x000D_ _x000D_ This session is based on a survey conducted during the fall of 2020 by HelpSystems. Over 500 IBM i users from all over the world, in different industries and installations of IBM i responded to 40 questions about how they use the platform, including their plans to leave or remain on IBM i and whether they run Linux alongside IBM i. We will discuss Impact of COVID, high availability, open source, RDi, SAN, OS levels and more during this session._x000D_ _x000D_ Drawing on his 30 years of experience listening to HelpSystems customers, Tom will share his analysis of the data and provides his IBM i experience.

Learning Objectives:
1. Learn how to communicate the value of IBM i_x000D_ 2. Learn about emerging technologies on IBM i and their utilizations

Speakers
avatar for Tom Huntington

Tom Huntington

EVP of Technical Solutions, HelpSystems
Tom Huntington is Executive Vice President of Technical Solutions at HelpSystems, and a 29-plus-year veteran of the company. He works with business alliances, acquisitions and large customer relationships and ensures that the HelpSystems software works with other major software and... Read More →


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 6 Online

9:45am CDT

Introduction to Python on IBM i
Come get your first look at Python and learn some of the basics! Also, learn about the product offerings that enable you to do software development with the language on the platform. Upon completing this class, you will be able to acquire, install, and use the language on IBM i, as well as extend its power using contributions from the larger open source community. We will also explore DB2 Data Access and IFS file system access as primary use cases for Python on IBM i.

Learning Objectives:
1) Installation of Python._x000D_ 2) Multiple methods of use and access_x000D_ 3) DB2 data access from Python

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect
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 October 4, 2021 9:45am - 10:45am CDT
Breakout 1 Online

9:45am CDT

🟢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_x000D_ 2. Attain your goals and improve your work performance_x000D_ 3. Earn the respect of your coworkers and build good will

Speakers
avatar for Steven Wolk

Steven 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 October 4, 2021 9:45am - 10:45am CDT
Breakout 12 Online

9:45am CDT

Best Practices for moving from RPG IV to RPG Free
There are still millions of lines of RPG IV code in use every day that are critical to business operations. This session will explore the options available in order to help you make the best choices possible as you protect your investment in the IBM i. A sample program will be Converted from RPG IV to RPG Free in order to show the conversion process._x000D_ _x000D_

Learning Objectives:
- Mapping the gap between the current state and the selected reference architecture_x000D_ - Business Justification for converting from RPG IV to RPG Free_x000D_ - Best Practices for converting from RPG IV to RPG Free

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 October 4, 2021 9:45am - 10:45am CDT
Breakout 4 Online
  RPG

9:45am CDT

🟢 SQLRPGLE the Better File Access
We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process with embedded sql. How to handle sql exceptions. And finally, how can you leverage SQL to replace your current record level access. _x000D_

Learning Objectives:
Overview of embedding sql in your RPG programs. How to streamline sql procedures with the use of a SQL utility service program. how to modernize your current record level access to use embedded sql

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 is one of two IBM i admins... Read More →


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 10 Online
  RPG, N2i

9:45am CDT

IBM i 7.4 Overview
Hear Steve Will, Chief Architect of IBM i, give an overview of the IBM i 7.4 release, including new features which have been made available in the Technology Refreshes since 7.4 GA.

Learning Objectives:
1. Learn about new resiliency features available with 7.4_x000D_ 2. Learn about new security features._x000D_ 3. Learn about new application development features._x000D_ 4. Learn about new system access and management features.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.


Monday October 4, 2021 9:45am - 10:45am CDT
Breakout 8 Online
  Systems Management
  • Session Level All

9:45am CDT

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_x000D_ Know which attributes of the user profile contribute to the capabilities of the user and understand the best practices settings for these attributes_x000D_ Understand the options available for setting authority on objects (files, programs, etc)_x000D_ Know the order in which IBM i checks authority when a user accesses an object_x000D_

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 October 4, 2021 9:45am - 12:00pm CDT
Breakout 7 Online
  Security

11:00am CDT

Advanced Python Programming and IBM i
Building upon the introductory session, this session will address the object oriented world of Python programming and introduce several topics for those considering Python for development. Some of these include Exception processing, Pathing, GUI use ODBC, Web Services and much more.

Learning Objectives:
1. Understand the Object Oriented model of Python_x000D_ 2. Master the use of ODBC from client AND server Db2 connectins_x000D_ 3. Many other topics that help continue the growth of a Python developer

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect
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 October 4, 2021 11:00am - 12:00pm CDT
Breakout 1 Online

11:00am CDT

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. _x000D_

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

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Monday October 4, 2021 11:00am - 12:00pm CDT
Breakout 6 Online

11:00am CDT

Getting started with DevOps
What is DevOps and how I can start to use the features of DevOps without needing to use ALL the feature of DevOps?_x000D_ _x000D_ This session will walk you through the key components of DevOps in your development environment and will highlight ways to use those components on IBM i.

Learning Objectives:
1. Understand what DevOps is._x000D_ 2. Understand the life cycle and use cases of DevOps._x000D_ 3. How to set up and use a simple DevOps technique with IBM i_x000D_

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently Java Team Lead at Bible Study Fellowship International. Pete is an RPG/C++/VB/Java programmer with over 24 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Secure Software Programmer-Java, and as a MCSE. His passion has always been in... Read More →


Monday October 4, 2021 11:00am - 12:00pm CDT
Breakout 12 Online

11:00am CDT

Microservices on IBM i
The design paradigm of enterprise solutions has changed dramatically over the last couple of years. Why is SOA not the big buzz any longer and how can a much simpler technology gain all the focus? Microservices is easy to work with and runs in any environment on IBM i. From node.js and JAVA to Python and RPG. You can expand and deploy to any platform on premise or in the cloud. It's so flexible!!

Learning Objectives:
1. learn the microservices paradigm 2. learn how to implement it on IBM i using python, java, nodejs and RPG. 3. See it in action.

Speakers
avatar for Koen Decorte

Koen Decorte

CEO, CD Invest


Monday October 4, 2021 11:00am - 12:00pm CDT
Breakout 3 Online

11:00am CDT

PHP 8 - The Future is Here
You did know that PHP 8 is already available, yes? Let's take a look at the performance improvements and functional changes brought to the language in version 7.x, and then see what you benefit from in version 8. And learn how to stop being surprised by backwards-compatibility breaks when upgrading!

Learning Objectives:
1. Learn where to know, months and sometimes years in advance, what future changes in PHP are being discussed, have been approved, and in what version when they'll be implemented._x000D_ 2. Learn about performance improvement from PHP 5 through PHP 8, using new benchmarks._x000D_ 3. Understand several specific language changes in PHP 8.x, and how they will affect existing application code and behavior, and what opportunities they bring to you as a developer.

Speakers
avatar for Clark Everetts

Clark Everetts

Senior Professional Services Consultant, Zend by Perforce
Clark works for Zend by Perforce as a Senior Professional Services Consultant, helping clients innovate, meet business needs, and build better web applications through architecture and performance audits, mentoring in software development best practices, and guiding them using PHP... Read More →


Monday October 4, 2021 11:00am - 12:00pm CDT
Breakout 5 Online

11:00am CDT

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_x000D_ 2. Learn the basics of how Node.js works from a technical standpoint_x000D_ 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 October 4, 2021 11:00am - 12:00pm CDT
Breakout 2 Online

11:00am CDT

🟢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:_x000D_ 1. How to plan your meeting for success_x000D_ 2. How to run your meeting for maximum productivity_x000D_ 3. The best ways to take meeting notes_x000D_ 4. When and how to end your meeting_x000D_ 5. Tips and tricks to maximize your use of technology and supercharge your work from home environment_x000D_ _x000D_

Speakers
avatar for Steven Wolk

Steven 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 October 4, 2021 11:00am - 12:00pm CDT
Breakout 10 Online

11:00am CDT

What's New for RPG in 7.3 and 7.4
Find out about some of the recent "TR-timed" enhancements to RPG that have been delivered through PTFs for 7.3 and 7.4.

Learning Objectives:
• Learn about the new features available to RPG programmers in 7.3 and 7.4

Speakers
avatar for Barbara Morris

Barbara Morris

IBM
Barbara Morris is the lead developer for the RPG compilers in the IBM Toronto Lab. She has been working on the RPG compilers since she started at IBM in 1989 after receiving a Computing Science degree from the University of Alberta. The first enhancement she developed was the ENDIF/ENDDO... Read More →


Monday October 4, 2021 11:00am - 12:00pm CDT
Breakout 8 Online
  RPG
  • Session Level All

11:00am CDT

Case Studies on Critical Performance Failures: Common Performance Issues and Their Resolution
Many critical performance problems are actually common problems that can impact almost any shop. This session will review real-world critical 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. Attend this session to learn how to avoid common performance pitfalls.

Learning Objectives:
1. Learn about common performance issues_x000D_ 2. Learn how to identify and resolve them

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 October 4, 2021 11:00am - 12:00pm CDT
Breakout 9 Online

11:00am CDT

IBM i Systems Management and Monitoring
When it comes to managing and monitoring the IBM i, there are a number of tools and options....and it keeps on changing and expanding. This session will look at some of the more popular options and how IBM i fits into these tools. Of course, Demos are a must where ever possible..

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 October 4, 2021 11:00am - 12:00pm CDT
Breakout 4 Online

12:00pm CDT

Lunch Break in the Expo
Monday October 4, 2021 12:00pm - 1:00pm CDT
All-Attendee Expo Online

1:00pm CDT

Get Started with Secure Open Source on the IBM i in Minutes
How would you like free access to leading edge mobile and web code so you could quickly provide your uses with the latest capabilities? Would it be helpful if you could easily add up to the minute shipment location tracking or weather data or vehicle data to your RPG systems? What if you could convert pdf or word documents automatically into IBM i data? How about adding items to your Amazon store or moving backups to low cost Cloud storage? These are just a few of the thousands of functions that are available adding open source modules to your applications. In this session, we will set up an IBM i for open source and build the code to call public web services. We will show you how to download the modules you need, how to add modules you want and then show you the code you need to write. We will show you the basics of open source security and we will demonstrate how to manage both your IBM i native code and your new web code using the same open source tools._x000D_ _x000D_

Learning Objectives:
1. Learn how to set up the open source environment on your IBM i_x000D_ 2. Learn how to download and use the best open source modules to extend your application_x000D_ 3. Learn how to keep you open source environment secure.

Speakers
avatar for Daniel Magid

Daniel Magid

CEO, 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 October 4, 2021 1:00pm - 2:00pm CDT
Breakout 10 Online

1:00pm CDT

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._x000D_ _x000D_ 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_x000D_ 2. Learn where Angular may fit in your development efforts_x000D_ 3. Develop a simple Angular application

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently Java Team Lead at Bible Study Fellowship International. Pete is an RPG/C++/VB/Java programmer with over 24 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Secure Software Programmer-Java, and as a MCSE. His passion has always been in... Read More →


Monday October 4, 2021 1:00pm - 2:00pm CDT
Breakout 12 Online

1:00pm CDT

🟢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._x000D_ Discover how to work smarter with ACS whether your a user, administrator or a fellow code monkey like me._x000D_ 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, Jack Henry & Associates
Gregory Simmons is a Software Engineer at Jack Henry and Associates, where he contributes to new and existing banking and financial software products for midsize local and regional banks. He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered... Read More →


Monday October 4, 2021 1:00pm - 2:00pm CDT
Breakout 11 Online

1:00pm CDT

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._x000D_ _x000D_ 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 October 4, 2021 1:00pm - 2:00pm CDT
Breakout 4 Online

1:00pm CDT

⭐ Connect RPG and Db2 to the World
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!

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 October 4, 2021 1:00pm - 2:00pm CDT
Breakout 7 Online
  Database

1:00pm CDT

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
IBMi, Quality Assurance, project management


Monday October 4, 2021 1:00pm - 2:00pm CDT
Breakout 6 Online

1:00pm CDT

🟢 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_x000D_ 2. Understand the different file systems_x000D_ 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 October 4, 2021 1:00pm - 2:00pm CDT
Breakout 1 Online
  IFS, N2i

1:00pm CDT

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

Learning Objectives:
During this session you'll learn:_x000D_ * Hiring tips to ensure you get the people you need on your team (and to communicate better with them)_x000D_ * Learn to interview candidates like a pro (or to ace your next interview)_x000D_ * Techniques to build your bench by creating a reserve of good will_x000D_ * How to keep your people motivated (and yourself!)_x000D_ * Methods to align your team's success (as well as your own) with that of your organization_x000D_ _x000D_ By the end of this session you'll have the tools you need to build a team of the best and brightest, and keep them as engaged as... Ninjas!

Speakers
avatar for Steven Wolk

Steven 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 October 4, 2021 1:00pm - 2:00pm CDT
Breakout 9 Online

1:00pm CDT

Developing Your Modernization Plan: What Are Your Options?
IBM i applications have been successfully serving business operations for decades. Modern technologies are enabling new levels of automation, scalability, resiliency and flexibility. In this session, Chris Koppe discusses what application modernization and transformation is and the various options available to help them realize the full potential of the future while building on the value of their IBM i applications._x000D_ _x000D_ In this session, Chris will discuss:_x000D_ • Several client roadmaps that include incremental modernization strategies and the outcomes achieved at various stages_x000D_ • Modernization approaches and automated solutions available_x000D_ o Quick wins with UI modernization_x000D_ o APIs & integration capabilities_x000D_ o Code & DB conversion_x000D_ o Architectural & infrastructure options_x000D_ o Deployment options including various cloud models

Learning Objectives:

Speakers
avatar for Chris Koppe

Chris Koppe

SVP Portfolio & Strategic Services, Fresche Solutions
Chris Koppe is responsible for overall portfolio strategy and or the Strategy Consulting organization at Fresche Solutions. He has led the development of legacy management strategies for hundreds of companies, across a variety of platforms, languages, databases, and technologies... Read More →


Monday October 4, 2021 1:00pm - 2:00pm CDT
Breakout 2 Online
  IT Strategy
  • Session Level All

1:00pm CDT

Work Management 101
In this session, we will drill through the many components of work management. If you really want to know how IBM i works and controls your processing, this session is for you. IBM Power servers certainly have grown in their processing capabilities, but you can even get more out of your system if it is configured properly. These work management components will be covered: 1. What’s a subsystem? 2. Auto Start Entries 3. Memory Pools 4. Activity Levels 5. Different types of jobs and why they end up running where they do 6. Threads 7. Job Queues 8. Routing Entries 9. Classes 10. Automated tuning options Along with these components, we will share many other tips using commands and ACS to manage your work management environment. This technology is one of the main reasons customers for years have enjoyed running multiple applications in one partition.1. What is Work Management? 2. What are the components of a subsystems? 3. How to configure your subsystems along with memory pools?

Learning Objectives:
1. How to navigate their subsystems and understand how things are configured_x000D_ 2. How to get jobs into a memory pool_x000D_ 3. What's the difference between subsystem pool and memory pool.

Speakers
avatar for Tom Huntington

Tom Huntington

EVP of Technical Solutions, HelpSystems
Tom Huntington is Executive Vice President of Technical Solutions at HelpSystems, and a 29-plus-year veteran of the company. He works with business alliances, acquisitions and large customer relationships and ensures that the HelpSystems software works with other major software and... Read More →


Monday October 4, 2021 1:00pm - 2:00pm CDT
Breakout 8 Online
  Systems Management
  • Session Level All

1:00pm CDT

How to Deploy, Update, and Roll back PHP Applications
You have options for getting your code from your editor to the filesystem, configured properly, and serving incoming web traffic. See what I use to get new apps onto the server, update those apps as bugfixes and new features are added, and roll back apps to previous versions when necessary. From shell scripts, Git, and Zend Server Deployment, to open source tooling, you have a wide selection to choose from. Let's find the right deployment mechanism for YOUR application._x000D_

Learning Objectives:
1. Learn how deployment is more than getting PHP source code into the right location on the filesystem, especially with a team of developers, or when facing a crisis in Production._x000D_ 2. Learn safe and reliable application deployment, rollback, and update techniques that help developers, managers, and administrators know exactly what version of an application is deployed to which environment._x000D_ 3. Observe several free, open source, and paid solutions - in action - for managing application deployments.

Speakers
avatar for Clark Everetts

Clark Everetts

Senior Professional Services Consultant, Zend by Perforce
Clark works for Zend by Perforce as a Senior Professional Services Consultant, helping clients innovate, meet business needs, and build better web applications through architecture and performance audits, mentoring in software development best practices, and guiding them using PHP... Read More →


Monday October 4, 2021 1:00pm - 2:00pm CDT
Breakout 5 Online

2:15pm CDT

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._x000D_ 2. Become familiar with the SQL statements used for writing SQL routine logic.

Speakers
avatar for Sue Romano

Sue Romano

Technical Lead Db2 foi 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 October 4, 2021 2:15pm - 3:15pm CDT
Breakout 6 Online
  Database

2:15pm CDT

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 used to provide database abstraction and the strengths and weaknesses of each approach.

Learning Objectives:
1. Evaluate three different approaches to database abstraction and their benefits._x000D_ 2. Walk step by step through the implementation of a Logical File database abstraction layer._x000D_ 3. Review the reference architecture for a database I/O service program._x000D_ 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 October 4, 2021 2:15pm - 3:15pm CDT
Breakout 3 Online
  Database

2:15pm CDT

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. _x000D_

Learning Objectives:
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:_x000D_ _x000D_ • Key design points and basic configuration that every Web server requires_x000D_ • How to get your web site up and running using the graphical integration wizards provided by IBM Web Administration for i_x000D_ • 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._x000D_ o The basics of web security and securing the HTTP server_x000D_

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 October 4, 2021 2:15pm - 3:15pm CDT
Breakout 7 Online

2:15pm CDT

🟢Words to Live By: A Blueprint for Success
Would you like to be more successful in life? Do you have goals you haven't yet reached, or haven't even tried to reach? What is it about some people that allows them to succeed at virtually everything they do? Take a break from all the technical sessions, and join us for a look at what makes people successful. Discover the relationship between how you think and what you achieve. We'll discuss these topics using meaningful quotes, combined with funny and poignant stories. Discovering the power behind these "Words to Live by" can lead to a more productive and successful outlook on life! We'll examine the habits and mindsets of successful people that you can apply to your own life, perhaps leading to your own greater success! A lifelong study of the characteristics of successful people has led to the discovery of 12 key principles to follow. Join us for this uplifting session, and learn all 12 principles and many more motivational "Words to Live by"!

Learning Objectives:
After participating in this session, attendees should have the skills and vision to: _x000D_ - Understand the relationship between mindset and success_x000D_ - Determine what life changes may lead to greater success in reaching your goals_x000D_ - Develop a plan for yourself to implement those life changes by altering your outlook on life

Speakers
avatar for Steven Wolk

Steven 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 October 4, 2021 2:15pm - 3:15pm CDT
Breakout 12 Online

2:15pm CDT

Darn... Cursored Again! - Using SQL & Cursors in Your Programs
This session demonstrates the use of SQL in your programs. After a short discussion of the differences between Dynamic and Static SQL in your programs; we demonstrate the important concepts in creating a robust SQL program. Topics include host variables, data-structures, error trapping and using tables with SQL

Learning Objectives:
1 Internalize the benefits of using SQL in your programs.
2. Correct use of SQL and CURSORS in your RPG Programs
3. Understand error handling in SQL subprocedures and service programs

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Number ONE in IBM i Education! :)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... Read More →


Monday October 4, 2021 2:15pm - 3:15pm CDT
Breakout 5 Online
  RPG
  • Session Level All

2:15pm CDT

Expand and Simplify RPG Using C Run-Time Functions
Although RPG has an extensive set of operations and functions that the developer can use, there are many functions provided by the C/C++ run-time that can enhance what the developer can do with RPG. And these are often very easy to use._x000D_

Learning Objectives:
1. Learn how to find documentation for C functions. _x000D_ 2. Learn how to create prototypes for this type of function. _x000D_ 3. Discover simple useful functions like access() and system(). _x000D_ 4. Explore more complex examples of C functions_x000D_

Speakers
avatar for Vern Hamberg

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 for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →


Monday October 4, 2021 2:15pm - 3:15pm CDT
Breakout 1 Online
  RPG

2:15pm CDT

Crash Course on Modernizing Frontend Architecture
Do you have an old frontend codebase using jQuery? Want to start using more modern JavaScript and TypeScript language features? This crash course is for you! I will go over what it means to modernize the frontend: what to build, how to build it, where to deploy it, and how to maintain it.



Speakers
avatar for Noel Madali

Noel Madali

Web Architect, The Weather Company at IBM
Frontend and backend architecture, web technologies, eating, cooking, coffee, latte art!


Monday October 4, 2021 2:15pm - 3:15pm CDT
Breakout 2 Online

2:15pm CDT

Best Practices of Security
Best Practices of Security: Understand all the different areas of security one needs to consider — not just on IBM I — and prevent common mistakes and data loss or intrusion.

Learning Objectives:
Understand critical security risks on the IBM i_x000D_ Be able to check for these issues on company systems

Speakers
avatar for Robert Andrews

Robert Andrews

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for the IBM i Security and Authentication Lab Services Power Systems Delivery Practice in Rochester, MN.  He is a Senior Managing Security Consultant and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2... Read More →


Monday October 4, 2021 2:15pm - 4:30pm CDT
Breakout 4 Online
  Security

2:15pm CDT

Managing your IBM i with SQL – Made Easy!
SQL is for more than just doing database things. With the invention of IBM i Services, there are many options for accessing and managing your IBM i. This modified, workshop-style 2-part session will look to explore the many already existing examples shipped in IBM i Access Client Solutions (ACS). _x000D_ _x000D_ We will learn how to modify and enhance these to take your system management capabilities to the next level. Additionally, there are many examples that Scott has created to help IBM i clients accomplish modern system management. _x000D_ _x000D_ Come with your laptop loaded with the LATEST level for ACS. This will get you rolling on the road to managing your environment._x000D_ _x000D_ Download ACS at http://ibm.biz/IBMi_ACS_x000D_

Learning Objectives:
1. Learn how to take IBM i (SQL) Services and put them to work in ACS._x000D_ 2. Explore shifting from viewing data to leveraging data to gain insight on your IBM i._x000D_ 3. Examine techniques for using this SQL knowledge to automate processing.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 October 4, 2021 2:15pm - 4:30pm CDT
Breakout 8 Online

3:30pm CDT

Don’t underestimate the importance of UX when developing IBM i web applications or modernizing the UI.
For anyone involved in modernizing or building IBMi web applications the User eXperience is often a critical factor in adoption or failure. It’s the bridge in between your application and your users. In this session, Nick will share the critical factors in UX success and adoption learned on over 25 years of UX projects on IBMi. 

Learning Objectives:

Speakers
avatar for Nick Hampson

Nick Hampson

Director of Design, Fresche Solutions
Nick has extensive experience in design, UX, product management, innovation and pre-sales. Focused on bringing the business value of design and UX to IBM i customers and the community at large, Nick is recognized as a UX expert on IBM i. He also describes himself as a geek and a bookworm... Read More →


Monday October 4, 2021 3:30pm - 4:30pm CDT
Breakout 5 Online

3:30pm CDT

Managing RPG and non-RPG development simultaneously
You have a mix of applications on your IBM i, many with interconnected non-IBM i applications. Can you manage both at the same time with the same tools? While managing multiple code development workflows feels daunting, it doesn’t have to be. In this session we’ll discuss the best practices around managing not just the development and deployment of applications using multiple languages on multiple platforms, but also how doing so will help set up a winning strategy for your modernization deployments._x000D_

Learning Objectives:
• How to evaluate multiple build technologies and fit them into your development lifecycle_x000D_ • How to define strategies for the deployment your application components_x000D_ • How to ensure that all team members have the latest project status information and the tools to enable them to ‘play their part’ in the process_x000D_

Speakers

Monday October 4, 2021 3:30pm - 4:30pm CDT
Breakout 2 Online

3:30pm CDT

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._x000D_ _x000D_ This is the first of 2 sessions and presents the basic information needed to accomplish this task. The second, "advanced topics" session presents some interesting things that can be done using this methodology.

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

Speakers
avatar for Vern Hamberg

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 for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →


Monday October 4, 2021 3:30pm - 4:30pm CDT
Breakout 1 Online

3:30pm CDT

Supervision Required: Using Query Supervisor to Bring Order to Unruly Queries
Experienced database engineers know that problem queries comes in all shapes and sizes. Some are runaway queries that never seen to end. Others are small changes that become magnified as they run thousands of times. Keeping an eye on all the database activity on your system is not humanly possible. For that reason, IBM introduced the Query Supervisor for Db2 for IBM i. Query Supervisor provides realtime monitoring of queries so that you can detect, understand and address problem queries when they happen. This session will give you a working introduction to Query Supervisor and show you how it fits in with other database tools so that you can take control of problem queries on your system.

Learning Objectives:
1. Understand how Query Supervisor works_x000D_ 2. Configure Query Supervisor for basic operation_x000D_ 3. Apply insights gained from Query Supervisor

Speakers
avatar for Timothy Clark

Timothy Clark

Advisory Software Engineer, IBM


Monday October 4, 2021 3:30pm - 4:30pm CDT
Breakout 3 Online
  Database

3:30pm CDT

⭐ Using Neural Networks for Real-time Db2 Transaction Analysis
Ready to infuse artificial intelligence (AI) into your business? In this session, we will explore a unique methodology for doing real-time analytics of database activity by streaming events to Apache Kafka. Even better, you can leverage the exciting new on-chip AI technology in the latest generation of IBM Power!

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 October 4, 2021 3:30pm - 4:30pm CDT
Breakout 10 Online
  Database

3:30pm CDT

The Art of Advancing your Career Beyond the Technical: Strategic IT
What are your career goals? Sure, we're all great with technology, but to continue growing in our careers requires that we learn to become better communicators and think in terms of the business. 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!

Learning Objectives:
1. Speaking the language of the business_x000D_ 2. Thinking like a businessman_x000D_ 3. Demonstrating strong leadership_x000D_ 4. Selling fellow business leaders on the value proposition of IT investments_x000D_ 5. Always being prepared_x000D_ 6. Earning influence_x000D_ 7. Preparing for and navigating board meetings_x000D_ 8. Difficult conversations_x000D_ 9. Always keeping your cool_x000D_ 10. Aligning IT with business goals.

Speakers
avatar for Steven Wolk

Steven 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 →
avatar for Gregory Simmons

Gregory Simmons

Software Engineer, Jack Henry & Associates
Gregory Simmons is a Software Engineer at Jack Henry and Associates, where he contributes to new and existing banking and financial software products for midsize local and regional banks. He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered... Read More →


Monday October 4, 2021 3:30pm - 4:30pm CDT
Breakout 12 Online

3:30pm CDT

Breaking bad habits with ACS
We all fall into ruts. We continue to do things the same way we have always done them, why? Because it's comfortable. We tell our selfs, that learning something new will 'slow us down'. This session is aimed at breaking down the excuses and helping you see that there is a better way. We will spend most of the time doing live demos on how ACS can help change, and improve you life with the 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 October 4, 2021 3:30pm - 4:30pm CDT
Breakout 7 Online
  Systems Management
  • Session Level All

4:45pm CDT

The Application Testing Landscape
Good development practices include application testing. Exceptional development practices demand it! In this session we look at various levels of testing you should apply to your applications, including Acceptance, Functional, and Unit testing. We discuss methods for defining and executing the testing as well as tools available to help automate the process. If you want good applications, you need good testing practices.

Learning Objectives:
1. Learn what the various types of testing are and what benefits each type brings to the table, and see examples of each in action._x000D_ 2. Know what testing is more and less easily automated, and how automation tools can help your QA team complement manual testing, and form the foundation for continuous integration and delivery._x000D_ 3. Know where to go for reliable information to further your knowledge of application testing.

Speakers
avatar for Clark Everetts

Clark Everetts

Senior Professional Services Consultant, Zend by Perforce
Clark works for Zend by Perforce as a Senior Professional Services Consultant, helping clients innovate, meet business needs, and build better web applications through architecture and performance audits, mentoring in software development best practices, and guiding them using PHP... Read More →


Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 5 Online

4:45pm CDT

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.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 October 4, 2021 4:45pm - 5:05pm CDT
Breakout 7 Online

4:45pm CDT

Knowledge is Power: How the Optimizer Uses Column Stats and Key Range Estimates to Make Queries Run Faster
Database query performance depends on good access plans. The optimizer can build a good access plan when it has accurate information about the data your application is querying. Column statistics and key range estimates are both important sources of information that help the optimizer do its job. This session will peek "under the hood" of the optimizer to provide insight into how these database features work together to make for faster queries. The session will also cover options for configuring these features and best practices.

Learning Objectives:
1. Understand how column statistics and key range estimates help the optimizer._x000D_ 2. Apply best practices to configure these database features._x000D_

Speakers
avatar for Timothy Clark

Timothy Clark

Advisory Software Engineer, IBM


Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 3 Online
  Database
  • Session Level All

4:45pm CDT

IBM i AND Cloud
Today’s IT marketplace is dominated by the discussion of “The Cloud.” Yet most businesses run their critical workloads on servers, such as those used by IBM i clients. How do these two facts intersect? What are the current, and future, capabilities when both IBM i and Cloud are considered? That’s the topic for this session from Steve Will, the IBM i Chief Architect.

Learning Objectives:
1. Understand how IBM i fits into today's discussions of "the Cloud"_x000D_ 2. Understand your options as an IBM i users if you want to use IBM i and Cloud technology.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.


Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 2 Online
  IT Strategy
  • Session Level All

4:45pm CDT

SSH vs SSL - More different than one letter
As the IT industry correctly places a higher emphasis on security an important part of that is securing how your applications connect and your data passes across the network. SSH and SSL are 2 foundations upon which secure communications can be based._x000D_ _x000D_ There seems to be a common misconception that these technologies are more or less secure versions of the same thing. Receiving questions on wanting to secure Telnet with SSH instead of SSL because SSH is more secure, or needing to move from FTP-s to sFTP for the same reason._x000D_ _x000D_ This session with explain the foundational approaches that each of these technologies takes, how they are both secure, and how they are different and are not usually direct replacements for each other.

Learning Objectives:
Understand the differences between SSH and SSL

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 October 4, 2021 4:45pm - 5:05pm CDT
Breakout 4 Online
  Networking

4:45pm CDT

The Beauty of Second Best
Whether it is concerning a career or a certain aspect of one's life, being labeled second best is not a favorable choice for most. What if coming in second is actually more beneficial for you at your job rather than always coming in first? What if allowing yourself to accept the second place title in life will put you in a better mental state for your future? The beauty of being second best will explain exactly that.

Learning Objectives:
1. Learn to see the other side of being second in life and at work_x000D_ 2. How to overcome the disappointment and push away a negative mindset_x000D_ 3. How a person can learn from not coming in first

Speakers

Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 10 Online

4:45pm CDT

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?_x000D_ - Technical details of parameters, candidates, etc_x000D_ - Full examples you can use yourself_x000D_

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help... Read More →


Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 11 Online
  RPG

4:45pm CDT

🟢 Why Procedures are Better than Subroutines
If you aren't using procedures, you're missing out! We'll discuss why sub-procedures are better than subroutines, and show how easy they are to use.

Learning Objectives:
1. Why you want to use sub-procedures_x000D_ 2. How to code a sub-procedure

Speakers

Monday October 4, 2021 4:45pm - 5:05pm CDT
Breakout 9 Online
  RPG, N2i

4:45pm CDT

Intro to Techniques Used to Manipulate HTML at Run Time
This session will provide a rather fast-paced glimpse into a handful of strategies for changing HTML at run time. This kind of manipulation is usually needed when building a web page that is to operate like a traditional IBM i business application. Similarly, we are going to need a way to change the literal HTML UI element properties at run time based on run time conditions._x000D_ _x000D_ We’ll take a high-level peek at techniques, while avoiding focus on pros and cons. However I may bring in a little bit about the primary focus of a technique based upon the kind of challenge I think it is intending to solve. We’ll touch upon CSS3 media queries, JavaScript, jQuery, PHP and compiled code-behind, not necessarily in that order. We'll see at least one code or script snippet for each topic._x000D_

Learning Objectives:
1. Begin thinking about server versus client side logic separation_x000D_ 2. Gain an intro into the kinds of HTML manipulation that are possible_x000D_ 3, See some code or script examples that parallel things you might do in a traditional IBM i application_x000D_

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 October 4, 2021 4:45pm - 5:05pm CDT
Breakout 1 Online
  Web Applications
  • Session Level All

4:45pm CDT

🟢Be a Customer Service Superhero
We all dream of being a superhero, right? What if your superpower was providing awesome, world-class customer service. Customer service? Who needs customer service when you work in IT? The answer is that we all have customers. Even if you develop software just for use in your own company, those people who use your software are your customers. Those people who contact your help desk for support are your customers. You'd be amazed how much you can improve the perception of your software and your IT department by unleashing your inner customer service superhero! As part of this presentation, we'll examine real world examples of excellent - and terrible - customer service, and discuss what we can take away from each. _x000D_

Learning Objectives:
Learning objectives:_x000D_ * Who are your customers_x000D_ * A customer first mindset_x000D_ * Is the customer always right?_x000D_ * How helpful is your help desk?_x000D_ * The Superhero skills required to deliver world class customer service

Speakers
avatar for Steven Wolk

Steven 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 October 4, 2021 4:45pm - 5:45pm CDT
Breakout 8 Online

5:15pm CDT

A First Look at Physical Computing with Raspberry Pi
Physical computing: Applications that interact with the physical world. The Internet of Things is driven by the ability to write applications that are able to interact with real, physical things. This session introduces physical computing by demonstrating how an RPG program can communicate with a Raspberry Pi that is controlling real-world devices.

Learning Objectives:
1. Understand what Raspberry Pi is_x000D_ 2. Understand how it can be used to control switches, sensors and more_x000D_ 3. See how you can communicate from an RPG program

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help... Read More →


Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 11 Online

5:15pm CDT

PHP Migration with PHPCompatibility Tool
You need to know how big or small the job is before you begin a PHP version migration. I'll show you how to use a free, open source tool called PHPCompatibility to generate a report that tells you much of what you need to change, line by line, in your application, to migrate to a new PHP version. I've helped migrate nearly seven million lines of PHP in the last three years. This is but one of the tools we use. Would you like an introduction?

Learning Objectives:
1. Learn how to set up the tooling you'll need, with my ready-to-use repository._x000D_ 2. See how to choose which code from your application to include and exclude from scans_x000D_ 3. Learn how to run PHPCompatibility and my custom summary report tool, and interpret the results, like which findings to focus on, and which ones you can safely ignore.

Speakers
avatar for Clark Everetts

Clark Everetts

Senior Professional Services Consultant, Zend by Perforce
Clark works for Zend by Perforce as a Senior Professional Services Consultant, helping clients innovate, meet business needs, and build better web applications through architecture and performance audits, mentoring in software development best practices, and guiding them using PHP... Read More →


Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 5 Online

5:15pm CDT

Wireframing & Prototyping: A Strong Start to IBM i Web / Mobile Development
Considering web and mobile development on IBM i? Before you start coding, it’s advantageous to validate your vision with a simple visual representation of how the proposed application will work in the form of a wireframe and/or protype. Adding this step to your development process increases the likelihood that your project will succeed because it gives stakeholders a clear understanding of how the application will solve users’ problems before you build it._x000D_ In this session, Scott Gingerysty will cover wireframing and prototyping fundamentals and best practices. He’ll discuss:_x000D_ _x000D_ • What wireframes and prototypes are_x000D_ • The differences between wireframes and prototypes _x000D_ • The advantages of wireframing and prototyping_x000D_ • Use cases and examples on IBM i

Learning Objectives:

Speakers
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for over 20 years, the last 13 with Fresche Solutions where he is currently a Modernization Specialist. In addition to business development activities, Greg also coordinates pre-sales technical demonstrations and discussions, performs business... Read More →


Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 6 Online

5:15pm CDT

🟢IBM i ACS 5250 Overview
IBM i Access Client Solutions (IBM i ACS) provides a best of breed 5250 emulator with many transformational features and capabilities that you may not be aware of or using most effectively. Join us for a quick, predominantly live demo session to get the most out of your IBM i ACS 5250 emulator

Learning Objectives:
1) Get the most out of your IBM i ACS 5250 Emulator

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 October 4, 2021 5:15pm - 5:35pm CDT
Breakout 4 Online
  Client Connectivity
  • Session Level All

5:15pm CDT

⭐ 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!

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 October 4, 2021 5:15pm - 5:35pm CDT
Breakout 7 Online

5:15pm CDT

Your Team and COVID
Employees in the Developing field work as a team to ensure a project is being done properly and submitted within a certain time frame. Each individual has a certain responsibility that needs to be completed for the rest to move forward. Most of this work was done on site. When COVID hit, employers were forced to have their employees work from home. During this time, there were many things we have learned about the atmosphere change and the employees in general. This session will elaborate on those teachings and how you can use them to instill trust within your team.

Learning Objectives:
1. How COVID impacted the work field_x000D_ 2. Understand the atmosphere has pros and cons_x000D_ 3. How to recover from the setback.

Speakers

Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 10 Online

5:15pm CDT

DevOps on IBM i (and how RedHat fits in)
So you've probably heard the buzz around two terms in DevOps: Continuous Integration (CI) and Continuous Deployment (CD). You probably also have heard about things like Ansible and Docker and Kubernetes and how they relate to CI/CD and DevOps and are completely confused about how they apply to the real work that you are doing on your IBM i today._x000D_ _x000D_ The answer is that CI/CD concepts are completely relevant to what you do, but some of the tooling that you've probably heard about (Docker/Kubernetes) really don't apply; however, since IBM acquired RedHat a little more than a year ago, some of that has changed (specifically in relation to Ansible)._x000D_ _x000D_ Learn about DevOps tooling in general (with a special nod to Ansible) but most importantly, this presentation should help to convince you that DevOps is not a passing fad that is going to take resources away from your "real" projects; rather, it is a fundamental shift that will make development faster, more efficient, more responsive, and (most importantly, to many) less costly with minimal investment.

Learning Objectives:
Learn about DevOps tooling_x000D_ _x000D_ Get background on the RedHat acquisition and its impact on IBM i (especially as it relates to Ansible)_x000D_ _x000D_ Understand why DevOps is important (hint - $$$)

Speakers
avatar for Andrew Clark

Andrew Clark

DevOps Manager, Arcad Software
Andrew Clark has been working on the IBM i platform for more than 30 years, beginning with the “secret Mankato Project” on a pre-release version of os/400, and an internship at IBM Rochester working on the Query team. He has development expertise in more than a dozen languages... Read More →


Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 3 Online
  IT Strategy
  • Session Level All

5:15pm CDT

🟢 What the Heck is Binder Source and Why Do I Care?
Learn what binder source is and what it does, and why you definitely want to use it with your service programs.

Learning Objectives:
1. What is a service program signature_x000D_ 2. What is binder source_x000D_ 3. How to avoid recompiling everything after changing a service program_x000D_

Speakers

Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 9 Online
  RPG, N2i

5:15pm CDT

Monitor your IBM i via Grafana
Grafana is the modern open source analytics and interactive visualization application. It is very popular on open platforms. It supports lots of data source but no direct option for IBM i. The topic will demonstrate how to virtualize IBM i system status via IBM i service, REST and Grafana.

Learning Objectives:
1. How to build data source on IBM i to be consumed by Grafana._x000D_ 2. How to leverage IBM i services to fetch IBM i system status information_x000D_ 3. How to create dashboard in Grafana

Speakers
avatar for Chang Qing Zheng

Chang Qing Zheng

Software Engineer, IBM
I am working on IBM i Web Integration area, covering several products on IBM i, like Web Admin, HTTP server, Db2 Mirror, Java toolbox, node.js and open source technologies.


Monday October 4, 2021 5:15pm - 5:35pm CDT
Breakout 1 Online

5:30pm CDT

Networking Event: Birds of a Feather
Connect with peers, industry experts, and solution providers who have common interests and goals. Circle the event networking platform to exchange ideas and learn from your fellow participants. This is a wonderful opportunity to meet new people, catch up with old friends, and build the platform one conversation at a time.

Monday October 4, 2021 5:30pm - 6:30pm CDT
Breakout 12 Online
 
Tuesday, October 5
 

7:30am CDT

Morning Yoga, Sponsored by Midrange Dynamics
Join us first thing for gentle morning stretching at your desk. Simple for those who have never tried yoga with modifications for those who have, this is a wonderful way to start your day.

Speakers
avatar for Jennifer Hollister

Jennifer Hollister

Yoga Teacher, Jennifer Hollister Yoga
An E-RYT Yoga Teacher, Trauma Based Yoga Therapist and Trauma Psychotherapist, Jennifer has an extensive background in mental and physical health for over 20 years.Jennifer teaches a variety of yoga styles in addition to Yoga Therapy, stress relief and meditation classes. She offers... Read More →


Tuesday October 5, 2021 7:30am - 7:55am CDT
Breakout 1 Online

8:00am CDT

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.

Learning Objectives:
1. Improving developer productivity with Templates & Snippets _x000D_ 2. Creating Templates & Snippets_x000D_ 3. Sharing Templates and Snippets with other Developers_x000D_ _x000D_

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 →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 4 Online

8:00am CDT

Keeping Your System Safe with the Latest in API Security
Are you looking to securely access APIs from your IBM i applications?_x000D_ _x000D_ APIs make doing business faster, easier and just better. Anyone can go to a single shopping site and browse products from a wide variety of suppliers to get instant price quotes and immediately see how much shipping will cost. However, all that convenience comes with a cost. APIs have become the number one target for hackers looking to attack a company’s systems. It is critical to have a strong security strategy to go along with your API efforts to keep your company safe._x000D_ _x000D_ In this session, we will step you through setting up the latest in security technology to protect your APIs. And we will show you how to set up processes to ensure your security systems stay up to date._x000D_ _x000D_

Learning Objectives:
1. Learn how to use the latest open source modules for securing your IBM i APIs (so you don't have to try and write the code yourself)_x000D_ 2. Learn about the latest threats and how to protect your systems_x000D_

Speakers
avatar for Daniel Magid

Daniel Magid

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


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 10 Online

8:00am CDT

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_x000D_ 2. How to interact with Node.js and IBM i from the same system_x000D_ 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 →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 2 Online

8:00am CDT

⭐ Microservice apps on OpenShift & IBM i - Demo/ Q&A
Get Started with OpenShift and containers with IBM i.  Based on real cases, this demo illustrates the use of the latest technologies on a live environment (#ShowNotTell) and a fictive company ‘AcmeAir’: app development and test of a microservice application running on OpenShift integrated with a 'customer' (CRM) microservice running on IBM i / Db2 Mirror for i.  Stateless and Stateful: Best of both worlds.
key words: jdbc , java, odbc, node.js, API , Db2 for i, integration, container, ILE, IWS, OpenShift, Red Hat.

Speakers
avatar for Benoit Marolleau

Benoit Marolleau

Architect, IBM
Benoit Marolleau is Cloud Architect at the IBM Montpellier Systems Center for EMEA. focusing on Hybrid Cloud & Power solutions architecture for business critical applications: app modernization, Open Source, Red Hat & Cloud solutions, AI, DevOps & IBM Cloud, with a constant motivation... Read More →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 6 Online

8:00am CDT

Generating JSON Documents with SQL (SQL and JSON – Part 1)
JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose and can be faster parsed than XML. In this way JSON becomes more and more important especially when data is exchanged by RESTful web services. The use of XML declines in favor of JSON. _x000D_ With Release 7.3 TR 3 a bunch of scalar and aggregate functions were integrated into SQL, for generating JSON objects, arrays and for combining JSON components into complete documents. The focus of this session is to generate JSON documents.

Learning Objectives:
Get an introduction into JSON basics. Learn how JSON object and arrays can be generated, concatenated or nested and composed into JSON documents.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 7 Online
  Database

8:00am CDT

Managing MultiPlatform development from your IBMi
As we all progress into development environments with multiple languages deployed to multi platforms, managing inter-dependencies and deployment gets ever more difficult. Here we will show you some simple tools and techniques to make life a little easier, using tools to perform Impact Analysis, compilation, unit testing, compilation and distribution.

Learning Objectives:
1. How to start your DevOps journey on IBMi._x000D_ 2. What toolsets are out there to enable the journey._x000D_ 3. How to link in your IBMi to the wider DevOps process in your company.

Speakers
avatar for Karl Haggart

Karl Haggart

Managing Director, Remain Software


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 9 Online
  IT Strategy
  • Session Level All

8:00am CDT

Exploring Open Source on IBM i
Open Source is exploding on the IBM i platform. This workshop provides us a unique opportunity get up close and personal with open source on the world's best platform! We will start out by talking about what open source means to the platform and take a look at setting up the initial open source ecosystem. From there we will take a look at the containerization capability provided by the chroot utility and how it can be used to build file-system containers so that different developers can have different software/package collections. Once our containers are setup we will then explore the various open source programming languages including python, node.js, and php and take a look at how to integrate those languages with Db2 and ILE. Finally we will take a look at how open source productivity solutions such as WordPress, Magento, and Drupal can be implemented on the platform. Time has never been better to take a dive into the Open Source end of the pool.

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 11 Online

8:00am CDT

Jazz up your Open Source BI with Jasper
Jasper Reports and Jasper Server are two great open source tools that can provide awesome reporting tools for next to no monetary investment. This session will review the installation, design and deployment of Jasper Reports to the Jasper Server all of which can be hosted on IBM i.

Learning Objectives:
1. How to install Jasper Server_x000D_ 2. How to design and deploy Jasper Reports_x000D_ 3. How to configure and manage reports and dashboards in Jasper Server

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently Java Team Lead at Bible Study Fellowship International. Pete is an RPG/C++/VB/Java programmer with over 24 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Secure Software Programmer-Java, and as a MCSE. His passion has always been in... Read More →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 12 Online

8:00am CDT

Python Productivity: Python Modules for Productivity
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. We’ll wrap up with a Live Q&A with demos.

Learning Objectives:
1) Understand how Python modules are implemented and used. _x000D_ 2) Explore the Python Standard Library or PSL._x000D_ 3) Install and explore several open source modules that add productivity to the development team._x000D_ 4) Take a quick tour of Flask as both a module and open source framework. _x000D_

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect
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 →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 1 Online

8:00am CDT

Writing "modern" RPG code
This session discusses some of the features of the ILE RPG language that allow you to write modern code, and to develop in a modern way.

Learning Objectives:
Learning Objectives:_x000D_ - Learn the features of ILE RPG that allow you to write "modern" code_x000D_ - Learn which old features to avoid_x000D_ - Learn how to get the best performance for your call operations_x000D_ - Learn where to define variables and files so you can make changes more quickly and confidently_x000D_

Speakers
avatar for Barbara Morris

Barbara Morris

IBM
Barbara Morris is the lead developer for the RPG compilers in the IBM Toronto Lab. She has been working on the RPG compilers since she started at IBM in 1989 after receiving a Computing Science degree from the University of Alberta. The first enhancement she developed was the ENDIF/ENDDO... Read More →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 8 Online
  RPG
  • Session Level All

8:00am CDT

Securing SSH for IBM i
As more IBM i clients start to use SSH, it is important to understand how to properly secure it on the platform. This session will cover recommended ways to harden SSH. A discussion of the various file transfer options will also be included.

Learning Objectives:
1. How to configure SSH for IBM i_x000D_ 2. How to lock down SSH for IBM i_x000D_ 3. Learn about the various file transfer tools

Speakers
avatar for Robert Andrews

Robert Andrews

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for the IBM i Security and Authentication Lab Services Power Systems Delivery Practice in Rochester, MN.  He is a Senior Managing Security Consultant and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2... Read More →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 5 Online
  Security

8:00am CDT

Understanding Network Security: Securing Network Applications with Digital Certificates
Understanding Network Security_x000D_ Network communications today require encryption. This session provides the foundation to configure and manage network security on IBM i using Digital Certificates assigned to Application Definitions that will establish industry standard Transport Layer Security (TLS) encryption.

Learning Objectives:
1. Understand the cryptography related to digital certificates._x000D_ 2. Use the latest Digital Certificate Manager web application to create certificates._x000D_ 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

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (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, Integrated... Read More →


Tuesday October 5, 2021 8:00am - 9:00am CDT
Breakout 3 Online
  Security

9:15am CDT

🟢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. _x000D_ _x000D_

Learning Objectives:
We will work through the benefits to modernizing your code and why you want to adopt unit testing._x000D_ We will work through breaking apart monolithic programs and how to write their respective unit tests._x000D_ 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 is one of two IBM i admins... Read More →


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 3 Online

9:15am CDT

Consuming JSON Documents and Web Services with SQL (SQL and JSON - Part 2)
JSON becomes more and more important especially in RESTful web services. The use of XML declines in favor of JSON. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed.

Learning Objectives:
Learn how JSON documents located in either the IFS or a column in a table or JSON answers from web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected. You’ll also get an overview over the new http-functions and how to use them for getting access to web services.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 7 Online
  Database

9:15am CDT

Exploring Open Source Databases on IBM i
Open Source databases have been available on IBM i ever since MySQL was released on the platform back in the mid 2000s. Now with the expansion of Open Source adoption on the platform more open source databases have arrived including MongoDB and Redis with more to follow. This session will provide an overview of the open source database management systems available on the platform, there features, the solutions that they enable, and why they are important to the platform.

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 11 Online
  Database
  • Session Level All

9:15am CDT

Implementing a DR Solution in the Cloud
IBM i in the Cloud opens up a new world of possibilities for IBM i shops.  One of the opportunities is to use the cloud in implementing your DR and availability design. Learn how to use the same logical replication solutions to sync up and maintain a switchable HA/DR environment using Cloud services.

Learning Objectives:
Learn the some recommended approaches to using IBM i in the cloud to deliver DR and HA _x000D_ Understand the key differences between implementing an availability solution on-premises vs. in the cloud

Speakers

Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 10 Online

9:15am CDT

⭐ i Stands for Innovation: IT Professionals Talk About Today’s Achievements and Building a Foundation for the Future
Attend a lively, interactive panel discussion including IBM i community members from AMPORTS, REI, Hatco Corporation, and Liberty Mutual Insurance.

We will chat about the opportunities and challenges they encounter as they gear up for current and future IT directions. Plus, we’ll learn how they continue to advance their IT initiatives and overcome obstacles. You will hear their advice for, and the benefits of, upgrading skills and software tools to support:
· Their teams’ advanced development and modernization directions,
· Application integrations - including integrating IBM i business assets with the wider world
· Smooth hardware and OS upgrades, and more.

Featuring Gordon Leary from AMPORTS, Mike Loyd from REI, Ted Macksam from Hatco Corporation, David Jones from Liberty Mutual Insurance, and other special guests. Moderator is Donna Westmoreland, Midrange Dynamics North America.



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.
ML

Mike Loyd

Principal Software Engineer, REI


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 6 Online
  IT Strategy

9:15am CDT

⭐ ODBC Up and Running
IBM i now provides an ODBC driver for Db2 that works just like the one on Windows, Linux, and Mac. With this driver, fully supported by IBM, developers can code on their PCs, then deploy the same code to IBM i for production. Learn Alan’s recommended settings and tips for using ODBC with open source languages, including Node.js, PHP, and Python, and R, as well as .NET, and how to convert proprietary Db2 driver functions to standard ODBC functions.

Learning Objectives:
  1. How to install and configure ODBC on IBM i
  2. How ODBC can help you develop software that can run on any platform while accessing IBM i data
  3. How to use ODBC from the various languages safely and effectively, avoiding common mistakes

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 8 Online

9:15am CDT

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_x000D_ 2. Understand password protection tools

Speakers
avatar for Robert Andrews

Robert Andrews

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for the IBM i Security and Authentication Lab Services Power Systems Delivery Practice in Rochester, MN.  He is a Senior Managing Security Consultant and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2... Read More →


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 5 Online
  Security

9:15am CDT

Live Demo of the New IBM Navigator for i
The IBM Navigator has been around for a very long time, the good news, a brand new version has just been delivered that re-images Navigator from the ground up. Really, the only thing that the same is the Title. The User interaction, tables, data , architecture, is all completely new and is leveraging the very latest in modern technology. As the title says... we will explore many of the new aspects of the IBM Navigator via a live demo.

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 →


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 1 Online

9:15am CDT

What You Need to Know to Successfully Upgrade to IBM i 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 →


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 12 Online
  Systems Management
  • Session Level All

9:15am CDT

⭐ Power Virtual Server & Hybrid Cloud - Hands-on or Demo or Presentation
Discover IBM Power Virtual Server in IBM Cloud: In this session, you will see how to deploy an AIX, IBM i or Linux on Power environment in the IBM Cloud. You will experience operations such as VM deploy, console access, configuration updates, image capture/import from IBM Cloud Object Storage and VM Destroy with support from IBM instructors. Prerequisite: Bring a valid IBM ID with access to the IBM Cloud. Please login before the session begins at: cloud.ibm.com/login

Speakers
avatar for Benoit Marolleau

Benoit Marolleau

Architect, IBM
Benoit Marolleau is Cloud Architect at the IBM Montpellier Systems Center for EMEA. focusing on Hybrid Cloud & Power solutions architecture for business critical applications: app modernization, Open Source, Red Hat & Cloud solutions, AI, DevOps & IBM Cloud, with a constant motivation... Read More →


Tuesday October 5, 2021 9:15am - 10:15am CDT
Breakout 9 Online

10:30am CDT

⭐ The Evolving Landscape of IBM i Applications - A look at trends, directions and what is being adopted
In today’s hyper-competitive and business environment, organizations need to be agile and have systems that can quickly adapt to the pace of change. The need for highly modern, scalable and secure systems in IT has never been higher and will continue to accelerate.

Join Chris Koppe, leading IBM i modernization and transformation expert at Fresche, to learn about the latest IT trends for 2021, next-gen IBM i technologies being adopted, and get a look at several IBM i client roadmaps to see the directions being taken.
Chris will cover:
  • Latest trends in IT, impacts of COVID and what’s on the horizon?
  • Current state of IBM i applications 
  • Deep dive into real-life customer roadmap examples
    • The business needs, the challenges and the opportunities
    • Technologies, architectures and approaches including APIs, web, mobile, cloud, etc.
    • Next Gen IBM i applications. What do they look like?
  • How to create the perfect roadmap for you?

Speakers
avatar for Chris Koppe

Chris Koppe

SVP Portfolio & Strategic Services, Fresche Solutions
Chris Koppe is responsible for overall portfolio strategy and or the Strategy Consulting organization at Fresche Solutions. He has led the development of legacy management strategies for hundreds of companies, across a variety of platforms, languages, databases, and technologies... Read More →


Tuesday October 5, 2021 10:30am - 11:30am CDT
Breakout 1 Online

11:45am CDT

Rest API Engine (IWS) Enhancements for Protecting & Understanding APIs
Learn about enhancements for protecting APIs deployed in the integrated web services server, and ensuring that your APIs are functioning as expected using new logging features of the integrated web services server.

Learning Objectives:

Speakers
avatar for Nadir Amra

Nadir Amra

Software Engineer, IBM
Nadir Amra has B.S. and M.S. degrees in Computer Science from the Ohio State University.   He has worked for IBM in Rochester, MN since 1988, starting in the Communications area, where he was an instrumental member of the development teams that introduced the CPI-Communication and... Read More →


Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 5 Online

11:45am CDT

🟢IBM i ACS IFS Overview
IBM i Access Client Solutions (IBM i ACS) provides an IBM i IFS utility with many features and capabilities that you may not be aware of or using most effectively. Join us for a quick, predominantly live demo session to get the most out of your IBM i ACS IFS Utility.

Learning Objectives:
1. Get the most out of IBM i ACS IFS

Speakers
avatar for Wayne Bowers

Wayne Bowers

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


Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 4 Online
  Client Connectivity
  • Session Level All

11:45am CDT

The Success Story of Java & Open-Source Software on the IBM i
Java is a very good option on the IBM i and the Java ecosystem has greatly benefited from the contribution of the Open-Source community in the last 25 years or so.

Learning Objectives:
This presentation will include several examples such as build automation, test automation, application framework, etc. These categories of Open-Source initiatives will be described including some detail on the pros and cons of each Open-Source project.

Speakers
FM

Frederic Marceau

Senior Strategist, Fresche Solutions
I am a digital transformation strategist with expertise on strategic analysis and code transformation. I am very knowledgeable on newer technologies such as Java and .NET but also web technologies and open source languages and solutions such as PHP, python. I have been an adept of... Read More →


Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 6 Online

11:45am CDT

Its Now or Never
Are you putting something off for a later time that involves furthering your education and career? I am here to tell you, it is now or never. There will always be another reason, another obstacle that will cause you to put off your goal for later. If you can train your brain, change your mindset, to lessen the impact of these obstacles, you can achieve what you have been putting off.

Learning Objectives:
1. Why are people inclined to put off something that will enhance their career when they see an obstacle_x000D_ 2. How to change your thought process and use those thoughts to reach your goals_x000D_ 3. Understand there will always be another reason to not do it now and learning how to overcome certain obstacles.

Speakers

Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 10 Online

11:45am CDT

Graph History - What is it
Graph history as been around for a while now, but there are still many that don't understand its value or that they have access to this treasure trove of info! In this session Lora will do a live demo to show graph history in action as seen from the New IBM Navigator for i interface Objectives:

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).


Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 12 Online

11:45am CDT

⭐ Dipping your Toe in the Jargon of the Internet of Things
With an estimated 50 BILLION devices attached to the Internet, with a business value of over ONE TRILLION DOLLARS, you need to learn about this technology! We will race through the basic concepts of the IoT, terminology and why this is such an exciting technology to explore.

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

CEO, Central Park Data Systems
Charles Guarino has been an Information Technology consultant for the vast majority of his career. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →


Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 1 Online

11:45am CDT

🟢 Debugging in the Browser: Introduction to Chrome DevTools
Included in the popular (and free!) Google Chrome web browser are some of the most useful front-end development and debugging tools you'll ever need. Even IBM i programmers with little or no background in web development can find useful elements in these tools, as they provide a mechanism for understanding what's happening with any element on a web page communicating with their IBM i server. The tools also provide an effective playground for experimenting with HTML, CSS and JavaScript concepts._x000D_ _x000D_ In this short session Rob will introduce Chrome's integrated DevTools, demonstrating how it can be used to interrogate data going between an IBM i back-end and a front-end web application, view source code, analyze visual elements and dig into other common aspects of a typical web page. The focus will be on items that would be most pertinent to RPG developers who may have little or no prior experience in programming involving web pages.

Learning Objectives:
1. Learn how to access Chrome DevTools from Windows or Mac, and navigate to the most commonly used elements_x000D_ 2. Become familiar with basic concepts behind JSON, JavaScript and the DOM, all of which can be inspected and tweaked in DevTools_x000D_ 3. See how to use DevTools to understand where data in a business app is coming from - essential information for debugging a problem

Speakers
avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation


Tuesday October 5, 2021 11:45am - 12:05pm CDT
Breakout 9 Online

11:45am CDT

🟢 SQL 101 Bullet Train
Hang on as we go from 0 to 300 MPH with SQL. We'll start out slow by covering the basics of creating tables, inserting, and selecting data. We pick up speed as we discuss Constraints, Join Types, and SQL Views. We will be going at full speed when we learn how to leverage Functions, Procedures, and Db2 Services! We will bring it all back to the station as we use all our SQL skills to build a project that combines everything we've learned along the way.

Learning Objectives:
1. Use SQL to create tables and avoid common data errors with constraints_x000D_ 2. How to use Views, Functions, Procedures_x000D_ 3. Discover how many Db2 services are available!_x000D_ 4. See how all these things fit together

Speakers

Tuesday October 5, 2021 11:45am - 12:45pm CDT
Breakout 11 Online
  Database, N2i

11:45am CDT

🟢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 _x000D_ 2. trying something new and seeing the results. _x000D_ 3. being comfortable with trying something new again.

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 is one of two IBM i admins... Read More →
avatar for Rochelle Petty

Rochelle Petty

Application Support & Developer, 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 →


Tuesday October 5, 2021 11:45am - 12:45pm CDT
Breakout 2 Online

12:15pm CDT

Use native functionality to retrieve public data for 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. _x000D_ _x000D_ 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_x000D_ 2. How to find a public web service API and understand its inputs and outputs_x000D_ 3. How to structure and execute an SQL statement to pull data from the web service_x000D_

Speakers
avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation


Tuesday October 5, 2021 12:15pm - 12:35pm CDT
Breakout 9 Online

12:15pm CDT

IBM i ACS Data Transfer Overview
IBM i Access Client Solutions (IBM i ACS) provides a Db2 Data Transfer features and capabilities that you may not be aware of or using most effectively. Join us for a quick, predominantly live demo session to get the most out of your IBM i ACS Data Transfer.

Learning Objectives:
1. Get the most out of IBM i ACS Data Transfer

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 Michael Swenson

Michael Swenson

Software Engineer, IBM
Michael has worked in IBM support since 1994. Starting with supporting PC Support for DOS and OS/2 through the current IBM i Access Client Solutions products.  I've specialized in the data access functions (data transfer, ODBC, JDBC, APIs, etc) for most of that time.


Tuesday October 5, 2021 12:15pm - 12:35pm CDT
Breakout 4 Online
  Client Connectivity
  • Session Level All

12:15pm CDT

🟢IBM Navigator for i
Please join us for a quick, informative session on the latest with IBM Navigator for i

Learning Objectives:

Speakers

Tuesday October 5, 2021 12:15pm - 12:35pm CDT
Breakout 6 Online
  Client Connectivity
  • Session Level All

12:15pm CDT

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._x000D_ 2. Understand the most valuable aspects of using OR REPLACE._x000D_ 3. Understand how you can shift to management of master source for your data model.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 →


Tuesday October 5, 2021 12:15pm - 12:35pm CDT
Breakout 1 Online
  Database

12:15pm CDT

Monitoring Activity for Many IBM i nodes from a Single Pane with IBM Navigator
One of the design points for the New IBM Navigator was to be a single place where a user can manage and monitor many IBM i endpoint nodes. With the Custom Charts features in IBM Navigator, you can easily create a single chart to visualize a metric on many systems. This session will explore this new feature and of course... include a live demo.

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 →


Tuesday October 5, 2021 12:15pm - 12:35pm CDT
Breakout 12 Online

12:15pm CDT

Using Message Watches to Capture Intermittent Failures
Intermittent problems can be difficult to debug. If you have an intermittent problem that can be identified because a message is sent, you can use message watches to dynamically collect data when the message is sent. This session will demonstrate how to start watches and will go over a simple example of a message watch exit program. Attend this session to add another diagnostic tool to your toolbox.

Learning Objectives:

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 →


Tuesday October 5, 2021 12:15pm - 12:35pm CDT
Breakout 10 Online

12:30pm CDT

Lunch Break in the Expo
Tuesday October 5, 2021 12:30pm - 1:30pm CDT
All-Attendee Expo Online

1:30pm CDT

🟢Development Lifecycles and How to Test Them
As businesses modernize there are multiple types of software requiring support. We will discuss the types of software life-cycles all needing different testing. Specifically covered are the development types V-model, Waterfall model, and Iterative model. From there we will talk about component, integration, system, and acceptance testing and where and how to use each _x000D_

Learning Objectives:
Comprehend the different levels of testing: major objectives, typical objectives of testing, typical targets of testing (e.g. functional or structural) and related work products, people who test, types of defects and failures to be identified. Understand the definitions of Development types: V-Model, Waterfall Model, and Iterative _x000D_

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 6 Online

1:30pm CDT

Fast Start to Delverying Value with Db2 Web Query's Analytics Infrastructure: Intro to Db2 Web Query and Metadata
Db2 Web Query is very robust Business Intelligence and Data Warehouse family of products. But when you first start out it can be a bit of a challenge to understand the fundamentals that you can build on moving forward. One of those is the meta data layer - and understanding different data sources (like an RPG Program) that might already exist that you can leverage. This session is designed to provide hints and tips to a FAST START to making web query work for you.

Learning Objectives:
1. Get tips on how best to get up to speed after installation_x000D_ 2. Understand the benefits of the meta data layer and how to create and extend._x000D_ 3. Learn about auto generation facilities

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 →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 3 Online
  Database

1:30pm CDT

Performing Backups using your HA system
Your High Availability environment can protect you from downtime but did you realize it can also deliver other important benefits? Performing Backups on a High Availability target system always has been a great solution for customers.  Come and see why it still is and some new opportunities opened up by IBM i in the cloud.

Learning Objectives:
Learn how to use your HA environment to optimize your backup operations_x000D_ Understand the benefits over doing backups from your primary system

Speakers
avatar for Dan Simms

Dan Simms

Project Management Director, IBM i HA Solutions, Precisely
Hello, my name is Dan Simms.  I am the Director of Product Management for the IBM i HA portfolio at Precisely.  My portfolio includes Assure MIMIX, QuickEDD, iTera, OMS/ODS, Assure MIMIX for AIX, and iOptimize.  I have been with Precisely (Syncsort, Vision Solutions) for 25 years... Read More →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 10 Online

1:30pm CDT

⭐ Create IBM i Web or Mobile Apps with No Programming (unless you want to)
The Valence Framework for IBM i, available for free download, includes a browser-based development tool called Nitro App Builder that allows anyone with a solid understanding of their IBM i database to quickly create dazzling dashboard and query apps, complete with download-to-Excel functionality. You can also create apps that adjust data in the underlying physical files, call RPG programs and much more. _x000D_ _x000D_ The key point is that all of this front-end development can be done with no coding, though advanced developers can easily extend the app's functionality with additional UI or business logic as needed. _x000D_ _x000D_ The bottom line: With Valence, IBM i developers and super users alike can crank out highly functional web and mobile apps in a matter of minutes with no prior experience in web or mobile development. Come to this session to see how easy it can be to build such apps on your system today!

Learning Objectives:
Attendees will see how simple it is to log in to their IBM i through a browser and leverage their business and database knowledge to quickly create & deploy intuitive apps that pull data from their physical files. RPG developers will learn about methods to link these apps to their own back-end business logic, thereby making it possible to update IBM i data from user actions in a browser or mobile device.

Speakers
avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 9 Online

1:30pm CDT

IBM i OS Networking Security
Network Communications security is a necessity for nearly everyone in at least some scope, and this session will look at some of the technology and tools available on the IBM i OS_x000D_ _x000D_ TLS network encryption is a very important part of the security picture, and we will look at some protocol details, managing the communications network encryption environment on your IBM i OS, differentiating what is available and how the configuration approach differs at the differing IBM i OS releases, and what is the latest coming in the TLS encryption protocol. We will also briefly look at sniffer traces showing different connection handshakes._x000D_ _x000D_ Depending on available time we may also look at other Networking Security topics like Intrusion Detection, IP Filtering & NAT with Packet Rules and VPN.

Learning Objectives:
1. This session will allow the participant to understand the Transport Security topic terminology and implementation better_x000D_ _x000D_ 2. How to manage the Transport Security environment on the IBM i OS_x000D_ _x000D_ 3. Knowledge of other IBM i OS Network Security topics.

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 Thom Haze

Thom Haze

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (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, Integrated... Read More →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 4 Online
  Networking

1:30pm CDT

⭐ PHP 8.1 Sneak Preview
PHP keeps getting better. PHP 8.1, arriving later this year, includes features that help developers cut down on bugs and enjoy writing high quality code. Alan will share his favorite new features in PHP 8.1 as well as improvements from PHP 8.0. Security enhancements will be covered as well.

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 8 Online

1:30pm CDT

RPG User Defined Functions & Table Functions
RPG is the best language in the world for writing business rules. But what happens when you want to use those business rules from SQL? Or from a web application that accesses your business logic through SQL? DB2 for i lets you write User Defined Functions (UDFs) in high level languages like RPG. UDFs can be called from SQL statements run from anywhere, including ad-hoc queries, SQL run from web applications, and SQL run from the embedded SQL precompilers used by RPG and other languages._x000D_ _x000D_ UDFs can even return a table (often called a UDTF, User Defined Table Function) which lets them do the same sort of work that a stored procedure would do -- but unlike stored procedures, they can return result sets to any language, including PHP, Java, .NET and embedded SQL written in ILE RPG._x000D_ _x000D_ UDFs are a powerful tool for any programmer's toolbox.

Learning Objectives:
1. Why User Defined Functions Are Useful_x000D_ 2. How to A User Defined Function in RPG_x000D_ 3. How to code a User Defined Table Function in RPG

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help... Read More →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 2 Online
  RPG

1:30pm CDT

Implementing Object Level Security Using Authority Collection
Many organizations have files or directories containing data that needs to be secured but are afraid to lock them down for fear of breaking something. Or perhaps you want to remove *ALLOBJ but aren't sure what authority to grant the user. Authority Collection to the rescue! During this session Carol will demonstrate how to use the Authority Collection to successfully remove *ALLOBJ and to determine what authorities profiles need to objects (objects in both libraries as well as directories) so they can be secured without fear of causing issues.

Learning Objectives:
1. Learn how to configure Authority Collection and read the output to determine what objects a profile is using and what authority they require to both library and IFS objects_x000D_ 2. Learn how to configure Authority Collection on an IFS object as well as a database file to determine which profiles are using them and what authority is required so they can be secured_x000D_ 3.Learn methods for successfully rolling out more restrictive security settings_x000D_ 4.Review the IBM i authority checking algorithm

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 →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 7 Online
  Security

1:30pm CDT

PASE at a Good Pace
What the heck is PASE anyway? Is it QP2TERM? Is it QSH? BASH? It's none of the above! These technologies live in the Portable Application Solutions Environment for i, or PASE for i. PASE allows one to port IBM AIX applications to the IBM i. Basically, PASE allows for a UNIX like environment on the IBM i, and this session will cover everything you need to know about this powerful tool at a pace everyone can understand.

Learning Objectives:
1. Learn what PASE really is._x000D_ 2. Find out the power PASE unlocks._x000D_ 3. Awesome PASE. Curated list of awesome applications.

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 11 Online

1:30pm CDT

How JSON and Javascript Changed my Life!
If you are developing any type of web application you'll run into JavaScript and JSON, the building blocks interactive web design. In this session we'll take a look at the client side: JavaScript and consuming JSON. We will also take a look at the server side: Generating JSON in RPG, SQL, PHP or Java on IBM i. We'll overview the technology, the available resources and the technique that will make you successful in implementing these mainstays of web development.

Learning Objectives:
1. Learn how to make the most of JavaScript and JSON in your web applications_x000D_ 2. How to create JSON strings using multiple tools on IBM i

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently Java Team Lead at Bible Study Fellowship International. Pete is an RPG/C++/VB/Java programmer with over 24 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Secure Software Programmer-Java, and as a MCSE. His passion has always been in... Read More →


Tuesday October 5, 2021 1:30pm - 2:30pm CDT
Breakout 12 Online

2:45pm CDT

Holistic DevOps: How to set up your DevOps environment so it’s built for success
Your IBM i application is no longer exclusively isolated to IT. It interacts with many distributed systems applications, exchanging data and calling APIs. So development on IBM i shouldn’t be isolated either._x000D_ _x000D_ Join this session to learn how to build a DevOps environment that can harmonize development and release processes across platforms using integrations with open-source tools already in your company like Git, Jira, and Jenkins. Learn how to expedite development cycles, integrate teams, and how to retain top talent across your organization._x000D_

Learning Objectives:
• How DevOps can harmonize development and release processes across platforms using integrations with open-source tools already in your company like Git, Jira, and Jenkins. _x000D_ • How to expedite development cycles, integrate teams, and enforce process controls with Rocket Aldon_x000D_ • How to plan for future trends so you’re set up for success _x000D_ _x000D_

Speakers
avatar for Andrew Finley

Andrew Finley

Solutions Engineer, Rocket Software


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 5 Online

2:45pm CDT

Tips for IBM i Pros Who Need to Support Excel Users
Many IBM i programmers and operators don’t use Microsoft Excel, but must support business users who want custom data sets to study and share in Excel. Your value to your company and the respect you get from the business people you support will rise if you take the time to understand more about Excel, what your user community needs, and how best to deliver the data they require. This is not a session on configuring middleware. This is a quick run through Excel from the perspective of the people who use it and will help you understand how Excel imports files.

Learning Objectives:
Learn what file formats and delivery methods will help the users you support and save you time. _x000D_ _x000D_ You will see step-by-step how to use Excel's file import features with various types of file formats and how to automate refreshes of the visualization objects used to analyze that data.

Speakers
avatar for William Langston

William Langston

Director of Marketing, New Generation Software
During my long career I have served in marketing, sales, training, and technical support roles and worked closely with IBM i application developers. I focus on query, reporting, and analytics software, database topics, and IBM i software.  


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 1 Online

2:45pm CDT

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 →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 2 Online
  IFS

2:45pm CDT

Enhancing, Improving, and Growing your IBM i Team
As IT departments change it is important to keep teams vital and relevant in order to support business properly. This session will discuss options in the industry to retain staff, hire effectively, and ensure your organization is ready for any challenge. Options discussed will include cross training, entry level hiring, managed services, and continuing education.

Learning Objectives:
1 - Determine how to hire the right personal for your organization_x000D_ 2 - Strategies for helping experienced employees improve their skills_x000D_ 3 - Discussion of resources and techniques to supplement your department's efforts

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 6 Online

2:45pm CDT

⭐ HCL Domino 12 and Beyond: Secure Email and Apps at your Fingertips
HCL Domino is one of the most secure platforms in the world and is currently leveraged by thousands of organizations and government agencies around the world whether is for email, applications, or both. And now, with HCL Domino 12, we are introducing new capabilities that will blow you away and will make you wonder why you are not using it or taking advantage of it, especially if your organization is concerned by the thousands of hacks and security incidents happening in the IT world with other vendors. Join this session and learn the latest, the greatest, the roadmap and everything HCL Domino can do for you.

Learning Objectives:

Speakers
avatar for Barry Rosen

Barry Rosen

Senior Regional Director for Products and Platforms, HCL
Barry Rosen is a Senior Regional Director for Products and Platforms at HCL Technologies.He is responsible for the full offering requirements for IBM Notes, IBM Domino, Sametime and IBM Verse. Barry has owned many key product responsibilities across IBM's Messaging and Collaboration... Read More →
avatar for Luis Guirigay

Luis Guirigay

Senior Global Director, HCL Software
Luis is a Senior Global Director and Head of the Digital Solutions Technical Advisors at HCL Software. He has over 20 years of experience across all products in the HCL Digital Solutions Portfolio as well as other technologies such as Cloud, HADR, NoSQL and AppDev. Luis is a well-known... Read More →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 10 Online

2:45pm CDT

Open Source Package Management for Dummies
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 →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 4 Online

2:45pm CDT

Shell Programming
If you are going to work in the Linux operating system, or PASE for that matter, then understanding how to program in the shell is an important skill that you must possess. This session will introduce you to the basic shells that are available and go through a number of programming constructions including looping, functions, and I/O processing.

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 11 Online

2:45pm CDT

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 more.

Learning Objectives:
Understand how to use CL commands and IBM Services to get information out of the audit journal and analyze it_x000D_ Show examples of using the audit journal to:_x000D_ - debug an authority failure_x000D_ - determine how a profile is used _x000D_ - determine whether the system was used during a breach_x000D_ 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 →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 7 Online
  Security

2:45pm CDT

Best Practices for IBM i Performance Management
Knowing about the tools and techniques for performance management is necessary, but understanding the overall performance management life-cycle and applying best practices to each aspect of performance is essential to maintain a well-performance solution. End-to-end performance management includes work to size and plan for system hardware and software changes, monitoring the ongoing performance of the solution, doing detailed performance analysis when necessary, and trending your performance characteristics over time. This session focuses on this performance management life-cycle and reviews the best practices to keep your hardware and software performing at their very best.

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 →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 9 Online

2:45pm CDT

What to know when moving to the Cloud
In this session, we'll discuss what you need to think about when moving to the cloud. It’s not as easy as just moving your workload from one machine to another. Pete will cover: Costs associated with moving to the cloud, what you should be moving, understanding planning, migration, testing and more.

Learning Objectives:
Is the cloud right for you? What to expect from a cloud provider? Migration issues.

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 →


Tuesday October 5, 2021 2:45pm - 3:45pm CDT
Breakout 12 Online

2:45pm CDT

IBM i Architecture - Overview & Evolution
The IBM i operating system is not Unix; it’s not Windows; and it’s certainly not Linux. This session describes the architecture of the operating system which had its origins in the System/38’s Control Program Facility, but which has evolved as it has been the basis of the AS/400 and its descendents. If you’ve started using the platform in the past decade or so, this session will teach you why things are “different” on IBM i. If you’ve been on the platform since “the beginning” it will provide a refresher, as well as teaching you about the key differentiators of today’s IBM i. This presentation will include architectural changes required by the most recent functional enhancements of IBM i. And, very importantly, it will explain why IBM i today is far more capable than AS/400 was in the past.

Learning Objectives:
Understand the basic architecture of IBM i, the elements which have remained since the days of System/38 and AS/400, the key elements added since then, and why today's IBM i is so much more than "just" AS/400.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.


Tuesday October 5, 2021 2:45pm - 5:00pm CDT
Breakout 8 Online

2:45pm CDT

IBM i Security For Programmers
Although IBM i is one of the most secure-able platforms available, the protection of critical data is often undermined by weak security design at the application level. This session covers the main considerations that a programmer should be aware of as they design and code their applications. _x000D_

Learning Objectives:
Attend this session to learn about:• Object ownership • Adopted authority • Public and private authorities  • Command line permission  • Client-server considerations

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 →


Tuesday October 5, 2021 2:45pm - 5:00pm CDT
Breakout 3 Online
  Security

4:00pm CDT

Automate Logistics the Modern Way with API Connections
Do you want to connect your native IBM i WMS applications to your logistics providers like UPS, FedEx, PINC and CH Robinson using public APIs?_x000D_ _x000D_ The world of paper documents, fax machines, phone calls and even old style EDI is rapidly being replaced by online, real-time communications using APIs (Application Programming Interfaces). _x000D_ _x000D_ APIs make it possible to instantaneously obtain rates, track shipments and generate shipping documents across the entire supply chain. They allow you to easily add new sales channels via online sites like Amazon, Shopify and EBay. You can use them to electronically process orders and invoices without requiring manual effort. Automation allows everything to move faster and more efficiently from suppliers to customers. _x000D_ _x000D_ In this session, we will use real world examples of connecting native IBM i applications to logistics providers using public APIs. We will show you how these IBM i users are improving customer satisfaction, optimizing resources and generating additional revenue by automating logistics through APIs._x000D_ _x000D_

Learning Objectives:
1. Learn about the wide variety of APIs that are available for automating logistics - from shipping scheduling, to package tracking, to address verification to container location and inventory and many others._x000D_ 2. Learn about how to take advantage of pub/sub technology to automate application to application communication_x000D_ 3. Learn the pros and cons of different approaches to connecting application (eg. edi vs APIs)

Speakers
avatar for Daniel Magid

Daniel Magid

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


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 10 Online

4:00pm CDT

Developing your Web & Mobile Strategy
As digital technologies evolve, web and mobile development has become an essential part of IBM i modernization. Not only do web applications have a modern look and feel that’s intuitive for users, they can also drive new revenue, streamline workflows and improve access to information. _x000D_ _x000D_ Many organizations are facing an urgent need to provide web and mobile access to their IBM i applications and data. Perhaps you have employees working from home who can’t access your IBM i applications remotely. Maybe your retail stores have had to close and an eCommerce solution will enable your business to continue operating. Your decision to digitally innovate could also improve operational efficiency and mitigate disrupters in your industry. _x000D_ Business Case & Approaches_x000D_ • Building the business case for UI/UX modernization and development_x000D_ • Use heatmaps to understand how end-users interact with your applications and the best places to start_x000D_ • Choosing the right approach (Leverage your 5250 applications or develop new)_x000D_ • Boost efficiency with global rules and settings for out of the box and quick time to production_x000D_ • Real-world examples that might give you ideas for your project_x000D_ APIs, Web Services & Integration_x000D_ • Improving workflow and business processes_x000D_ • Integrate with other applications, APIs / web services, and web portals_x000D_ • Developing new and innovating for new revenue streams_x000D_ • Strategies for getting it all done

Learning Objectives:

Speakers
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for over 20 years, the last 13 with Fresche Solutions where he is currently a Modernization Specialist. In addition to business development activities, Greg also coordinates pre-sales technical demonstrations and discussions, performs business... Read More →


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 6 Online

4:00pm CDT

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


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 5 Online

4:00pm CDT

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 →


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 4 Online
  Database
  • Session Level All

4:00pm CDT

Integrating eCommerce with your IBM i Based ERP
Data is often misconceived as being “locked” within legacy AS400 and IBM I systems.  But companies in any sort of retail market (B2B or B2C) should take advantage of eCommerce opportunities to help better their customer experience and streamline their own processes. Connecting your legacy RPG with eCommerce platforms doesn’t have to be complicated. No matter what ERP you’re running on your IBM I, a successful integration has the power to increase transactions, unique purchases, conversions, and revenue. By understanding how and why eCommerce integrations are important and then identifying the methodology for your company, you can take your business to the next level.

Learning Objectives:
  1. Learn how to successfully expose data from the IBM i while maintaining the integrity of your ERP data (including JDE World and E1)
  2. Tips for how to get started and best practices for creating your integration roadmap
  3. Discover the available tools (including middlware platforms) and determine the ones that are right for you

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 →


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 7 Online
  Middleware (other)
  • Session Level All

4:00pm CDT

Code Monkey's Guide to Consuming XML documents with RPG
In this session we will build a solid foundation for reading XML files in your RPG programs. We will start with a simple example with the XML-Into operation code and build on that into the XML-Into operator with the %Handler option. Then we will round the corner with the XML-SAX operator. Finally, we will talk about a few utilities QSHELL offers to round out our foundation of XML consuming test programs.

Learning Objectives:
1. Get started with the XML-Into RPG op code in it's simplest form; then with the %Handler option._x000D_ 2. Discover the XML-SAX RPG op code._x000D_ 3. Learn a couple of utilities QSHELL can offer to round out your XML importing._x000D_

Speakers
avatar for Gregory Simmons

Gregory Simmons

Software Engineer, Jack Henry & Associates
Gregory Simmons is a Software Engineer at Jack Henry and Associates, where he contributes to new and existing banking and financial software products for midsize local and regional banks. He is a COMMON certified Application Developer – ILE RPG on IBM I on Power. He is also a registered... Read More →


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 11 Online
  RPG
  • Session Level All

4:00pm CDT

Understand your System 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_x000D_ 2. Understand what wait metrics mean_x000D_ 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 →


Tuesday October 5, 2021 4:00pm - 5:00pm CDT
Breakout 9 Online

5:00pm CDT

Networking Event: Meet the Solutions Providers
Connect with peers, industry experts, and solution providers who have common interests and goals. Circle the event networking platform to exchange ideas and learn from your fellow participants. This is a wonderful opportunity to meet new people, catch up with old friends, and build the platform one conversation at a time.

Tuesday October 5, 2021 5:00pm - 6:00pm CDT
Breakout 1 Online
 
Wednesday, October 6
 

7:30am CDT

Morning Yoga, Sponsored by Midrange Dynamics
Join us first thing for gentle morning stretching at your desk. Simple for those who have never tried yoga with modifications for those who have, this is a wonderful way to start your day.

Speakers
avatar for Jennifer Hollister

Jennifer Hollister

Yoga Teacher, Jennifer Hollister Yoga
An E-RYT Yoga Teacher, Trauma Based Yoga Therapist and Trauma Psychotherapist, Jennifer has an extensive background in mental and physical health for over 20 years.Jennifer teaches a variety of yoga styles in addition to Yoga Therapy, stress relief and meditation classes. She offers... Read More →


Wednesday October 6, 2021 7:30am - 7:55am CDT
Breakout 1 Online

8:00am CDT

Advanced Embedded SQL
While native I/O can only be used with programming languages such as RPG and COBOL, (embedded) SQL can, or even must, be used by other programming languages. The main goal of embedded SQL is accessing and modifying data in SQL tables. However instead of using embedded SQL in the same way as native I/O, it makes more sense to join multiple tables or views, merge different sub-selects and even aggregate data in a single SQL-statement (Set based thinking). The result can be either processed sequentially or with a single block fetch read into an array data structure. SQL scalar functions can be used directly in embedded SQL without accessing any table or view. Beginning with Release 7.1 result sets returned by stored procedures can be directly consumed with (embedded) SQL. All kinds of documents (for example XML documents and text files) as well as audio and video files can be stored in the IFS or inserted as large objects into SQL tables. With embedded SQL those files cannot only be copied, but also written into the IFS and directly read from the IFS. In this session you’ll discover these secrets!

Learning Objectives:
In this session you’ll learn some tricks are not widely known to make embedded SQL more convenient. This session will also show in examples how to consume result sets with embedded SQL and how to read and write IFS files with embedded SQL.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 7 Online

8:00am CDT

APIs and Integration – Developing A Strategy That Works for You!
APIs are no longer a nice to have, they are essential to the modern organization. However, implementing APIs in your company is not easy – it means understanding how to go about modernizing old applications and determining which API strategy is best.

There are a variety of ways to implement APIs, enabling the business to leverage the value of legacy IP whilst taking advantage of modern development techniques, integrating with third-party applications and enhancing customer and user experience.

In this session, we will cover:
• What are APIs
• RESTful APIs and IBM i
• Case Studies: Real-world success stories and business outcomes 

Speakers
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for over 20 years, the last 13 with Fresche Solutions where he is currently a Modernization Specialist. In addition to business development activities, Greg also coordinates pre-sales technical demonstrations and discussions, performs business... Read More →
avatar for Pascal Polverini

Pascal Polverini

Solutions Strategist, Fresche Solutions
Pascal Polverini has a strong experience in digital transformation, end-to-end software architectures, with expertise on DB, programming languages, communication protocols and UI.Co-author of the IBM i Modernization Redbooks, he is an expert in cross technologies.Active member of... Read More →


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 6 Online

8:00am CDT

Webshop breakdown into reusable Microservices
The IT-market is very competitive and evaluates fast. There are many different programming languages with their own advantages and disadvantages. The right tools, combined with reusable solutions is the only way to stay competitive. _x000D_ _x000D_ A Microservice architecture serves both these requirements, it gives you the ability to create small components with the technologies which are the best ones for the job. And if they are implemented right, these microservices are 100% reusable for your future projects. _x000D_ _x000D_ I will demonstrate this by breaking down a fictional webshop into logic-components.

Learning Objectives:
1. Connection to DB2 with different technologies (advantages, disadvantages)_x000D_ 2. Deployment of open source technologies on the IBM i_x000D_ 3. Tips on how you should split your projects into reusable microservices

Speakers
avatar for Mario Aquino

Mario Aquino

Software Engineer, Easi


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 1 Online

8:00am CDT

Creating a Master File Data Layer with SQL PL
This session will examine working examples of IBM SQL PL, for maintaining and inquiring upon a "master" file. The SQL PL statements will be segregated into a set of stored procedures, probably best described as a simple data layer. IBM SQL PL is standardized across all of the versions of Db2. The (complete SQL PL) examples 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 across the enterprise (interactive, batch and/or remote web server)). We'll hit inquiry, delete, add and update. The update stored procedures include working examples of those that achieve the optimistic record locking technique even from a remote web server, so that accidental overlays are prevented in high volume, multi-user environments without allocating the record. The optimistic technique reviewed does require use of commit/rollback boundaries from within your high-level language program. We won’t have time to get into consuming the stored procedures however, so the specifics of high-level languages calling the stored procedures won’t be covered.

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_x000D_ 2. See differences in syntax and create steps for stored procedures using *LIBL and system naming (probably not applicable to all programming environments)

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 →


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 4 Online
  Database

8:00am CDT

Leverage IBM i Objects from Open Source Languages: Exploiting Db2 Data from Open Source
Leverage IBM i Objects from Open Source Languages Business Case:Integration is everything – you’ve invested in data and business logic on your IBM i – leverage those via open source languages including Python, Node.js, and PHP. Don’t rewrite; integrate and innovate!_x000D_ Part I: Integrating ILE (RPG, CL, Data Areas, Data Queues, etc) via XMLServer and Related Toolkits_x000D_ Part II: Exploiting Db2 Data from Open Source

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 11 Online

8:00am CDT

PHP: Where we are and where we're going
PHP has turned the corner from being a “new kid on the block” to becoming a “legacy” solution. How do we battle implementing new solutions without disturbing the existing application set? In this presentation come find out how the latest PHP is simply not your father’s PHP and also where PHP is headed. Concepts like deprecation cycles, Implementing change and PHP Version 7 and 8 will be discussed.

Learning Objectives:
Understand the evolution of PHP on the IBM i platform _x000D_ Understand key features of PHP7_x000D_ How to install and manage Zend Server 9

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect
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 →


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 2 Online

8:00am CDT

Combatting Malware: Using Multi-Factor Authentication and Exit Point Security to block access to the IFS
It seems we hear about a new malware security breach every day. Often, these breaches can be traced to compromised passwords. This compels IBM i shops to implement stronger password management controls. In order to protect your company from malware and ransomware attacks, you should deploy a combination of multi-factor authentication and exit point security.

Learning Objectives:
Learn how malware can get onto the IBM i system_x000D_ What true multi-factor authentication really is_x000D_ Authentication options and tradeoffs_x000D_ Tips on implementing exit point security to thwart malware attacks

Speakers
avatar for Dawn Winston

Dawn Winston

Product Management Director – Security Solutions, Precisely


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 8 Online
  Security
  • Session Level All

8:00am CDT

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. Whether running JD Edwards ERPs on IBM i platforms, or using homegrown applications, security is imperative.

Learning Objectives:
A walk-thru of the top JDE and IBM i security flaws we come across _x000D_ Learn best practices for threat remediation on JDE and IBM i _x000D_ Identify strategies for how to build your cybersecurity barrier through a proactive approach using IBM i and JDE 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 →


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 9 Online
  Security
  • Session Level All

8:00am CDT

IBM i Proactive Performance Preparation
No one plans to have a performance problem. When it next happens to you, will you have the information necessary to identify the root cause of the problem? This session will show you how to be prepared in the event of an unplanned performance problem. It will also discuss ways to avoid that problem from happening in the first place, and how to be notified as soon as possible that a problem may be starting.

Learning Objectives:
1. learn how to configure IBM i performance tools to have the data you need when a problem happens_x000D_ 2. learn how to get notified of potential problems

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 →


Wednesday October 6, 2021 8:00am - 9:00am CDT
Breakout 5 Online
  Systems Management
  • Session Level All

8:00am CDT

Learn your IBM i to learn
Learning! This is the machine challenge. From birth, our brains have a talent that the best artificial intelligence software is not yet able to imitate, but they have many other advantages! Learn how machines can analyze your data and give you valuable information. Learn how to use visual recognition, analytics and other cool stuff in your own applications on IBM i.

Learning Objectives:
1 learn the difference in machine learning, deep learning and how AI works 2 learn the use of AI in business applications

Speakers
avatar for Koen Decorte

Koen Decorte

CEO, CD Invest


Wednesday October 6, 2021 8:00am - 10:15am CDT
Breakout 3 Online

9:15am CDT

Modernize your IBM i Applications With up to a Dozen Different Approaches
IBM i application modernization has been a highly used term over the past decade, typically associated with leveraging the UI of your 5250 applications. But for many organizations, modernization means something different.

  • Modernization includes a multitude of strategies, at different companies, including but not limited to:
  • User Interface enhancements
  • Architectural Changes to be more Modular and Object-Oriented
  • Data integration/exchange via EDI (XML, SOAP Web Services, or REST APIs)
  • New Graphical Applications – PC Web, Mobile Web, Rich Client
  • Multiple Data Sources, with a Distributed Database.
  • Multilingual Solutions
  • Multiplatform Solutions
  • Including Low-Code Development on the IBM i

Andrew Vaiciunas and Grant Cooper will give you an overview of many of these strategies, providing some examples where IBM i shops have been adopting these approaches over the past 10 years.

Speakers
avatar for Andrew Vaiciunas

Andrew Vaiciunas

Senior Sales Engineer, LANSA Inc.
Andrew has over 35 years of business systems design and development experience on various operating system platforms, including 25+ years on IBM S/38 and AS/400-iSeries platforms, 30+ years with LANSA products, along with team facilitation and software sales.  During this time he... Read More →
avatar for Grant Cooper

Grant Cooper

Director of Sales, LANSA Inc.
Grant has been actively involved with the IBMi marketplace over the past 25 years. During his time with LANSA, he has served in many roles, from Project Consultant, Trainer, Technical Specialist and Account Manager, working with a wide range of IBMi organizations, from around the... Read More →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 9 Online

9:15am CDT

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. This session will hit all of the main steps required for using this data provider (a part of ACS) in a vb.net web forms style project. We will use Visual Studio Community Edition 2019 as the IDE. 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._x000D_ _x000D_ 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. A second virtually identical example is mobile-friendly. The mobile-friendly version is accomplished via use of the responsive master page provided within the base web forms project template. _x000D_ _x000D_ Complete code of the vb.net version will be offered to POWERUp 2021 attendees on day of presentation or via email request. _x000D_ _x000D_ The examples do not require elevated authorities, respect native authorities and allows setup of a *LIBL. The SQL syntax is limited only by your version of Db2 for i._x000D_

Learning Objectives:
1. Be conversant with Microsoft developers at your company regarding this efficient way to access Db2 for i in real time (and without data staging prerequisites such as work files or extracts). _x000D_ 2. See an example of the standard file access technique used in OO programming, where there is no open data path, so files are opened and closed as a part of each data access or data update process._x000D_ 3. Gain an introduction to a working web page and get a taste of the challenges involved in web programming without having to spend a lot of time learning_x000D_ 4. For developers, be able to create and run your own dynamically formatted web page inquiry to prototype and run dynamic SQL statements on physical files, logical files and views with joins etc._x000D_

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 →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 4 Online
  Database

9:15am CDT

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


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 7 Online
  Database

9:15am CDT

What's New in DB2 for i
In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced DB2 for i capabilities added to IBM i 7.3 and IBM i 7.4 over the last Technology Refreshes. _x000D_ Resource: https://www.ibm.com/support/pages/node/1116645/

Learning Objectives:
1. Understand the new database capabilities added to IBM i 7.3 and 7.4._x000D_ 2. Learn how the enhancements can be utilized._x000D_ 3. Hear about the Db2 for i strategy.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 8 Online
  Database

9:15am CDT

🟢 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_x000D_ 2. Discover how RDi and ACS cooperate to enhance using SQL in our applications_x000D_ 3. Examine features in ACS that can have an impact on RPG development

Speakers
avatar for Vern Hamberg

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 for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 1 Online
  Database, N2i

9:15am CDT

Scalable Management of HA/DR Systems Using Dashboards
As more customers leverage Service Providers to manage their High Availability and Disaster Recovery Solutions, better tools are needed to manage all these solutions.  By sending replication status to commonly used dashboard platforms, service providers can deliver real-time monitoring, history and eventually machine learning.

Learning Objectives:
  • Learn to simplify the management of your HA system
  • Learn techniques that can make your systems and data more resilient

Speakers
avatar for Dan Simms

Dan Simms

Project Management Director, IBM i HA Solutions, Precisely
Hello, my name is Dan Simms.  I am the Director of Product Management for the IBM i HA portfolio at Precisely.  My portfolio includes Assure MIMIX, QuickEDD, iTera, OMS/ODS, Assure MIMIX for AIX, and iOptimize.  I have been with Precisely (Syncsort, Vision Solutions) for 25 years... Read More →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 10 Online

9:15am CDT

🟢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._x000D_

Learning Objectives:
- Understand the semantics of integrated file system security_x000D_ - Learn other methods of securing beyond permissions including virus scanning, and more_x000D_ - Learn ways to manage and improve integrated file system security_x000D_

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 →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 2 Online
  IFS

9:15am CDT

Innovation Stories from IBM i Customers
Do you ever feel like you’re the only business using IBM i? Nothing could be further from the truth! IBM i is the operating system underneath the applications which are used by thousands and thousands (and thousands!) of companies around the world to run their business. Yet as most IBM i clients go about their normal day, they have very little awareness of the many kinds of businesses which depend on Power Systems running IBM i. Steve Will, Chief Architect for IBM i, Alison Butterill, the IBM i Global Product Manager, and Brandon Pederson, IBM i Marketing manager, will take you on a virtual journey through many countries and many industries, giving specific examples of IBM i clients who are using advanced, integrated technology to innovate and succeed._x000D_

Learning Objectives:
1. Become aware of companies in many industries around the world doing great things with IBM i. 2. Learn the business value various IBM i technologies are bringing to business.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, 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 Brandon Pederson

Brandon Pederson

IBM i and Power Systems Scale-Out Product Marketing Manager, IBM


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 6 Online

9:15am CDT

Leverage IBM i Objects from Open Source Languages: Integrating ILE (RPG, CL, Data Areas, Data Queues, etc) via XMLServer and Related Toolkits
Leverage IBM i Objects from Open Source Languages_x000D_ _x000D_ Business Case: Integration is everything – you’ve invested in data and business logic on your IBM i – leverage those via open source languages including Python, Node.js, and PHP. Don’t rewrite; integrate and innovate!

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 11 Online

9:15am CDT

Monitoring Your IBM i
How can you monitor your IBM i partition? Let's count the ways - watches, events, monitors, services, and more! In this session we will cover the various ways to monitor your IBM i using features built into the operating system. Learn how to proactively get notified before a small problem becomes a large one.

Learning Objectives:
1. learn about watches, monitors, and services that can be used to monitor your IBM i partition_x000D_ 2. learn how to get notified of potential problems

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 →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 5 Online
  Systems Management
  • Session Level All

9:15am CDT

Moving from HMC Classic GUI to the new Enhanced GUI
The new Enhanced GUI is really nice, but if you haven't used it, it is very different from the classic GUI. Basically, you can't find anything, and things work and behave differently. Come to this session to learn where the functions you were used to using, where they are now.

Learning Objectives:
1) Learn where everything is in the new GUI._x000D_ 2) Explore the functions and become familiar with the tasks as they are now in the new interface._x000D_ 3) How to go about using the functions that you used to do in the classic GUI, and where they are now.

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 →


Wednesday October 6, 2021 9:15am - 10:15am CDT
Breakout 12 Online

10:30am CDT

Connecting your IBM i Applications to e-commerce Platforms like Amazon and Shopify
Would your company like to take advantage of all the ready-made ecommerce opportunities by connecting with platforms like Amazon and Shopify? Are you looking for more go to market channels? _x000D_ _x000D_ In this session we will demonstrate how you can take advantage of the free software development kits provided by these vendors and others by making it easy to connect your applications to these new channels. You will see how you can automatically list products, update pricing, reflect current inventory, take orders and schedule shipments – all using easily accessible APIs. We will cover what technology is involved and how you can ensure your connections are secure and reliable. We’ll show you step by step how to make the connection right from your native IBM i applications.

Learning Objectives:
1. Learn about calling public web services directly from IBM i RPG applications_x000D_ 2. Learn the advantages of using Software Development Kits provided by API providers like Amazon and Shopify to save significant amounts of coding time_x000D_ 3. Discover new channels to bring your companies products to market via new technology

Speakers
avatar for Daniel Magid

Daniel Magid

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


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 10 Online

10:30am CDT

End to end testing framework
"If you cannot test it, don't do it!" This affirmation summaries the all importance of testing. We all know it is important but for decades it was hard and cumbersome to test IBM i application from end to end, including the UI. This is now not anymore the case. 
In this session you will see why and with what tool you will be able to accomplish and automate end-to-end testing, some live demo are included. 

Learning objectives:
- Risk impact on not Testing. Learn to lower the risk for your project success. 
- Budget impact on not Automating testing. Learn to automate. 
- Testing not only to validate changes, but also to accelerate all your development cycle.

Speakers
avatar for Pascal Polverini

Pascal Polverini

Solutions Strategist, Fresche Solutions
Pascal Polverini has a strong experience in digital transformation, end-to-end software architectures, with expertise on DB, programming languages, communication protocols and UI.Co-author of the IBM i Modernization Redbooks, he is an expert in cross technologies.Active member of... Read More →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 5 Online

10:30am CDT

🟢Get Started with GIT and Version Control: Building IBM i Source from Git
Get Started with GIT and Version Control_x000D_ Business Case:Increase software development agility and standardize on a version control that is platform agnosticBuilding IBM i source from Git: Strategies for setting up a build process and the Open Source tools available to manage native i compiles and dependencies. Learn from our experience of setting up Builds for our customers.

Learning Objectives:
1. What are requirements for a Build Process for IBM i source_x000D_ 2. What does the workflow look like, Build triggers_x000D_ 3. What are the tools available for setting up the Build_x000D_ 4. How do we set up this automatic Build process

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 →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 11 Online

10:30am CDT

🟢 ⭐ 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.

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

Speakers
avatar for Vern Hamberg

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 for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 1 Online
  Database

10:30am CDT

Hardware required for IBM Db2 Mirror for i
Find out more about what hardware is needed for Db2 Mirror and why. Be introduced to a variety of different topologies of Power servers, network adapters, and storage systems where Db2 Mirror can be implemented.

Learning Objectives:

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 →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 4 Online

10:30am CDT

Virtual Tape Library (VTL) Backup Options in IBM Power Virtual Server
On 9/23 we are announcing new DSI VTL support in PowerVS for IBM I customers. This session will review this new option for backing up your system.

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 →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 12 Online

10:30am CDT

Productivity, Time Management, and Organization for the IT Professional
In the commonly resource bound departments we find ourselves in working smarter not harder has never been more important. Drawing on tools and techniques learned from quality and assurance and project management we will explore ways to increase efficiently. Importantly, communicating our efforts and documenting has become more visible in team dynamics. Suggestions for handling projects, time, and resource management will all be covered.

Learning Objectives:
Organize projects and clearly identify exit criteria to complete cleanly._x000D_ _x000D_ How to organize and notate for your own use based on your own style._x000D_ _x000D_ Taking your efforts and communicating them properly to the rest of the team via documentation and self avocation._x000D_ _x000D_ Time management techniques and forecasting skills

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 6 Online

10:30am CDT

⭐ Reducing Application Complexity with HCL Volt MX
We are all facing complexity in our application development process. These complexity's result in longer hours, stressful situations, missed milestones, and eventually employee turnover. Volt MX can help reduce this complexity while increasing developer productivity and delivering world class applications. Let us show you how we can help.

Learning Objectives:

Speakers
avatar for Luis Guirigay

Luis Guirigay

Senior Global Director, HCL Software
Luis is a Senior Global Director and Head of the Digital Solutions Technical Advisors at HCL Software. He has over 20 years of experience across all products in the HCL Digital Solutions Portfolio as well as other technologies such as Cloud, HADR, NoSQL and AppDev. Luis is a well-known... Read More →
avatar for Darrell McDonald

Darrell McDonald

Volt MX Product Specialist, HCL Software
I'm passionate about Volt MX and have over 10 years experience working with it.   Volt MX can help reduce application development complexity while increasing developer productivity and delivering world class applications.   Let us show you how we can help you develop native (IOS/Android... Read More →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 3 Online

10:30am CDT

Open API on IBMi
Unlock your IBM I data easily, quickly, and safely by building fully functional REST APIs that automatically generate RPG-Free routines to allow you to re-use your existing IBMi resources. We will show you how to make a REST API with Remain OpenAPI Studio based on both an existing database definition and a current RPG routine, and generate ready-to-run API's. The resulting API's are fully compatible with the OAS3 standard to allow easy and controlled access to your back-end data and routines, to allow you to expose your current assets to colleagues as you start your modernization journey.

Learning Objectives:
1. How to build OAS3 compliant API's._x000D_ 2. How to utilize existing, working resources and make them available outside the IBMi._x000D_ 3. See how easily you can start the journey towards modernization without leaving the platform.

Speakers
avatar for Karl Haggart

Karl Haggart

Managing Director, Remain Software


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 9 Online

10:30am CDT

How to Get to Unicode from RPG: Using CCSIDS in RPG
This session describes how to work with Unicode data in RPG.

Learning Objectives:
1. Learn how to define Unicode variables in RPG _x000D_ _x000D_ 2. Learn how to avoid some of the pitfalls when working with Unicode data, especially when converting between Unicode and EBCDIC

Speakers
avatar for Barbara Morris

Barbara Morris

IBM
Barbara Morris is the lead developer for the RPG compilers in the IBM Toronto Lab. She has been working on the RPG compilers since she started at IBM in 1989 after receiving a Computing Science degree from the University of Alberta. The first enhancement she developed was the ENDIF/ENDDO... Read More →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 8 Online
  RPG
  • Session Level All

10:30am CDT

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

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

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help... Read More →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 2 Online
  RPG

10:30am CDT

Modernizing the Way you Manage IBM i Security
Still running Display User Profile (DSPUSRPRF) to an outfile to analyze user profiles or Display Object Authority (DSPOBJAUT) to view ownership and authorities? Much more efficient methods exist! During this session, Carol will provide examples of how you can use the most recent IBM i Services to update user profile management, as well as reporting on object authorities and ownership, system values, audit journal entries and more.

Learning Objectives:
1. Understand how IBM i Services provide more options for generating security reports than IBM-supplied commands._x000D_ 2.See examples of using IBM i Services to get security information _x000D_ 3. See an example of using IBM i Services in a CL program

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 →


Wednesday October 6, 2021 10:30am - 11:30am CDT
Breakout 7 Online
  Security
  • Session Level All

11:45am CDT

Terminate your 5250 terminal. MiWorkplace is in town.
Join us as we show you how to develop modern ILE code quickly and easily using MiWorkplace templates to create an ILE service program in less than twenty minutes.

Learning Objectives:
1. An low footprint alternative IDE from 5250 sessions._x000D_ 2. Another way to modernize.

Speakers
avatar for Karl Haggart

Karl Haggart

Managing Director, Remain Software


Wednesday October 6, 2021 11:45am - 12:05pm CDT
Breakout 6 Online

11:45am CDT

⭐ Best Practices for Debugging and Servicing SQL
In this session, Scott will share some of his techniques for producing and maintaining functional SQL.
Every programmer has their techniques building, debugging, and maintaining code.
Come to this session to see some of Scott’s tried and true techniques.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 →


Wednesday October 6, 2021 11:45am - 12:05pm CDT
Breakout 10 Online

11:45am CDT

Journal Performance Considerations that Everyone Should Know
Journaling isn't slow, disk drives are slow. Hardware and software improvements have dramatically improved journal performance compared to what it was several years ago. In some environments the overhead of journaling can be undetectable. We will discuss I/O subsystem considerations, the use of journal caching, commitment control and SMAPP and how each of them can impact performance.

Learning Objectives:
1. Understand how different journal options affect system performance and recovery_x000D_ 2. Understand the benefits of journal caching

Speakers
avatar for Bruce Hansel

Bruce Hansel

Software Engineer, IBM
Bruce is an IBM i developer and has been a member of the Journal development team for over 25 years. In additional to design and development responsibilities he works extensively with the IBM i Support organization. He has significant experience investigating Journal, DB and High... Read More →


Wednesday October 6, 2021 11:45am - 12:05pm CDT
Breakout 4 Online

11:45am CDT

Using IBM Db2 Mirror for i Application Evaluation to gain insight
Ever wonder if Db2 Mirror is right for you? Find out how the Application Evaluation feature can assist with preparing to use IBM Db2 Mirror for i. Be introduced to how it helps provide a different perspective into the types of IBM i objects being used and how those objects fit in a Db2 Mirror environment.

Learning Objectives:

Speakers
avatar for Mi Huynh

Mi Huynh

IBM i High Availability Development, IBM
Mi started at IBM in 2017 and she is a key developer working on the IBM i Development team in Rochester. She is specifically focused on IBM i High Availability development with Db2 Mirror for i.  


Wednesday October 6, 2021 11:45am - 12:05pm CDT
Breakout 2 Online

11:45am CDT

Learn about the LUG
Join the LUG COO, Lynne Benedict, to learn more about the LUG and how your company might become a part of this organization that complements COMMON membership. The Board of Directors of both COMMON and LUG have been working together to support the efforts of both organizations and form a symbiotic relationship by dispelling the competitive myth that surrounds the two distinct groups.

Learning Objectives:
1. LUG and COMMON are complementary, not competitive, organizations._x000D_ 2. If you want to learn how to do something, go to COMMON. If you want to know why to do something, go to LUG. _x000D_ 3. Guidelines for joining the LUG._x000D_

Speakers
avatar for Lynne Benedict

Lynne Benedict

Director of Operations & COO, LUG
Lynne has been the only LUG employee for over 21 years and has served as the LUG COO since 2015. She is a trusted advisor to the LUG Board of Directors. Lynne holds degrees in Computer Science and Business Administration. She enjoys spending time with her family, cooking, reading... Read More →


Wednesday October 6, 2021 11:45am - 12:05pm CDT
Breakout 1 Online
  IT Strategy
  • Session Level All

11:45am CDT

🟢 ⭐ Intro to RPG
This session is an introduction to the RPG language, its history and evolution over time and why it's still a relevant language today.

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 is one of two IBM i admins... Read More →
avatar for Rochelle Petty

Rochelle Petty

Application Support & Developer, 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 →


Wednesday October 6, 2021 11:45am - 12:05pm CDT
Breakout 9 Online
  RPG, N2i

11:45am CDT

⭐ Developing React with Maintainability in Mind
You chose React as your developer team's UI library of choice, great! How do we architect and develop with best practices in mind to improve developer velocity and maintainability? Often bad design patterns can lead to spaghetti code. Good design patterns should really lead to nicely layered lasagna, where you have proper separation of concerns (lasagna noodles separated from the meat sauce from the ricotta. This talk goes over engineering decisions, organization of code, and everything else needed to ensure your lasagna doesn't turn into spaghetti!

Speakers
avatar for Noel Madali

Noel Madali

Web Architect, The Weather Company at IBM
Frontend and backend architecture, web technologies, eating, cooking, coffee, latte art!


Wednesday October 6, 2021 11:45am - 12:45pm CDT
Breakout 5 Online

11:45am CDT

IBM i ACS Advanced Usage, Administration and Security
BM i Access Client Solutions (IBM i ACS) 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 it is the premier software to access and manage your IBM i and the only workstation deployed solution that IBM supports. _x000D_ _x000D_ In this session we will cover some of the more advanced IBM i ACS Java client capabilities including how to use command syntax to script actions to be ran, including natively on the IBM i, Administration approaches to controlling what functions of IBM i ACS are available to an user, and secure TLS configuration amongst other items.

Learning Objectives:
1. Become familiar with some of the more advanced capabilities of IBM i ACS_x000D_ 2. Learn administration approaches to IBM i 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 →


Wednesday October 6, 2021 11:45am - 12:45pm CDT
Breakout 3 Online

11:45am CDT

⭐ IBM i Report Modernization: Enabling User-Driven Analytics
Reports are meant to share information, but the people who receive them often find they don’t tell the whole story.

Whether it’s sales, inventory, shipments, budgets, and payroll across dates, accounting periods, locations, service codes, or other elements, most users would be happier to receive the report data, not the report. Spreadsheets quickly get complicated, time consuming, and corrupted. Most users simply need a safe, modern interface where they can break report data down in various ways, format, filter, summarize, and chart on the fly.

At past COMMON conferences we’ve shared legacy report modernization methods using API’s, SQL Views, and the SPOOLED_FILE_DATA command. Now we encourage you to look at how the Qport™ SmartView module of NGS-IQ™ enables non-technical users to play with report data in a read-only environment that can reduce the number of queries you write and run, while improving how your company understands its data.

Speakers
avatar for William Langston

William Langston

Director of Marketing, New Generation Software
During my long career I have served in marketing, sales, training, and technical support roles and worked closely with IBM i application developers. I focus on query, reporting, and analytics software, database topics, and IBM i software.  


Wednesday October 6, 2021 11:45am - 12:45pm CDT
Breakout 7 Online
  Database

11:45am CDT

⭐ Need Online Meetings? OnPrem, Cloud or Hybrid. Your Meetings, Your Choice
In 2020 the world changed and every engagement, every meeting, every one-to-one conversation became an online meeting. Now, a year later most organizations are yet to send people back to the office and the need for secure, affordable and stable meeting platforms is still on the rise. Join this session and learn how HCL Sametime is the best solution for your meeting needs where no one will ever have access to your meetings or information, and it can be deployed wherever and however you want.

Learning Objectives:

Speakers
avatar for Luis Guirigay

Luis Guirigay

Senior Global Director, HCL Software
Luis is a Senior Global Director and Head of the Digital Solutions Technical Advisors at HCL Software. He has over 20 years of experience across all products in the HCL Digital Solutions Portfolio as well as other technologies such as Cloud, HADR, NoSQL and AppDev. Luis is a well-known... Read More →


Wednesday October 6, 2021 11:45am - 12:45pm CDT
Breakout 8 Online

12:15pm CDT

Testing Exported SubProcedures and Programs
This presentation reviews an approach to building reusable/automatic tests for programs and exported subprocedures_x000D_

Learning Objectives:

Speakers
avatar for Robert Arce

Robert Arce

Solutions Strategy - IBM i SME, Fresche Solutions
Robert Arce works in Corporate Strategy for Fresche Solutions. He is a subject matter expert in the IBM i system, assisting companies all over the world with their modernization projects.His expertise is using IBMi Application Analysis and Management Suite X-Analysis.Mr. Arce has... Read More →


Wednesday October 6, 2021 12:15pm - 12:35pm CDT
Breakout 2 Online

12:15pm CDT

What's New in Rational Developer for i
Highlights of the latest features available in Rational Developer for i.

Learning Objectives:
Learn what is available in the latest Rational Developer for i.

Speakers
avatar for Eric Simpson

Eric Simpson

IBM i Application Development Tools, IBM


Wednesday October 6, 2021 12:15pm - 12:35pm CDT
Breakout 4 Online

12:15pm CDT

Why you should instrument your SQL Workloads with Client Registers
Client Registers are an overlooked Db2 for i feature that can streamline SQL analysis on your systems. Learn how to easily instrument your SQL workloads with the client registers to add workload and business context to all your SQL statements. You'll also see how these register values can be displayed with the ACS SQL Performance Center tooling.

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 →


Wednesday October 6, 2021 12:15pm - 12:35pm CDT
Breakout 6 Online
  Database
  • Session Level All

12:15pm CDT

Data Protection for IBMi
Data protection – security, backup, and archival – for IBMi software and hardware remains a difficult task, especially as the requirements and locations – on-premises data centers, offsite tape repositories, and clouds – have multiplied. In this session, veteran technologists from FalconStor, a longtime IBM i - centric backup software specialist, will DEMO how to embrace backup to disk on-premises, achieve 6x the speed of tape and up to 20:1 deduplication and automate replication to a second site, a public cloud or tape for long-term preservation, encrypted at every step._x000D_ _x000D_

Learning Objectives:
Learn how to achieve 6x the speed of tape and up to 20:1 deduplication_x000D_ _x000D_

Speakers
avatar for Mark Delsman

Mark Delsman

VP Product, FalconStor Software
Backup, Archive, Cloud Storage, Data Protection


Wednesday October 6, 2021 12:15pm - 12:35pm CDT
Breakout 1 Online

12:15pm CDT

🟢 ⭐ Intro to RPG Procedures
This session is an introduction to RPG procedures and why you want to use them in your everyday code.

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 is one of two IBM i admins... Read More →
avatar for Rochelle Petty

Rochelle Petty

Application Support & Developer, 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 →


Wednesday October 6, 2021 12:15pm - 12:35pm CDT
Breakout 9 Online
  RPG, N2i

12:30pm CDT

Lunch Break in the Expo
Wednesday October 6, 2021 12:30pm - 1:30pm CDT
All-Attendee Expo Online

1:30pm CDT

ACS for the SQL Developer
IBM i Access Client Solutions (ACS) can do so many things well. In this session, Scott will explore a day in the life of an SQL programmer using ACS. Sharpen your SQL knives by attending this practical and example based session._x000D_ _x000D_ This session will include a focus on Run SQL Scripts, the Graphical Debugger, Printer Output, and more._x000D_

Learning Objectives:
1. Leave the Green behind._x000D_ 2. Embrace ACS._x000D_ 3. Rock on.

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i 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 →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 8 Online

1:30pm CDT

File System Containers for Open Source: Introduction to Chroot Containers on IBM i
Containers and Resource Control for Open Source_x000D_ _x000D_ Business Case:As open source technologies are becoming more and more prevalent, you may be interested in leveraging containers or other resource-controlling technologies to manage the applications deployed in your infrastructure. Come to this module to learn more about what's available on IBM i.Part I: Intro to Chroot Containers on IBM iPart II: Workload Capping Groups, Memory Pools, and SubsystemsPart III: LIVE Q&A and Panel Discussion

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

Customer Success Manager - Architect, IBM
With over 25 years working in the IBM i community with IBM (with a brief stint with the Zend by Perforce team) I have worked with a number of technologies on the POWER platform including cloud (PowerVC) Dev/Ops solutions (Docker, Chef), Open Source technologies (Linux, MySQL/MariaDB... Read More →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 11 Online

1:30pm CDT

SOLID PHP: Writing Clean Object-Oriented Code
Write better PHP! Partake in this introduction to five pillars of clean object-oriented code that help make your applications more maintainable, testable, and adaptive to change. The SOLID OOP Principles have weird names, but these small, clear, yet real-life examples of improvements to some of my clients' code (no naming, no shaming) - will help you understand what they are and why they're important._x000D_

Learning Objectives:
1. Learn what the components of SOLID (Single Responsibility, Open-Closed, Liskov Substitution, Interface Segregation, and Dependency Injection) mean and how they help you write more maintainable applications._x000D_ 2. Learn how to make existing application source code more "SOLID."

Speakers
avatar for Clark Everetts

Clark Everetts

Senior Professional Services Consultant, Zend by Perforce
Clark works for Zend by Perforce as a Senior Professional Services Consultant, helping clients innovate, meet business needs, and build better web applications through architecture and performance audits, mentoring in software development best practices, and guiding them using PHP... Read More →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 5 Online

1:30pm CDT

With FREE OPEN SOURCE I can give you the ability to build an IBM i Dashboard which turns boring data into valuable information for your business
A dashboard summarizes data into easy-to-understand visuals that provide insights about your business data. That’s true whether you’re operating your vehicle or monitoring your IBM i Server. Come to this session and I’ll show you how simple it is to create and customize a dashboard for whatever type of information you find important. Your colleagues and managers will say WOW (just don’t let them know how easy it was to build. Come learn something new, you really need a break coding from green screens. These coding tools will change your programming future starting today.

Learning Objectives:
1. Learn new free opensource coding using javascript tools._x000D_ 2. Teach how to use your rpg skills to create exciting content Dashboards for your company_x000D_ 3. Enhance your value with your company with new and valuable skills to pull data from all areas of your company with dashboards._x000D_ 4. Impress your programming friends with your new skills._x000D_

Speakers
avatar for Monty Chicola

Monty Chicola

President, Real Vision Software, Inc.
Software Developer since 1980. President of RVI, a Content Management Company. I developed imaging on the AS/400 before its general release back in the 1980's. It has been my pleasure developing software and hardware with IBM Rochester over the years. With thousands of customers world... Read More →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 9 Online

1:30pm CDT

⭐ Best RDi Tips to Improve Your Code, Career and Life!
RDi is so feature-rich that a session is needed to showcase its usefulness. Attend this session for the next crop of reasons why any developer who is serious about their career as a developer will use RDi.

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

CEO, Central Park Data Systems
Charles Guarino has been an Information Technology consultant for the vast majority of his career. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 7 Online

1:30pm CDT

Empowering IBM i Services with Db2 Web Query for i
IBM i services are SQL interfaces into systems information. They are GREAT, but they are plumbing, and you still need to build something around them to simplify the value of them. Perhaps you want to see the data in spreadsheets or chart representation, or email important utilization trend reports to stake holders. Web Query can provide the SOLUTION around the plumbing EASILY with new features like "EZ-Report." This session will show you how, including how to get Spooled File data into a spreadsheet or PDF with ease.

Learning Objectives:
1. Learn how Db2 Web Query can leverage SQL specific to IBM i Services_x000D_ 2. Learn how to handle different delivery options of IBM i Services (views, UDTFs, procedures)_x000D_ 3. Learn how to enable services for reports that consolidate data from multiple systems/LPARs.

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 →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 3 Online
  Database

1:30pm CDT

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._x000D_ _x000D_ 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._x000D_ _x000D_ Do you need to mask sensitive data, or protect data from unauthorized users? This session is for you._x000D_ _x000D_ 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_x000D_ 2. Add audit fields that are automatically updated_x000D_ 3. Use constraints to ensure data integrity_x000D_ 4. Use Row And Column Access Control (RCAC) to control access to your data_x000D_

Speakers

Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 10 Online
  Database

1:30pm CDT

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 →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 4 Online
  Database

1:30pm CDT

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._x000D_ _x000D_ 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_x000D_ 2. Learn how different technologies can help achieve various RPO and RTO targets._x000D_ 3. Learn how the technologies can be combined to form solutions with several examples of common solutions

Speakers
avatar for Brian Nordland

Brian Nordland

Principal Software Engineer, HelpSystems
Brian Nordland is the architect for the PowerHA SystemMirror for i product at HelpSystems. Brian has spoken at events, webinars, and users 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 →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 1 Online

1:30pm CDT

IBM i Anywhere, IBM i Everywhere – IBM i Strategy, Roadmap & Innovation
IBM i is used by businesses everywhere in the world, who want to conduct that business anywhere at any time. In this presentation, Steve Will, the IBM i 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_x000D_ 2. Understand the future direction of IBM i, and how that is helping clients today_x000D_ 3. Learn several client examples of innovative technology solving business problems using IBM i today.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, 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 →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 6 Online
  IT Strategy
  • Session Level All

1:30pm CDT

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._x000D_ _x000D_ Since JSON has become crucial to IBM i businesses, these are must-know features!

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

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help... Read More →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 2 Online
  RPG

1:30pm CDT

Be More Productive with Navigator: Latest Features in Navigator for i
Be More Productive with Navigator Business Case:So, you are not using Navigator for i... why? This is not the same old Navigator from even a few years ago. There are several new features that will be highlighted along with general usage. This, along with the dive into the performance analysis tools available, will make you a better IBM i Administrator. Part I: Latest Features in Navigator for i Part II: Performance Tasks in Navigator for i Part III: LIVE Q&A and Panel Discussion

Learning Objectives:

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 →


Wednesday October 6, 2021 1:30pm - 2:30pm CDT
Breakout 12 Online
  Systems Management
  • Session Level All

2:45pm CDT

Test Analysis and Design focusing on planning, cases, and conditions
This session is a deep dive into the creation of tests:_x000D_ Covering scope, approach, resources, schedule of activities, features, tasks. _x000D_ Determine entry and exit criteria and the rational for what is decided upon as well as establishing bi-directional functionality. _x000D_ Organize input values, execution preconditions, expected results, and post conditions into test cases._x000D_ Isolate what items or components of the system can be verified by a case._x000D_ Write cases that are repeatable, verifiable, and traceable back to the requirements, quality risk, etc._x000D_ Transform the above into executable tests that scale to all levels of testing infrastructure_x000D_

Learning Objectives:
1) Take foundational or informal knowledge of testing and improve it procedurally for optimal results._x000D_ 2) organize the components of proper testing into a viable plan

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 6 Online

2:45pm CDT

The New Low-code / No-code Movement
It used to be that we measured programmers’ productivity by counting lines of code. Yet, in a recent interview, Elon Musk declared that the best developers accomplish their goals with as little code as possible. Having less code certainly does increase flexibility and reduces technical debt! But how do you get things done by writing less code rather than more? In this session, we’ll explore the new Low-code / No-code movement and why the idea of writing less code might just make sense for your IT environment._x000D_

Learning Objectives:
You will learn:_x000D_ 1. Why it makes sense to embrace Low-code / No-code_x000D_ 2. How Low-code / No-code environments work_x000D_ 3. How we implemented Low-Code for our toolset at Profound Logic_x000D_ _x000D_ You will also see a a Demo of how Low-code can be used to extend RPG applications

Speakers
avatar for Alexander Roytman

Alexander Roytman

CEO, Profound Logic
Alex Roytman is the founder and CEO of Profound Logic. He is a Node.js and RPG educator who shares his knowledge at user groups and events around the world. His decades of experience and passion in the field of Web and Mobile development have led his company to create many popular... Read More →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 7 Online

2:45pm CDT

True End-To-End Open Source DevOps on IBM i
Open Source DevOps toolchains have traditionally not handled IBM i-specific technologies, which has stuck them in the "hobby project" category. However, today those free tools are entirely capable of managing IBM i resources, allowing your teams to finally use the same DevOps tools regardless of platform, across your entire company. _x000D_ _x000D_ In this session, we will introduce developers to common open source tools used in a DevOps environment. We will demonstrate real world application development automation for IBM i and non IBM i code through a single set of open source tools.

Learning Objectives:
Attendees will be able to:_x000D_ 1. Practically apply Git and other Open Source tools like VSCode, Make, Jenkins, Azure DevOps, and Ansible to their native IBM i objects_x000D_ 2. Effectively articulate the pros and cons of this approach to their teams_x000D_ 3. See real world examples of managing multiplatform development including native IBM i code with open source tools.

Speakers
avatar for Daniel Magid

Daniel Magid

CEO, 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 →
avatar for Aaron Magid

Aaron Magid

VP, Open Source Technologies, Open Source Technologies
Before I came to the IBM i, I led the JavaScript web application development for an IoT company. Now I'm working to bring the IBM i together with the world of open source technology. I'm always happy to chat about web technology, IoT, IBM i in the cloud, modern devops, or just about... Read More →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 10 Online

2:45pm CDT

What to Expect When Transforming Your IBM i RPG or CA 2E (Synon) Applications into Modern Languages
Most organizations are seeking better, faster ways to deliver powerful new digital experiences for their customers and employees. When you rely on legacy IBM i applications, this often requires piecing together capabilities from a mix of traditional and modern application architectures and technologies. Transforming your RPG and CA 2E (Synon) applications to modern languages is one way to enhance these core applications while embracing open source, cloud, web, and AI technologies.  _x000D_ Join our session to learn how you can modernize applications at lower cost and risk than rewriting or replacing while building on the investment in your customized systems. _x000D_ Topics:_x000D_ • Building Your Strategy: Sample roadmaps, defining what needs to be transformed, and choosing the best architecture and technology stack._x000D_ • Transformation: Fresche’s automated process, flexible delivery models, integration and potential workflow improvements._x000D_ • Testing: Defining your strategy, types of testing required and automation capabilities._x000D_ • Implementation / Deployment: Aligning the strategy with the organization, ease of adoption and defining the best options for you._x000D_ • Beyond: What happens next and how to enhance your applications going forward.

Learning Objectives:

Speakers
avatar for Nick Hampson

Nick Hampson

Director of Design, Fresche Solutions
Nick has extensive experience in design, UX, product management, innovation and pre-sales. Focused on bringing the business value of design and UX to IBM i customers and the community at large, Nick is recognized as a UX expert on IBM i. He also describes himself as a geek and a bookworm... Read More →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 5 Online

2:45pm CDT

Breaking Down the Monolith: A closer Look at Code and Database Transformation
In some cases, it might make sense for you to transform your RPG and CA 2E (Synon) code and database. Code transformation enables you to take advantage of modern technology, integration opportunities and more readily available skill sets while preserving the functionality, business processes and structure of your applications. Database modernization, on the other hand, improves security, reliability and performance._x000D_ When you’re ready to deploy your transformed applications, should you go hybrid? Multi-cloud? What is the best option for you and what does it all mean from a practical perspective?_x000D_ Join Chris Koppe and Robert Arce for this session where they will break down some of the many options available:_x000D_ • Business benefits of automated code and database transformation_x000D_ • Automatically transforming your RPG to PHP or Java and Synon to Java_x000D_ • Database modernization and re-architecting fundamentals_x000D_ o Alternately, Remodelling, transforming and modernizing your database – without needing to make changes to the application code.

Learning Objectives:

Speakers
avatar for Chris Koppe

Chris Koppe

SVP Portfolio & Strategic Services, Fresche Solutions
Chris Koppe is responsible for overall portfolio strategy and or the Strategy Consulting organization at Fresche Solutions. He has led the development of legacy management strategies for hundreds of companies, across a variety of platforms, languages, databases, and technologies... Read More →
avatar for Robert Arce

Robert Arce

Solutions Strategy - IBM i SME, Fresche Solutions
Robert Arce works in Corporate Strategy for Fresche Solutions. He is a subject matter expert in the IBM i system, assisting companies all over the world with their modernization projects.His expertise is using IBMi Application Analysis and Management Suite X-Analysis.Mr. Arce has... Read More →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 4 Online
  Database
  • Session Level All

2:45pm CDT

Getting a fast start with Auto Generation of reports and charts in Db2 Web Query
Db2 Web Query offers many ways to QUICKLY have a report/chart (and underlying foundational object called a synonym) built for you. Modernize a set of Query/400 reports in seconds; Get a FAST report over a file or SQL Statement (including IBM i Services); Convert SQL from other tools; Auto generate a spreadsheet from a spooled file; Use cloud based ML Models through web query's "Generate Insights" to return multiple charts automatically showing data correlations, outliers and time-series relationships.

Learning Objectives:
1. Learn how to import a Query/400 report _x000D_ 2. Leverage EZ-Report for building synonyms and reports over SQL Statements_x000D_ 3. Learn about the new facility for leveraging AI/ML models in the cloud to provide additional data insights

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 →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 3 Online
  Database

2:45pm CDT

🟢How Journaling works with DB2
From its humble beginning journaling local database changes to physical files on the System/38, IBM i journaling technology has evolved to include SQL tables, the integrated file system (IFS), and even remote journaling. In fact, many IT teams have been using IBM i journaling technology for audits, replication, problem determination, removal of bad updates, and high availability for years!

This session will take you through the process of how journal works against data base files and IFS. You will learn about the various commands for creating and working with journals and journal entries.

Learning Objectives:
• How to start journaling of PF/SQL/IFS
• Why before and after images are important
• How to use remove journal changes
 • What remote journaling is

Speakers
avatar for Tom Huntington

Tom Huntington

EVP of Technical Solutions, HelpSystems
Tom Huntington is Executive Vice President of Technical Solutions at HelpSystems, and a 29-plus-year veteran of the company. He works with business alliances, acquisitions and large customer relationships and ensures that the HelpSystems software works with other major software and... Read More →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 12 Online

2:45pm CDT

Running an Old Version of JDE on the IBM i? What Next Steps Should You Be Taking? (Part 1)
If you’re running an older version of JD Edwards you may be wondering, where do you go from here. Should you be upgrading and if so, what are your upgrade options. Is support truly necessary? What should you do when your version of JDE drops support? Should you stay on World? Should you upgrade to E1? Is it time to leave JDE completely? And where does your IBM i system come in to play with all this? If you’re running an old version on JDE, we have answers.

Learning Objectives:
1. The different upgrade options you have available including whether you should upgrade, modernize, or migrate off your current JDE platform and the advantages of staying on World, moving to E1, moving to a new platform _x000D_ 2. Learn whether support is necessary and what to do if your current version is no longer supported by Oracle JD Edwards_x000D_ 3. Assess the possibility and benefits of preforming a business process review to determine your next steps_x000D_

Speakers
DB

David Balser

Director - JD Edwards, Briteskies LLC
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 →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 8 Online
  Middleware (other)
  • Session Level All

2:45pm CDT

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 →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 9 Online

2:45pm CDT

Monitor and Manage IBM i with SQL Services
IBM i Services are provided by Db2 for i and can be used to access and manage the IBM i operating system. This session will include many examples of how to use IBM i Services to modernize administration on IBM i. Invest in understanding this alternative to existing IBM i APIs and commands._x000D_ http://ibm.biz/Db2foriServices_x000D_

Learning Objectives:
1. What are IBM i SQL services._x000D_ 2. Understand some of the many areas of system administration where IBM i Services can help you automate and manage your system.

Speakers
avatar for Sue Romano

Sue Romano

Technical Lead Db2 foi 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 →


Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 1 Online

2:45pm CDT

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_x000D_ 2. How to create web pages with React_x000D_ 3. Manage state with React hooks

Speakers

Wednesday October 6, 2021 2:45pm - 3:45pm CDT
Breakout 11 Online

4:00pm CDT

Explore IBM Db2 Mirror for i as a Continous-Availability Solution
Continuous availability is the next step to high availability or disaster response plans. Discover how Db2 Mirror for i improves business continuity problems and how it can shift availability to a near zero RPO and RTO. Be introduced to the basic concepts for how Db2 Mirror operates to create a synchronous environment and how to maintain Db2 Mirror as the production environment evolves. 

Learning Objectives:

Speakers
avatar for Mi Huynh

Mi Huynh

IBM i High Availability Development, IBM
Mi started at IBM in 2017 and she is a key developer working on the IBM i Development team in Rochester. She is specifically focused on IBM i High Availability development with Db2 Mirror for i.  


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 2 Online

4:00pm CDT

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

Learning Objectives:
1. Learn how to deploy PowerHA with IBM FlashSystems Global Mirror_x000D_ 2. See how to synchronize security and configuration related objects across the environment_x000D_ 2. Understand how to migrate data and applications to an Independent Auxiliary Storage Pool (IASP)_x000D_

Speakers
avatar for Brian Nordland

Brian Nordland

Principal Software Engineer, HelpSystems
Brian Nordland is the architect for the PowerHA SystemMirror for i product at HelpSystems. Brian has spoken at events, webinars, and users 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 →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 1 Online

4:00pm CDT

Why should I Use Journaling and How do I Use it well?
Journaling an object makes it more recoverable in the event of an outage, more easily replicated in an HA environment and more auditable. This session provides an introduction to how objects are journaled and how journal entries are used for each of these purposes. We will also discuss SMAPP, commitment control, Remote Journal and how journaling is used in an HA environment for logical replication, hardware replication and DB2Mirror. Performance considerations and tips will be identified as well.

Learning Objectives:
1. Learn the benefits of journaling and how to use the journal for multiple purposes_x000D_ 2. Understand the benefits of additional functions that use journaling

Speakers
avatar for Bruce Hansel

Bruce Hansel

Software Engineer, IBM
Bruce is an IBM i developer and has been a member of the Journal development team for over 25 years. In additional to design and development responsibilities he works extensively with the IBM i Support organization. He has significant experience investigating Journal, DB and High... Read More →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 4 Online

4:00pm CDT

Top Five Security Issues Facing Organizations Today
Organizations are facing increasing security threats via nation-state attacks, exploitation of software flaws, ransomware, BEC (Business Email Compromise) and even their own or former employees. During this session Carol will discuss the current threats., She will also provide near-term steps you can take as well as long term objectives that you can make to address these issues. The goal, of course, is to reduce your organization's overall risk level.

Learning Objectives:
Understand today's current threats_x000D_ Understand how to evaluate an organization's risk level_x000D_ Hear practical steps they can take to reduce their organization's risk

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 →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 7 Online

4:00pm CDT

Getting Started with Project Management
As IBM i professionals are asked to take on more responsibilities project management is increasingly becoming part of their duties. This session will explore the fundamentals of project management and how to integrate the practices into the work flow of traditional IT personal.

Learning Objectives:
Learn methods of projects management and what environments are best for each_x000D_ Determine how to track moving parts_x000D_ Identify distinct stages of the project management cycle and how to communicate at each point_x000D_ Suggestions for scheduling, forecasting, and documentation

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 6 Online
  IT Strategy
  • Session Level All

4:00pm CDT

Machine Learning: Creating Value for your Business
See how machine learning can enable your business to harness the deeper value of your data. This session will use the latest machine learning software to demonstrate the building of an AI model that can then be deployed to draw new insights. The majority of the talk will focus on native IBM i machine learning software with training and inferencing both being done on the system. IBM Watson Machine Learning in IBM Cloud will also be briefly discussed.

Learning Objectives:
1. How machine learning works_x000D_ 2. How to build a model directly on IBM i_x000D_ 3. How a model can be deployed and used on new data as it enters your 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 →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 3 Online

4:00pm CDT

Running an Old Version of JDE on the IBM i? What Next Steps Should You Be Taking? (Part 2)
Decided it’s time to upgrade, but not sure where to start? Whether it’s determining what licensing to choose, what version JDE to move to, or deciding on the details like whether to leverage scrum agile versus waterfall options, there is a path that’s right for you.

Learning Objectives:
1. Best practices around a JDE (World to World, World to E1) upgrade including examples from a client A7.3 to A9.4 we recently performed_x000D_ 2. Balancing simultaneous JDE and IBM i upgrades_x000D_ 3. How to spot if your ERP implementation went south and how to recover_x000D_

Speakers
DB

David Balser

Director - JD Edwards, Briteskies LLC
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 →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 8 Online
  Middleware (other)
  • Session Level All

4:00pm CDT

Open-Source Utilities for IBM i
With over 300 open-source packages available on IBM i there has to be a few that can add value to virtually every IBM i shop. In this session we’ll explore the installation of Open Source on IBM i and several of these packages such as yum, cron, python, bash and many more .

Learning Objectives:
1) Explore the open-source options for administrators and developers for IBM i._x000D_ 2) Learn how to install open-source solutions on IBM i_x000D_ 3) Examine the principle use cases for open-source solutions on IBM i _x000D_

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Architect
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 →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 10 Online

4:00pm CDT

🟢 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.

Learning Objectives:
1) How to use the refactoring capabilities of RDi_x000D_ 2) How to extract business logic into procedures using RDi_x000D_ 3) Best Practices for Refactoring

Speakers
avatar for Ray Everhart

Ray Everhart

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


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 5 Online
  RPG, N2i

4:00pm CDT

What? I Can Create a Private Cloud with IBM Power Servers?
PEP 2.0 and new private cloud options IBM made available across systems starting in 2020

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 →


Wednesday October 6, 2021 4:00pm - 5:00pm CDT
Breakout 11 Online

5:00pm CDT

Networking Event: Ask the Experts
Connect with peers, industry experts, and solution providers who have common interests and goals. Circle the event networking platform to exchange ideas and learn from your fellow participants. This is a wonderful opportunity to meet new people, catch up with old friends, and build the platform one conversation at a time.

Wednesday October 6, 2021 5:00pm - 6:00pm CDT
Breakout 1 Online
 
Thursday, October 7
 

7:30am CDT

Morning Yoga, Sponsored by Midrange Dynamics
Join us first thing for gentle morning stretching at your desk. Simple for those who have never tried yoga with modifications for those who have, this is a wonderful way to start your day.

Speakers
avatar for Jennifer Hollister

Jennifer Hollister

Yoga Teacher, Jennifer Hollister Yoga
An E-RYT Yoga Teacher, Trauma Based Yoga Therapist and Trauma Psychotherapist, Jennifer has an extensive background in mental and physical health for over 20 years.Jennifer teaches a variety of yoga styles in addition to Yoga Therapy, stress relief and meditation classes. She offers... Read More →


Thursday October 7, 2021 7:30am - 7:55am CDT
Breakout 1 Online

8:00am CDT

Help, my printed reports could use a facelift !
As our businesses move to modern report presentations such as Excel spreadsheets,fancy PDF documents, etc. we face the challenge of taking our existing stock of printer files and programs and converting them to produce modern output. Learn how to build modern reports by using RPG and open source. Use true type fonts, include images, print by using PCL and PS languages, build excelfiles, ... Your wildest dreams are possible, just use the tools available on your IBM i.

Learning Objectives:
1 make nice reports using RPG and printerfiles 2 convert printing to ps / pcl 3 manipulate PDF documents (add indexes, make booklets, ...) and many more

Speakers
avatar for Koen Decorte

Koen Decorte

CEO, CD Invest


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 12 Online

8:00am CDT

Providing REST APIs: Creating Rest APIs with Loopback
Create secure, semantically correct REST APIs from existing Db2 tables and views using LoopBack, a framework that runs on Node.js. The sessions covers the anatomy of a LoopBack application before demonstrating the ease of creating a REST APIs from existing tables, securing those APIs, and publishing them for use. Finally we will explore some of the other great things Loopback can do, like using GraphQL or SwaggerUI.

Learning Objectives:
1. Installing Node.js packages with npm_x000D_ 2. Creating REST API endpoints from existing Db2 tables using LoopBack_x000D_ 3. Securing 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 →


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 4 Online

8:00am CDT

⭐ Using Process Insights to Prioritize Projects and Drive Business Results
Digital transformation is critical for your business to not only survive, but also thrive in a volatile market. Modernization of your IBM i applications is part of that larger strategy. Where do you start? How do you know which modernization project will have the most impact to the business? If you understand the details of operational workflows and processes on those applications, you can make a prioritization decision using hard data, not assumptions. But often businesses struggle to reach that level of visibility. In this session, you will learn how process insights can deliver the actionable insights you need to take the right steps in your modernization journey.

Learning Objectives:
• The 3 levels of workflow visibility and why they are all critical to understanding the business
• How to set up Rocket® Process Insights to record how your business engages with IBM i applications
 • How to build the best IBM i automation plan that aligns to business needs

Speakers
avatar for Jeroen van Dun

Jeroen van Dun

Product Manager, Rocket Software


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 2 Online

8:00am CDT

Db2 for i Web-Services ? Yes i can!
In a modern world, information gets exchanged over the web. A request is put and an answer is returned. We do not care where the data is located. On the i data is stored within a relational database. Data access occurs with native I/O or SQL. _x000D_ What if we could receive the request and provide the data directly by executing a SQL statement? Wouldn’t that be great?_x000D_ With Release 7.4 the HTTP Web Administration GUI interface can now be used for deploying SQL Statements as REST APIs while the IBM Db2 acts as RESTful service provider._x000D_

Learning Objectives:
In this session you’ll learn how to _x000D_ - Create the integrated web services server_x000D_ - Deploy the SQL statements as a RESTful web service, including how to define the database properties and how to depose the SQL statements for each HTTP-method _x000D_ - Manage the deployed services_x000D_

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 7 Online
  Database

8:00am CDT

Performance Pre-Check for Db2 Mirror
IBM Db2 Mirror for IBM i enables continuous availability, but what are the implications for performance? Come and learn some of the key performance considerations at both a partition level and an application level when considering Db2 Mirror.

Learning Objectives:
1. Learn what performance pitfalls to avoid before rolling out Db2 Mirror 2. Learn how to identify if you have those pitfalls on your partitions 3. Learn how to avoid those pitfalls.

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 →


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 5 Online
  Database

8:00am CDT

IBM i Resiliency: How to set up MFA as part of a layered security defense for the IBM i
No matter how prepared you believe you are, sometimes a nefarious entity finds its way onto your network. How to you make sure the critical data and applications on the IBM i are still secure? In this session, we’ll show you how to set up MFA as part of a layered defense around your IBM i to minimize password vulnerabilities._x000D_ Learning objectives:_x000D_

Learning Objectives:
*Why IBM i specific security is critical and how to convince the business it should be part of the security policy_x000D_ *How to set up MFA for IBM I using Rocket MFA_x000D_ *How to integrate MFA into your applications like terminal emulation

Speakers

Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 3 Online
  Security
  • Session Level All

8:00am CDT

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._x000D_ Determine the testing approaches that would be the most useful._x000D_ 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
IBMi, Quality Assurance, project management


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 6 Online
  Security
  • Session Level All

8:00am CDT

Everything You Need to Know About the IBM i Administration Runtime Expert
Everything You Need to Know About the IBM i Administration Runtime Expert, Part Business-critical applications must be up and running reliably without failure. When something unexpected occurs, you must identify the cause and correct it quickly. We all want to find ways to make our jobs easier, and unexpected surprises are not fun. 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 free product 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. In this session, you will learn the basics for how to set up templates and validate systems.

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_x000D_ 2. Learn how to create templates that define the attributes to verify_x000D_ 3. Learn how to set up system groups for verification_x000D_ 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 →


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 9 Online
  Systems Management
  • Session Level All

8:00am CDT

IBM i, AIX, and Linux in the IBM Cloud
In this continuation from the iNSIGHT overview session, you learn about the technical underpinnings of this service, possible network topologies, how you can leverage the service for HA / DR, and how your on-prem environment can be migrated to PowerVS.

Learning Objectives:
1. Understand IaaS architecture_x000D_ 2. Learn how to migrate data to PowerVS_x000D_ 3. Learn how to setup backup and HA/DR in PowerVS

Speakers
SA

Shamsundar Ashok

IBM Cloud Technical Offering Manager, IBM
Ashok has been in IBM Systems management for 20 years, seeing the evolution of Power from virtualization to cloud to Cognitive, and providing the tools to manage the infrastructure. He has several patents as a result of work he has been involved with in this domain. He's the Technical... Read More →


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 1 Online

8:00am CDT

Performance Data Investigator and the IBM Navigator
With the release of the new updated IBM Navigator the world of PDI has also been improved. In this session Lora will take a look at how to get the most of your PDI interface. She will go over how to better navigator and look for the data and charts to help you with reviewing performance on your IBMi. This session will include much live demo as well as help you understand what we have delivered and where we are headed.

Learning Objectives:

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).


Thursday October 7, 2021 8:00am - 9:00am CDT
Breakout 10 Online

9:15am CDT

Is Low-Code in your Future? What it Is and What it Does
Lately, there has been a lot of focus on low-code development platforms. But its meteoric rise was not so sudden. There are several business and technical reasons for its emergence and why you may want to go low-code to develop internal applications, customer-facing experiences, integrations, and automation.

In this session, we will discuss:
  • How can low-code be used to address current business issues,
  • Look at examples of low-code usage,
  • Attempt to answer the question, “What options are available for your IBM i systems?”

Andrew Vaiciunas will share his extensive experience of IBM i shops that have been adopted low-code to enhance innovation and agility.

Speakers
avatar for Andrew Vaiciunas

Andrew Vaiciunas

Senior Sales Engineer, LANSA Inc.
Andrew has over 35 years of business systems design and development experience on various operating system platforms, including 25+ years on IBM S/38 and AS/400-iSeries platforms, 30+ years with LANSA products, along with team facilitation and software sales.  During this time he... Read More →


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 1 Online

9:15am CDT

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_x000D_ 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._x000D_ 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. _x000D_

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. _x000D_ 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. _x000D_

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 7 Online
  Database

9:15am CDT

Integrating Virtual Tape Into IBM i Backup And Recovery
Incorporating virtual tape into backup and recovery operations is essential to meeting modern day backup and recovery needs. This session covers the first steps needed to decide if virtual tape is the right solution, and specific scenarios where integrating virtual tape is warranted. Attendees will learn about incorporating deduplication appliances and backing up to the cloud. Plus the specific benefits of using virtual tape, how it can transform IT operations without disrupting day-to-day business, how to achieve significant time savings for systems and IT personnel, and how to improve data protection by ensuring backups remain current and complete ensuring data is there when needed.

Speakers

Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 9 Online

9:15am CDT

LetsEncrypt and DCM Simplified
Having websites secured by an SSL certificate used to be the exception but as more an more web browsers demand a secure site before connecting, the need for adding SSL to your website has grown. This session will look at why the secure website movement is growing and how the open source community is responding. We'll look specifically at Let's Encrypt, a free and open source SSL solution. We look at how to implement Letsencrypt certificates on Apache on IBM i using DCM (Digital Certificate Manager)

Learning Objectives:
1. Understand the need for SSL and how it works_x000D_ 2. Looks at the Let's Encrypt implementation of free certificates._x000D_ 3. Walk through the step by step instructions on getting it to work with DCM.

Speakers
avatar for Pete Helgren

Pete Helgren

Team Lead, Bible Study Fellowship
Currently Java Team Lead at Bible Study Fellowship International. Pete is an RPG/C++/VB/Java programmer with over 24 years of system 3X/AS400/iSeries/IBM i experience. He holds certifications as a GIAC Secure Software Programmer-Java, and as a MCSE. His passion has always been in... Read More →


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 12 Online

9:15am CDT

Under the hood of Digital Transformation: IBM i, Microservices, and the API Ecosystem
Digital transformation is a term you hear so often and is used in so many ways that it’s started to feel less like an IT initiative and more like a marketing buzzword. But, IT teams are taking that hype and using it to drive momentum in the business for real modernization projects around the IBM i. In this session, you will learn about digital transformation best practices around microservices and the API ecosystem. _x000D_ _x000D_

Learning Objectives:
This session will cover:_x000D_ · Methods for creating APIs._x000D_ · How to use APIs to support mobile and web user interfaces._x000D_ · Orchestrating services from multiple sources to meet complex needs._x000D_ · How to manage APIs for optimal use and potential profit with Rocket Process Automation.

Speakers
avatar for Charles Jones

Charles Jones

Rocket Software


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 4 Online

9:15am CDT

Programming Standards and Guidelines
We have all unfortunately seen really bad code or really bad practices. Have you ever wanted to take that code and throw it against the wall and start over? This session will give you the steps and guidelines that will help you start the discussion so you and your colleagues can implement standards and guidelines and start the process of cleaning up your code or the code you have inherited.

Learning Objectives:
1. We will look over various different recommended programming standards and guidelines._x000D_ 2. we will look at bad code vs new code and make recommendations that you can take back and implement in your shop. _x000D_ 3. We will learn why its important to have standards and guidelines and how you can start the standards discussions at your shop. _x000D_

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 is one of two IBM i admins... Read More →


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 11 Online
  RPG, N2i

9:15am CDT

What's The Fuss? - Using Procedures and Service Programs
This session discusses the advantages of using modern techniques in your RPG programs. After a short introduction to modularity in programming; we go step-by-step through the process of replacing called programs with sub-procedure modules and then converting these modules to procedures in a called service program.

Learning Objectives:
1 Internalize the benefits of using modular coding practices.
2 Understand the steps in coding modular subprocedures and service programs.
3 Develop reusable subprocedures and service programs.

Speakers
avatar for Jim Buck

Jim Buck

CEO & Head Instructor, imPower Technologies
Number ONE in IBM i Education! :)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... Read More →


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 6 Online
  RPG
  • Session Level All

9:15am CDT

🟢 The Awesomeness of Service Programs (and the truth about binder source)
Learn why service programs are so awesome. We will weight the pros and cons of the different options we have for creating shared routines. We'll learn how to create a service program and how easy it is to use these shared procedures in our applications. We will discuss the importance of binder source and how using it can make updating our service programs painless.

Learning Objectives:
1. What is a service program_x000D_ 2. How to create a service program_x000D_ 3. How to use a service program

Speakers

Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 10 Online
  RPG, N2i

9:15am CDT

IBM i Security: What’s New for IBM i 7.3 and 7.4
Security improvements continue to be high priority to help mitigate vulnerabilities. Come see what’s new with security related features on IBM i 7.3 and 7.4 that you can take advantage to improve the health of your environment.

Learning Objectives:
Discuss new enhancements in IBM i 7.3 and 7.4 related to TLS 1.3, Authority Collection, Digital Certificate Manager, SMB 3, SST Profiles, and more.

Speakers
avatar for Thom Haze

Thom Haze

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (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, Integrated... Read More →


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 2 Online
  Security

9:15am CDT

Modern Authentication Methodologies
The days of using a simple password to access your most prized business systems are over. Today, modern authentication methodologies are required to increase security. These include technologies such as Single Sign-On using Kerberos and Multi Factor Authentication using a rotating six-digit pin in addition to a password. Come learn the basics of these technologies and see them live in a demo at the end of the session.

Learning Objectives:
1. Understand how to use more than just a password for authentication_x000D_ 2. Learn what integration options exist for IBM i

Speakers
avatar for Robert Andrews

Robert Andrews

Executive Security Consultant, IBM
Robert Andrews is the Team Lead for the IBM i Security and Authentication Lab Services Power Systems Delivery Practice in Rochester, MN.  He is a Senior Managing Security Consultant and a certified Thought Leader in IBM for security.  Besides security, Robert is an expert in Db2... Read More →


Thursday October 7, 2021 9:15am - 10:15am CDT
Breakout 5 Online
  Security

9:15am CDT

Hands-on IBM i + Node-RED = succeed faster in programming
Node-RED, which is built on Node.js, is a browser-based flow editor that makes it easy to wire together devices, APIs, and online services by simply dragging and dropping nodes on a palette. You then connect, or wire, the nodes to create flows that can be then deployed to the lightweight Node.js runtime with a single click. Make your idea a reality by prototyping like a master using Node-RED, and Node.js in conjunction with IBM i! Get hands-on experience and learn how to use Watson services, make a chatbot, connect to your RPG programs, use NoSQL databases using node-RED. And you don’t even need any programming experience!

Learning Objectives:
1 learn the node-red environment 2 make some simple flows and connect to RPG and DB2 3 build a small chatbot using watson 4 build a dashboard

Speakers
avatar for Koen Decorte

Koen Decorte

CEO, CD Invest


Thursday October 7, 2021 9:15am - 11:30am CDT
Breakout 3 Online

10:30am CDT

Tracking & Corralling Query Resource Hogs
There's a good chance in the past that you've experienced the "fun" of a runaway query taking over your system with heavy CPU or IO usage and all the attention that follows. The reality is that fighting query fires like this is never fun - however, the good news is that Db2 provides a number of built-in tools and services that can help prevent this type of fire in the future. These tools can be used proactively to help you both track and limit the amount of resources consumed by SQL workloads.

Learning Objectives:
1) Learn how to use the ACS Plan Cache tooling to identify queries with high system resource usage_x000D_ 2) Learn how to use the new Query Supervisor and other Db2 services to monitor and control the system resources consumed by queries. _x000D_ 3) Learn about what causes queries to inefficiently use system resources

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 →


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 4 Online
  Database

10:30am CDT

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._x000D_ 2. Understand how to manage a PowerHA environment and see it in action_x000D_ 3. See tools within PowerHA that help your environment stay secure

Speakers
avatar for Brian Nordland

Brian Nordland

Principal Software Engineer, HelpSystems
Brian Nordland is the architect for the PowerHA SystemMirror for i product at HelpSystems. Brian has spoken at events, webinars, and users 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 →


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 1 Online

10:30am CDT

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.

Learning Objectives:
- Understand the file sharing options on the IBM i and their differences_x000D_ - Understand how to set up/use the file sharing options on the IBM i_x000D_ - 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 →


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 2 Online
  IFS

10:30am CDT

On the Clock
We've all seen the national debt clock, fictitious to some, but a real threat to our country. Closer to home is a another threat just as serious and yet just as fictitious to some. We're talking about your organization's technical debt. Not the lease payments on your Power system, but rather the sum total of hidden exposures and future expenses that are brought about by less than optimal practices. Every company has it. They key is minimizing if not eliminating it through better practice, technology and collaboration. Join me as we explore some of the worst examples of technical debt and how to stop the bleeding, All while putting it into terms that your boss will understand.

Learning Objectives:
1. Understand the concept of technical debt and its adverse effects on an organization._x000D_ 2. Be able to convey this message to non-technical C-level managers._x000D_ 3. Take steps to eliminate (pay down) technical debt and prevent it from accruing in the future.

Speakers
avatar for Christopher Burns

Christopher Burns

Sr. Consultant, GEMKO Information Group
Most of my peers know me as the brains behind Inuendo, an open source database model and API layer. But I'm just an IBM i geek like everyone else. Check out my open source projects on GitHub under CFBURNS.


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 11 Online

10:30am CDT

Be the Cool Kid: Modernize with APIs
More and more clients are building their modernization strategies around API patterns that can read and update IBM i data and program logic. In this session, we’ll demo a set of APIs and tooling that clients are using today rapidly build out new capabilities that interface seamlessly with existing applications.

Learning Objectives:
• API basics for IBM i clients_x000D_ • Leverage API patterns_x000D_

Speakers

Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 7 Online

10:30am CDT

Inspirational Women in STEM and what they teach today’s professionals.
Woman have been involved in the most important areas of industry, science, finance, and information technology far longer than we have been highlighting them in WIT events. By reviewing these women and their importance to their fields we learn how to optimize our teams and utilize diversity._x000D_ Covering _x000D_ Marie Curie and Mileva Maric (Einstein’s first wife)_x000D_ Grace Hopper_x000D_ Margaret J Winker Mintz (original financial backer of Disney Brothers Studio)_x000D_ WASP - Women Airforce Service Pilots in WWII_x000D_ The Mercury 13: Women who could have been NASA’s first female astronauts_x000D_ The first 6 American women astronauts_x000D_ Current women in IT focusing on innovation at Pixar

Learning Objectives:
1) Learn about inspirational careers and how STEM fields have evolved over the last 125 years._x000D_ 2) See what challenges have been overcome and use this knowledge to surpass issues in current environments._x000D_ _x000D_

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 6 Online

10:30am CDT

Protect Critical Workloads Running on IBM i with Zero Trust Segmentation
On average, it takes 280 days for an organization to identify and contain a data breach. It’s crucial for organizations still running critical business workloads on legacy IBM i (AS/400) servers to account for them in Zero Trust and general security strategies. Join us in this 30-minute panel discussion where you can learn how to segment these essential systems. 
 
You will learn: 
  • How IBM i can be an integral part of the latest security framework
  • How Zero Trust method can be applied for these systems
  • How to define and manage rules according to critical business need in your IBM i framework 
  • Learn how IBM i can be segmented just like other critical workloads

Speakers
MR

Marco Raffaelli

Alliances Manager, Guardicore


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 9 Online
  Security

10:30am CDT

⭐ Pete's Perspective on IBM i
In this session, Pete Massiello will go over his thoughts on the IBM i today, as well as the future direction of IBM i. You will hear the gospel according to reality vs. the IBM gospel on IBM i. What has reached end of service, where we are today, the technology, the hardware, the operating system. We will talk about HMCs, Internal and External Storage, Virtualization, Tapes vs VTLs, High Availability and Disaster Recovery, Cloud, Power Chips, Power Servers, and security. Plus bring your questions for discussion.

Learning Objectives:
Understand the hardware currently in the market, different ways to virtualize your environment, and who should be moving to external storage.

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 →


Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 12 Online
  Systems Management
  • Session Level All

12:30pm CDT

Lunch Break in the Expo
Thursday October 7, 2021 12:30pm - 1:30pm CDT
All-Attendee Expo Online

1:30pm CDT

⭐ 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, Central Park Data Systems
Charles Guarino has been an Information Technology consultant for the vast majority of his career. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 7 Online

1:30pm CDT

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_x000D_ 2. Learn how to use ACS tools to process Db2 Index Advice _x000D_ 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 →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 4 Online
  Database

1:30pm CDT

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_x000D_ 2. Learn how XML support in Db2 for i was used to resolve these issues

Speakers
avatar for Vern Hamberg

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 for the Pest Elimination division at Ecolab. He is degreed in both music and mathematics, which gives him a distinct approach to the art and science... Read More →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 9 Online
  Database
  • Session Level All

1:30pm CDT

Modernize your Storage for IBM i
Managing you modern storage on IBM i is easier than baking an apple pie. Dan and Douglas will talk about modern storage options around internal storage and NVMe. What is out there, and look at some of the new modern tools for helping you manage your storage.

Learning Objectives:

Speakers
avatar for Douglas Gibbs

Douglas Gibbs

Offering Manager, IBM
Douglas Gibbs is the offering manager for IBM Power Systems I/O and works closely with the overall Offering Management, Sales and Development teams regarding all manners of I/O. Douglas has worked in the IT Industry for more than 25 years and has been in a variety of positions at... Read More →
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 →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 2 Online
  Hardware

1:30pm CDT

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_x000D_ 2. Learn and see the exciting new features_x000D_ 3. A preview of what is to come in the future

Speakers
avatar for Brian Nordland

Brian Nordland

Principal Software Engineer, HelpSystems
Brian Nordland is the architect for the PowerHA SystemMirror for i product at HelpSystems. Brian has spoken at events, webinars, and users 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 →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 1 Online

1:30pm CDT

Work smarter not harder with Ansible
Whether you're new to Ansible or a Playbooks pro, learn how to take advantage of the radically simple IT automation platform for IBM i. This session covers the latest Ansible Content for IBM i and how you can start using it in your organization today with real use cases and examples.

Learning Objectives:

Speakers
avatar for Scott Heinlein

Scott Heinlein

DevOps Consultant, Arcad Software
https://www.linkedin.com/in/sbheinlein/


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 5 Online
  IT Strategy
  • Session Level All

1:30pm CDT

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!_x000D_ • The question of being relevant?_x000D_ • How to know… your relevancy _x000D_ • Uh Oh… I’m not relevant (what to do)_x000D_ • Business vs IT Skills – the Balance_x000D_ • The Specialist vs the generalist – Let’s hire a consultant_x000D_

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
Number ONE in IBM i Education! :)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... Read More →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 6 Online

1:30pm CDT

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_x000D_ 2. Understand the types of web services and their terminology_x000D_ 3. Demonstrate how to create a web service in RPG with Integrated Web Services_x000D_ 4. Demonstrate how to create a web service in RPG without a web service tool

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software. He also volunteers as a member of COMMON's Board of Directors and Strategic Education Team. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help... Read More →


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 12 Online
  RPG

1:30pm CDT

⭐ Optimizing Your Toolchain When Migrating IBM Power Workloads from the Data Center to the Cloud
Migrating on-premise workloads running on IBM i or AIX from the data center to the cloud creates an opportunity for organizations to re-evaluate how well their existing toolchain is working and whether there are cloud-based options that better fit their needs. While adding more complexity to a cloud migration is something that most IT shops want to avoid, they may be well-served to weigh the potential long-term benefits of new tools against the short-term work involved in adopting them. _x000D_ _x000D_ The typical software development toolchain includes both custom and commercial solutions for functions like provisioning (such as Ansible or Terraform), identity and access management, developer tools like IDEs and source control, disaster recovery and backup, as well as monitoring, logging and auditing (such as Datadog), and more. While offering similar functionality to on-premise solutions, cloud-based tools typically offer more flexibility, pay-as-you-go licensing and are easier to scale up or down, move workloads around, and to expand to other regions. The key question for most organizations is whether those benefits are worth the effort necessary to replace existing tools._x000D_ _x000D_ Key Learnings: This presentation will walk through a five-step process to help IT evaluate current tools, decide whether a change is worthwhile, and how to plan for the transition.

Learning Objectives:
Which tools to consider replacing when moving to the cloud_x000D_ Important factors in evaluating current tools, including vendor support, licensing, management, business needs, etc. _x000D_ Advantages of cloud-based tools versus homegrown or on-premise alternatives. For example, cloud-based tools may require retraining, but typically offer nearly unlimited compute and storage, dynamic workloads, and support in multiple regions. _x000D_ How to approach licensing, tool management and opportunities to consolidate tools in the destination cloud._x000D_ How to create a migration plan when replacing a tool that covers updating documentation, retraining, rewriting scripts, and what to do with historical data from tools that are being retired, etc.

Speakers
avatar for Dan Jones

Dan Jones

Senior Vice President of Products, Skytap
Dan has over 20 years experience at major enterprises leading product strategy and user experience for everything from cloud and data platform to gaming. Prior companies include Nordstrom, Microsoft, IBM, and Hewlett Packard


Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 3 Online

1:30pm CDT

🟢 CSS – Adding Style to your content
Make your web pages look stunning using CSS. We’ll start with the basics of CSS including the cascade, rule precedence, selectors, and declarations. We’ll talk about the Box Model, floats, page layouts, and Flexbox. We’ll finish up with how to avoid spaghetti code by using CSS style guides (SMACCS & BEM) and pre-processing with SASS.

Learning Objectives:

Speakers

Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 10 Online

2:45pm CDT

Apache Camel: A Framework for Enterprise Integration Patterns
Integrating IBM i applications with other other systems in your enterprise is rarely an easy task. To solve the issues that arise, many businesses employ "Enterprise Integration Patterns" to do exactly that: Integrate! Apache Camel is an open-source integration framework that allows you to use pre-constructed modules to connect from any number of technologies, like Kafka, Git, WordPress, and AWS to name a few. It also has the ability to integrate with IBM i through data and message queues, meaning Apache Camel could be exactly what your enterprise has been looking for to tie your disparate systems together.

Learning Objectives:
1. Learn the basic concepts of Enterprise Integration Patterns_x000D_ 2. Learn how Apache Camel solves many integration issues that enterprises have faced for years with those enterprise integration patterns_x000D_ 3. Learn how to download, install, and use Apache Camel on IBM i to integrate the system with the rest of your technology stack

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 →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 4 Online

2:45pm CDT

IBM i Next Gen Applications
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 Chief Architect, will discuss what this means, and talk about approaches 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._x000D_ 2. Learn the value of incorporating Next Gen concepts, and how that approach is far more successful than re-platforming._x000D_ 3. Understand the patterns, approaches, and tools available to move applications to the Next Generation.

Speakers
avatar for Steve Will

Steve Will

Chief Architect - IBM i, IBM
Steve has worked on the IBM i operating system and its predecessors since the initial development of the AS/400. Since 2007, he has been the IBM i Chief Architect, responsible for the strategy of the operating system and the plan for future releases.


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 7 Online

2:45pm CDT

Analyze your journals and journal entries using IBM i Services and Access Client Solutions (ACS)
In the past, the only way to convert journal entries into a readable format was through the DSPJRN and CPYAUDJRNE command or the Retrieve Journal Entries API. Now, however, you can use IBM i services and Access Client Solutions to better understand both your journals and journal entries. Easily query your journal entries including audit journal entries, quickly determine what objects are journaled to your journals, and analyze your audit journal for security concerns. Automate you journaling tasks through SQL.

Learning Objectives:
Come to this session to learn how to use IBM i Services to analyze your journals and journal entries using the power of SQL and see how to leverage ACS to quickly navigate, filter, and analyze your journals and journal entries.

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 →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 2 Online
  Database

2:45pm CDT

Improving development using DB2 for i Services
IBM DB2 for i Services are one of the most recent exciting extensions to the IBM i that continue to regularly improve DB2. These services can be used to do system activities work that used to require multiple programming objects, use of temporary files and programing for sorting and selection. This session will provide examples of using these services to help solve some real world problems. _x000D_ _x000D_

Learning Objectives:
1. Discuss what DB2 for i services are and what they are used for_x000D_ 2. Provide examples of using some of the most common services such as running commands, library list, job log, history, and user information using SQL _x000D_ 3. Demonstrate the power of using SQL with these services to sort, select, join and display_x000D_ 4. Provide complex examples of JSON and HTTP services to integrate other content_x000D_ 5. Provide some real life examples for improved understanding_x000D_

Speakers
avatar for Rex Maughan

Rex Maughan

Cerner
Rex Maughan has worked on the IBM midrange platform since 1981. First AS/400 experience began with the model A40 in 1987. Rex has deep development experience in database, languages, web development, design, integration and management on the IBM i. Rex has 3 software patents with more... Read More →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 9 Online
  Database

2:45pm CDT

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 Sue Romano

Sue Romano

Technical Lead Db2 foi 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 →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 1 Online
  Database

2:45pm CDT

IFS data in IBM Db2 Mirror for i 
Learn about how Db2 Mirror is more than just making Db2 data highly available. Integrated file system (IFS) data can be made highly available too using IBM Db2 Mirror for i. Find out more about the differences between how Db2 Mirror makes IFS and Db2 data highly available.

Learning Objectives:

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 →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 3 Online

2:45pm CDT

🟢How to Solve Business Problems with a Design Thinking Approach
Design Thinking solves business problems through customer-centric application development. This approach has been shown to solve business issues efficiently and profitably at a pace that makes sense for your organization. This comprehensive overview covers:_x000D_ _x000D_ • Customer-focussed set of development processes for Design Thinking_x000D_ • How the approach employs a different way of thinking compared to standard business processes_x000D_ • The set of tools and methodologies that Design Thinking uses to build a repeatable, flexible development process

Learning Objectives:

Speakers
avatar for Nick Hampson

Nick Hampson

Director of Design, Fresche Solutions
Nick has extensive experience in design, UX, product management, innovation and pre-sales. Focused on bringing the business value of design and UX to IBM i customers and the community at large, Nick is recognized as a UX expert on IBM i. He also describes himself as a geek and a bookworm... Read More →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 5 Online

2:45pm CDT

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 →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 11 Online
  IT Strategy
  • Session Level All

2:45pm CDT

Python APIs aka: Web Services
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._x000D_ 2) Explore modules used with services_x000D_ 3) Review several examples of services consumption and provisioning _x000D_

Speakers
avatar for Mike Pavlak

Mike Pavlak

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


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 10 Online

2:45pm CDT

POWERFul Leadership, mentoring, and colaboration for women in IT
Working from Nilofur Khan's "Young Women in IT, Hear our Voice" session from Navigate we will layer in statistics about challenges women face and how to overcome them. Focusing on 25 years of success as a women in the IBM i world we will talk about professional development, networking, and the extreme importance of mentoring for all young professionals in the community. Leadership in the current corporate climate and lessons learned from successful STEM visionaries included.

Learning Objectives:
Discuss how to encourage and support women in the IBM i professions._x000D_ _x000D_ Talk about the importance of the next gen and what tomorrow's professionals want from their employers, and how to lead the teams we need for success._x000D_ _x000D_ Highlight professional development, mentor ship, and collaboration opportunities that enhance the careers of all professionals in this community._x000D_

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
IBMi, Quality Assurance, project management


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 6 Online

2:45pm CDT

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_x000D_ 2) How to setup a system using NVMe_x000D_ 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 →


Thursday October 7, 2021 2:45pm - 3:45pm CDT
Breakout 12 Online
  Systems Management
  • Session Level All

4:00pm CDT

Providing REST APIs: IWS
Rest APIs are a key part of todays applications. The integrated Rest api engine within IBM i provides a simple way to create and host Rest APIs for ILE applications as well as direct SQL calls. This session will do live demo on how to create Rest APIs for multiple backend connections.

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 →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 12 Online

4:00pm CDT

What Does a Next Generation Application Look Like?
Studies have shown that modernizing your IBM i application will consistently lead to a better outcome than re-writing it on another platform.   In this session, the characteristics of a "Next Generation" application for IBM i will be identified and explored.

Learning Objectives:
1. Characteristics of Next Gen Applications_x000D_ 2. Building the Business case for Next Gen Applications_x000D_ 3. Additional Resources to help you begin building Next Gen Applications

Speakers
avatar for Ray Everhart

Ray Everhart

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


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 2 Online

4:00pm CDT

Speed Dating with a Date Dimension Table
Are your apps killing CPU time doing DATE processing? A recent customer benchmark shared with us took a 20 second routine down to milliseconds through the date dimension table technique. The date dimension table also provides huge benefits to reporting/dashboarding applications that heavily use dates for prompts, date ranges, date calculations, and other date attributes. Simplify and speed up date processing with the date dimension table!

Learning Objectives:
1. How to simply work with problematic legacy date fields_x000D_ 2. Learn about methods to extend/enhance your applications and reports with additional date attributes._x000D_ 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 →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 3 Online
  Database
  • Session Level All

4:00pm CDT

Is your Infrastructure Engineered for Agility? What’s New with IBM Power
Talk about Power9 and Power10 processor/server options, I/O, etc. We are still selling Power9 for awhile and people will also be curious about Power10.

Learning Objectives:

Speakers
avatar for Douglas Gibbs

Douglas Gibbs

Offering Manager, IBM
Douglas Gibbs is the offering manager for IBM Power Systems I/O and works closely with the overall Offering Management, Sales and Development teams regarding all manners of I/O. Douglas has worked in the IT Industry for more than 25 years and has been in a variety of positions at... Read More →
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 →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 11 Online
  Hardware

4:00pm CDT

IBM i Resiliency: How to set up your IBM i to be available when and where it’s needed
There are any number of reasons why a system goes down. Sometimes it’s planned maintenance. Sometimes something breaks on the server. No matter the reason though, you still need to ensure 99.999% availability. In this session, we’ll show you how to set up your IBM i HA/DR and ensure its data and applications are available to the users who need them when they need them.

Learning Objectives:
• Why backup isn’t enough. The difference between backup and HA_x000D_ • How does replication work_x000D_ • How to set up HA/DR for IBM i using Rocket iCluster_x000D_

Speakers

Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 7 Online

4:00pm CDT

Revamping Your Web Pages for Mobile without CSS3 Media Queries
If you have existing web pages specified in HTML via PHP or another kind of server-side programming, and they don't dynamically reformat for mobile-sized devices, then this session is for you. We will discuss ways to gain mobile formatting that involve incremental changes to existing HTML, without requiring CSS frameworks such as Bootstrap or CSS3 media queries (two of the most prevalent ways to achieve mobile formats, frequently referred to as " responsive design"). For web strategies that don’t have/use server-side programming, evidence is building that you can do a lot, maybe all, of the techniques discussed in this presentation in javascript on the client side._x000D_ _x000D_ This session will examine a technique that achieves multi-view flexibility by simply changing the viewport metatag and various other HTML5 elements at run time (along with a small amount of CSS3 changes). What might be considered a moving target with responsive, isn’t applicable. Examples of detail page level HTML that works for the multiple views will be shown, along with net change comparisons to the original HTML. _x000D_ _x000D_ This session won’t get into all of the exact programming or script required to accomplish the run-time changes, but all of it will be covered at the conceptual level and specifics involving the viewport meta-tag and outer most HTML containers will be shown.

Learning Objectives:
1. Gain insight into one strategy for leveraging existing web and intranet applications to deliver mobile-friendly views (without compromising Desktop or Theatre views)_x000D_ 2. Learn about key HTML elements such as viewport and how width specifications and others can interact well in a relatively flat CSS design_x000D_ _x000D_

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 →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 4 Online

4:00pm CDT

Understand Emerging Security Threats: State of Security
A staple resource for IBM i security teams since 2004, the State of IBM i Security Study outlines the good, the bad, and the ugly in IBM i configurations around the world. This session will be hosted by the chief analyst for that study who will reveal content from the study as well as share expertise on how to avoid being your own statistic.

Learning Objectives:
1. Discover interesting facts from the 2021 State of IBM i Security study _x000D_ 2. Learn common configuration flaws_x000D_ 3. Understand how to determine your configuration_x000D_ 4. Get hints and tips for tightening your IBM i security controls

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 →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 6 Online
  Security

4:00pm CDT

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 →


Thursday October 7, 2021 4:00pm - 5:00pm CDT
Breakout 5 Online
  Systems Management
  • Session Level All

5:00pm CDT

Closing Session, Hosted by Fresche Solutions
End POWERUp 2021 on a high note at the fun and exciting Closing Reception. Fresche Solutions is delighted to be the master of ceremony this year. Be ready to be dazzled by the magic and entertainment of Harrison Kramer, a world-class virtual magician. After 4 days of education, it’s time to relax and have a good time with friends and peers, as we look forward to POWERUp 2022 in New Orleans, LA.

Thursday October 7, 2021 5:00pm - 6:00pm CDT
Breakout 1 Online