Sessions

Topic Series

RPG Programmer Bootcamp

All You Need to Know About RDi in Four Hours

Charlie Guarino |  December 8, 2020  |  1:00 p.m. - 5:00 p.m. CT

Your development efforts are constrained using ancient green screen tools; blast to a fast path to modern tooling by learning RDi.



REST APIs and RPG

Scott Klement |  December 9, 2020  |  1:00 p.m. - 5:00 p.m. CT

Rest APIs are a key part of todays applications. Learn the many options for consuming and creating APIs on IBM i today.



How should RPG Programmers be Doing their Testing

Marcel Sarrasin |  December 10, 2020  |  1:00 p.m. - 5:00 p.m. CT

Test driven development; Code Coverage; RPG Unit

Basics for Admins


IBM i Admin - Back to the Basics

Pete Massiello, Steve Pitcher, and Steven McIver |  December 8, 2020  |  1:00 p.m. - 5:00 p.m. CT

Join iTech Solutions’ Pete Massiello, Steve Pitcher, and Steven McIver as they discuss Basics for the IBM i System Administrator. Pete, Steve, and Steven will cover basics of topics such as commands, management, Backups, Restores, Disaster Recovery & HA, Types of IPLs, Security, Basic Cleanup, Performance, TCP, HMC, FSP, ASMI, Tapes, and more. This session will offer fundamentals to those new to the system, as well as provide a refresher and best practices to those who have had years of experience on the platform.



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

Kent Milligan |  December 9, 2020  |  1:00 p.m. - 5:00 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 factors. 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.



Managing Your IBM i in a Modern Way

Tim Rowe & Scott Forstie |  December 10, 2020  |  1:00 p.m. - 5:00 p.m. CT

In this session Scott Forstie & Tim Rowe will teach you how to use IBM i Access Client Solutions (ACS) and IBM i (SQL) Services. SQL can be used for more than querying database tables. With the invention of IBM i Services, there are many options for accessing and managing IBM i. This workshop will explore how to leverage ACS and SQL to accomplish amazing things. 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.
Workshop requirement: You must have ACS 1.1.8.5 installed and connected to an IBM i running at IBM i 7.3 or IBM i 7.4. Download ACS at http://ibm.biz/IBMi_ACS



Understanding and Managing the Performance of your IBM i

Dawn May, Lora Powell, & Shauna Rollings |  December 17, 2020  |  1:00 p.m. - 5:00 p.m. CT

This workshop is a deep dive into the Performance Data Investigator (PDI), focusing on how you can use PDI with Collection Services data to understand the health and performance of your IBM i partition.  This workshop will consist of a mix of lecture materials and hands-on demonstrations.  The demonstrations are designed such that you can repeat these same tasks, investigating the performance data from your own partition.


The following topics will be covered in this workshop:

  • Overview and best practices for Collection Services
  • Overview of IBM i Wait Accounting
  • Deep dive on using PDI to investigate Collection Services data
  • Using System Monitors for proactive performance monitoring
  • Basics of Job Watcher 
  • Introduction to Performance Explorer

ACS Trail Map

Configuring, Controlling and Setting up ACS for your enterprise

Wayne Bowers |  December 15, 2020  |  1:00 p.m. - 5:00 p.m. CT

  • Join us for a nuts and bolts workshop on IBM i Access Client Solutions (IBM i ACS).  We will start off our time together with special guest speaker IBM Business Architect Tim Row, where he will show us why in ACS IBM really has built the better mousetrap for accessing and managing your IBM i.  Then your main speaker, IBMer Wayne Bowers, will spend the rest of the time in presenting and live demoing many different aspects of IBM i Access Client Solutions including:

    - Best Practices for deploying to your users
    - Latest support for easily updating
    - Administrative tools for customizing and restricting functions and behavior
    - Advance usage topics like scripting actions and running on IBM i
    - Overview of the separate, complimentary Application Packages



Managing Open Source on the Platform

Erwin Earley |  December 16, 2020  |  1:00 p.m. - 5:00 p.m. CT

Open Source is Here!  Open Source is Here!  By Now you have heard the buzz around open source on the IBM i platform and the benefits it can bring to your organization/business.  This workshop will focus on the “how” of Open Source, highlighting how to enable the platform for open source solutions, how to work with open source packages including how to manage packages even when your system is behind a firewall.  The workshop will also take a look at how to take advantage of containers to establish environments that ben be used to isolate development activities and even instances of production solutions.  The workshop will also take a look at getting familiar with concepts for working in the PASE environment.  The workshop is a blending of presentation as well as hands-on opportunities to become familiar with working with open source on IBM i.  If you are looking to get your feet wet and start working with Open Source Solutions on IBM i then you will not want to miss this workshop.



Enterprise Messaging in an Open Source World

Erwin Earley |  December 17, 2020  |  1:00 p.m. - 5:00 p.m. CT

