Loading…
Attending this event?

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

Monday, April 6
 

2:00pm

DEEP DIVE: Python Half Day Hands-on Workshop
Python is a language that has been perceived as infrastructure or plumbing in the IT department, much like CL. While this is an excellent use for Python, it has emerged as a strategic language for application development, too. In this workshop, we’ll explore the implementation, syntax, and application use cases of Python on IBM i. From a fundamentals perspective, you will get hands-on experience using the command line, shell environment, script creation, storage, and execution. As we progress through the workshop, we will delve into Db2 data access and program calls using XML Service as well as a brief tour of frameworks. Then we’ll wrap things up with how open source applications built in Python can add value to your IT environment.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →


Monday April 6, 2020 2:00pm - 6:15pm
(F) Carlisle

2:00pm

DEEP DIVE: Part 1 − Generating and Consuming XML with SQL & Part 2 − Generating and Consuming JSON Documents with SQL (Workshop)
DEEP DIVE: Part 1 − Generating and Consuming XML with SQL (Workshop)
Level: Advanced
With Release 7.1, XML support is included in SQL and the DB2 for i database. Multiple scalar and aggregate functions are introduced for generating elements, attributes with or without name spaces, and even complete XML documents, solely with SQL. XML support also includes two methods for consuming XML data. Annotated XML Document Decomposition allows XML documents to be shredded directly into database tables based on registered XML schemas. With the XMLTABLE table function, XML documents can be parsed, converted into a relational representation, and data picked specifically out. Additionally, SQL includes multiple http-functions for accessing web services. Using these http-functions in combination with the XMLTABLE table functions, XML data returned from web services can be directly consumed within a SELECT-Statement.

Learning Objectives:
  • Get an introduction into XML basics.
  • Learn how XML elements and attributes can be generated, concatenated, or nested and composed into XML documents.
  • Discover how well-formed XML documents located in either the IFS or an XML column or returned by a web service can be parsed with the XMLTABLE table function, converted into a relational representation, and data specifically selected.
  • You’ll also get an overview of the http-functions and how to use them for getting access to web services.
Audience:
Developers and users who are experienced in SQL Queries and need to create and consume XML documents located in either SQL Tables or in an IFS file. Developers and users who want to access web services and consume the returned XML answers. Everybody who simply wants to enhance his SQL know-how.
 
Part 2 − Generating and Consuming JSON Documents with SQL (Workshop)
 JSON (Java Script Online Notation) is a data exchange format like XML, however JSON is simpler, less verbose, and can be parsed faster than XML. 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, 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 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. 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 combination with the JSON_TABLE function, the JSON answers returned by web services can be consumed within a SELECT-Statement.

Learning Objectives:
  • Get an introduction into JSON basics. Learn how JSON objects and arrays can be generated, concatenated, or nested and composed into JSON documents.
  • 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.
  • You’ll also get an overview of  the new http-functions and how to use them for getting access to web services.
Audience:
Developers and users who are experienced in SQL Queries and want to create JSON data with SQL. Developers and users who need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services. Everybody who simply wants to enhance his SQL know-how.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Monday April 6, 2020 2:00pm - 6:15pm
(E) Ashland

6:30pm

 
Tuesday, April 7
 

7:15am

Breakfast
Tuesday April 7, 2020 7:15am - 8:00am
(AA) Solutions Center

8:00am

RPG! It’s Alive with New Treasures! ***
“New” RPG Free Form enhancements? Well sure, but that happened at 7.1. Time marches on and so
do the enhancements. Today’s RPG is living, vibrant and ever-evolving, keeping pace and meeting the
requirements and needs of TODAY’S programming community. If you haven’t been keeping up you are missing out on the many new treasures that will not only improved the readability of your code but also the reliability. Long live RPG!

Speakers
avatar for Charlie Guarino

Charlie 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 April 7, 2020 8:00am - 9:15am
(E) Ashland

8:00am

Updating our IBM i Modernization Mindset
Make modernization a strategy baked into your everyday processes. Learn about the upgrade challenges and costs of IT environments that have stagnated for a number of years. Set your self up for success by planning projects with modernization in mind rather than planning a modernization project.

Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Steve Pitcher is a Solutions Expert on Systems Administration and Security with iTech Solutions Group and an Industry Analyst at MC Press Online. He’s been a specialist in IBM i solutions since 2000 with an emphasis on modernization, security and collaboration products. Steve has... Read More →


