Loading…

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

Sunday, September 8
 

8:00am EDT

A1AA WORKSHOP: 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 20 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. Since Release 6.1 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. XML functions for generating and consuming XML data located in either a table or within the IFS were introduced in release 7.1. 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 SQL Select Statement. Learning Objectives: Expand your SQL know-how with not-widely known scalar functions for string handling including regular expressions or numeric rounding. Handle different conditions with case-clauses within a single SELECT-Statement. Use multi-dimensional grouping for building totals. Join and merge tables and views. Instead of coding several SQL statements or building temporary tables, use sub-selects and/or common table expressions (CTE) including recursive CTE. Learn how recursive data can be analyzed.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →


Sunday September 8, 2019 8:00am - 12:00pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Database

8:00am EDT

A1AI WORKSHOP: IBM i and Power Systems Management Part One — Keeping It Current and Best Practices
There are two half days broken up into two logical sections:

In Part One, we will discuss keeping things current along with best practices on your HMC, your System, and the IBM i Operating system.

In Part Two, we will discuss day-to-day systems management tasks including monitoring, some system tuning, system clean-up, and spooled file handling.

Note that Part One is NOT a prerequisite for Part Two.

PART ONE TOPICS:

Setup and verify of Call Home functions on the HMC. Setup of a limited HMC user. A review of HMC command line capability including watching HMC disk space.

Setup and verify of Call Home functions in IBMi. What and how to set them up and how to test them to be sure your system is protected.

PTF Review and processing. We'll discuss how to find out your current levels and how to get new levels and tools to help you install them. This will include PTF Groups and Image catalogues. We'll also touch on HMC Updates, Flexible Service Processor (FSP) updates, why, when and how.

Validating your network configuration to assure it is correct and settings to review for best performance and reliability.

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →


Sunday September 8, 2019 8:00am - 12:00pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

1:00pm EDT

A5AA WORKSHOP: SQL Programming
SQL is much more than a query language. Besides querying and manipulating data in database objects and generating those database objects, SQL also provides all kinds of commands and constructs, for writing and executing programs. With the SQL Programming Language, Stored Procedures, Triggers and User Defined (Table) Functions can be written, without knowing anything else than SQL commands! This session will give you an introduction into the SQL Programming Language. The procedure and function create options and controls are explained. You’ll learn how to structure the source code within the routine body, how to define variables and cursors, what control statements are available, how to read data row by row in a loop, how to receive and return parameter values and result sets and how to handle errors. Besides the pure coding you’ll get also a short introduction into the development tools.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →


Sunday September 8, 2019 1:00pm - 5:00pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Database

1:00pm EDT

A5AI WORKSHOP: IBM i and Power Systems Systems Management Part Two — Daily System Monitoring, Tuning, Clean-up, and Spooled File Handling
There are two half days broken up into two logical sections:

In Part One, we will discuss keeping things current along with best practices on your HMC, your System, and the IBM i Operating system.

In Part Two, we will discuss day-to-day systems management tasks including monitoring, some system tuning, system clean-up, spooled file handling.

Note that Part One is NOT a prerequisite for Part Two.

PART TWO TOPICS:

Explore graphical methods for monitoring IBM i Performance. This includes Management Central and IBM Navigator for i System Monitors.

Things to watch out for: Memory usage, Disk I/O and storage, avoiding dead cash batteries. Message queues to use to keep the finger on the pulse of your IBM i.

Storage Management - Discover your disk and what's filling it. Tips for deciding on what doesn't need to be there.

Various System values you should understand.

Spool file maintenance including use of iASPs, Joblog Servers, and disconnected spool file functions.

This workshop will focus on key items that should be set up and managed on your system to assure it is running well and stays that way!

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →


Sunday September 8, 2019 1:00pm - 5:00pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

5:15pm EDT

A8AH Young i Professionals (YiPs) Networking Event
Young IBMi Professionals  are encouraged to come meet fellow conference attendees during this networking event. Join us on the third floor in the Studio Lounge to enjoy hors d'oeuvres, ice breakers, networking game, and prizes! 

Speakers
avatar for Richie Palma

Richie Palma

