Workshops by Topic

Application Development

Embedded SQL - An Introduction

Birgitta Hauser |  February 22, 2022  |  8:30 a.m. - 12:00 p.m. CT

SQL is IBM's relational database language that can be used to query, update and delete data from the database. SQL is becoming the 'de facto' industry standard for accessing distributed data.
Record Level Access can only be used with RPG and Cobol, while in all other programming languages data access is performed through SQL. Additionally SQL provides a lot of great features, such as aggregating rows and building sub-totals or updating a bunch of rows with a single statement.
SQL also includes various scalar functions for example for date and time calculation, that are not available in RPG or Cobol.
Embedded SQL allows SQL commands to be included and executed directly from within RPG or Cobol and thereby profiting from all the powerful SQL features without additional programming.

Learning Objectives:
In this session you will learn how to embed and execute SQL commands from within an HLL respectively RPG. It provides an overview of the commands to use in an application program to exploit SQL scalar functions as well as for updating, deleting and accessing data located in database objects.

Overall Testing as a Foundation of QA

Yvonne Enselman |  February 22, 2022  |  8:30 a.m. - 12:00 p.m. CT

Fundamentals, Testing throughout the development lifecycle, static testing, test techniques, test management, tool support for testing.

Security testing concepts: Basics, security testing purposes, goals, and strategies, security testing processes, security testing throughout the software lifecycle, testing security, mechanisms, human factors in security testing, security test evaluation and reporting, security testing tools, security and industry trends.

Testing and quality assurance is important to all organizations. The first part of the workshop will tie all the components of QA as a practice together on a foundational level. The second part will move into the advanced concepts of security testing given how crucial that is to environments in the current climate of information technology.

Learning Objectives:
1. Learn how testing should be organized and implemented
2. See how the myriad components of QA work together
3. Explore the world of comprehensive security testing


Monitoring and Managing SQL on Db2 for i

Scott Forstie |  February 22, 2022  |  1:00 p.m. - 4:30 p.m. CT

In this new workshop, Scott will cover, explain, and demonstrate the varied techniques that can be used to see what SQL is being executed on your IBM i.

Topics include, but are not limited to:
-- SQL Performance Monitors
-- SQL Plan Cache analysis
-- Guardium Database Activity Monitor
-- Journal Extract Tool (JET)
-- Db2 for i SQL services
-- Db2 for i Client Special Registers
-- Db2 for i SQE Query Supervisor
-- IBM i (SQL) Services
-- Authority Collection

Learning Objectives:
1. If you have a need or requirement to capture database activity, this session is for you.
2. If you need to have techniques to understand the SQL being executed (right now), this session is for you.
3. If you need to a better foundation for understand who is doing what with SQL on your IBM i, this session is for you.

Get Your Data Ready for Analytics on IBM i

Doug Mack |  February 23, 2022  |  8:30 a.m. - 12:00 p.m. CT

It has been said that any Analytics project is going to require 70% or more of your time getting the data ""right."" For IBM i customers that have a majority of their critical information stored in Db2 for i, the Db2 Web Query product provides multiple architectures and facilities to ease the effort of preparing that data to feed into analytical applications. Those applications could be standard reports, slice and dice reports, dashboards using Db2 Web Query, or generate data feeds into other databases (such as a data warehouse) or cloud based AI/ML analytical services. This workshop will cover how to leverage Db2 *and* web query facilities to prepare and manage your data to simplify you analytics!

Learning Objectives:
1. Learn about a meta data infrastructure to support your analytics strategy - ""get the data right"" and everything else becomes easier.
2. Understand that you can use both Db2 SQL or web query facilities (or a combination of the both) to do data preparation and avoid having to build RPG programs to get the data in the right formats to be consumed by analytics.
3. Discover different architectural options for on premise analytics or integrating data into and out of cloud based analytical services.

Creating and Consuming JSON Data with SQL

Birgitta Hauser |  February 23, 2022  |  8:30 a.m. - 12:00 p.m. CT

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.

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 JSON_TABLE tables function for consuming JSON data was already introduced with Release 7.3 TR 1. 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 http-functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed within a SELECT-Statement.

Learning Objectives:
1. Get an introduction into JSON basics.
2. Learn how JSON object and arrays can be generated, concatenated or nested and composed into JSON documents.
3. Discover how JSON documents located in either the IFS or a column of a table or JSON answers returned by web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected.
4. Get an overview over the new http-functions and how to use them for getting access to web services.

Take Your Application Performance to the Next Level with Database Engineer Essentials

Kent Milligan |  February 23, 2022  |  1:00 p.m. - 4:30 p.m. CT

In this workshop, you'll start by learning how to get the proper database foundation in place for all your applications by learning about best practices for design of your data model and Db2 tables. Besides having a good database design, you also need a good understanding of key SQL performance concepts and critical success factor such as indexing strategy. You will learn how to analyze and investigate these important SQL performance concepts using the graphical performance tools that are included with Db2 for i featuring, Index Advisor, Visual Explain, and the Plan Cache tooling.

Taking the Next Steps with SQL

Simon Hutchinson |  February 24, 2022  |  1:00 p.m. - 4:30 p.m. CT

Take the next steps from simple SQL and start thinking about the data in your database differently. Change the way you think about keeping data in a normalized form, to see the advantages of gathering data into unnormalized forms that will save you time and effort. Learn how to remove your logic from your programs and into the database itself. See real life examples of how you can use SQL to gather data from multiple partitions and present them all in one place. Discover how by using SQL you can simplify your programming, and reduce your workload, to produce results with less effort than you could using many programming languages.