Tuesday April 7, 2020 8:00am - 9:15am
(G) Middlesex West

8:00am

Intro to Git
In this intro to Git, we cover how to use Git on any platform - including IBM i. We
look at installation, terminology, commands, workflow, and other useful tools to
make it easier to get started with Git.

Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →


Tuesday April 7, 2020 8:00am - 9:15am
(F) Carlisle

8:00am

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.

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 →


Tuesday April 7, 2020 8:00am - 9:15am
(D) Commons I

8:00am

Securing Your Data in Db2 for i
This session discusses data security. Data has value and is a critical asset to a business. When a business is "hacked", it means data is stolen or destroyed and a company's reputation is tainted, possibly permanently. Plus, with compliance laws continuing to be enacted, there can be legal consequences for not properly securing and managing data.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Tuesday April 7, 2020 8:00am - 9:15am
(C) Commons II

8:00am

The Best of ACS!
IBM i Access Client Solutions (ACS) is the strategic member of the IBM i Access Product Family, and it is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. In this session Tim will use ACS to show best practices in managing and administering the database as well as other aspects of the system. Come to this session to learn about all the great features available in ACS, and how they are in many cases better than what you've been using! Much of this session is done using Live demo, so not only do you get to learn about better ways to do things, you get to experience them first hand.

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 April 7, 2020 8:00am - 9:15am
(A) Grand South

9:20am

Keynote: The State of the Union Address
Speakers

Tuesday April 7, 2020 9:20am - 10:10am
(A) Grand South

10:15am

Morning Break
Tuesday April 7, 2020 10:15am - 10:30am
(AA) Solutions Center

10:30am

Configuring RDi for RPG Development
RDi is the most versatile application development tools available today. It provides more and more
functionality with each update, and the results are obvious. This session focuses on the particular
attributes of enhancing your RPG development. How many of these features are you already using?

Speakers
avatar for Charlie Guarino

Charlie 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 April 7, 2020 10:30am - 11:45am
(E) Ashland

10:30am

Introduction to Python on IBM i (Beginner)
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.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
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 April 7, 2020 10:30am - 11:45am
(C) Commons II

10:30am

Migrating to Git (for RPG/ILE Apps)
This technical talk covers everything you need to know about migrating your source
code into Git — from learning the workflow, to user setup, to moving the source
members, to building your application changes and continuous delivery. A mostly
demoed session, you will see what steps you would have to take in real time.


Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →


Tuesday April 7, 2020 10:30am - 11:45am
(F) Carlisle

10:30am

SQL – Queries – Do you know what you can do with a simple SELECT-Statement?
Today SQL is not only used for ad-hoc queries, but replaces more and more native I/O and must be used in composition with all programming languages other than RPG and COBOL. Moving business logic into data base is one of the main goals when we talk about application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement which may be much more powerful than you can imagine. Currently SQL provides around 180 scalar functions and 30 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. All kinds of sub- and grand totals can be built. Recursive Common Table Expressions and hierarchical query clauses allow recursive data (such as bill of materials or flight plans) to be analyzed. Since release 7.2 TR 1 regular expressions can be used. Release 7.3 offers a new range of OLAP-Functions … In this workshop you will learn multiple ways for solving your requirements by using a single SQL Select Statement.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Tuesday April 7, 2020 10:30am - 11:45am
(D) Commons I

10:30am

10 Years of  ‘i Can’ – Top Tips for IBM i
The ‘i Can’ blog started in August of 2009. http://ibmsystemsmag.com/blogs/i-can/. In nearly 10 years, more than 350 articles have been written on various subjects, many of which are technical tips. In this session, Dawn will review her favorite tips as well as some hidden gems.

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on work management, systems management, performance, and diagnostics, with intimate knowledge of the IBM i operating system developed through her distinguished career with IBM. Today, as an independent consultant, she focuses her skills on helping companies... Read More →


Tuesday April 7, 2020 10:30am - 11:45am
(G) Middlesex West

10:30am