Tech Solutions Consultant, iTech Solutions
A Tech Solutions Consultant for iTech Solutions Group, IBM Champion for Power, IBM Fresh Face, founder of the “Midrange Meetup” in Grand Rapids, Michigan, on the steering committee for YIP’s (Young i Professionals), and on the board for SEMIUG (South East Michigan IBM i User... Read More →
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →
avatar for Rochelle Petty

Rochelle Petty

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


Sunday September 8, 2019 5:15pm - 6:15pm EDT
Studio Lounge One South Capitol Avenue, Indianapolis, Indiana, United States, 46204
 
Monday, September 9
 

8:00am EDT

11AC COMMON Opening Session
The Opening Session officially kicks off 2019 Fall Conference & Expo. Start your week off right by attending. Hear an update from COMMON's President, Larry Bolhuis, and business updates from IBM Executives. See you at 8:00 a.m. Monday.

Monday September 9, 2019 8:00am - 9:15am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

9:30am EDT

12AA Moving from Power7 to Power9
Are you on a POWER7? This seminar will make a case on why moving to POWER9 could be a good move for business, and tips on how to get you there.
This webinar will cover:
Key differences between POWER7, POWER8, and POWER9
POWER9 Server specifications and details to know about
POWER9 Chips specifications and details to know about
What to look out for when moving from POWER7 to POWER9, including
compatibility, LAN consoles, HMCs, and more
Upcoming dates for End of Support to be aware of
Roadmap of Power processors

Speakers
avatar for Pete Massiello

Pete Massiello

President, iTech Solutions
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →



Monday September 9, 2019 9:30am - 10:30am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204

9:30am EDT

12AG Speed Dating with a Date Dimension Table
Simplify date processing and extend applications and reports with additional date attributes through the use of a Date Dimension Table. IBM supplies a date dimension sample table and routines to create your own in the Db2 Web Query EZ-Install package, and this session will show you how to extend legacy date formats in your data (can you say "packed 8 decimal"?) for simplified, extensible date processing.

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

Speakers
avatar for Doug Mack

Doug Mack

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



Monday September 9, 2019 9:30am - 10:30am EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Database

9:30am EDT

12AI The best of ACS!
IBM i Access Client Solutions (ACS) is the stratigic 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 Scott and 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 for the database developer and administrator, and how they are in many cases better than what you've been using! Learning Objectives: 1. Discover the latest features in Run SQL Scripts, SQL Performance Center, and more 2. Revisit the IBM i system access and management strategy 3. Live Demo !!

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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



Monday September 9, 2019 9:30am - 10:30am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Middleware (other)

9:30am EDT

12AB Open Source Applied - Real World Use Cases
This isn't your typical case study, this is the reality of open source: One hundred percent of organizations use varying degrees of OSS, yet we still focus on one particular package or layer when it comes to sharing best practices. The reality is, when we get stuck, it's the configuration and operational interrelationships between packages that matter.

This session takes open source support data across multiple organizations to examine three different scenarios that represent the most common issues we see today (in fact, 80% of the cases we see are due to configuration and package interrelationship issues). Justin Reock covers e-commerce, mobile PaaS, and high performance computing examples to illustrate top problems and solutions for stack selection, infrastructure implementation, and production troubleshooting.

If you use or are planning to use Apache web server, ActiveMQ, CentOS, Docker, Kubernetes, Nginx, OpenSSL, Puppet, or PHP, these stories cover how most organizations use them. Even if you're not using these specific packages, the information presented here also applies to other technologies.

Learning Objectives:

Speakers
avatar for Justin Reock

Justin Reock

Chief Architect, OpenLogic by Perforce
Justin has over 20 years’ experience working in various software roles and is an outspoken free software evangelist, delivering enterprise solutions and community education on databases, integration work, architecture, and technical leadership. He is currently the Chief Architect... Read More →



Monday September 9, 2019 9:30am - 10:30am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

9:30am EDT

12AD What's The Fuss? - Using Procedures and Service Programs
This session discusses the advantages of using modern techniques in your RPG programs. After a short introduction to modularity in programming; we go step-by-step through the process of replacing called programs with sub-procedure modules and then converting these modules to procedures in a called service program. Learning Objectives: 1 Internalize the benefits of using modular coding practices.
3 Understand the steps in coding modular subprocedures and service programs.
2 Develop reusable subprocedures and service programs.

Speakers
avatar for Jim Buck

Jim Buck

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



Monday September 9, 2019 9:30am - 10:30am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204

9:30am EDT

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

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

Speakers
avatar for Scott Klement

Scott Klement

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



Monday September 9, 2019 9:30am - 10:30am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

9:30am EDT

12AE Introduction to the IBM i Performance Data Investigator
IBM Navigator for i has a rich set of performance tasks that include many traditional i performance management capabilities. It also has the ability to manage your performance data collections. The most exciting feature is the `Investigate Data` task, which provides the ability to graphically view your IBM i performance data through a browser interface; Collection Services, Disk Watcher, Job Watcher, and Performance Explorer data can all be 'investigated'. This session will go through the capabilities of the Performance Data Investigator, including an overview of many exciting enhancements that have been been added in the 7.2 and 7.3 releases. You will learn how to look at your performance data through the Performance Data Investigator, discover various IBM-supplied views of your performance data, and how you can use PDI for performance reporting.

Learning Objectives:
1. Learn what the Performance Data Investigator is and how to access it.
2. Learn about many of the type of graphs you can use to view Collection Services data.
3. Learn how to create performance reports.

Speakers
avatar for Dawn May

Dawn May

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



Monday September 9, 2019 9:30am - 10:30am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

9:30am EDT

12AC Speed up Your Web Site
In this talk, Alan will share techniques that can improve web performance within minutes. Alan recently helped a company's site speed up by 10x with a single tip. Alan will focus on free tools that help diagnose performance bottlenecks, how to configure the Apache web server for speed, and demonstrate the techniques on live sites.

Learning Objectives:
How to identify possible performance bottlenecks at a glance
A few easy changes in the Apache web server configuration that can improve performance
What to look for after the initial, quick improvements

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group



Monday September 9, 2019 9:30am - 10:30am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Web Applications

10:45am EDT

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

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

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Monday September 9, 2019 10:45am - 11:45am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Application Development

10:45am EDT

13AG Stop Building Data Extracts for BI/Analytics!
Building work files, temp files, and extracts can be unproductive, add extraneous processing, and creates too many copies of (unsecure?) data. In this session we will talk about simplifying and automating processes to eliminate custom extract programs. We'll cover tools like DataMigrator, why the data warehouse might make sense, and streamlining creation of PDFs or Excel files outputs w/o having to reverse engineer spool files.

Learning Objectives:
1. learn about simplifying and automating data transformations and replication.
2. Understand how Db2 Web Query can eliminate many extra steps currently in place to get data into a spreadsheet or visualization tool.
3. Learn about an IBM i based ETL tool that you probably haven't heard of.

Speakers
avatar for Doug Mack

Doug Mack

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



Monday September 9, 2019 10:45am - 11:45am EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Database

10:45am EDT

13AI Revving Up SQL Performance with (Database) Indexes
One of the most important things needed to improve SQL performance is to have the proper indexing over files, especially as the files grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them. This session will provide background on indexes, explains why they are so important, and gives you the knowledge to be more confident in defining and using them.

Learning Objectives:

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 →



Monday September 9, 2019 10:45am - 11:45am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

10:45am EDT

13AF VENDOR: Green Screen UI Modernization for Busy IBM i Developers
When approaching your green screen modernization project, a screen-by-screen approach can seem quick and simple. But when you have to build UIs for hundreds of screens - then maintain and update them - you might realize that this approach requires a lot of time and effort.

Join Greg Patterson to see how quickly you can modernize your green screens using automated modernization solutions. You’ll learn how Newlook and Presto:

-Turn your 5250 applications into modern UIs that you can deliver on any device

-Show you a heatmap of screen usage to know where to focus efforts

-Quickly modernize applications with global rules and settings

-Integrate with web applications, APIs / web services and web portals

-Automatically enable your applications for mobile devices

Speakers
avatar for Greg Patterson

Greg Patterson

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



Monday September 9, 2019 10:45am - 11:45am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

10:45am EDT

13AB POWER PICK: Future of Open Source on IBM i
The world of open source is fast-moving and exciting, with innovation happening at mind-numbing speeds! Come to this session for some updates on the latest or coolest stuff that's available at your fingertips!

Learning Objectives:
1. Get the latest news about open source on IBM i

Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

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



Monday September 9, 2019 10:45am - 11:45am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

10:45am EDT

13AC PHP Syntax
PHP is the most popular open-source scripting language for coding business logic into web applications. This session will help you to get your feet wet with PHP by going through the syntax of the language and exploring basic capabilities. Both procedural and Object Oriented (OO) coding is supported by PHP and while this session will stay mainly focused on procedural an introduction to Object Oriented programming in PHP will be provided.

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

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



Monday September 9, 2019 10:45am - 11:45am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

10:45am EDT

13AA Building an IBM i partition, from scratch, Live and in Color!
This session is a live build of an IBM i guest partition. We will create each of the components needed through the HMC for both the host and the guest. Then on the host we’ll create the IBM i NWS configuration objects and storage and connect those pieces. Finally, we’ll create the partition itself, all in 60 minutes! Audience input will influence the build!!

Learning Objectives:
Understand just how simple it is to create a guest partition on IBM i.
Learn the components required to turn your standalone partition into a host partition.
Learn some of the options that influence how the guest partition is installed and started and stopped.
Learn a few tricks for customizing your host partition so you don’t have to remember every time!

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →



Monday September 9, 2019 10:45am - 11:45am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Virtualization

11:30am EDT

COMMON Expo
Monday September 9, 2019 11:30am - 1:30pm EDT
Cosmopolitan Ballroom

12:00pm EDT

Lunch in the COMMON Expo
Monday September 9, 2019 12:00pm - 1:00pm EDT
Cosmopolitan Ballroom

1:30pm EDT

15AG KEYNOTE: Hey, What's the Big i-dea?
You already know your i can do everything short of leaping tall buildings in a single bound. And you're here at the Fall COMMON conference developing the skills needed to build world-class applications on i... applications your users will love to use! But where do you start once you get back home? Sometimes all that's missing is an idea. Come to this keynote to be inspired by two success stories of customers who started with an i-dea, and built amazing business solutions on i.

Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →
avatar for Gordon Leary

Gordon Leary

AMPORTS, Inc
Gordon is the IT Manager of AMPORTS, Inc. and has been involved with the IBM midrange community since 1987. AMPORTS is an automotive port processor with locations in the US and Mexico. Gordon has attended COMMON conferences since 1988, and in the last several years, he has participated... Read More →


Monday September 9, 2019 1:30pm - 2:30pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  IT Strategy

2:45pm EDT

16AB Sponsor: Improve IBM i Developer Productivity by 50%
Do you ever find yourself thinking, "There has to be a better way to do this?”

With automated analysis and modernization tools, you can reduce the time spent managing IBM i applications and onboarding new developers, move projects forward faster, and reduce the risks involved in making changes to your code.

In this session, Fresche’s Ray Everhart demonstrates the business value derived from application documentation, analysis and better understanding of your IBM i applications.

You’ll see:

· Automated graphical documentation that makes it easy for IT to visualize and understand application design and flow.
· Powerful impact analysis that tracks “where used” information so you can make code changes with confidence.
· How IBM i organizations have used X-Analysis to save significant developer time and better understand their applications.


Speakers
avatar for Ray Everhart

Ray Everhart

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


Monday September 9, 2019 2:45pm - 3:45pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Application Development

2:45pm EDT

16AI Using DB2 and SQL with Open source languages
DB2's ever-expanding capabilities can simplify development in open source languages such as PHP, Ruby, Node.js, and Python. These languages, known for their ease in building web and mobile applications, can run most types of SQL, but why complicate them with repetitive database code that distracts from their power and simplicity? This talk shows examples of how to reduce tedious coding by using such DB2 structures as Views, User Defined Functions, stored procedures, Row and Column Access Control (RCAC), LIMIT/OFFSET, exciting new DB2 Services, and more. Security, performance, and ease of maintenance in the open source scripting languages will be the result of the recommendations and techniques given in this talk

Learning Objectives:
  • Learn DB2 techniques that improve security, performance, simplicity 
  • Understand how coding in open source scripting languages can be made simpler and more powerful by use of DB2's modern capabilities.

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

Alan Seiden

Principal, Seiden Group



Monday September 9, 2019 2:45pm - 3:45pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

2:45pm EDT

16AD How to Ensure the Success of Every Project You Work On
Successful projects are key to a successful business. How do you navigate the process and ensure your projects are a success? By attending this session of course! We will talk about and address: barriers and threats to success; key elements to forming teams and how to be a successful team player; leadership essentials; why communication is paramount to any successful project, what needs to be communicated at all times, how to have effective meetings, and how to excel at all forms of communication; managing relationships; essential elements of schedules; how to resolve problems; and the importance of customer involvement and high integrity communication.

Learning Objectives:

Speakers
avatar for Kim Greene

Kim Greene

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

Richie Palma

Tech Solutions Consultant, iTech Solutions
A Tech Solutions Consultant for iTech Solutions Group, IBM Champion for Power, IBM Fresh Face, founder of the “Midrange Meetup” in Grand Rapids, Michigan, on the steering committee for YIP’s (Young i Professionals), and on the board for SEMIUG (South East Michigan IBM i User... Read More →



Monday September 9, 2019 2:45pm - 3:45pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Developing Business Skills

2:45pm EDT

16AG PANEL: Women in IT – IBM Power Systems - Did you Know?
A Panel of Women with varied backgrounds will discuss IBM Power Systems Highlights.
Watson, IBM Q, Power9 Servers at Google, Pangea III – world’s most powerful commercial supercomputer is based on IBM Power9 and MORE!

All are welcome! Share your knowledge!

Moderators
avatar for Sue Zimmermann

Sue Zimmermann

Application Manager, HarrisData
Sue  is currently  an Application Manager in R&D  at HarrisData.  HarrisData is an IBM ISV that has been providing ERP/Payroll  software for IBM mid-range platforms for over 48 years.Armed with a ‘Total Data Processing’ Certificate that included a 6 week course in COBOL and... Read More →

Speakers
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →
avatar for Kelly Mason

Kelly Mason

Kelly is an EDI specialist and software developer for Central Park Data Systems for just over a year. She has been in IT for 5 years with an Associate’s degree in software development. She was continually on the Dean’s list and graduated in May of 2015 with presidential honors.Kelly... Read More →
avatar for Michelle Lyons

Michelle Lyons

Chief Operating Officer, imPower Technologies
Michelle is an independent IBM i consultant and co-owner of imPower Technologies with Jim Buck. She has been actively involved in the IBM i community – volunteering for COMMON, working on the annual “Women in IT” Event for Wisconsin Midrange Computer Professional Association... Read More →
avatar for Rochelle Petty

Rochelle Petty

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

April Medinger

Harris Data
Teaching herself how to design graphics and develop basic HTML websites as a hobby in high school, April designed many websites for friends and non-profit organizations in her spare time. After serving in the United States Air Force, April decided to turn her passion for website and... Read More →


Monday September 9, 2019 2:45pm - 3:45pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  IT Strategy

2:45pm EDT

16AA IBM i Meets IoT
Want to communicate between your Node.js applications and small devices? Come learn about MQTT - a machine-to-machine (M2M)/"Internet of Things" connectivity protocol. This talk will provide an introduction to MQTT, examples of how to use it with Node.js and then finish up with some demos of using on IBM i as well as using it for home automation.

Learning Objectives:
1. Learn what MQTT is and its key characteristics
2. Learn how to use MQTT to connect devices to your applications

Speakers


Monday September 9, 2019 2:45pm - 3:45pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

2:45pm EDT

16AF The World of Node.js On IBM i
Node.js is just getting started, but it is very hot! Everyone seems interested in getting started with this language today, and it may very well represent the future of Application Development on IBM i. In this session, we'll look at Node.js, discuss how it works and how to write simple applications. Then, we'll take a look at the Node Package Manager (npm) and the power it brings to the Node.js environment.

Learning Objectives:
1, Why Node.js? How do you learn it?
2. The value of the "eco-system" surrounding Node.js
3. Demonstration of putting together some Node.js modules to build a business application

Speakers
avatar for Scott Klement

Scott Klement

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



Monday September 9, 2019 2:45pm - 3:45pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

2:45pm EDT

16AC Clean up your IBM i Disk
How much disk storage do you have on your system? The most common answer is 'not enough!' Attend this session and find out where all that space went, what you can clean up, and what should be left alone. Learn about reporting, automating, and managing your disk space in IBM i. Develop a deeper understanding of the tools IBM has built into IBM i and how to leverage them to help keep your system clean. Especially learn how to leverage SQL to find consumers of disk QUICKLY! Walk away with a solid understanding of how to clean up your disk space both QSYS and the IFS.

Learning Objectives:
  • How to determine where all your disk space has gone.
  • How to clean up unused space in physical files.
  • How to search for object filling up the IFS
  • How to use *nix and PASE tools to work in the iFS.
  • How to use SQL to find disk users and usage.

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →



Monday September 9, 2019 2:45pm - 3:45pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

2:45pm EDT

16AE IBM i Services for the System Administrator
IBM i Services - certainly you've heard about these SQL interfaces and how they can provide access to useful system information; many of these services are very useful for system administrators. This presentation will review several of these IBM i Services and how you can use them to improve or customize the management of your IBM i partition.   Attend this session to add new tools to your management toolbox.

Learning Objectives:

Speakers
avatar for Dawn May

Dawn May

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



Monday September 9, 2019 2:45pm - 3:45pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

4:00pm EDT

17AD Date and Time Calculation with SQL
Calculating date and time values correctly within commercial applications can be critical. SQL has become very powerful in date calculation and date operation functions. In this way SQL includes multiple functions for converting character representations of a date/time value into a real date/time value and vice versa. There are a lot of functions for calculating time differences or determining date information, such as the day of week or the date of the next wednesday without using a calendar table. This session will give you an overview over the SQL scalar functions for date and time calculation.

Learning Objectives:
  • Convert character and numeric date and time values into real date and time data types. 
  • Calculate date and time differences
  • Retrieve date and time information from a date and/or time value or expression, such as the numeric day of week, the week according the ISO guidelines and much more.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Monday September 9, 2019 4:00pm - 5:00pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Database

4:00pm EDT

17AG What's New in Db2 Web Query? LOTS!
You own it. You may have looked at it many years ago. Today’s Version 2.2.1 is night and day different than the original version, including the “easy button” for creating sample reports, many new visualizations like geographical maps and responsive dashboards, and data replication and transformation tools. This session reviews this low cost business intelligence solution, with updates on the latest cool enhancements.

Learning Objectives:
1. Learn the fundamental features of DB2 Web Query for i
2. Understand how to put it to quick use with creation of templates out of the box
3. Learn about the latest features that you own

Speakers
avatar for Doug Mack

Doug Mack

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



Monday September 9, 2019 4:00pm - 5:00pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Database

4:00pm EDT

17AI SQL Views for Dummies
SQL views provide the modern user interface to obtain system level information traditionally available via OUTFILE and API support.  Attend this session and learn how easy it is to use a SQL view. SQL views provide the administrator of the system easy access to lots of system configuration and management information. This session will provide a list of available SQL views and their purpose as well as examples of how to use them. I will explain how the examples work and you'll leave with the skills necessary to be a better and more system administrator.  This is not an introduction to SQL class, but rather an explanation of why you need to add SQL to your toolset and a quick-start guide showing you how to become a better systems administrator or security officer. http://ibm.biz/DB2foriServices

Learning Objectives:
1. Understand the SQL alternatives to IBM i Commands and APIs.  2. Learn how to leverage SQL to get things done, without being an SQL expert.  3. Gain knowledge of the different ways SQL based IBM i Services can be used.

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 →



Monday September 9, 2019 4:00pm - 5:00pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

4:00pm EDT

17AF IBM i 7.4 and Other New Things
IBM i has so many features and functions, it's impossible to know about them all, so in this session, Tim Rowe will give an overview of the most recent capabilities which have been produced for IBM i, so you can be up-to-the-minute up-to-date! Learning objectives: 1. Learn the biggest items most recently delivered for IBM i 2. Be able to describe the business value of those new enhancements 3. Hear a brief overview of many of the other important enhancements so you can learn about them more completely at other sessions.

Speakers
avatar for Tim Rowe

Tim Rowe

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



Monday September 9, 2019 4:00pm - 5:00pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  IT Strategy

4:00pm EDT

17AB Getting Started with Node.js
Learn to leverage the power of server-side Javascript with this Node.js introductory tutorial. We’ll dive into Node’s architecture and understand the build and dependency management systems involved. Several modules for Node will be demoed, and we’ll learn how to debug Node applications within an IDE. You’ll come away with an understanding of what sets Node apart from traditional Javascript, it’s inherently asynchronous and event-driven architecture, and take a look at some real world applications built on Node.

Learning Objectives:

Speakers
avatar for Justin Reock

Justin Reock

Chief Architect, OpenLogic by Perforce
Justin has over 20 years’ experience working in various software roles and is an outspoken free software evangelist, delivering enterprise solutions and community education on databases, integration work, architecture, and technical leadership. He is currently the Chief Architect... Read More →



Monday September 9, 2019 4:00pm - 5:00pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

4:00pm EDT

17AC Understanding PHP Frameworks
Frameworks are a great way to bring structure to your PHP development. When properly utilized frameworks can speed up the development effort by putting an end to the need to develop repetitive code. This session will explore the basic concepts of frameworks and highlight some of the more popular PHP frameworks including Zend Frameworks, Laravel, and Symfony.

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

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



Monday September 9, 2019 4:00pm - 5:00pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

4:00pm EDT

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

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

Speakers
avatar for Ray Everhart

Ray Everhart

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


Monday September 9, 2019 4:00pm - 5:00pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

4:00pm EDT

17AA HMC, IBM I, FSP, & Firmware: Putting All the Pieces Together
Come to this session and dissect all the new components and concepts involved with partitioning your IBM Power Systems. Learn how all the pieces connect to each other, what you need to do to set them up, and how to manage and upgrade them. Get a handle on the various components of the Hardware Management Console (HMC), the Flexible Service Processor (FSP), and the Advanced Systems Management Interface (ASMI). Find out about the firmware in your machine, and how to make the required updates to it in an LPAR environment or on a standalone machine. Get tips for upgrading and setting up communications between the HMC and FSP as well as insight on where the ASMI fits in. Leave this session with up-to-date knowledge on these important hardware features of IBM PowerSystems & IBM i

Learning Objectives:
1) Understand how to upgrade & update your HMC.
2) Understand how to upgrade your FSP.
3) Learn how everything connects and interacts.