Have you ever had disparate systems/applications that you wish could talk together to share data or notifications of actions?  Enter Enterprise Messaging!  In this workshop we will explore how solutions such as ActiveMQ (message-oriented middleware), Kafka (message queue), and Camel (integration framework) can be used to build an event streaming platform.  The workshop will be IBM I focused and all of the solutions presented run on the IBM i.  Demonstrations will show how Enterprise Messaging can be used with RPG programs as well as Db2 data and hands-on exercises will be used to re-enforce the content learned, again on an IBM i instance.

Security Dive

Regulations and Security Standards and Impact on the IBM i

Craig Johnson |  December 16, 2020  |  1:00 p.m. - 5:00 p.m. CT

SOX, SOC1 & 2, PCI-DSS, FFIEC, GDPR, NY Reg, CCPA, etc.



Security Tune-Up

Carol Woodbury |  December 17, 2020  |  1:00 p.m. - 5:00 p.m. CT

Top 10 items to check, practical guide, quick and dirty and effective.

Open Source Language Care and Feeding

Managing Open Source on the Platform

Erwin Earley |  December 8, 2020  |  1:00 p.m. - 5:00 p.m. CT

Open Source is Here!  Open Source is Here!  By Now you have heard the buzz around open source on the IBM i platform and the benefits it can bring to your organization/business.  This workshop will focus on the “how” of Open Source, highlighting how to enable the platform for open source solutions, how to work with open source packages including how to manage packages even when your system is behind a firewall.  The workshop will also take a look at how to take advantage of containers to establish environments that ben be used to isolate development activities and even instances of production solutions.  The workshop will also take a look at getting familiar with concepts for working in the PASE environment.  The workshop is a blending of presentation as well as hands-on opportunities to become familiar with working with open source on IBM i.  If you are looking to get your feet wet and start working with Open Source Solutions on IBM i then you will not want to miss this workshop.



Introduction to Open Source and Open Source Languages

Erwin Earley |  December 16, 2020  |  1:00 p.m. - 5:00 p.m. CT

There has been a significant expansion in the Open Source Programming Languages available on IBM i.  This workshop will explore several of open source languages including PHP, Python, and Node.js.  We will discuss the strengths (and weaknesses) of each language as well as their typical usage/application.  The workshop will also take a look at understanding the syntax of each language as well as the integration capabilities that each language has with regards to IBM I – including Db2 access and ILE integration and the toolkits that are available for each language.  We will also explore how to use file-system container technology to establish multiple, isolated development environments.  In addition to the information presented in the lecture portion of the workshop, participants will also have the opportunity to get hands-on with each language. 


Enterprise Messaging in an Open Source World

Erwin Earley |  December 17, 2020  |  1:00 p.m. - 5:00 p.m. CT

Have you ever had disparate systems/applications that you wish could talk together to share data or notifications of actions?  Enter Enterprise Messaging!  In this workshop we will explore how solutions such as ActiveMQ (message-oriented middleware), Kafka (message queue), and Camel (integration framework) can be used to build an event streaming platform.  The workshop will be IBM I focused and all of the solutions presented run on the IBM i.  Demonstrations will show how Enterprise Messaging can be used with RPG programs as well as Db2 data and hands-on exercises will be used to re-enforce the content learned, again on an IBM i instance.

SQL Bootcamp

SQL Basics

Sue Romano |  December 15, 2020  |  1:00 p.m. - 5:00 p.m. CT

SQL is the standard for defining, manipulating, and accessing your data on IBM i and on most other systems. What's the best way to get started with SQL without feeling overwhelmed? Why, join us for this session, of course! Even if you already use SQL, you're sure to learn techniques that will make you more productive. What's included?

- Query constructs including scalar functions, grouping, joins, and common table expressions.

- How to write procedures, functions, and triggers using SQL PL, the programming language of SQL

- Accessing data on remote systems

- And a lot more!



Practical SQL in RPG

Birgitta Hauser & Vern Hamberg |  December 16, 2020  |  1:00 p.m. - 5:00 p.m. CT

Now that you know the basics of SQL language, here are the important things to know to extend your knowledge and applications with RPG and SQL.

Pre-compiler messages

What makes valid host variable

Using SQLcod

SQLstate

OLAP 

Parsing XML and JSON

Database Engineer Essentials

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

Kent Milligan |  December 9, 2020  |  1:00 p.m. - 5:00 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 factors. 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.



Getting a FAST Start to IBM i Analytics with Db2 Web Query

Doug Mack |  December 9, 2020  |  1:00 p.m. - 5:00 p.m. CT