What You Need to Know When Upgrading IBM i to 7.3 and 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. While this presentation will focus on upgrading to 7.3 and 7.4, if you are upgrading to an earlier release (7.2 or 7.1), we will also cover those releases.

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 April 7, 2020 10:30am - 11:45am
(A) Grand South

11:45am

Lunch
Tuesday April 7, 2020 11:45am - 12:30pm
(AA) Solutions Center

12:30pm

Accessing RPG & IBM i from other Platforms (Beginner/Executive)
Even when the native green screen is in full swing as the primary I/O for IBM i, there may still be a need for other systems to provide an interface whether for UI, Integration or BI type uses. This session will explore the architectures of the alternative approaches to accessing IBM i from various systems and where a good investment might help an organization meet it goals in leveraging IBM i as the system of record.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
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 April 7, 2020 12:30pm - 1:45pm
(E) Ashland

12:30pm

Cool Things in Navigator to be a Star Administrator
IBM Navigator for i is a powerful tool to better manage your IBM i environment. Get expert advice for features in the tool to make you a RockStar system administrator. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Learn ways to protect your system from intrusions, as well as close security holes such as FTP. See how this tool can help you select and install Logical files on your system to improve performance with the Index Advisor. Learn about the enhancements to this valuable tool in the release of version 7.3, while we see how this tool provides tips and techniques for better and more easily managing your IBM i.

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 April 7, 2020 12:30pm - 1:45pm
(A) Grand South

12:30pm

IBM i and Our False Sense of Security
While IBM i is arguably the most "securable" operating system in the world, your environment may have some wide open doors that you can't ignore. This session will highlight the importance of encrypting data in transit and show you how to do it easily with minimal interruption to the business..

Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Steve Pitcher is a Solutions Expert on Systems Administration and Security with iTech Solutions Group and an Industry Analyst at MC Press Online. He’s been a specialist in IBM i solutions since 2000 with an emphasis on modernization, security and collaboration products. Steve has... Read More →


Tuesday April 7, 2020 12:30pm - 1:45pm
(G) Middlesex West

12:30pm

Best Practices for the SQL Developer
In this session, we will share several best practices for SQL development on Db2 for i. While some of the shared practices come from knowledge of the underlying database, many come from good old fashion experience overcoming failure. Take advantage of the opportunity to avoid some bruised knees that go along with being an SQL programmer.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Tuesday April 7, 2020 12:30pm - 1:45pm
(C) Commons II

12:30pm

Tips and Tricks for 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 be written into the IFS and directly read from the IFS. In this session you’ll discover these secrets! How to create, manage and use temporal tables will be demonstrated within this session.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Tuesday April 7, 2020 12:30pm - 1:45pm
(D) Commons I

12:30pm

IBM Db2 Mirror for IBM i 7.4 - What is it and why do I care?
IBM Db2 Mirror for i is the latest product for IBM i providing continuous availability. Tim will dive into Db2 Mirror, helping you understand how Db2 Mirror works, and how this solution can be key in your business.

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 April 7, 2020 12:30pm - 1:45pm
(F) Carlisle

1:45pm

Dessert Break
Tuesday April 7, 2020 1:45pm - 2:15pm
(AA) Solutions Center

2:15pm

The “Best Stuff” of Advanced RDi topics
Once you have a solid basic understanding of RDi you will want to attend this advanced session that
demonstrates many of the finer points of application development. Here is where you can truly
customize RDi to watch your development time shrink and performance soar.

Speakers
avatar for Charlie Guarino

Charlie 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 April 7, 2020 2:15pm - 3:30pm
(E) Ashland

2:15pm

Node.js & Db2 . . . Best Friends?
Interested in how you can use Node.js to create a service layer? How about using
Node.js to create a web application? How about both of those, using data from your
Db2 for i database? This talk will cover the different database connectors for talking to Db2 for i and
show the many different ways to represent data.

Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →


Tuesday April 7, 2020 2:15pm - 3:30pm
(F) Carlisle

2:15pm

SQL Writing 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. Whether it is writing queries or procedures, taking the right approach for writing SQL can help the database help you.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Tuesday April 7, 2020 2:15pm - 3:30pm
(C) Commons II

2:15pm