Speakers
avatar for Pete Massiello

Pete Massiello

President, iTech Solutions
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →



Monday September 9, 2019 4:00pm - 5:00pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

5:15pm EDT

18AI How to Write DB2 for IBM i SQL Stored Procedures
How to Write DB2 for IBM i SQL Stored Procedures. Making the most of SQL procedures by leverage the full power of the language

Learning Objectives:
1. Determine when to write an SQL procedure 2. Using more advanced techniques to more fully leverage the programming language's capabilities

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 →



Monday September 9, 2019 5:15pm - 6:15pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

5:15pm EDT

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

Learning Objectives:

Speakers
avatar for Kim Greene

Kim Greene

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



Monday September 9, 2019 5:15pm - 6:15pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204

5:15pm EDT

18AB Node.js Deeper Dive
You’ve taken your first steps into Node.js. You’ve learned how to initialize your projects, you’ve played with some dependencies, and you’re ready to get into some serious Node work. In this session, we’ll dive further into Node as a framework. We’ll learn how to master Node’s inherently asynchronous nature, take advantage of Node’s events and streams capabilities, and learn about sophisticated Node deployments at scale. Participants will leave with a richer understanding of what Node has to offer and higher confidence in dealing with some of Node’s more difficult concepts.

Learning Objectives:

Speakers
avatar for Justin Reock

Justin Reock

Chief Architect, OpenLogic by Perforce
Justin has over 20 years’ experience working in various software roles and is an outspoken free software evangelist, delivering enterprise solutions and community education on databases, integration work, architecture, and technical leadership. He is currently the Chief Architect... Read More →



Monday September 9, 2019 5:15pm - 6:15pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204

5:15pm EDT

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

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

Speakers
avatar for Scott Klement

Scott Klement

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



Monday September 9, 2019 5:15pm - 6:15pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

5:15pm EDT

18AG POWER PICK: Intro to Unit Testing RPG Using IBMiUnit
We will learn how to unit test your RPG code using iUnit, an RPG unit testing framework written by Marina Schwenk and Steve Johnson-Evers. We will learn how to automate your testing process once you get your test written and you have to run them over and over again. We will go through basic unit testing concepts, how to setup the project and write your own unit tests and how to identify parts of the program that you can break up into pieces that you can verify with your unit tests.

Speakers
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →



Monday September 9, 2019 5:15pm - 6:15pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204

5:15pm EDT

18AE 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.

Learning Objectives:
The attendee will learn how to better manage prestart server jobs. The topics are many, but will include managing job logs and output, using Watches to debug intermittent problems, determining what the job is doing, including the SQL statement the job is running, how to determine the rate at which prestart jobs are being used and reused, and much more.

Speakers
avatar for Dawn May

Dawn May

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



Monday September 9, 2019 5:15pm - 6:15pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

5:15pm EDT

18AA POWER Pick: Cloud Virtualization Planning and Best Practices
Transitioning from a traditional IBM Power deployment to a secure internally hosted private cloud should be front of mind. Learn how to manage the fear of change. Explore the best practices, design and planning considerations for your IBM virtualization strategy. Hear real-world experience of deploying a variety of cloud enabled solutions and the costs benefits with your private cloud. Session covers uptime, HA, Data Center considerations, Network, security business benefits. Cloud enabling your IBM i is not the future it is now!

Learning Objectives:
- Learn the benefits of IBMi virtualization
 - Justifying IBM i in your Private Cloud

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →



Monday September 9, 2019 5:15pm - 6:15pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Virtualization

5:15pm EDT

18AC Web Server Magic on IBM i
Anyone who uses a web server will appreciate the techniques shown here:
  • Security at the web server level Apache and Nginx web server tips and tricks 
  • How to configure SSL encryption (HTTPS), including using the free Let's Encrypt.
  • Create user-friendly and search-engine friendly URLs over any web application
  • Set up a load-balancing proxy server Prevent outsiders from accessing your web application
  • Change the ports (80, 443, 10080, more) and determine if they are running properly
  • How to provide multiple domain names in one Apache configuration Ensure that both “www” and non-“www” requests go to the same place
  • How to debug your configuration

Learning Objectives:
  • Understand how to secure the Apache and nginx web servers on IBM i 
  • Learn to use the most useful features, including search engine optimization, logging, and virtual hosts

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group



Monday September 9, 2019 5:15pm - 6:15pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Web Applications

6:00pm EDT

Welcome Reception in the Expo
Monday September 9, 2019 6:00pm - 8:00pm EDT
Cosmopolitan Ballroom
 
Tuesday, September 10
 

8:00am EDT

21AB DevOps from a Dev Perspective
Less hand-waving and more real-world examples! This session is a deeper drill-down into what is actually required for developers on the front-line when implementing a DevOps solution; we'll show actual examples of using iProjects and Git from RDi (no command-line needed!), how to break up your monolithic programs with actual code examples for Test Driven Development (TDD) and Model View Controller (MVC), modernizing your database access with SQL, and makefile strategies for your builds. Learning Objective: 1. Using iProjects and Git from RDi
2. Code refactoring strategies
3. Database modernization (using SQL)
4. Makefile strategies

Speakers
avatar for Andrew Clark

Andrew Clark

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



Tuesday September 10, 2019 8:00am - 9:00am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204

8:00am EDT

21AE 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.

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

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



Tuesday September 10, 2019 8:00am - 9:00am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

8:00am EDT

21AI What's New in Db2 for i
What could possibly have changed in Db2 for i since the release of IBM i 7.3 back in April of 2016?
The answer... an awful lot! Come to this session to get a grasp on the new and enhanced capabilities added into Db2 for i. We'll focus on answer the most important question of technology... "Why should I care?" when reviewing the myriad of enhancements that are waiting for you and your team to adopt. Resources: www.ibm.com/developerworks/ibmi/techupdates/i73
www.ibm.com/developerworks/ibmi/techupdates/i73-TR1
www.ibm.com/developerworks/ibmi/techupdates/i73-TR2
www.ibm.com/developerworks/ibmi/techupdates/i73-TR3
www.ibm.com/developerworks/ibmi/techupdates/i73-TR4
www.ibm.com/developerworks/ibmi/techupdates/i73-TR5
www.ibm.com/developerworks/ibmi/techupdates/i73-TR6
www.ibm.com/developerworks/ibmi/techupdates/i74

Learning Objectives:

Speakers
avatar for Doug Mack

Doug Mack

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



Tuesday September 10, 2019 8:00am - 9:00am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

8:00am EDT

21AF 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 September 10, 2019 8:00am - 9:00am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204

8:00am EDT

21AD Networking on IBM i - Best Practices
Twenty Seven years ago we had two types of connections to OS/400; Twinax, and serial-which was mostly SDLC. Since then we've transitioned to IBM i and along the way from those through Token-ring, FDDI, wireless, ISDN and IPX finally arriving at pure TCP/IP on Ethernet. Given this is the primary remaining option for anyone to connect to our systems it must be done right. Taking this lightly or simply ignoring it will not result in the most reliable connection or keep the help desk phone silent. You've seen the capabilities that IBM i has for networking and connectivity. You've seen the many enhancements that IBM has provided since the early days of IBM i 7.1. But you're not a networking expert you're an IBM i Admin or worse you're a developer! So what to do, what to do! In this session we'll go through those settings and options connecting your system to the network. We'll discuss the line description, redundancy and capacity. We'll discuss the various servers that IBM i provides and which of those should be stopped, which should be running and which need restrictions on them. We'll talk about SSL and where it should be used. Finally, we will finish with discussing PTF Maintenance.

Learning Objectives:
1. Learn the configuration options needed to assure your IBM i stays connected.
2. Learn some of the many components needed to keep your IBM i network secure.
3. Learn some of the enhancements IBM i network has received in recent releases.

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →
avatar for Wayne Bowers

Wayne Bowers

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



Tuesday September 10, 2019 8:00am - 9:00am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Networking

8:00am EDT

21AC Web Language Shootout
In this session, we'll compare some of the open source languages commonly used for web-related development and the role of RPG alongside them. Languages include PHP, Python, and Node.js (javascript). The session contains concrete information as well as a lively discussion.

Learning Objectives:
1. Learn what makes each of these languages unique
2. Get an idea of when each language would be best
3. Learn someething about web and API architecture

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group



Tuesday September 10, 2019 8:00am - 9:00am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

8:00am EDT

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

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

Speakers
avatar for Pete Massiello

Pete Massiello

President, iTech Solutions
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →



Tuesday September 10, 2019 8:00am - 9:00am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

8:00am EDT

21AG POWER Pick: IBM i Security Best Practices
This presentation will cover the best practices necessary to secure your IBM i server. Topics include why you need to run at security level 50, including examples of security exposures that exist at the lower security levels, how to detect and prevent programs that could compromise security on your system, necessary system value settings, security recommendations when developing applications, and more. If you are a system administrator or system security officer, this session is a must for you to attend.

Learning Objectives:

Speakers
avatar for Jeff Uehling

Jeff Uehling

IBM i Security Expert
Jeff Uehling is an independent consultant specializing in IBM i security. Prior to retiring from Syncsort, he worked for over 30 years at IBM where he served as lead architect for IBM i security technology. Jeff’s previous responsibilities at IBM included architecture, design and... Read More →