Learning Objectives:
1. Understand why working with SQL means you change from “record at a time” to “data sets” way of thinking
2. Learn how to maximize the value of SQL to simplify your programs
3. Learn how to access data from multiple partitions

Developing Business Skills 

N2i Workshop

Marina Schwenk |  February 24, 2022  |  8:30 a.m. - 12:00 p.m. CT

This workshop is a personal development workshop that is beneficial to everyone, and those who is just starting out in their career. We will cover areas like how to get hired, how your first five years could look like, and for everyone, how to learn to get out of your comfort zone. This workshop will offer bits of advice that everyone can  use to help advance in their career.

How to Get Hired with Steve Wolk
Length: 1 hour

How to Learn with Richie Palma
Length: 30 Minutes

Get Out of Your Comfort Zone! with Marina Schwenk and Rochelle Petty
Length: 30 minutes

Your First 5 Years: Are You Ready? with Marina Schwenk and Rochelle Petty
Length: 1 hour

Personal Development Panel with Marina Schwenk, Rochelle Petty, Steve Wolk and Richie Palma
Length: 1 hour

High Availability Resilience

Your Disaster Recovery Plan

Richard Dolewski | February 23, 2022  |  1:00 p.m. - 4:30 p.m. CT

Do you have a disaster recovery plan? Are you really prepared? The difference in surviving in business depends on how well you prepare for the unexpected. If a disaster struck, how would your company do? Using the Business Continuity Model, the session breaks down the various components of the recovery planning as it relates to the availability and recovery of computing services.

Mobile and Modernization

Introduction to IBM Power Systems Virtual Server for IBM i Servers

Tonny Bastiaans |  February 22, 2022  |  1:00 p.m. - 4:30 p.m. CT

During this workshop we will explain IBM Power Systems Virtual Server ( PowerVS) and vi a hands-on attendees will will be able to create an IBM i instance on PowerVS and do a migration from on-premise IBM i workload to PowerVS

Learning Objectives:
1. Describe PowerVS
2. Create an PowerVS instance
3. Migrate workload from on-premise to PowerVS

Open Source Languages

Modern PHP with Mezzio and Vue.js

Joshua Hall |  February 22, 2022  |  1:00 p.m. - 4:30 p.m. CT

See what it's like to build a modern PHP application using open source tools. Using Mezzio and its convenient CLI, we'll quickly build a lightweight, RESTful PHP API to communicate with our IBM i Db2 data. Once we have meaningful endpoints, we'll use the Javascript framework, Vue.js, to rapidly build a front-end to display and manipulate the data served by our RESTful PHP API.

Systems Management

Deep Dive into the IBM i Administration Runtime Expert

Dawn May |  February 22, 2022  |  8:30 a.m. - 12:00 p.m. CT

This half-day workshop takes a deep dive into all of the features of the IBM i Administration Runtime Expert (ARE) product.

ARE can help you ensure consistent configuration settings for your partitions and workloads running on your system. You can verify system values, network attributes, installed PTFs, TCP/IP configuration, security settings, user profiles, application attributes and much more. You can ensure the settings remain unchanged on a single partition or ensure they are consistent across multiple partitions.

The workshop is a mix of lecture and live demonstrations to explore all the features of ARE. Attendees are encouraged to actively use ARE in their own environment to follow along with the demonstration.

This workshop includes the following:
- Overview of what ARE is and why you should use it, with example use cases
- Architecture and terminology of ARE
- Prerequisites, installation, and logging into the ARE console
- Creating and editing templates, with live demonstration all of the ARE plugins and how to use them for verifications.
- Setting up system groups, verification options, and verifying systems
- Understanding the reports
- Fix actions
- Using ARE for PTF management
- Script interfaces
- Writing custom plugins to extend the functionality of the base product

Learning Objectives:
1. You will learn the following in this workshop:
2. What is ARE and how it can help you ensure your environment is in a known, consistent state
3. How to create templates and verify systems
4. How to extend the functionality with custom plugins

Managing Your IBM i with SQL - Made Easy!

Scott Forstie |  February 24, 2022  |  8:30 a.m. - 12:00 p.m. CT

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 workshop will look to explore the many already existing examples shipped in Access Client Solutions. 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.

Come with your laptop loaded with the LATEST level for ACS. This will get you rolling on the road to managing your environment. Download ACS at

Learning Objectives:
1. Learn about the full complement of IBM i (SQL) Services alternatives to CL and APIs
2. Explore SQL programming techniques to formulate interesting queries
3. Leave the workshop with a higher SQL IQ and confidence level

Introduction to Open Source

Mike Pavlak |  February 24, 2022  |  1:00 p.m. - 4:30 p.m. CT

Open Source technology is BOOMING on IBM i and you don’t want to get left behind. In this session we will explore the fundamentals of using open source technology on IBM i. Concepts to be explored include but are not limited to use of shells, BASH, Python basics, Git, Open Source Package Management & YUM, CURL, CHROOT, ODBC and much more. This session is ideal for ANYONE who is interested in what Open Source is all about, from executive down to admin.

Learning Objectives:
1. Understand how to install and manage open source tools on IBM i
2. Learn fundamental concepts of open source and how that applies to IBM i
3. Get a survey level perspective of dozens of open source projects