IBM i Fast Start: Understanding Save and Restore
Understand the different ways to save your system, using BRMS or traditional native commands. Learn about what you need to restore your system, and the steps involved to perform the restore. Tips will be given along the way on best practices.

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 April 7, 2020 2:15pm - 3:30pm
(A) Grand South

2:15pm

Take Control of Your IBM i Prestart Server Jobs 
Prestart jobs are used to service requests from clients in the network. There are many uses of prestart jobs on IBM i, the most common is the database server. Prestart jobs present many challenges for how to understand what is happening on the system and the work that these jobs handle. This session will review all the key characteristics of prestart jobs and provide many tips to better understand what is happening on your system.

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on work management, systems management, performance, and diagnostics, with intimate knowledge of the IBM i operating system developed through her distinguished career with IBM. Today, as an independent consultant, she focuses her skills on helping companies... Read More →


Tuesday April 7, 2020 2:15pm - 3:30pm
(G) Middlesex West

2:15pm

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

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 →


Tuesday April 7, 2020 2:15pm - 3:30pm
(D) Commons I

3:45pm

Batch processing in the 21st Century (Beginner/Executive)
Batch workloads were a fundamental component of IBM Midrange environments. In this session we will explore the history and evolution of batch processing in IBM i environments. Modern approaches to asynchronous processing and alternatives to the "nightly run" have made shops much more nimble. All aspects of the batch processing world will be explored including alternatives to data backup and HA processing. RPG is an excellent language for batch and business logic. Yet many will ask if PHP, Python or Node is good for batch? The first question we will explore is “why batch is still being done?”.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
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 April 7, 2020 3:45pm - 5:00pm
(E) Ashland

3:45pm

Building a Web App in One Hour
This mostly demo talk will show how easy it is to build a basic CRUD application
using Node.js alongside the frontend framework Bootstrap, with a sprinkle of a
template framework on top. While the demo is happening, the technology used is
explained and used in real time.

Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →


Tuesday April 7, 2020 3:45pm - 5:00pm
(G) Middlesex West

3:45pm

Date and Time Calculation with SQL
Calculating dates and times correctly within commercial applications are can be critical. Even though RPG can handle real date and times and has been enhanced by several operation codes and built-in-functions, SQL has become much more powerful in date calculation and date operation functions. But there are some features that can be handled easier with RPG. This session will give you an overview over the latest SQL scalar functions for date and time calculation and for conversion between numeric and character date/time representations and real date/time values. You will also learn when to use RPG and when to use SQL and what are the pitfalls.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Tuesday April 7, 2020 3:45pm - 5:00pm
(D) Commons I

3:45pm

The Science and Art of Indexing on Db2 i
Quiz: what is one of the most effective, quickest ways to improve database (SQL) performance? Indexing! This session explores database indexing technology for Db2 for i, index advice, and the proper way to determine which indexes to create. Not all good indexes are advised and not all advised indexes are good.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Tuesday April 7, 2020 3:45pm - 5:00pm
(C) Commons II

3:45pm

Managing IBM i using SQL and ACS
SQL is NOT just for the database anymore. SQL is a very powerful language that can be used for managing and learning about your IBM i.  This session will take a look this strategic change to managing the IBM i. We will leverage ACS along with the many examples that are included, showing most things with live demos. Concerned that you don’t know SQL ??  No worries!!!  I don’t either! Yet this session will show you all sorts of SQL that you can use to do things that with the existing technology (CL commands and system APIs) are just not possible.

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 April 7, 2020 3:45pm - 5:00pm
(F) Carlisle

5:00pm

6:30pm

Casino Night
Tuesday April 7, 2020 6:30pm - 9:30pm
(AA) Solutions Center
 
Wednesday, April 8
 

7:15am

Breakfast
Wednesday April 8, 2020 7:15am - 8:00am
(AA) Solutions Center

8:00am

Debugging with RDi From the On Ramp to the Cruising Lane
Displaying active variables? Check. Breakpoints? Yep, we got those too. Conditional and watch
breakpoints? Sure thing. But what about service entry points, which allow us to debug another user’s job
without having to use STRSRVJOB? Debug configurations to save multiple debug settings? Code
coverage that shows each line of code executed when a program has completed? This is only the start
of how the graphical RDi debugger exceeds the capabilities to the green screen version.