Tuesday September 10, 2019 8:00am - 10:15am EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Security

9:15am EDT

22AD Embedded SQL - An Introduction
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. 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.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Tuesday September 10, 2019 9:15am - 10:15am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Database

9:15am EDT

22AE Essentials of Backup/Recovery for Disaster Recovery on IBM i
A complete backup and recovery strategy is key to any business. Learn what you need to know to update your backup and recovery strategy for Logical Partition (LPAR) systems, Hardware Management Console (HMC), Lotus Notes Servers, IBM i hosted partitions, and the use of Independent ASPs. Support for backing up spooled files and performing a backup of the system data in a non-restricted state will be covered. The latest releases provide great new enhancements for logical/physical file system recovery and system recovery for journals. This session also takes you through example backup strategies and the steps needed to recover your system after a system failure or disaster.

Learning Objectives:
• Learn what changes are necessary to keep your backup and recovery strategy current and up to date.
• Be prepared for system recovery in case of a failure or disaster.

Speakers
avatar for Debbie Saugen

Debbie Saugen

Owner, Debbie Saugen Consulting, LLC
Debbie Saugen is recognized worldwide as an expert on IBM i backup and recovery, disaster recovery, and high availability. Debbie's IBM career spanned 37 years serving as the Technical Owner of IBM i Backup/Recovery and the IBM i National Lead for IBM Resiliency Services. She continues... Read More →



Tuesday September 10, 2019 9:15am - 10:15am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

9:15am EDT

22AA What's New in Domino 10
Domino 10 has a tremendous number of new features and enhancements! This session will not only explain these enhancements but will also demo a number of them. Be prepared to be blown away by how much new functionality is included in this new release!

Learning Objectives:
Learn about what's new in Domino 10.
See Domino 10 in action.

Speakers
avatar for Kim Greene

Kim Greene

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



Tuesday September 10, 2019 9:15am - 10:15am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Lotus Collaboration

9:15am EDT

22AB Getting Started with Machine Learning on IBM i
The emerging realm of AI and Machine Learning can bring seemingly-limitless opportunity for your enterprise (and perhaps even mankind). How can you leverage these new technologies from IBM i?This session will provide an overview of what technologies you can be using from your IBM i today. We will cover various AI/ML packages available to run on the system, as well as the cloud-based capability of IBM Watson. After all, IBM i has always been a data-centric platform. Surely, Db2 for i houses mission-critical and intensely valuable data. Coupling AI and ML with this data can bring an unprecedented amount of innovation.

Learning Objectives:

Speakers
avatar for Jesse Gorzinski

Jesse Gorzinski

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



Tuesday September 10, 2019 9:15am - 10:15am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Middleware (other)

9:15am EDT

22AF Mobile RPG with PhoneGap
The no charge, open source, PhoneGap environment makes it possible to create a mobile app using standard web technologies. More than just a web page, PhoneGap lets you access device features, write code that runs when the app is not connected to a network, and even distribute your app in the popular mobile stores such as Google Play and Apple's App Store.  Did you know that PhoneGap can easily be integrated with RPG and IBM i? This is a powerful way to make apps from your IBM i data that take advantage of your RPG skills.

Learning Objectives:
1. How PhoneGap Works
2. How PhoneGap Provides Access to Device Features
 3. Integrating PhoneGap with RPG on IBM i

Speakers
avatar for Scott Klement

Scott Klement

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



Tuesday September 10, 2019 9:15am - 10:15am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

9:15am EDT

22AC PHP7 – Benefits of Upgrading
While version 7 of PHP has been available since late 2015, many companies are just now looking at moving to the current version. This session will explore various features of version7, as well as highlight those features/functions from earlier versions of PHP that are deprecated in the latest version. Additionally, the session will take a look at migration strategies for moving from version 5 to version 7 of PHP and highlight how separate subsystems for version7 and version 5 of the PHP engine on IBM i can be leveraged to perform a step-wise migration of your PHP application(s).

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

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



Tuesday September 10, 2019 9:15am - 10:15am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

9:15am EDT

22AI VENDOR: Ensuring API Success on IBM i: Why Creating a RESTful API Isn’t Enough
Today’s customers expect to interact with your business through newer, more engaging web and mobile experiences. To address this, development teams must deliver innovation at a faster pace than ever before. Enter APIs and the promise of faster, simpler application development. But it isn’t that simple, and without some form of orchestration or API management, you could undermine the integrity of your new digital applications.

Speakers
avatar for Robert Young

Robert Young

Director, Rocket Software
Robert Young is responsible for the Sales Engineering Team at Rocket Software and has more than 25 years of experience in Modernization Solutions for the IBM i platform. Robert is a leading authority on Modernization Solutions helping customers to understand how to take their critical... Read More →


Tuesday September 10, 2019 9:15am - 10:15am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Web Applications

10:30am EDT

23AC POWER Pick: Enterprise DevOps
The complexity and cost of managing diverse software development toolchains is driving the IT industry to standardize on common enterprise solutions across all technology platforms. This is no less true on the IBM i platform, whose traditional tools and languages have tended to foster a specific IBM i development culture and in some cases a resistance to change. Based on IBM i customer case studies, this session will explore how the use of enterprise tools such as Git, Jenkins and Jira can reduce development effort, cost, and the risk of error.

Learning Objectives:
1. Learn about DevOps tooling
2. Learn what DevOps tools and strategies apply across multiple dev environments
3. Implement a checklist for getting started with DevOps

Speakers
avatar for Andrew Clark

Andrew Clark

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



Tuesday September 10, 2019 10:30am - 11:30am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Application Development

10:30am EDT

23AE POWER PICK: Are You Covered: Brand New Tooling for Quality Assurance
How can you easily identify holes in your test bucket? How do you know if and when your test coverage is dropping due to newly contribute code? IBM has provided brand new code coverage tools on the IBM i that is freely available. In conjunction with automated testing, this can give you hard numbers on the quality of your quality assurance. Learning Objectives: 1. Learn about the new CODECOV command available with IBM i and how it can help with quality assurance.
2. Learn how to combine this information with tooling to both analyze and automate the measuring of your test quality

Speakers
avatar for Charles Guarino

Charles Guarino

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



Tuesday September 10, 2019 10:30am - 11:30am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

10:30am EDT

23AD IBM i Access Client Solutions Deployment Guide
IBM i Access Client Solutions is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. This future is already here as IBM i ACS is the only client supported on Windows 10 and later OS, and IBM i Access for Windows is being withdrawn from support on April 30, 2109. Being a platform independent product the install or deployment of IBM i Access Client Solutions onto the workstation is approached via approaches and mechanisms unique to this product. This session will walk though the tooling and capabilities available to deploy IBM i Access Client Solutions and the best practice approaches to get this new client out in your enterprise.

Learning Objectives:

Speakers
avatar for Wayne Bowers

Wayne Bowers

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



Tuesday September 10, 2019 10:30am - 11:30am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Client Connectivity

10:30am EDT

23AI Securing Sensitive Data in DB2 for i
This session will include an overview of technologies that can be used to answer the tough data security questions and satisfy the important mandates for securing data. The session includes enhancements made at IBM i 7.3 to allow you to identify and safely remove excess authority. Technologies discussed at this session will include: Authority Collection Consumption of Journal data using SQL Row Permissions Column Masks Guardium for IBM i Securing columns from Database Engineers Adopted authority and SQL and more.Security should be a topic where clients continuously invest to reduce risk and enable real-time incident discovery. Come to this session to arm yourself with the technical knowledge you need to address this important topic.

Learning Objectives:
1. Understand how other customers are using data-centric technologies to reduce access to data.
2. Leave with the critical knowledge to frame this important topic.
3. Learn about the resources that can be tapped to help you engage on this topic.

Speakers
avatar for Doug Mack

Doug Mack

Consultant LAB Services, IBM
Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design... Read More →
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 September 10, 2019 10:30am - 11:30am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

10:30am EDT

23AF Hidden Gems of Open Source
The IBM i team has delivered over 250 open source packages in the last 18 months, alone! On top of that, the IBM i community continues to contribute even more innovation for public use. With all this stuff going on, great technology can be easily missed! Come to this session to discover open source hidden gems: things that you might have missed but should definitely know about!

Learning Objectives:

1. Learn about some of the very useful but lesser known open source goodies for IBM i.

Speakers


Tuesday September 10, 2019 10:30am - 11:30am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

10:30am EDT

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

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

Speakers
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →



Tuesday September 10, 2019 10:30am - 11:30am EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

10:30am EDT

23AB Application Security Basics
Application Security is more important than ever, but as enterprise architectures grow in size and complexity it continues to increase in relevance, making process and standards more important than ever. John Saboe got his start in application security from a developer perspective and has continued to be an advocate for building architectures the right way – including security concerns from the start – throughout his career. John will cover application security basics, demystifying some of the common terminology and standards, and introduce resources for further learning. He will also discuss examples from his own experiences as an application security consultant, as a developer, supporting architectures, and designing new architectures with security in mind.

Learning Objectives:

Speakers
avatar for Justin Reock

Justin Reock

Chief Architect, OpenLogic by Perforce
Justin has over 20 years’ experience working in various software roles and is an outspoken free software evangelist, delivering enterprise solutions and community education on databases, integration work, architecture, and technical leadership. He is currently the Chief Architect... Read More →



Tuesday September 10, 2019 10:30am - 11:30am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Security

10:30am EDT

23AA Managing IBM i PTFs
What are PTFs? Why do I need them?  How do I get them? Which ones do I need?  Does my technology really need a refresh?

In this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place. We'll help you determine what PTF strategy is the one for you and your system.

Learning Objectives:
1. What PTFs, and PTF Groups are and why you need them.
2. How to get PTFs and load them onto IBM i.
3. The use of Virtual Image Catalogs and Virtual DVD drives to save time and problems in the PTF process.
4. How to determine which PTFs you need for your system.

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →



Tuesday September 10, 2019 10:30am - 11:30am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

11:30am EDT

COMMON Expo
Tuesday September 10, 2019 11:30am - 1:30pm EDT
Cosmopolitan Ballroom

12:00pm EDT

Lunch in the COMMON Expo
Tuesday September 10, 2019 12:00pm - 1:00pm EDT
Cosmopolitan Ballroom

1:30pm EDT

25AD External 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. But what about accessing data in non-database objects such as data areas, user spaces or IFS files? Those objects can be easily accessed with an HLL (High Level Language) such as RPG or COBOL. External UDTFs are programs or procedures written in an HLL and called by the database manager in a call back processing. Parameters can be passed to an UDTF and a set of data, i.e. a predefined number of columns and zero to m rows will be returned. UDTFs must be specified within the FROM clause of an SELECT statement. An HLL program written and registered as UDTF can access non-database data and return them as table. In this way it is possible to access non database-objects with SQL.

Learning Objectives:
In this session you will learn how call back processing works. You’ll also learn how to write an external UDTFs, how to pass parameters to them and how to join them together. You will get a lot of tips and tricks how to create and register external UDTFs for accessing data areas, user spaces and IFS data.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Tuesday September 10, 2019 1:30pm - 2:30pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Database

1:30pm EDT

25AI Advanced SQL Set Processing
Advanced SQL Set Processing. Taking advantage of SQL as it was intended to be used

Learning Objectives:
1. Understand set based processing 2. identify different ways to utilize more advanced features of SQL 3. learn to recognize when SQL could be better used

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 September 10, 2019 1:30pm - 2:30pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

1:30pm EDT

25AB Connecting to Db2 on IBM i with Node.js
The most important operation for a Node.js server running on the IBM i is connecting to the internal Db2 database. There are approximately 6 official packages that simplify the process of connecting a querying, but their quality varies widely. This session begins with an overview of all of these packages and their relative strengths and weaknesses. From there, I select the two packages that are the future of Node.js and Db2 connections and go in-depth with how to configure, connect, and perform both simply and complex queries and stored procedure calls, enabling users to achieve the full potential of Db2 inside the Node.js environment.