A famous quote from an IBM General Manager over a decade ago about IBM i clients: "It makes sense, our customers have most if not all of their core business data in Db2 for i - we should be providing the tools, techniques and attributes to support analyzing that data." With that came Db2 Web Query for i and this in depth session will cover tips, techniques and best practices on how to get a fast start to delivering value to your business. It'll cover simplifying complex data structures for end users though meta data or SQL; dealing with legacy (like Packed 8 decimal) date fields to simplify the report authors world; options for getting data into Excel from files/tables, query/400 definitions, even spool files. Practical examples will be used to provide real world data wrangling challenges that come with the territory of getting information out of databases designed for transaction processing!

Career Growth & Development 

Your First Five Years in IT: Are You Ready?

Marina Schwenk & Shelly Petty |  December 10, 2020  |  1:00 p.m. - 5:00 p.m. CT

This workshop is designed to give students and Young i Professionals pointers on how to prepare for the real world.

We will be covering what you should be doing in your last year of college, how to prep for your interview, resumes, what to expect in your first job, how to brand yourself, and what you can do to make sure you are successful in your career.

We will give an overview of the IBM i community, the benefits of being a part of COMMON, the COMMON academic membership, and your local user groups.

We want to make sure you get every perspective; we will hold a manager’s panel that will consist of industry experts who also either have or currently hold a management role. And finally, we will hold a Young i professionals’ panel that gives you a chance to ask industry experts your burning questions!

Schedule

Last Year of College and Interview Prep
Speakers: Marina Schwenk, Shelly Petty, Vern Hamberg 
This session will cover what you should be doing in your final year of college, interview prep, and resume prep. We will make sure that we cover as many concerns that students coming out of college have.

Managers perspective – Panel
Speakers: Steve Pitcher, Ajay Gomez, Steve Wolk, Dawn May, Barbara Harris, Andy Buchholtz
Moderator: Marina Schwenk, Shelly Petty

The First Job and The Next 5 Years
Speakers: Marina Schwenk, Shelly Petty, Vern Hamberg 

This session will cover what to expect in your first position, how to brand yourself, continuing education, and how to be a productive team member. We will make sure you feel prepped to transition from student to professional.
10-minute break.

Young IBM i Professionals (YiPs) Panel
Speakers:
Steve Pitcher, Ajay Gomez, Richie Palma, Vern Hamberg, Steve Wolk, Dawn May, Marina Schwenk, and Shelly Petty






The Art of Advancing Your Career Beyond the Technical

Steve Wolk |  December 16, 2020  |  1:00 p.m. - 5:00 p.m. CT

  • Do you love being a developer or sysadmin, but aspire to be more? Do your career goals take you further up the ladder, perhaps even to being a CIO or CTO one day? If you'd like to develop the skills you'll need to land your dream job and be successful in it, this two-part session is the perfect start.
  • Step 1: Communications. Sure, we're all great with technology, but to continue growing in our careers requires that we do the unthinkable... we actually have to TALK to each other. And even worse... we have to TALK to the business people in our companies! Why? WHY? Why would we possibly want to TALK to PEOPLE? The answer to that question is that today more than ever, technology IS the business. So it makes sense that IT can help or hurt a business more than ever. It's critical that we align our IT efforts, goals, and strategies with those of the business - and all of that requires good communication. Would you like to have a seat at the table, to be taken seriously as a businessperson, and to have a voice in the decisions our companies make? Then this is the interactive workshop for you. Fair warning... this will be an INTERACTIVE workshop. Attendees will be encouraged to speak in front of the group, work together on critical thinking exercises, and participate in role play. If you find that uncomfortable, perfect! Take that first step outside your comfort zone. Enroll, participate, be uncomfortable, and grow... and you may just find yourself listened to with newfound respect and interest by your business! We'll cover critical skills including:
    • Speaking the language of the business
    • Thinking like a businessman
    • Demonstrating strong leadership
    • Selling fellow business leaders on the value proposition of IT investments
    • Always being prepared
    • Earning influence
    • Preparing for and navigating board meetings
    • Difficult conversations
    • Always keeping your cool
    • Aligning IT with business goals.
  • Step 2: A Day in the Life of a CIO. If you work in IT, it's very likely you report - directly or indirectly - to your company's CIO, or perhaps CTO. How can you best enhance and leverage that relationship to support your company's IT initiatives, and advance your career - and eventually land the role of CIO or CTO yourself? The first step is to understand your CIO's role. The role of the CIO or CTO may seem mysterious and overwhelming at first, but it's critical to understand the big picture in order to better support your boss, and become a superhero to your CIO! We'll cover:
    • What is your CIO responsible for? We'll discuss the practical elements as well as the strategic decisions of the job
    • What does a day in the life of your CIO look like?
    • What are the differences between a CIO and CTO?
    • Who does your CIO communicate with? Who is he or she responsible to, and for what?
    • What pressures does your CIO deal with every day, and from whom?
  • Audience: All IT professionals who aspire to improve their communications skills, become a superhero to their CIO, and perhaps become a CIO or CTO themselves one day!