Speakers
avatar for Charlie Guarino

Charlie 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 April 8, 2020 8:00am - 9:15am
(C) Commons II

8:00am

Extending RPG with Db2 for i Functions
This session explores the wealth of non-database capabilities that SQL can achieve
for you within your RPG programs. These range from the use of simple SQL scalar
functions within your RPG (e.g., for upper/lower translations or math functions) to
grabbing IFS text to executing web services - and making sense of the XML or JSON
data that often comes back from them. Learn to exploit the power of basic SQL functions, user-defined functions (UDFs) and some of the Db2 for i Services from your RPG code. It's easier than you think!

Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →


Wednesday April 8, 2020 8:00am - 9:15am
(F) Carlisle

8:00am

PHP Arrays for the RPG Programmer – (Intermediate)
Until recently, RPG has neglected the sophistication of elegant array processing while PHP has supported the use of arrays since its inception. This session examines why array processing is so important and how many of the over 70 array functions relate to RPG operation codes and built-in functions. Participants will see how arrays are used to pass parameters between functions and programs, as well as how arrays can be used to supplant nearly all of the purposes data structures serve in RPG. This intermediate level session is important for the RPG programmer exploring PHP for production purposes.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
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 April 8, 2020 8:00am - 9:15am
(E) Ashland

8:00am

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

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 →


Wednesday April 8, 2020 8:00am - 9:15am
(G) Middlesex West

8:00am

Advanced SQL DDL - More Than Just Physical Files
Physical and logical files are well known entities in database. Through SQL, database supports many advanced SQL table features, as well as other objects that can be very useful in simplifying and extending capabilities. This session will cover several topics including constraints, audit columns, views, alias, three-part naming and more.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Wednesday April 8, 2020 8:00am - 9:15am
(D) Commons I

8:00am

Best Practices for Deploying and Managing ACS
Access Client Solutions is the strategic solution for accessing the IBM i.  It has many features to help make the experience of the user better…normal. In the past we had Access for Windows, which is no longer supported and was very difficult for administrators to keep current for their users. With ACS, there are many options for distributing ACS to the users in your company. This session will review some of the best practices as well as some brand new methods for easily keeping your user community running on the latest support.

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 →


Wednesday April 8, 2020 8:00am - 9:15am
(A) Grand South

9:30am

Activation Groups and Overrides in Action
A discussion on what activation groups are (simply put, a job within a job!), and how and when to use them in everyday programming. Are your programs running in QILE? Not the best choice! Do you use RCLRSC in your programs? It won’t work when using a named activation group, come hear why. In RCLRSC in your programs? It won’t work when using a named activation group, come hear why. In RCLRSC in your programs? It won’t work when using a named activation group, come hear why. In addition, we will take a close examination on overrides and how they work with activation groups. We’ll review the differences between overrides in the default activation group, call level, activation group and job levels. When and why should create a *NEW activation group. When should you be using *CALLER? Finally, what actually happens when multiple overrides are issued in the same job? What results is a merged override, but how are the parameters actually merged? Come to this session and see how all merged override, but how are the parameters actually merged? Come to this session and see how all thee pieces fit together.

Speakers
avatar for Charlie Guarino

Charlie 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 April 8, 2020 9:30am - 10:45am
(C) Commons II

9:30am

IBM i Application Development – On the Path to "Normal"
What is ‘Normal’ ?  Ask 10 people, get 11 answers. Development on IBM i is much like development on any other platform, ever changing.  The tool, methodologies, languages available on IBM i today for development is very different than what was available 10 years ago.  The IBM i platform is committed to being successful well into the future, insuring that the talent of tomorrow can be used to develop great business applications on IBM i.  This session will review this path of development. Look at the latest languages, and best practices to help you keep your business application relevant into the future.

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 →


Wednesday April 8, 2020 9:30am - 10:45am
(D) Commons I

9:30am

Moving from Classic HMC GUI to Enhanced HMC GUI
The new enhanced GUI is really nice, but if you haven't used it, it is very different from the classic GUI. It seems that you can't find anything, and things work and behave differently. Come to this session to learn where familiar functions are located now and how they work.  There are quite a few goodies in here which we will go through as well.

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 April 8, 2020 9:30am - 10:45am
(A) Grand South