Learning Objectives:
1. How to set up a Node.js environment on the IBM i.
2. How to connect to Db2 on IBM i through different packages, including odbc, which allows development across platforms.
3. Learning how to run everything from simple queries to stored procedure calls in Node.js

Speakers
avatar for Kevin Adler

Kevin Adler

Software Engineer, IBM
Kevin Adler works at IBM, attempting to bring as much Linux and open source awesomeness to the IBM i platform. He has a wide range of knowledge on various computing subjects. He enjoys learning languages (both computer and natural) - currently he's learning Rust and French. If you... Read More →



Tuesday September 10, 2019 1:30pm - 2:30pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

1:30pm EDT

25AC PHP and Database Access
As the “glue” that holds the LAMP stack together, PHP is used both as the language to represent the business logic of a web application as well as leveraging data from various data sources including relational databases. The session will start out with a look at the basic database access and manipulation functions provided by PHP. From there we will explore the PHP language extensions for accessing and working with data resident in DB2 on IBM i. Additionally, we will take a look at how PHP accesses MySQL/MariaDB data and how that data can actually be stored in DB2 without any code changes. Finally, we will take a look at how the PHP language can be used to build solutions from multiple disparate data sources – specifically in our case we will look at how data from DB2 and data from MariaDB can be represented together to deliver holistically (from a data perspective) solutions.

Learning Objectives:

Speakers
avatar for Erwin Earley

Erwin Earley

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



Tuesday September 10, 2019 1:30pm - 2:30pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

1:30pm EDT

25AF A Nerd's Guide to DATA-INTO in RPG
RPG's DATA-INTO opcode is a powerful tool for mapping data from documents (such as JSON, XML, CSV, etc) into RPG variables. DATA-INTO works together with a separate program, known as a "parser" that interprets the data format. In this session, Scott will explain the basics of using DATA-INTO, first by showing how to use it with an existing parser, then he will provide the really nerdy stuff: How to write your own parser!

Learning Objectives:
1. What RPG's DATA-INTO opcode? When is it useful?
2. How to use it with an existing parser program.
3. How to write your own parser program

Speakers
avatar for Scott Klement

Scott Klement

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



Tuesday September 10, 2019 1:30pm - 2:30pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

1:30pm EDT

25AG What’s New in 7.2, 7.3 and 7.4 Security
This presentation will cover the extensive list of security enhancements added by IBM in the 7.2, 7.3 and 7.4 operating system releases. The 7.2 enhancement called Row and Column Access Control (RCAC) will be discussed including an example designed to get you started with RCAC. The 7.3 security changes include the major security enhancement called Authority Collection plus exciting new support to Audit Network Communication sessions into and out of your IBM i Server. The 7.4 security changes including new support called Object Level Authority Collection, New security support for the DB2 Mirror enhancement in 7.4, SST User Management changes plus Networking security changes.

Learning Objectives:

Speakers
avatar for Jeff Uehling

Jeff Uehling

IBM i Security Expert
Jeff Uehling is an independent consultant specializing in IBM i security. Prior to retiring from Syncsort, he worked for over 30 years at IBM where he served as lead architect for IBM i security technology. Jeff’s previous responsibilities at IBM included architecture, design and... Read More →



Tuesday September 10, 2019 1:30pm - 2:30pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Security

1:30pm EDT

25AA What You Need to Know to Successfully Upgrade to 7.4, 7.3, and 7.2
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.4, if you are upgrading to an earlier release (7.3, 7.2), we will also cover those releases.

Learning Objectives:
1) Preparation steps required for OS Upgrade.
2) Compatibility issues between releases.
3) Requirements for upgrading.

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 September 10, 2019 1:30pm - 2:30pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

1:30pm EDT

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

Speakers
avatar for Dawn May

Dawn May

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



Tuesday September 10, 2019 1:30pm - 2:30pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

2:45pm EDT

26AB Building Reusable APIs
When should I use an API? What are the benefits of writing APIs? This talk will cover when to use Web APIs to access your data, as well as some tips on how to write a Web API that is flexible and designed to last. Using code examples in multiple languages, I will share lessons recently learned from working on a large integration project with Salesforce.

Learning Objectives:
1. Learn the basics of REST APIs and how to implement them successfully.
2. See code examples in RPG, Node.js, Python and PHP

Speakers
avatar for Stephanie Rabbani

Stephanie Rabbani

Consultant, Seiden Group
A senior consultant for Seiden Group, Stephanie Rabbani has been developing web applications on the IBM i for over 15 years. She previously worked for BCD Software Professional Services.In her IBM i career, she has developed a large range of applications such as APIs, shopping carts... Read More →



Tuesday September 10, 2019 2:45pm - 3:45pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Application Development

2:45pm EDT

26AF REST for IBM i, its more that 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!!

Learning Objectives:

Speakers
avatar for Tim Rowe

Tim Rowe

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



Tuesday September 10, 2019 2:45pm - 3:45pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Application Development

2:45pm EDT

26AD IBM i ACS Advanced Usage and Administration
BM i Access Client Solutions (IBM i ACS) is a platform independent client that is supported running on multiple Operating Systems like Macintosh, Linux, and Windows. Familiarity with IBM i Access Client Solutions is very important as this is the future of the IBM i Access Family software on workstation operating systems. This future is already here as IBM i ACS is the only client supported on Windows 10 and later OS, and IBM i Access for Windows is being withdrawn from support on April 30, 2109.

In this session we will cover some of the more advanced IBM i ACS Java client capabilities like running a Data Transfer natively on the IBM i OS and how to use command syntax to script actions to be ran. We will also look at the associated IBM i Access Client Solutions Windows Application and the Administration of that along with the base Java package.

Learning Objectives:

Speakers
avatar for Wayne Bowers

Wayne Bowers

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



Tuesday September 10, 2019 2:45pm - 3:45pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Client Connectivity

2:45pm EDT

26AI Advanced SQL DDL - More Than Just Physical Files
Physical and logical files are the bread and butter of databases. But SQL supports other objects that can be very useful in simplifying and extending capabilities. This session will cover several topics including views, alias, UDTFs, three-part naming and more.

Learning Objectives:

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 September 10, 2019 2:45pm - 3:45pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Database

2:45pm EDT

26AE POWER Pick: What's New with Backup Recovery on IBM i - Including Virtual Tape and Encryption
Find out what new things you need to know for the very latest releases to ensure you have a good backup strategy. Learn what changes need to be made to update your disaster recovery plans. New and exciting changes for Backup and Recovery are highlighted including Virtual Tape support, Backup Encryption and the latest and greatest for Backup Recovery and Media Services (BRMS).

Learning Objectives:
• Learn about the latest backup and recovery enhancements to incorporate into your backup and recovery plans to ensure you have a good comprehensive strategy.
• New techniques with Backup Recovery and Media Services will be gained to automate and ensure your backups and recoveries are easy to perform.

Speakers
avatar for Debbie Saugen

Debbie Saugen

Owner, Debbie Saugen Consulting, LLC
Debbie Saugen is recognized worldwide as an expert on IBM i backup and recovery, disaster recovery, and high availability. Debbie's IBM career spanned 37 years serving as the Technical Owner of IBM i Backup/Recovery and the IBM i National Lead for IBM Resiliency Services. She continues... Read More →



Tuesday September 10, 2019 2:45pm - 3:45pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

2:45pm EDT

26AA PANEL: Women in IT - Perspectives
A Panel of Women with varied backgrounds will discuss the following Topics:
  • Open Source on IBM i- the Basics
  • Terminology
  • Backup/Recovery considerations
  • Continuing Education Options
  • Balancing Work & Personal Lives
All are welcome! Share your stories!

Moderators
avatar for Sue Zimmermann

Sue Zimmermann

Application Manager, HarrisData
Sue  is currently  an Application Manager in R&D  at HarrisData.  HarrisData is an IBM ISV that has been providing ERP/Payroll  software for IBM mid-range platforms for over 48 years.Armed with a ‘Total Data Processing’ Certificate that included a 6 week course in COBOL and... Read More →

Speakers
avatar for Dawn May

Dawn May

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

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →
avatar for Kim Greene

Kim Greene

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

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →
avatar for April Medinger

April Medinger

Harris Data
Teaching herself how to design graphics and develop basic HTML websites as a hobby in high school, April designed many websites for friends and non-profit organizations in her spare time. After serving in the United States Air Force, April decided to turn her passion for website and... Read More →


Tuesday September 10, 2019 2:45pm - 3:45pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204

2:45pm EDT

26AC VENDOR: Tools to Modernize Your IBM i Applications and Adopt DevOps
Modernization requires automation. Modernization has many layers, the database, the source code, and the user interface. To modernize your applications from A to Z, you need to consider all of these.

Join Andrew Clark, a Software Architect, from ARCAD Software to see how you can leverage the value in your existing IBM i applications by automatically converting them to modern standards.

Andrew will show you how you can convert your code to RPG Free, convert your database from DDS to DDL, migrate away from 4GL tools, move to new user interfaces, and more. After this session, you’ll know how to improve the flexibility of your IBM i code and get it ready for modern web and cloud architectures.

Of course, modernization requires mass change, and that means risk. Andrew will also show you how to take the risk out of modernization by using a structured DevOps process: ARCAD for DevOps.

Speakers
avatar for Andrew Clark

Andrew Clark

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



Tuesday September 10, 2019 2:45pm - 3:45pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

4:00pm EDT

27AE POWER Pick: 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 and get you on your way. Attend this session and you will see how to implement RDi and Git - The Easy Way!

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

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



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

4:00pm EDT

27AG JavaScript 101: First Look from an RPG Perspective
Since its introduction nearly 23 years ago, JavaScript has fast become the most prominent programming language on the Internet. You would be hard-pressed to find a single page on the web today that does not employ some amount of JavaScript code. Learning JavaScript, along with basic HTML and CSS concepts, should be at the top of the to-do list for every RPG developer looking to get started with serious web development.

This session serves as an introduction to the fundamentals of the JavaScript language, drawing comparisons to coding concepts that should be familiar to all RPG programmers. No prior experience with web development is assumed. Topics to be covered include basic variable declaration, comparison & assignment operators, conditional statements, arrays, loops and functions -- all of which will be directly compared to their RPG equivalents. The instructor will demonstrate how you can practice these basic JavaScript concepts on your own using console tools inside the Google Chrome browser, and provide suggestions for further study of the language.