9:30am

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!

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 →


Wednesday April 8, 2020 9:30am - 10:45am
(F) Carlisle

9:30am

Anatomy of a Security Failure
After the dust settles after a security breach, the next logical questions are: “What happened and how can we prevent it from happening again?” We will deconstruct a number of security failures that will provide lessons that you can take home and put to use immediately.


Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Steve Pitcher is a Solutions Expert on Systems Administration and Security with iTech Solutions Group and an Industry Analyst at MC Press Online. He’s been a specialist in IBM i solutions since 2000 with an emphasis on modernization, security and collaboration products. Steve has... Read More →


Wednesday April 8, 2020 9:30am - 10:45am
(G) Middlesex West

9:30am

Advanced SQL Coding
Going beyond the general SELECT and basic join query, this session will dig deeper into advanced SQL topics such as Grouping Sets, Recursive Common Table Expressions, Lateral, get started on different join types, OLAP Extensions, and more.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Wednesday April 8, 2020 9:30am - 10:45am
(E) Ashland

10:45am

Morning Break
Wednesday April 8, 2020 10:45am - 11:00am
(AA) Solutions Center

11:00am

Build an IBM i Web App in Under 10 Minutes
The Valence Framework, available for free download, includes a browser-based low-code development utility called Nitro App Builder (NAB), through which anyone with a solid understanding of their IBM i database can create slick-looking web or mobile apps, including dashboards and data grids with download-to-Excel functionality, all in a matter of minutes! Running entirely on IBM i, the NAB tool can also be used to create intricate file maintenance apps through which users can adjust content in one or more physical files - you control which fields they can see or edit.

All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML5 and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.

The bottom line: With Valence, whether you're a developers or a super user, you can crank out highly functional web and mobile apps on IBM i in no time - no prior experience in web or mobile development required. Come to this quick demo session to see how easy it can be to build and deploy such an app on your system today!

Speakers
avatar for Robert Swanson

Robert Swanson

Senior Partner, Chicago, United States, CNX
Robert Swanson has worked as an IBM i developer since 1992, the past 12 years focused on promoting modernization efforts for legacy systems written in RPG. Currently serving as Managing Partner for CNX Corporation in Chicago, Robert is a strong advocate of introducing "Web 2.0-style... Read More →


Wednesday April 8, 2020 11:00am - 11:45am
(D) Commons I

11:45am

Lunch
Wednesday April 8, 2020 11:45am - 12:30pm
(AA) Solutions Center

12:30pm

REST for IBM i - It's more than just for ILE programs
Web Services have been an important component to modernization. IBM i has provided a Web Services engine for a number of years now, originally only creating SOAP based web services. The Integrated Web Services Engine has now been updated to provide the ability to easily create REST based services for your ILE RPG programs and service programs. This means now you can take advantage of the latest trend in Web Services. REST based services allows you to participate in the API economy. Quickly enable your key business logic as API's that can be leveraged from anywhere. We will cover the latest updates to the Integrated Web Services engine which now allow you to use SQL directly in your REST API!!

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 →


Wednesday April 8, 2020 12:30pm - 1:45pm
(C) Commons II

12:30pm

PHP Web Security in an Insecure World (more PHP tips)
The security of many business applications running natively on IBM i has been thought out several years ago in many cases. Introducing PHP into the IBM i environment can cause folks to start asking questions about access, security and authentication. In this session we will discuss application security, PHP IFS and Root file system access and several options to authenticate to a PHP application running natively on IBM i. This is a must-see session for anyone who is looking to go live with PHP and/or a web technology on IBM i.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
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 April 8, 2020 12:30pm - 1:45pm
(F) Carlisle

12:30pm

Psychology of a Bad Password
Do you know the differences between IBM i password levels? How about password rules that aren’t used or actually used too much to be effective? What about common patterns from keyboards to mobile devices that make it easy for someone to just guess your password? Steve will talk about how good and bad passwords are constructed as well as how to break them with social engineering, dictionary attacks, brute force attacks and more. Learn why most passwords stink so you can protect yourself and your users.

Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Steve Pitcher is a Solutions Expert on Systems Administration and Security with iTech Solutions Group and an Industry Analyst at MC Press Online. He’s been a specialist in IBM i solutions since 2000 with an emphasis on modernization, security and collaboration products. Steve has... Read More →


Wednesday April 8, 2020 12:30pm - 1:45pm
(G) Middlesex West

12:30pm

Quick Start Options to Gain Speed to Value with Db2 Web Query EZ-Install
You've heard about Db2 Web Query but are wondering what the value is to you. This session reviews how to get started quickly with the new EZ-Install package and includes many sample reports for business users and system administrators. Leverage the Query/400 Discovery tool for analysis of the hundreds of archaic reports on your system. Use the wizards to generate more samples over your data. Learn how to get trained on additional capabilities with tutorials and quick start services.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Wednesday April 8, 2020 12:30pm - 1:45pm
(E) Ashland

12:30pm

SQL User Defined Table Functions (UDTF) – Hidden Secrets
Data located within tables or physical files can be accessed, filtered and accumulated by executing a SQL SELECT statement. Creating and using SQL views instead of joining the tables and accumulating the data manually or within the source code helps to mask complexity and to reduce the source code. If the request can be fulfilled with a more or less complex SELECT statement, a view is the perfect tool. But if multiple statements must be performed for a single request, some type of program, either a stored procedure or a UDTF is needed. A User Defined Table Function (UDTF) is a program written either in SQL or a HLL (High Level Language such as RPG) that returns a table of data (x columns and y rows). A UDTF must be specified in the FROM clause of a SELECT statement. With external (written in a HLL) UDTF it is even possible to access non-database objects such as data areas, user spaces and IFS files and consume the data directly with SQL.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Wednesday April 8, 2020 12:30pm - 1:45pm
(D) Commons I

12:30pm

Tips and Tricks to Improve System Performance and Save Disk Space
What can you do to stop the rampant growth of data that’s eating up disk space? How do you improve system performance? Come to this session to find out how to make the most out of your existing configuration by leveraging the many optimization and cleanup techniques that are a part of i5/OS, including reorganization of physical files, sharing of access paths, and using the DISKTASK command. Pinpoint how to reduce your disk I/O by reorganizing files and clean up your system using the Retrieve Disk Information (RTVDSKINF) and Retrieve Directory Information (RTVDIRINF) commands. Learn how sharing access paths can reduce disk utilization and memory faulting. Know your options for reorganizing your files while your users continue to access them.

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 April 8, 2020 12:30pm - 1:45pm
(A) Grand South

2:00pm

One Order of Refactoring with a Side of RDi
Sloppy code, beautiful code. They both produce the same results, so who cares how it looks? If you have heard this before, or are living with this scenario, this is a MUST ATTEND session. Learn about code refactoring (aka "modernization") through real life examples and discussion to help rejuvenate old code into maintainable, flexible and scalable components. We will also review how RDi can assist in this process.

Speakers
avatar for Charlie Guarino

Charlie 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 April 8, 2020 2:00pm - 3:15pm
(A) Grand South

2:00pm

Stored Procedures and PHP on IBM i (Intermediate)
Db2 stored procedures offer great flexibility and ubiquity in accessing resources like Db2 data and HLL programs. This presentation explores the creation of SQL and RPG stored procedures for business applications. It examines how those stored procedures can be used in PHP scripts to bring legacy information to the web using quick and easy methods. The session highlights lots of PHP examples that can be easily replicated when the attendees return to the office.

Speakers
avatar for Mike Pavlak

Mike Pavlak

IBM i Strategist, Fresche Solutions
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 April 8, 2020 2:00pm - 3:15pm
(C) Commons II

2:00pm

Rapid Fire Admin
This overflowing session is designed to help ensure every IBM i administrator and operator has at least a backpack full of valuable tips for when they return home. From command line to shell to IBM Navigator for i, Steve will sprint through these tips at a pace of at least two tips per minute, for at least 150 tips! This session is updated every quarter with new and relevant information so that you don't miss good foundational tips but are keeping up with what updates IBM is releasing on a regular basis.

Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Steve Pitcher is a Solutions Expert on Systems Administration and Security with iTech Solutions Group and an Industry Analyst at MC Press Online. He’s been a specialist in IBM i solutions since 2000 with an emphasis on modernization, security and collaboration products. Steve has... Read More →