Learning Objectives:
1. Know how to code and test blocks of JavaScript inside their own browser (specifically, we'll look at the DevTools inside Google Chrome)
2. Understand the differences and similarities between JavaScript and RPG
3. Know where to go for further study of the language and what to focus on learning first

Speakers
avatar for Robert Swanson

Robert Swanson

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



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204

4:00pm EDT

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

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

Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Developing Business Skills

4:00pm EDT

27AB Intro to React
Come see how easy it is to build fast, accurate, and responsive web UIs using the React library. Even if you’ve never written Javascript before, React’s straightforward syntax can get you started with your UI project quickly. In this session, you’ll learn about React’s declarative syntax and state representation, explore some of the basic components that are used to build sophisticated UIs, and leave with a foundational application you can continue to build on.

Learning Objectives:

Speakers
avatar for Justin Reock

Justin Reock

Chief Architect, OpenLogic by Perforce
Justin has over 20 years’ experience working in various software roles and is an outspoken free software evangelist, delivering enterprise solutions and community education on databases, integration work, architecture, and technical leadership. He is currently the Chief Architect... Read More →



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

4:00pm EDT

27AC Help I've Fallen and I Can't git Up
Have you ever gotten yourself stuck using git and not known what to do? Maybe a rebase gone wrong or a cherry-pick went sour? git sometimes makes it easy to shoot yourself in the foot, but luckily includes a first aid kit to patch yourself up good as new. Learning Objectives: Learn how to undo and abort various git operations cleanly.
Learn how to recover lost files and data.
Learn how to purge a file from history.

Speakers
avatar for Kevin Adler

Kevin Adler

Software Engineer, IBM
Kevin Adler works at IBM, attempting to bring as much Linux and open source awesomeness to the IBM i platform. He has a wide range of knowledge on various computing subjects. He enjoys learning languages (both computer and natural) - currently he's learning Rust and French. If you... Read More →



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

4:00pm EDT

27AD POWER Pick: Finally – RPG Freed from the Fetters of Fixed Format
Finally! The time where RPG was a cryptic, column oriented, hard to decode programming language is over. Beginning with release V5R1M0 free format coding for C-Specs was introduced … but it took until release 7.1 TR 8 (respectively release 7.2) until the H, F, D and P-Specs got a free format equivalent. The complete free format coding includes several simplifications and/or assumptions, for example if not explicitly defined differently a file (F-Spec) is handled as input file. Instead of single characters that had to be coded on a specific position, descriptive keywords are introduced, for examples specific keywords exist for all data types. The sequence of F- and D-specs is no longer mandatory. And with release 7.2 TR 3 the last restriction (RPG source code has to be coded between position 8 and 80) is removed.

Learning Objectives:
In this session you will learn how to code free-format H-, F-, D- and P-Specs beginning with the new DCL-Opcodes, continued with the new keywords for defining data types in stand-alone fields or data structure sub-fields. This session will cover the file definition for keyed or unkeyed access in input and update mode. You’ll also learn how to define all kinds of work fields, constants, arrays, (nested) data structures etc. The coding of (sub-) procedures, prototypes and procedure interfaces are demonstrated as well as the coding of special data structures, such as program status data structure and data areas.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

4:00pm EDT

27AI Ch Ch-Ch-Changes – What ‘s your shame? – Not knowing what changed on your system!
System administrators are blamed for everything. Think about it...How many Monday's have you barely walked in the door, only to find the production system is in trouble and management is in your office screaming. ou then learn a change was implemented over the weekend, one where your systems team was blindsided…Just Perfect...Happy Monday. Whether it is a hardware change, software change, or network related, it is vital for system admins, application programmers, and especially IT management to understand the impact of ALL changes to the system / environment.

Learning Objectives:
In this session you will learn:
1) The methodologies to do powerful What's Different Analysis for all critical performance metrics.
2) The mission critical performance management tasks that most system admins fail to every month.
3) How to change your IT performance management culture from a "reactive" mode to a successful "proactive" mode.
4) How to measure the impact of memory tuning changes.
5) How to measure the impact of Capacity Planning projects when the upgrade didn’t go as planned.

Speakers
avatar for Doug Mewmaw

Doug Mewmaw

President, Peak System Performance LLC
Doug Mewmaw has worked in the IT industry for more than 30 years. His position as IBMi and AIX Technical Support Manager for Boise Cascade Office products gave him the opportunity to work daily with the Navigator family of products. In 2004 he left this position to become the Director... Read More →



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

4:00pm EDT

27AA Sponsor: The Path to the IBM i Cloud
Every company’s cloud journey is at a different pace, or sometimes that journey does not make sense to start at all.  In this presentation you will learn if the path to the Cloud is the right fit for your organization and hear an overview of the Datanational IBM i Cloud. We will discuss the following topics:
  • Cloud Concepts
  • Why Consider Moving to the Cloud
  • Datanational’s IBM i in the Cloud – What IT IS
  • Datanational’s IBM i  in  the Cloud – What IT IS NOT
  • Solution Overview
  • Migration Considerations
  • Business Continuity Options
As we review this information, we will share customer experiences and real-world scenarios as many customer have made this and then also discuss why some customers decided to remain with an On-Premise configuration.

Speakers
avatar for Derrick Smith

Derrick Smith

Solution Architect, Datanational Corporation
Over the last 23 years, Derrick has engaged with many IBM Power Systems companies in the delivery of technology solutions, including enterprise infrastructure modernization and cloud-based data protection and business continuity solutions.  He currently holds several IBM Power sales... Read More →



Tuesday September 10, 2019 4:00pm - 5:00pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204

5:15pm EDT

28AE Tips and Techniques for Shrinking Backup/Recovery Windows on IBM i
New hardware and tape technology in combination with software enhancements in Backup Recovery and Media Services (BRMS) using Concurrent and Parallel Saves, Save-while-active and Online Lotus Server Backups are resulting in huge reductions to backup and recovery windows. The latest IBM i releases provide faster system recoveries for logical and physical files residing in different libraries and journals. Learn how you too can dramatically reduce your backup and recovery windows!

Learning Objectives:
• Understand the factors affecting backup and recovery performance.
• Choose which available options will reduce your backup and recovery windows.

Speakers
avatar for Debbie Saugen

Debbie Saugen

Owner, Debbie Saugen Consulting, LLC
Debbie Saugen is recognized worldwide as an expert on IBM i backup and recovery, disaster recovery, and high availability. Debbie's IBM career spanned 37 years serving as the Technical Owner of IBM i Backup/Recovery and the IBM i National Lead for IBM Resiliency Services. She continues... Read More →



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204

5:15pm EDT

28AA What's New in Notes and Sametime 10
The Notes client hasn't had significant enhancements for a few releases now. This has changed with the release of Notes 10. The development team was busy listening to customers and partners to find out what the top needed have been and implemented those! Come to this session to learn about why you'll want to get your users on the Notes 10 client ASAP and how Sametime became much more usable and friendly across devices in Sametime 10.

Learning Objectives:
Learn about the plethora of enhancements made available to the Notes client with version 10.
Learn about how much more usable Sametime is in version 10.

Speakers
avatar for Kim Greene

Kim Greene

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



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204

5:15pm EDT

28AF Modernization on IBM i Heading to Normal
Application modernization can mean different things to different people-ask 10 people and you will get 10 different answers. One thing they all have in common, though, is the big question: “How can I deliver modern applications to our business?” With the delivery of our Modernization of IBM i Applications Redbook, we will dive into what modernization looks like and give some general principles that can be leveraged when you get home. We will look at how development on IBM i has moved toward 'Normal'.

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 September 10, 2019 5:15pm - 6:15pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

5:15pm EDT

28AD IBM i OS Networking Security
Network Communications security is a necessity for nearly everyone in at least some scope, and this session will look at some of the technology and tools available on the IBM i OS

TLS network encryption is a very important part of the security picture, and we will look at some protocol details, managing the communications network encryption environment on your IBM i OS, differentiating what is available and how the configuration approach differs at the differing IBM i OS releases, and what is the latest coming in the TLS encryption protocol. We will also briefly look at sniffer traces showing different connection handshakes.

Depending on available time we may also look at other Networking Security topics like Intrusion Detection, IP Filtering & NAT with Packet Rules and VPN.

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

Speakers
avatar for Wayne Bowers

Wayne Bowers

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



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Networking

5:15pm EDT

28AB Creating APIs in 5 minutes with Node.js and Loopback
We will install Loopback and the brand new IBM i Loopback connector, and use it to create an API accessing db2, lightning fast! We will use the rest of the time to expand on this demo and eat chocolate. Come see how quickly you can deliver your data with Node and Loopback.

Learning Objectives:
1. What is Loopback and how can it work for me?
2. How can I create a quick and secure REST API?

Speakers
avatar for Stephanie Rabbani

Stephanie Rabbani

Consultant, Seiden Group
A senior consultant for Seiden Group, Stephanie Rabbani has been developing web applications on the IBM i for over 15 years. She previously worked for BCD Software Professional Services.In her IBM i career, she has developed a large range of applications such as APIs, shopping carts... Read More →



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

5:15pm EDT

28AC Accessing IBM i from Python
Learn all the ways you can access the IBM i through Python: XMLSERVICE toolkit, database adapter, and more.

Learning Objectives:

Speakers
avatar for Kevin Adler

Kevin Adler

Software Engineer, IBM
Kevin Adler works at IBM, attempting to bring as much Linux and open source awesomeness to the IBM i platform. He has a wide range of knowledge on various computing subjects. He enjoys learning languages (both computer and natural) - currently he's learning Rust and French. If you... Read More →



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

5:15pm EDT

28AG IBM i Encryption Made Easy
Do you need to encrypt sensitive data on your IBM i, such as confidential employee information, personal credit information or personal health information, but worry about the complexity of implementing encryption? In this session, Jeff Uehling, Security Expert at Syncsort, well-known expert in cryptography and key management, put your encryption fears to rest. You’ll learn how IBM i Field Procedures (FieldProcs), introduced in V7R1, have greatly simplified encryption projects, often eliminating the need for application changes.

Learning Objectives:
• How to easily encrypt data without impacting applications using FieldProc
• Challenges and practical considerations for FieldProc encryption
• The importance of encryption key management to meet compliance requirements

Speakers
avatar for Jeff Uehling

Jeff Uehling

IBM i Security Expert
Jeff Uehling is an independent consultant specializing in IBM i security. Prior to retiring from Syncsort, he worked for over 30 years at IBM where he served as lead architect for IBM i security technology. Jeff’s previous responsibilities at IBM included architecture, design and... Read More →



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Security

5:15pm EDT

28AI My CIO said we are moving to the cloud – Now what do I do?
The cloud is the shiny new toy that everyone is moving to. As a system administrator, you’re thinking I’m gone - time to update my resume. STOP…Breathe…It’s going to be okay. I have good news for you. You still have value to your company. Think about it: The CIO is not going to stop asking a slew of questions, such as:
• What’s wrong with the system?
• What happened yesterday at 4 PM?
• Why is disk space growing at an alarming rate?
• Why did night batch processing run long last night?
• Are we going to have enough processing power for our peak period?

And so on

Did you know that managed service providers (MSPs) don’t always think about performance? It’s true. In this session, we will not only layout a performance management roadmap to ensure your move to the cloud is a smooth one, but we will prove to management that you now have the most important role in your company.

Learning Objectives:
1) We will introduce a mission-critical "Cloud Provider" checklist and discuss the steps that need to be done in a project of this magnitude.
2) We will talk about performance implications when moving to the cloud.
3) We will talk about performance best practice SLAs - especially the one that MSPs don't want you to think about.
4) We will talk about capacity planning and answer the question: Do I need to worry about that anymore?

Speakers
avatar for Doug Mewmaw

Doug Mewmaw

President, Peak System Performance LLC
Doug Mewmaw has worked in the IT industry for more than 30 years. His position as IBMi and AIX Technical Support Manager for Boise Cascade Office products gave him the opportunity to work daily with the Navigator family of products. In 2004 he left this position to become the Director... Read More →



Tuesday September 10, 2019 5:15pm - 6:15pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management
 
Wednesday, September 11
 

8:00am EDT

31AG POWER PICK: Accessing IBM i from Other Systems
IBM i is not the silo that the AS/400 once was. This highly diversified system hosts the lion’s share of data and business logic which, when properly enabled, can be consumed by all areas of the organization. This survey level session will explore the many ways IBM i content can be accessed and provisioned from simple ODBC to full on web services so that your IBM I remains the “System of Record” today, tomorrow and beyond. We’ll put together a list of pro’s and con’s of each approach and help identify the key components of a successful target architecture where IBM i participate faithfully and fully.

Speakers
avatar for Mike Pavlak

Mike Pavlak

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



Wednesday September 11, 2019 8:00am - 9:00am EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204

8:00am EDT

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

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

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Wednesday September 11, 2019 8:00am - 9:00am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Database

8:00am EDT

31AI Choose Your Own Adventure: An Interactive IBM i Modernization Case Study
Remember the wonderful Choose Your Own Adventure series of books from childhood? Join us for an interactive run through of an IBM i modernization case study, exploring some of the possibilities (and pitfalls of course) that often accompany the process. This interactive session will have our 'readers' help provide direction as we are guided through our real-life modernization case study.

Speakers
avatar for Greg Patterson

Greg Patterson

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



Wednesday September 11, 2019 8:00am - 9:00am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

8:00am EDT

31AF Everything they never taught you!
Ok, maybe we're setting the bar a little high by saying EVERYTHING, but did you ever feel like all the people around you seem to just KNOW things, things you don't? Sure, you're a wiz with SQL, and no one codes RPG like you do, but when it comes to people skills, to working in teams, to communicating well, to building your career... Well, they never taught you THAT! Come to this session to learn everything you've been missing out on.

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