Wednesday April 8, 2020 2:00pm - 3:15pm
(G) Middlesex West

2:00pm

Temporal Tables – Time Travel with Db2 for i
What are temporal tables? A new feature in Release 7.3! Temporal tables are traditional data (physical) files or SQL Tables linked with a history table with the same structure as the base file/table. When updating or deleting a row the row before manipulation is automatically stored in the history table. In this way history tables can be used for auditing purposes. The main advantage of however of a temporal table is, it can be queried for any timestamp in the past (after the creation date). So for reprinting the inventory report for the last month, simply the temporal system time of the current job must be set and the program must be executed.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Wednesday April 8, 2020 2:00pm - 3:15pm
(E) Ashland

2:00pm

Monitoring your IBM i and Data Center with Nagios
Monitoring your datacenter and your IBM i can often be a difficult task. Especially if you are using different tools for each component. With Nagios you can now easily see everything in your data center on a single interface!  Get alerts, notifications and see dynamic graphs that include metrics for your IBM i.

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 →


Wednesday April 8, 2020 2:00pm - 3:15pm
(D) Commons I

2:00pm

Subsystem Configuration for Server Jobs
There are many types of server jobs on IBM i, which all have a system-supplied default subsystem in which they run. This presentation will review how to configure your system so server jobs can run in customized subsystems. Subsystem configuration has benefits for performance considerations as well as making it easier to understand what works is done by these server jobs. This session will review how to configure the subsystems for the host servers, SQL server mode jobs, the HTTP Server, FTP, SMTP, SSH, and more.

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on work management, systems management, performance, and diagnostics, with intimate knowledge of the IBM i operating system developed through her distinguished career with IBM. Today, as an independent consultant, she focuses her skills on helping companies... Read More →


Wednesday April 8, 2020 2:00pm - 3:15pm
(F) Carlisle

3:15pm

3:45pm

RDi and Git – The Basics
What are the steps to getting your source code stored in a Git repository, be it on IBM i or externally, such as on GitHub? We will go through the entire process step by step so you can learn the fundamentals, using the eGit perspective in RDi.

Speakers
avatar for Charlie Guarino

Charlie 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 April 8, 2020 3:45pm - 5:00pm
(C) Commons II

3:45pm

CI/CD Workflow for RPG
This talk covers all the different parts of Continuous Integration/Continuous Delivery
that you need to deliver RPG (or COBOL, C, etc.) applications with speed, safety and
reliability. You’ll learn why using Git is an important part, how to move applications
around different environments, how to use GitHub for repo management and code
reviews, and how open-source tools can help you achieve this functionality.

Speakers
avatar for Liam Allan

Liam Allan

Software Advocate, Works Of Barry
Liam Allan, an IBM Champion, helps IBM i development teams modernize their applications and bridge the gap between traditional and modern development practices. Founder of Works of Barry, he specializes in DevOps, RPG, ILE, Node.js, PHP, PASE and open source. He also supports the... Read More →


Wednesday April 8, 2020 3:45pm - 5:00pm
(F) Carlisle

3:45pm

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

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →


Wednesday April 8, 2020 3:45pm - 5:00pm
(D) Commons I

3:45pm

Quick Wins on Improving SQL Performance
This session will provide an overview of the DB2 SQL performance tools and methods included in IBM i. Topics include Visual Explain, the Index Advisor and the SQL Plan Cache. These options leverage 'always available' information to make powerful tools readily available to the database engineer.

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →


Wednesday April 8, 2020 3:45pm - 5:00pm
(E) Ashland

3:45pm

Manage Work Better with Better Work Management
The IBM i 7.2 and later releases include significant enhancements for managing temporary storage on IBM i; the management of temporary storage is now more robust and there are additional ways to determine what jobs are consuming temporary storage.  In addition to improved temporary storage management, both IBM i 7.2 , 7.3, and 7.4 releases all have additional changes to better manage your IBM i.

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
Dawn May is a leading authority on work management, systems management, performance, and diagnostics, with intimate knowledge of the IBM i operating system developed through her distinguished career with IBM. Today, as an independent consultant, she focuses her skills on helping companies... Read More →


Wednesday April 8, 2020 3:45pm - 5:00pm
(G) Middlesex West