Speakers
avatar for 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 September 11, 2019 8:00am - 9:00am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Personal Development

8:00am EDT

31AE Controlling Access to IBMi Systems and Data
To protect your critical data from access by unauthorized users or intruders, and to comply with increasingly strict IT security regulations, you must take control of all access points to your IBM i server. Attend this session for an in-depth discussion of all the points of access that must be managed and how they can be secured using IBM i exit points.

Learning Objectives:
• Securing network access and communication ports
• How database access via open-source protocols can be secured
• Taking control of command execution

Speakers
avatar for Jeff Uehling

Jeff Uehling

IBM i Security Expert
Jeff Uehling is an independent consultant specializing in IBM i security. Prior to retiring from Syncsort, he worked for over 30 years at IBM where he served as lead architect for IBM i security technology. Jeff’s previous responsibilities at IBM included architecture, design and... Read More →



Wednesday September 11, 2019 8:00am - 9:00am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  Security

8:00am EDT

31AA Storwize Storage Advanced Topics
For the average IBM i shop storage has been just that storage. The primary differences between Internal disk and SAN disk for years was the complexity of connection and the price of the solution. Until not long ago questions such as “What else can it do?” were left unasked because the cost and complexity answers often put SAN storage out of reach.
Changes to the cost and complexity equation have placed SANs within reach of most if not all IBM i customers. So if we’ve got a SAN what can it do besides be storage? Glad you asked!

SANs bring to us the ability to make a combinations of storage types appear as one. They have the ability built in to move data between tiers of disk from the slowest of the spinning rust to the fastest of the Solid state storage based on frequency of access and you, the admin, doesn’t need to waste a moment doing it. SANs can encrypt your data at rest with no overhead to IBM i.

SANs can create a copy of 20TB of data in just seconds, really! OK Not really but it looks like it did so effectively it did. That copy can now be used to perform a backup or to run reports at a point in time or as a training environment or a test environment. When you’re done with it it goes away as fast as it was created, in a flash.

SANs can replicate date near or far for use in disaster recovery or high availability environments.

Higher end SANs can even front end other storage presenting that to IBM i or migrating data from one SAN to another.

In this session we’ll show how to make each of the above work and how each of these can be useful in your shop.
For the average IBM i shop storage has been just that storage. The primary differences between Internal disk and SAN disk for years was the complexity of connection and the price of the solution. Until not long ago questions such as “What else can it do?” were left unasked because the cost and complexity answers often put SAN storage out of reach.
Changes to the cost and complexity equation have placed SANs within reach of most if not all IBM i customers. So if we’ve got a SAN what can it do besides be storage? Glad you asked!

SANs bring to us the ability to make a combinations of storage types appear as one. They have the ability built in to move data between tiers of disk from the slowest of the spinning rust to the fastest of the Solid state storage based on frequency of access and you, the admin, doesn’t need to waste a moment doing it. SANs can encrypt your data at rest with no overhead to IBM i.

SANs can create a copy of 20TB of data in just seconds, really! OK Not really but it looks like it did so effectively it did. That copy can now be used to perform a backup or to run reports at a point in time or as a training environment or a test environment. When you’re done with it it goes away as fast as it was created, in a flash.

SANs can replicate date near or far for use in disaster recovery or high availability environments.

Higher end SANs can even front end other storage presenting that to IBM i or migrating data from one SAN to another.

In this session we’ll show how to make each of the above work and how each of these can be useful in your shop.
For the average IBM i shop storage has been just that storage. The primary differences between Internal disk and SAN disk for years was the complexity of connection and the price of the solution. Until not long ago questions such as “What else can it do?” were left unasked because the cost and complexity answers often put SAN storage out of reach.
Changes to the cost and complexity equation have placed SANs within reach of most if not all IBM i customers. So if we’ve got a SAN what can it do besides be storage? Glad you asked!

SANs bring to us the ability to make a combinations of storage types appear as one. They have the ability built in to move data between tiers of disk from the slowest of the spinning rust to the fastest of the Solid state storage based on frequency of access and you, the admin, doesn’t need to waste a moment doing it. SANs can encrypt your data at rest with no overhead to IBM i.

SANs can create a copy of 20TB of data in just seconds, really! OK Not really but it looks like it did so effectively it did. That copy can now be used to perform a backup or to run reports at a point in time or as a training environment or a test environment. When you’re done with it it goes away as fast as it was created, in a flash.

SANs can replicate date near or far for use in disaster recovery or high availability environments.

Higher end SANs can even front end other storage presenting that to IBM i or migrating data from one SAN to another.

In this session we’ll show how to make each of the above work and how each of these can be useful in your shop.

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →



Wednesday September 11, 2019 8:00am - 9:00am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

8:00am EDT

31AC Managing Open Source on IBM i with Containers
You may have heard about the latest news with open source: RPM's! As a system administrator, you may have lots of questions. What does this mean for me? Come to this session to demystify this bold new world. In doing so, you will learn important facets of open source management, like checking software levels, installing updates, etc. What best practices should you follow?

Also, we will explore the support options for the open source technologies you are leveraging. Learning objectives: 1. Learn the basics of RPM-based administration of software
2. Understand the security model behind the latest open source offerings
3. Discover ways to acquire support for your open source ecosystem.

Speakers
avatar for Kevin Adler

Kevin Adler

Software Engineer, IBM
Kevin Adler works at IBM, attempting to bring as much Linux and open source awesomeness to the IBM i platform. He has a wide range of knowledge on various computing subjects. He enjoys learning languages (both computer and natural) - currently he's learning Rust and French. If you... Read More →



Wednesday September 11, 2019 8:00am - 9:00am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

8:00am EDT

31AB Debugging your web application from A to Z (Apache to Zend)
500 internal server error? Wait, now it's a 404 error. I think it's actually a syntax error. And now my program call isn't returning anything. Attend this session to hear tips and tricks on how to debug your web application on IBM i.

Learning Objectives:
1. Analyzing Apache logs and Apache server issues.
2. Debugging your program calls and Toolkit issues
3. Debugging DB2 and library list issues
4. Debugging Javascript and CSS

Speakers
avatar for Stephanie Rabbani

Stephanie Rabbani

Consultant, Seiden Group
A senior consultant for Seiden Group, Stephanie Rabbani has been developing web applications on the IBM i for over 15 years. She previously worked for BCD Software Professional Services.In her IBM i career, she has developed a large range of applications such as APIs, shopping carts... Read More →



Wednesday September 11, 2019 8:00am - 9:00am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Web Applications

9:15am EDT

32AF The ABCs of RDi Shortcuts
There’s the long way and then there’s the short way of doing stuff. RDi, with its full collection of shortcuts easily speeds up your source code development. This session is a live demonstration of the what, wheres, whys and hows of the most popular shortcuts. Just using a few of them can really make a difference. Use them all? No contest. We will even discuss how to create your own to really ramp up your development.

Learning Objectives:

Speakers
avatar for Charles Guarino

Charles Guarino

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



Wednesday September 11, 2019 9:15am - 10:15am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204

9:15am EDT

32AA The Latest on Putting IBM i to the Cloud
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 September 11, 2019 9:15am - 10:15am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Client Connectivity

9:15am EDT

32AC VENDOR: Go Beyond Modernization with Profound Logic
What if you could modernize your company’s IBM i applications at your own pace – without the risk, disruption, and cost of system re-writes!

It’s possible… With Profound Logic! We combine a variety of modernization techniques, all of which perfectly fit together:

• RPG Open Access and RPG Free-format
• Node.js and Open Source
• HTML5 Rich Displays
• On-the-fly Refacing

Come see why our software is ideal for both Modernization and New Development.

Speakers
avatar for Al Lusher III

Al Lusher III

Solutions Architect, Profound Logic Software
I have been a Solutions Architect at Profound Logic since 2018. In my role, as part of the Pre-Sales team, I develop Proof of Concept applications and present demos for prospective customers.I have 19 years of experience working with the IBM i as a software developer as well as a... Read More →



Wednesday September 11, 2019 9:15am - 10:15am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

9:15am EDT

32AD Revamping Your Web Pages for Mobile without CSS3 Media Queries
If you have existing web pages specified in HTML via PHP or another kind of server-side programming, and haven't yet addressed mobile, this session is for you because these techniques involve incremental changes without requiring CSS frameworks such as Bootstrap or CSS3 media queries (the generally accepted method for achieving responsive). For web strategies that don’t have/use server-side programming, evidence is building that you can do a lot, maybe all, of the techniques discussed in this presentation in java script on the client side.

This session will examine a technique that achieves multi-view flexibility by simply changing the viewport metatag and various other HTML5 elements at run time (along with a small amount of CSS3 changes). What might be considered a moving target with responsive, isn’t applicable. Examples of detail page level HTML that works for the multiple views will be shown, along with net change comparisons to the original HTML.

This session won’t get into all of the exact programming or script required to accomplish the run-time changes, but all of it will be covered at the conceptual level and specifics involving the viewport meta-tag and outer most HTML containers will be shown. Also, a list of the server-side programming routines we use and info about their run sequence and timing in the web page cycle will be handed out on paper.

Learning Objectives:
1. Gain insight into one strategy for leveraging existing web and intranet applications to deliver mobile-friendly views (without compromising Desktop or Theatre views)
2. Learn about key HTML elements such as viewport and how width specifications and others can interact well in a relatively flat CSS design

Speakers
avatar for Rex Smith

Rex Smith

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


Wednesday September 11, 2019 9:15am - 10:15am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204

9:15am EDT

32AE Give me an hour, and I'll give you a week!
"Hey, do you have a minute?" We're asked that question many times every day, and while we say yes, the sad answer is... NO! Our lives and our careers are busier than ever. Feel like you're barely keeping your head above water at work? You're not alone. We struggle to keep up with the demands of our careers while retaining some semblance of balance between work and personal time.  

If you had an extra week - or more - every year, how would you spend it? Come to this session and learn the life hacks you need to supercharge your productivity!

Learning Objectives:
You'll leave this session knowing how to:
* Focus on the right things at the right times
* Better manage the constant interruptions
* Always have the information you need at your fingertips
* Automate repetitive tasks
* Use technology to your advantage

By the end of the session you'll have the tools to save over 168 hours - that's one full week - every year! What will you do with all that extra time?

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 September 11, 2019 9:15am - 10:15am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  Personal Development

9:15am EDT

32AB CI/CD workflow for RPG
This session will cover how to handle the development workflow when using Ci/CD for your RPG/COBOL applications; including handling library lists, multiple branches, doing code reviews with GitHub, automatically deploying to testing and production environments.

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 September 11, 2019 9:15am - 10:15am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  RPG

9:15am EDT

32AI What Happened To All The Memory / Faulting Best Practice Guidelines?!?
In the old days, IBM published clearly defined best practice guidelines in regards to memory pools. Today there are no guidelines...So the $64,000 question is, how do you effectively measure your memory / faulting on your systems?  Measuring the memory component is not easy...However, it can be if your memory is set up optimally on all your systems

Learning Objectives:
In this session, you will learn:
1) The hidden spot on the system where memory configurations are critical
2) How to manage memory by looking at more than the faulting rate
3) How to set up / manage your memory pools
4) How to establish memory guidelines that really work

Speakers
avatar for Doug Mewmaw

Doug Mewmaw

President, Peak System Performance LLC
Doug Mewmaw has worked in the IT industry for more than 30 years. His position as IBMi and AIX Technical Support Manager for Boise Cascade Office products gave him the opportunity to work daily with the Navigator family of products. In 2004 he left this position to become the Director... Read More →



Wednesday September 11, 2019 9:15am - 10:15am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

10:30am EDT

33AC Getting the Most Out of BRMS Recoveries!
Backup Recovery and Media Services (BRMS) takes the guesswork out of IBM i complete system recoveries. Learn how to get the most out of BRMS recovery on any release of IBM i. Tips for recovering with Media Library Devices will also be covered.

Learning Objectives:
• Learn valuable tips and techniques using BRMS to make your system recoveries easier and faster. • Understand how to use Media Library Devices during system recoveries.

Speakers
avatar for Debbie Saugen

Debbie Saugen

Owner, Debbie Saugen Consulting, LLC
Debbie Saugen is recognized worldwide as an expert on IBM i backup and recovery, disaster recovery, and high availability. Debbie's IBM career spanned 37 years serving as the Technical Owner of IBM i Backup/Recovery and the IBM i National Lead for IBM Resiliency Services. She continues... Read More →



Wednesday September 11, 2019 10:30am - 11:30am EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

10:30am EDT

33AD VENDOR: Create IBM i web and mobile dashboard apps with no programming (unless you want to)
"The Valence Framework for IBM i, available for free download, includes a browser-based development tool called Nitro App Builder that allows anyone with a solid understanding of their IBM i database to create dazzling dashboard and query apps, complete with download-to-Excel functionality. You can even create apps that enable users to adjust data in the underlying files.

All of this can be done with no coding required, though advanced developers can extend the app's functionality with RPG code to handle business logic and make database adjustments as needed. IBM i programmers who really want to get their hands dirty in the front-end code can put other Valence development tools to work to create highly intricate data entry apps, all working hand-in-hand with your server-side RPG code.

The bottom line: With Valence, IBM i developers and super users alike can crank out highly functional web and mobile apps in a matter of minutes with no prior experience in web or mobile development. Come to this session to see how easy it can be to build such apps on your system today!

Speakers
avatar for Robert Swanson

Robert Swanson

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


Wednesday September 11, 2019 10:30am - 11:30am EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

10:30am EDT

33AI Comparing Modernization Approaches : RPG OA, Node.js, PHP and more
There are many different approaches to modernizing green screens and developing new IBM i web and mobile applications. In this session, you’ll get an overview of the following approaches as well as their pros and cons:
* Refacing (5250 vs RPG OA)
* Open Source (PHP, Node.js, Python and more)
* Mobile (HTML5 vs Native)

Learning Objectives:
1. Learn from others experience in modernizing green screens
2. Decide if open source is right for you
3. What are the differences in mobile approaches

Speakers
avatar for Greg Patterson

Greg Patterson

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



Wednesday September 11, 2019 10:30am - 11:30am EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

10:30am EDT

33AB Djust Django: The Powerful, Flexible Python Framework
This session will cover the basics of Django, including installation, configuration on IBM i, and utilization of Django's ORM with db2. You should come out of this session excited to try creating some web apps with Django.

Learning Objectives:
1. Learn what Django is and how to get started
2. Learn how you can use Django to rapidly develop Python applications on IBM i
3. Introduce some useful Django plugins.

Speakers
avatar for Stephanie Rabbani

Stephanie Rabbani

Consultant, Seiden Group
A senior consultant for Seiden Group, Stephanie Rabbani has been developing web applications on the IBM i for over 15 years. She previously worked for BCD Software Professional Services.In her IBM i career, she has developed a large range of applications such as APIs, shopping carts... Read More →


djump3 ppt

Wednesday September 11, 2019 10:30am - 11:30am EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

10:30am EDT

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

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

Speakers
avatar for Mike Pavlak

Mike Pavlak

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



Wednesday September 11, 2019 10:30am - 11:30am EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages, Young i Professionals Pick

10:30am EDT

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

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

Speakers
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also the IBM i admin at Everbrite... Read More →



Wednesday September 11, 2019 10:30am - 11:30am EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  RPG, Young i Professionals Pick

10:30am EDT

33AG Authority Collection in 7.3 & 7.4: Locking Down Security for Sensitive Data, Files and Objects
This presentation will introduce a new capability in the 7.3 release called Authority Collection and also cover the exciting changes in the 7.4 release. Authority collection is new support designed to assist the security administrator and application provider in locking down object level security. This support will help ensure that object authority is set to the most secure value while still allowing an application to run successfully. This presentation is a must see for security administrators and application developers.

Learning Objectives:

Speakers
avatar for Jeff Uehling

Jeff Uehling

IBM i Security Expert
Jeff Uehling is an independent consultant specializing in IBM i security. Prior to retiring from Syncsort, he worked for over 30 years at IBM where he served as lead architect for IBM i security technology. Jeff’s previous responsibilities at IBM included architecture, design and... Read More →



Wednesday September 11, 2019 10:30am - 11:30am EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Security

10:30am EDT

33AA Tales from the Datacenter: Worst Practices in Systems Management
We've all heard stories of things gone wrong, some were just bad, some were horrible, and some were just plain hilarious! The more you know of these gruesome Tales from the Datacenter the more likely you can avoid them.

This session will also allow for user feedback where the horrible terrible and very bad experiences of audience members will be added to the speakers experiences and used as educational tools to prevent those problems from killing us. You have been warned!

System admins, facility managers, developers - everyone has an opportunity to be the "hero" or the "zero" in their company. This session will help you learn from the mistakes of others and lessen the cases of you being the "zero". Learning objectives: 1. Learn how the "Titanic effect" of cascading failures and mistakes often compounds a problem.
2. Learn simple tips and tricks for avoiding being the cause of an outage or disaster

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →
avatar for Kevin Mort

Kevin Mort

VP Technology Services, Flagship Solutions Group
Kevin Mort is the Vice President of Technology Services for IBM business partner Flagship Solutions Group, located in Boca Raton, Florida. He designs and supports technology solutions which include IBM Power, storage and software technologies, virtualization of many flavors, as well... Read More →



Wednesday September 11, 2019 10:30am - 11:30am EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

11:45am EDT

34AA A Free IDE Alternative For RPG
ILEditor is a free and open source IDE for RPG, COBOL, CL, C / C++ - any ILE language. This session will show the features that are available in the IDE and how to be the most productive with it. Learning objectives: 1. What the need for an open source alternative is (in any software)
2. How to install ILEditor
3. How to write and compile code from the IDE
4. How to be most productive with it

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 September 11, 2019 11:45am - 12:45pm EDT
Concept A-D 109 South Capitol Avenue Indianapolis, IN 46204
  Application Development

11:45am EDT

34AC Git for Open Source and Source Control
In this session find out how to use Git to contribute to open source projects, and get an introduction on how to use Git to manage source code within your organization.

Learning Objectives:
1. How to create your own repository
2. The basics of Git flow
3. Tips and tricks for using Git on Mac/Windows
4. How to use Github/Gitlab/Bitbucket to contribute to open source projects

Speakers
avatar for Stephanie Rabbani

Stephanie Rabbani

Consultant, Seiden Group
A senior consultant for Seiden Group, Stephanie Rabbani has been developing web applications on the IBM i for over 15 years. She previously worked for BCD Software Professional Services.In her IBM i career, she has developed a large range of applications such as APIs, shopping carts... Read More →



Wednesday September 11, 2019 11:45am - 12:45pm EDT
Regency A 109 South Capitol Avenue Indianapolis, IN 46204

11:45am EDT

34AD Recursive Queries and Hierachical Query Clause
According to the SQL Standard, hierarchical (e.g. organization charts, bill of materials) or bi-directional data (e.g. flight connections) can be evaluated by using a recursive common table expression (RCTE). RCTEs were integrated with release V5R4 into DB2 for i. Other databases such as Oracle use a non-ANSI SQL Standard method for querying data called hierarchical query clause. To allow maximum portability the hierarchical query clause is introduced with PTF SF99701 Version 9 in DB2 for i. This session will show you both methods in depth.

Learning Objectives:
In this session you’ll learn how recursive data must be stored in database tables/files and the methods to be used to analyze them.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →



Wednesday September 11, 2019 11:45am - 12:45pm EDT
Regency B 109 South Capitol Avenue Indianapolis, IN 46204
  Database

11:45am EDT

34AB Next Gen UI/UX & IOT Extensions for IBM i Terminal Emulation
There are a lot of things that are changing

1 - Traditional Retail is being eaten by Ecommerce
2 - Middlemen are getting eliminated by the Internet ruthlessly
3 - Millennials walking into work places
4 - Internet Equalizing the world is only getting accelerated

As all this is happening, the traditional Power System also needs to adapt to this changing world. At Smart Gladiator we have developed a modern Terminal Emulation that enables the IBM i to be run on a Wearable, Tablet and other mobile devices. Will discuss the best practices that we have followed that resulted in this innovation.

Learning Objectives:
1. Modernizing IBM i for the latest Mobile Tech
2. Modern UI/UX for the IBM i Terminal Emulation - Resulting in significantly reduced training time
3 IOT Extensions for the IBM i - Enabling capabilities that were not available previously.

Speakers
avatar for Puga Sankara

Puga Sankara

Principal, Smart Gladiator LLC
Puga Sankara is the co-founder of Smart Gladiator LLC. Smart Gladiator designs, builds, and delivers market-leading mobile technology for retailers, distributors, and 3PL service providers. So far, Smart Gladiator Wearables have been used to ship, receive, and scan more than 50 million... Read More →


Wednesday September 11, 2019 11:45am - 12:45pm EDT
Network 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

11:45am EDT

34AI Designing Responsive IBM i Mobile Web Applications
IBM i organizations benefit when users can access web applications from both desktops and mobile devices, all from the same code base. Learn how Bootstrap, the most popular framework for developing responsive web and mobile applications accommodates different device types without spending valuable time developing multiple versions of your applications. You'll also see case studies of real-world IBM i responsive mobile applications.

Speakers
avatar for Greg Patterson

Greg Patterson

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



Wednesday September 11, 2019 11:45am - 12:45pm EDT
Theory 109 South Capitol Avenue Indianapolis, IN 46204
  Mobile and Modernization

11:45am EDT

34AF Advanced Python Programming and IBM i
Building upon the introductory session, this session will address the object oriented world of Python programming and introduce several topics for those considering Python for development. Some of these include Exception processing, Pathing, GUI use ODBC, Web Services and much more. Learning Objectives: 1. Understand the Object Oriented model of Python
2. Master the use of ODBC from client AND server Db2 connectins
3. Many other topics that help continue the growth of a Python developer

Speakers
avatar for Mike Pavlak

Mike Pavlak

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



Wednesday September 11, 2019 11:45am - 12:45pm EDT
Regency D 109 South Capitol Avenue Indianapolis, IN 46204
  Open Source Languages

11:45am EDT

34AE Mission: Possible! Journaling Forensics 101 (with Free Tools)
Learn to think like a spy! Many shops use journaling for a variety of reasons, but may not be familiar with how to use these journals for forensic purposes. Mining your journals for the who, what, when, where, how - and sometimes even why - can be very useful, not to mention fun! Come join us for a lighthearted and entertaining "Mission: Impossible" themed look at one of the most useful things you can do with your journals. This session will introduce journaling concepts and share tuning tips to optimize your journal environment for forensics. After reviewing the "old fashioned" way to dig into your journals, we will demonstrate how much easier this is with the right tools. The DMPJRN and CVTJRNDTA commands used in this presentation will be made available as a free download to all attendees, including source code!

*** As a bonus, this session now includes examples using the new Journaling SQL Table Functions!

Learning Objectives:
  • After participating in this session, attendees should have the skills and tools to:
  • Optimize your journal environment to maximize the forensic information available to you
  • Understand what your journals are trying to tell you, and how to interrogate them to get the answers you need
  • Dump your journals quickly and easily using the free software made available
  • Be able to interpret the content of your journals to determine what really happened to your data
  • Use the techniques demonstrated in the provided source code to develop your own tools
  • Save the world from evil-doers

Speakers
avatar for 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 September 11, 2019 11:45am - 12:45pm EDT
Regency C 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management

11:45am EDT

34AG 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. Furthermore, this presentation has been updated to include tips to be inclusive of developers. If you're the developer and have no IBM i admin in your shop...you're also the admin.

Learning Objectives:

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM S/34 and S/36. Larry began working on the AS/400 at its introduction in 1988. In the 34 years... Read More →



Wednesday September 11, 2019 11:45am - 12:45pm EDT
Regency EF 109 South Capitol Avenue Indianapolis, IN 46204
  Systems Management