Loading…
COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall

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

Sunday, October 14
 

8:00am

A1AA WORKSHOP: Application Modernization Database
Today, when we talk about application modernization, most think about having to reface their application and going mobile. New technologies will be used to change the layout and programs will be rewritten. … but what will a nice design be worth if the base, i.e. the underlying database is still in your grandfather’s style, grown over the years with lots of redundancies? In this workshop you will learn why to go from DDS to SQL, what are the benefits of SQL over DDS. Techniques for converting and redesigning your existing grown over the time database into a modern normalized database will be shown. In a modern environment database objects can and must be accessed from multiple interfaces and programming languages. For guaranteeing data integrity and security business logic and security rules should be moved into the database.

This is Session ID:170027

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Sunday October 14, 2018 8:00am - 11:30am
City Center A

8:00am

A1AB WORKSHOP: Hands on Python Workshop for IBM i
Get your hands dirty handling one of the hottest languages in the IBM i space:Python! In this session we will conduct an introductory level exploration of Python on IBM i. From creating scripts, including libraries on up to application development. get a chance to play directly with Python as it interacts with Db2 and other native IBM i resources.

This is Session ID:180160

Speakers
avatar for Mike Pavlak

Mike Pavlak

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


Sunday October 14, 2018 8:00am - 11:30am
City Center B
  • Content Level All
  • Operating Systems IBMi

12:30pm

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 is Session ID:170049

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Sunday October 14, 2018 12:30pm - 4:00pm
City Center A

12:30pm

A5AB WORKSHOP: Open i – Exploring Open Source solutions on IBM i
Open Source solutions continue to be in vogue for businesses large and small and you might be surprised at the wealth of Open Source solutions that are available for you to leverage directly on the IBM i platform. This workshop will explore a number of popular open source solutions available for IBM i including PHP, SAMBA, node.js, and Ruby. Along the way we will also show you how you can install/enable tools such as bash, git, zip, perl, and others in the PASE environment. Give us a couple of hours and we will open your eyes to what is possible on your IBM i.

This is Session ID:180207

Speakers
avatar for Erwin Earley

Erwin Earley

Sr Solutions Consultant, Zend by Perforce
With over 20 years working in the IBM i community previously at IBM and now with Zend by Perforce 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, PHP). I... Read More →


Sunday October 14, 2018 12:30pm - 4:00pm
City Center B
 
Monday, October 15
 

8:00am

11AJ COMMON Opening Session
The Opening Session officially kicks off 2018 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 October 15, 2018 8:00am - 9:15am
Marquis Ballroom A-C

9:30am

12AD POWER PICK: Moving Application Development Practices into the Modern World
Modernization of applications and data opens to the door to creative solutions for business problems. Introducing Free Format RPG, eclipse tools, agile processes for development and implementing good DevOps practices means superior applications are delivered faster. What are these things and how can they be implemented within a development? This session answers those questions.

This is Session ID:170578

Speakers
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →


Monday October 15, 2018 9:30am - 10:30am
Grand Ballroom 5

9:30am

12AB Basics of Testing for Programmers
Designed for programmers this session will help application developers deliver more reliable work product. While the need for testing and QA is widely accepted and embraced it can be difficult to achieve in smaller IT departments where one professional wears many hats. Whether you are your own QA or you want to bullet proof your unit testing before hand off this will help you improve your own work product.

Learning Objectives:
Explore the world of pragmatic testing. Understand the different stages of testing and what can be achieved in each. Identify what types of risk analysis to perform by project. Use varied testing processes to move applications through the development process efficiently.

This is Session ID:170032

Speakers
avatar for Yvonne Enselman

Yvonne Enselman

Director of Professional Services, iTech Solutions
Yvonne Enselman is the Director of Professional Services for iTech Solutions where she manages the technical team and coordinates customer work. Her background is in Quality Assurance and she is certified at the advanced level. She enjoys all aspects of software testing and implementing... Read More →


Monday October 15, 2018 9:30am - 10:30am
City Center B
  • Content Level All
  • Operating Systems IBMi

9:30am

12AA OLAP (Online Analytical Processing) Functions – Much More Than Running Numbers!
The first OLAP Functions were already introduced with Release 6.1, for building running numbers and ranks, in a specific sequence and even with the ability to restart numbering at a predefined level. At release 7.3 a bunch of additional OLAP functions and enhancements for existing OLAP functions are introduced. With these enhancements it is possible to easily build running totals or averages with or without level breaks. Data cannot only be accumulated over all rows, but also within a specific range. It is easy to access and compare the first, previous, next or last occurrence of the data within a partition. This session will give you an overview over the available OLAP functions and how they can be exploited.

Learning Objectives:
In this session you will learn which OLAP functions are available and how they can be used for and how they can be exploited especially for statistical reports.

This is Session ID:180278

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Monday October 15, 2018 9:30am - 10:30am
City Center A

9:30am

12AC COMMON Certification Program — What You Need to Know
As technology professionals we have the responsibility to help the organizations we work for conduct business in a way that is efficient, timely, accurate, and compliant. Certification is a way for us to measure our ability and the abilities of those who work for us. The COMMON Certification Program does just that in the realm of Business Computing. The COMMON Business Computing Associate (CBCA), and its follow on the COMMON Certified BusinessComputing Professional (CCBCP), are the only credentials that measure our ability to effectively support our organizations. This session covers requirements for the certification program and walks through some of what you may find on the exams. Certification is important to your career and important to your employer. Getting started on the CCBCP now will give you the extra edge you need to get to and exceed your life goals.



This is Session ID:170123

Speakers
avatar for Randy Dufault

Randy Dufault

Genus Technologies LLC


Monday October 15, 2018 9:30am - 10:30am
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

9:30am

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

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

This is Session ID:180052

Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son, a 110 year old family owned and operated chain of 66 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college, and he's applied those... Read More →


Monday October 15, 2018 9:30am - 10:30am
Marquis Ballroom C
  • Content Level All

9:30am

12AE VENDOR: Arcad Software : Closing the Modernization Culture and Skills Gap with DevOps
DevOps is all about improving the way organizations work in order to deliver better software faster. It starts with three things, people, processes and tools. In this session, you’ll hear how IT leaders can lead cultural change within their organizations and put a Modernization strategy in place. In addition, attract, develop and retain the talent needed for Modernization success with Arcad Software.

This is Session ID:180217

Speakers
avatar for Floyd Del Muro

Floyd Del Muro

Director, Business Development, SenecaGlobal
With 31 years of experience on the IBM midrange platform, Floyd is Director, Business Development for the SenecaGlobal group. In his role at SenecaGlobal, Floyd has been extensively involved in the management of DevOps , Enterprise Modernization and refactoring projects on IBM i... Read More →
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →


Monday October 15, 2018 9:30am - 10:30am
Grand Ballroom 6
  • Content Level All
  • Operating Systems IBMi

9:30am

12AF iHeart Open Source
Ever wondered about open source and whether or not you should consider open source solutions in the IBM I environment – then this session is for you! We will start by taking a quick look at the Open Source ecosystem and then dive into some specific open source offerings including PHP and MySQL/MariaDB.


This is Session ID:180186

Speakers
avatar for Erwin Earley

Erwin Earley

Sr Solutions Consultant, Zend by Perforce
With over 20 years working in the IBM i community previously at IBM and now with Zend by Perforce 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, PHP). I... Read More →


Monday October 15, 2018 9:30am - 10:30am
Marquis Ballroom A

9:30am

12AG What You Need to Know to Successfully Upgrade to 7.3, 7.2, and 7.1
When doing an upgrade to IBM i, there is more work involved in the planning of the upgrade than in the actual upgrade itself. When you have done the planning, the actual upgrade is simple. We will cover planning tips, pre-requisites, and then post installation requirements. Your upgrade isn’t complete until this last step is done. While this presentation will focus on upgrading to 7.3, if you are upgrading to an earlier release (7.2, 7.1), we will also cover those releases.


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


This is Session ID:170361

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 October 15, 2018 9:30am - 10:30am
Marquis Ballroom B

9:30am

Certification Testing
Please check in at Registration.

Monday October 15, 2018 9:30am - 11:45am
Pittsburgh Room
  • Content Level All

10:45am

13AD POWER PICK: Watson and IBM i
Did you know that Watson and IBM i can work together ? This session will review what is Watson and its importance in your business. We will then dive into the technology that allows you to connect your IBM i data to Watson. There are a number of different options and we will be discussing each as we tour connecting IBM i and Watson.


This is Session ID:170659

Speakers
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →
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 October 15, 2018 10:45am - 11:45am
Grand Ballroom 5

10:45am

13AA Create or Replace … DDS Files with DDL Objects
With the latest releases and technology refreshes the SQL data definition language (DDL) for creating and maintaining database objects was enormously enhanced. DDS on the other hand is stabilized. But still a lot of applications even those with a modern graphical interface and where the latest goodies of the programming language are used in the source code are based on DDS described files. The excuse DDL enhancements cannot be used, because of the DDS description and the native I/O access of these files, does not count any more. With Reverse Engineering, the SQL code for DDS described objects can be retrieved. CREATE OR REPLACE statements allow DDS described files to be converted into SQL defined database objects, while the programs that use these files can stay untouched. With the CREATE OR REPLACE TABLE statement, files with fields based on field reference tables can be managed.

Learning Objectives:
In this session you will learn to convert DDS described files into SQL tables and SQL indexes without touching any program code. It will also be demonstrated how reference files can be used in composition with SQL tables and how (future) enhancements, for example adding columns on a specific position or changing data types and lengths can be managed.

This is Session ID:170028

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Monday October 15, 2018 10:45am - 11:45am
City Center A

10:45am

13AB 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


This is Session ID:170323

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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Monday October 15, 2018 10:45am - 11:45am
City Center B

10:45am

13AE VENDOR: Rapidly Create Responsive Web Applications with Fresche Solutions
Attend this session to learn how your existing staff can rapidly develop first-rate responsive web applications for desktop and mobile devices with Fresche solutions. We give you the choice to choose the development approach that best meets your needs.

You’ll see:
•Modernizing and mobilizing green screens with Presto
•Creating new PHP responsive web applications with WebSmart
•The advantages of responsive design for mobile and desktop web applications

This is Session ID:180318

Speakers
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for 18 years, the last 11 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 analysis... Read More →


Monday October 15, 2018 10:45am - 11:45am
Grand Ballroom 6
  • Content Level All
  • Operating Systems IBMi

10:45am

13AF Tools for Getting Started with Open Source
A lot has been happening in the world of open source on IBM i! Are you ready to join this exciting adventure? This session will help you get started. We will go over some fundamental concepts and introduce you to some of the tools that can be used for editing files, debugging, doing version control, etc.


Learning Objectives:
1. Learn the various ways to edit open source code on IBM i
2. Learn what a shell is and how to access one
3. Tie these tools together to be a productive open source user and developer!


This is Session ID:170232

Speakers
avatar for Joshua Hall

Joshua Hall

Owner, SoBored
Josh Hall is a passionate advocate of Open Source Software. He advocates for open source by providing education, training, and development through his business, SoBored. In addition, Josh spreads open source knowledge by giving labs and presentations at conferences and user groups.In... Read More →


Monday October 15, 2018 10:45am - 11:45am
Marquis Ballroom A

10:45am

13AH 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

This is Session ID:180307

Speakers
avatar for Marina Schwenk

Marina Schwenk

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


Monday October 15, 2018 10:45am - 11:45am
Marquis Ballroom C

10:45am

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


Learning Objectives:
1. Understand how modernization is a strategy rather than an objective.
2. Navigate the pitfalls and costs of upgrading after years of inattention.
3. Change your company's mindset about updating its infrastructure.


This is Session ID:180274

Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 


Monday October 15, 2018 10:45am - 11:45am
Marquis Ballroom B
  • Content Level All
  • Operating Systems IBMi

10:45am

13AC Connecting the Dots: Building Web Applications with PHP, HTML, CSS, and JavaScript
New to web development, or trying to get started? Have you taken a PHP course, but are having trouble understanding how to build complete applications for the web? Or maybe you're a manager trying to get an understanding of how web applications work at a high level. This presentation will provide an overview of how browser-based database applications work, with an IBM i / RPG audience in mind. It will demonstrate the client-side languages - HTML, CSS and JavaScript - and show how PHP scripts running on a server can dynamically build web pages including content from an IBM i DB2 database. We will discuss the HTTP protocol and how web servers work with HTML and PHP, look at some common formatting techniques in HTML and CSS, demonstrate how HTML forms interact with PHP scripts, and show what JavaScript is and how it makes the browser more functional. With these basics concepts in mind, you should be able to make better decisions about how to sort through the many options available for web-enabling your legacy databases. This presentation is for beginner to novice web programmers, or those who would like to understand the technologies and languages involved in a typical web application. This session is a recommended (not mandatory) pre-requisite for John's labs on HTML, PHP, and JavaScript.


This is Session ID:170065

Speakers
avatar for John Valance

John Valance

Senior Consultant, Profound Logic
John Valance is a senior consultant and modernization strategist for Profound Logic Software. He has worked on the IBM midrange platform since the 1980s, and on web development since 1998. As a consultant and developer, John specializes in modernization and web application development... Read More →


Monday October 15, 2018 10:45am - 11:45am
Grand Ballroom 1

11:30am

COMMON Expo
Monday October 15, 2018 11:30am - 1:30pm
Grand Ballroom 2-4
  • Content Level All

12:00pm

Lunch in the COMMON Expo
Monday October 15, 2018 12:00pm - 1:00pm
Grand Ballroom 2-4

1:30pm

15AJ KEYNOTE: Thirty Years of Innovation and We're Just Getting Started
IBM i is celebrating 30 years of amazing innovation from IBM and from our clients and partners!
This session celebrates the innovations and the innovators; what IBM has provided and what clients have accomplished with them.

Prepare to be amazed by some of the incredible IBM i customer stories from all over the world.

Speakers
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →


Monday October 15, 2018 1:30pm - 2:30pm
Marquis Ballroom A-C
  • Content Level All
  • Operating Systems IBMi

2:45pm

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


This is Session ID:180315

Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO, Central Park Data
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →


Monday October 15, 2018 2:45pm - 3:45pm
Grand Ballroom 5
  • Operating Systems IBMi

2:45pm

16AA What's New in Db2 for i
In the tradition of previous Technology Refreshes (TR), the database team is delivering enhancements on the same cadence. Attend this session to hear about the many enhancements to SQL on i, SQL Query Engine, IBM i Services and more. This session will cover the new and enhanced Db2 for i capabilities added to IBM i 7.2and 7.3 over the last Technology Refreshes.

This is Session ID:170110

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday October 15, 2018 2:45pm - 3:45pm
City Center A

2:45pm

16AH SQL Writing Tips and Techniques
SQL is a very powerful language for processing data. There are many ways to write SQL statements to get the desired results. However, not all queries are created equal. This session will compare and contrast different ways to approach a problem from an SQL perspective. Whether it is writing queries or procedures, taking the right approach for writing SQL can help the database help you.

This is Session ID:180169

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Monday October 15, 2018 2:45pm - 3:45pm
Marquis Ballroom C

2:45pm

16AC SPONSOR: Accelerate IBM i Development with X-Analysis
IBM i applications are often complex and old which makes them difficult and risky for developers to maintain. Attend this session to learn how to improve the way you maintain your RPG, COBOL and CA 2E applications with Fresche’s analysis and documentation solution, X-Analysis Advisor.

Join leading expert Robert Arce and learn how X-Analysis Advisor helps you:
• Reduce the risks of code changes & simplify application maintenance with impact analysis
• Make informed decisions with a 360-degree view of your applications and data
• Onboard new staff with application and database documentation
• Scope projects and create test plans

Speakers
avatar for Robert Arce

Robert Arce

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


Monday October 15, 2018 2:45pm - 3:45pm
Grand Ballroom 1

2:45pm

16AE VENDOR: Application Modernization. No Open Source or PASE Needed. See How!
IBM i organizations face a wide range of different application modernization options — from web enabling green screens, modernizing legacy code or building new web based or mobile solutions from scratch. Selecting the best approach requires understanding how you can quickly achieve tactical wins and introduce new web & mobile applications which work in harmony with your existing IBM i systems and databases

Attend this session to learn how to remove the obstacles of application modernization. Discover a fast, easy and cost-effective strategy to meet a broad spectrum of native modernization strategies that do not require open source or PASE.

See a live demonstration on how to leverage your existing applications, repurpose your existing functionality and extend your applications with brand new capabilities and walk away knowing how to rapidly modernize your IBM i applications using a single platform for all your modernization projects.

Attendees can expect to learn by attending the session:
1. Tactical techniques that deliver instant graphical interfaces for our existing 5250 applications.
2. Intermediate approaches that incrementally improve application flow, eliminate manual processes and aggregate information from multiple sources into a single pane of glass.
3. Long term strategies that increase developer productivity, improve software agility, reduce risk and extend the longevity of your applications.

This is Session ID:180316

Speakers
avatar for David Brault

David Brault

Product Manager / CAAC Member, LANSA
David Brault is the Product Marketing Manager at LANSA, a leading vendor in IBM i application development and integration tools. Since graduating from the University of Wisconsin, David has spent his last 25 years working in the IBM i industry, amassing extensive experience integrating... Read More →
avatar for Tom Cremieux

Tom Cremieux

LANSA
Tom Cremieux has 10 years of LANSA development experience. He’s skilled in application modernization, integration, and new development that utilize various mobile and web platforms/tools including .NET, Java, PHP, HTML and LANSA. Tom frequently demonstrates the latest LANSA technologies... Read More →


Monday October 15, 2018 2:45pm - 3:45pm
Grand Ballroom 6
  • Content Level All
  • Operating Systems IBMi

2:45pm

16AF Git Lost!
Educational Session: • Git Lost! – Everything you wanted to know about Git but were afraid to ask You've heard a lot about Git but don’t know where to start or don’t understand how all these Git things are related. GitHub, BitBucket, GitLab, Git Flow, Push, Pull, Rebase….. We help break it down in this session, about Git options, Git terminology, and Git usage for beginners and how you can consider Git to store your native source in a small shop or an enterprise setting. Welcome to the world of Git!


Learning Objectives:
1.Clarify Git
2. Explain how to incorporate in an i environment


This is Session ID:180130

Speakers
avatar for Floyd Del Muro

Floyd Del Muro

Director, Business Development, SenecaGlobal
With 31 years of experience on the IBM midrange platform, Floyd is Director, Business Development for the SenecaGlobal group. In his role at SenecaGlobal, Floyd has been extensively involved in the management of DevOps , Enterprise Modernization and refactoring projects on IBM i... Read More →
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →


Monday October 15, 2018 2:45pm - 3:45pm
Marquis Ballroom A
  • Content Level All
  • Operating Systems IBMi

2:45pm

16AB 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.


Learning Objectives:
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!


This is Session ID:180262

Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son, a 110 year old family owned and operated chain of 66 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college, and he's applied those... Read More →


Monday October 15, 2018 2:45pm - 3:45pm
City Center B
  • Content Level All

2:45pm

16AG Step-By-Step Guide to Creating Virtual I Partitions Hosted by IBM i
IBM i has the capability of hosting an IBM i Logical Partition (LPAR) to provide virtual disk storage for other IBM i partition. IBM i has provided „hosted disk” for Windows servers and AIX or Linux partitions for several years, but the ability to host another IBM i LPAR is new. See the step by step process in creating hosted virtual partitions. Learn the requirements, the prerequisites, and all the steps needed to create this once your back in the office. This will be great for creating a virtual partition to test your 7.2 or 7.3 upgradeI


Learning Objectives:
1) Understand the relationship between all the components of a virtual LPAR.
2) How to create virtual storage.
3) How to use this knowledge back at your shop to build your own.


This is Session ID:170524

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 October 15, 2018 2:45pm - 3:45pm
Marquis Ballroom B

2:45pm

Certification Testing
Please check in at Registration.

Monday October 15, 2018 2:45pm - 6:15pm
Pittsburgh Room
  • Content Level All

4:00pm

17AD POWER PICK: 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.

This is Session ID:170051

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
Grand Ballroom 5

4:00pm

17AA SQL Stored Procedures and Application Modernization
Among the many modernization technologies available on IBM i, SQL is perhaps the one best known by RPG developers. This session won't focus on how to write SQL statements, but rather how to write scripts that combine SQL statements together into procedures that encapsulate database access and core business logic for use in a myriad of modern applications. We'll discuss how stored procedures fit into a modernization strategy, and why they are such a good fit for RPG programmers who want to participate in modernization projects. They're also a great fit for anyone new to IBM I who needs access to its database for applications in PHP, Java, Crystal Reports, IBM Web Query, Excel, Web Services, conversion projects, etc. SQL is often embedded in other languages, such as RPG, PHP, Java, etc. But IBM provides the SQL Procedure Language (SQL/PL), which can be used to code complex or multiple SQL statements into procedures that can form the backbone of a service oriented architecture. These procedures can be called from any programming language. This can simplify the database access code in PHP, Java, and other host languages, while taking full advantage of DB2-specific SQL features. Come and learn about the many features and benefits of SQL stored procedures, how to code them, and how to use them in your modernization strategy.


This is Session ID:170074

Speakers
avatar for John Valance

John Valance

Senior Consultant, Profound Logic
John Valance is a senior consultant and modernization strategist for Profound Logic Software. He has worked on the IBM midrange platform since the 1980s, and on web development since 1998. As a consultant and developer, John specializes in modernization and web application development... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
City Center A

4:00pm

17AB Practicalities and Realities of IBM i Modernization
In this session, Trevor will share some of the realities of application modernization, identifying the challenges you might face, solutions to get through modernization roadblocks, and many practical lessons learned. He will review a modern architecture that can be adapted to suit IT environments for companies as a direction for modernization. And, he’ll outline a transformation architecture to enable your existing applications to co-exist with your modernized applications and that can be used during and beyond your modernization project.


Learning Objectives:
1. Understand how modernization fits your company
2. Learn approaches to counter the walls of attempting modernization


This is Session ID:180289

Speakers
avatar for Trevor Perry

Trevor Perry

FrescheThinker, Fresche Solutions
Trevor Perry is a veteran of the IBM i community. He is a consultant to companies on their I.T. modernization efforts, and has been engaged in all phases of the IT development cycle. He is a popular speaker at industry events on technical, strategic, modernization and motivational... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
City Center B
  • Content Level All
  • Operating Systems IBMi

4:00pm

17AF 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


This is Session ID:170690

Speakers
avatar for Mike Pavlak

Mike Pavlak

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


Monday October 15, 2018 4:00pm - 5:00pm
Marquis Ballroom A

4:00pm

17AH 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


This is Session ID:180257

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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
Marquis Ballroom C

4:00pm

17AC Anonymization of Sensitive Data- How Does GDPR Affect You?
Does your organization store or access personal data, such as credit card details, health records, biometric or even location data? If so, you may be concerned by the new data protection regulations, increasingly strict and with potential of heavy financial penalties. The digital economy has transformed the way data is circulated, on a global scale. Certain activities such as software testing are at particular risk of a data leak, as effective testing requires the use of real production data, often far less protected in test environments.


Our session will summarize these risks, and demonstrate how to anonymize data automatically, on any platform (IBM i, Windows, UNIX, Linux, z/OS), to protect your data privacy and ensure compliance:
• Anonymize personal data automatically
• Eliminate the risk of data leak
• Preserve the integrity, and usability, of data


This is Session ID:180265

Speakers
avatar for Floyd Del Muro

Floyd Del Muro

Director, Business Development, SenecaGlobal
With 31 years of experience on the IBM midrange platform, Floyd is Director, Business Development for the SenecaGlobal group. In his role at SenecaGlobal, Floyd has been extensively involved in the management of DevOps , Enterprise Modernization and refactoring projects on IBM i... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

4:00pm

17AG Configuring a Partition From HMC to Storwize with the Magic of the Command Line!
GUI GUI GUI STICKY GUI it's all we here about these days. The HMC has a GUI the fiber switches have a GUI the network switches have a GUI Storewize has a GUI the firewall has a GUI. They are so nice a purdy and all grpahicalike and such. However in case you've been living under a rock they keep changing. Allow me to imnumerate a few. HMC: No more with the classic now it's the super duper enhanced mega. Plus! And nothing is where it once was. In fact at this point in late 2017 some stuff ain't even there AND you cannot go back!! Fiber switches: Need JAVA. Stupid JAVA. And they download the big blobba java to your desktop through the browser to run it. And you cannot change the font size and you gotta wait for every click. I'm already old!! Oh your browser updated? Yeah sucks to be you, find an old XP machine and try from there, and good luck! Storwize, yeah that one actually ain't all bad! BUT the steps you need to take to create a host and create the LUNS and map the LUNS is not so quick. And then you gotta wait on those LUNS to format too. Icky sticky. And some stuff simply does not exist in the GUI. For example what percentage of your data is on SSD vs Spinny? How about how far behind is remote copy? No idea, I know, not visible! But it doesn't have to be this way! Did you know that you can create a partition on the HMC with ONE command?! Yep, just one. Did you know you can list the WWNs for that partition with one command? Did you know that on the SAN you can create the disk LUNS withOUT having to wait for them to format? How about that SSD vs Spinny? On the command line, presto chango, a little maconess and shazaam there it is! Fiber switch (face palm) There is so little you really need to do in there and it is Sooo logical that the massive 10 ton JAVA GUI is like a 12 lb sledge hammer for a little finish nail! Come, learn, be edjumacated about the way to be efficient and to NOT have to worry if the next browser update will blasticate your ability to manage the foundations of your enterprise!!


Learning Objectives:
1. Learn how simple the requirements are to create a guest partition hosted by IBM i.
2. Learn the options for sharing of disk, tape, and optical
3. Learn how to create a network bridge so allow network access.


This is Session ID:180205

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 midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
Marquis Ballroom B
  • Content Level All
  • Operating Systems IBMi

5:15pm

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



This is Session ID:180178

Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO, Central Park Data
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →


Monday October 15, 2018 5:15pm - 6:15pm
Marquis Ballroom C

5:15pm

18AD POWER PICK: 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


This is Session ID:170431

Speakers
avatar for Robert Swanson

Robert Swanson

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


Monday October 15, 2018 5:15pm - 6:15pm
Grand Ballroom 5

5:15pm

18AA Dueling SQL
At this new session, Tim and Scott will enter into an SQL duel. Who will win? The attendees of the session will decide. They will take turns presenting their favorite approaches to using one or more of the IBM i Services. Come to this session to have some fun and see the best of the best SQL has to offer. Let the match begin.


This is Session ID:180297

Speakers
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Monday October 15, 2018 5:15pm - 6:15pm
City Center A
  • Content Level All
  • Operating Systems IBMi

5:15pm

18AC Application Analysis: A Starting Point for Any Modernization Project
Application modernization projects leverage the business value buried in your applications while exploiting the opportunities that new technologies can offer. Like any major enhancement to your system, such projects start by a thorough analysis, to understand application structure, dependencies, data model and business rules. When performed manually, application analysis can consume 50% of the modernization effort. This session gives a practical view of automated application “discovery” using the latest IBM tools. Using case examples we will see how automated application analysis saves time and improves accuracy on modernization projects of any scale.


Learning Objectives:
1. Automated application analysis helps eliminate costly and timely modernization project errors.


This is Session ID:170394

Speakers
avatar for Floyd Del Muro

Floyd Del Muro

Director, Business Development, SenecaGlobal
With 31 years of experience on the IBM midrange platform, Floyd is Director, Business Development for the SenecaGlobal group. In his role at SenecaGlobal, Floyd has been extensively involved in the management of DevOps , Enterprise Modernization and refactoring projects on IBM i... Read More →


Monday October 15, 2018 5:15pm - 6:15pm
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

5:15pm

18AF Node.JS Crash Course
In this session, you will get a breadth of information including language basics, installation, connecting to DB2, and getting started with web development. Learn about unique languages features with Node.JS Learn how to use Express.JS and jade to get to the web Discover how to connect to the IBM i within a Node.JS application

Learning Objectives:
Learn about unique languages features with Node.JS Learn how to use Express.JS and jade to get to the web Discover how to connect to the IBM i within a Node.JS application

This is Session ID:170674

Speakers
avatar for Joshua Hall

Joshua Hall

Owner, SoBored
Josh Hall is a passionate advocate of Open Source Software. He advocates for open source by providing education, training, and development through his business, SoBored. In addition, Josh spreads open source knowledge by giving labs and presentations at conferences and user groups.In... Read More →


Monday October 15, 2018 5:15pm - 6:15pm
Marquis Ballroom A

5:15pm

18AB 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?


This is Session ID:180051

Speakers
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son, a 110 year old family owned and operated chain of 66 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college, and he's applied those... Read More →


Monday October 15, 2018 5:15pm - 6:15pm
City Center B
  • Content Level All

5:15pm

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


Learning Objectives:
1. Learn from the mistakes of high profile security failures
2. Understand what you can do right now to prevent security failures in your environment


This is Session ID:170728

Speakers
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 


Monday October 15, 2018 5:15pm - 6:15pm
Marquis Ballroom B
  • Content Level All
  • Operating Systems IBMi

6:00pm

Welcome Reception in the Expo
Monday October 15, 2018 6:00pm - 8:00pm
Grand Ballroom 2-4
 
Tuesday, October 16
 

8:00am

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



This is Session ID:170277

Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO, Central Park Data
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →


Tuesday October 16, 2018 8:00am - 9:00am
Marquis Ballroom C

8:00am

21AF Getting to Know IBM i Access Client Solutions
IBM i Access Client Solutions is the newest 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. 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 looks very bright and IBM i Access Client Solutions provides ease of deployment, and operational improvements in nearly every function the client provides. During this session we will make a survey of the IBM i Access Client Solutions functions and features and accomplishing the tasks and processes that we use IBM i Access for. Become familiar and more comfortable with IBM i Access Client Solutions!



This is Session ID:170162

Speakers
avatar for Wayne Bowers

Wayne Bowers

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


Tuesday October 16, 2018 8:00am - 9:00am
Marquis Ballroom A

8:00am

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

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

This is Session ID:180016

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday October 16, 2018 8:00am - 9:00am
City Center A

8:00am

21AE VENDOR: The Role of IBM I Applications in the API Economy
In an age where people expect self-service convenience, high quality, real-time business information and rapid response through mobile apps, websites, and online portals, organizations are focused on improving business insight and expanding customer engagement. To get there, they are building new workflows and business processes that match how customers and employees work within their new mobile or web environments.


In this session, Rocket Software will show you how you can most effectively build leading-edge mobile and web user experiences and update workflows by using your host-based applications as building blocks. Rather than replacing proven systems, turn the functions you need into APIs without changing the code – unlocking the full value of your existing applications, speeding project delivery timeframes, increasing productivity, reducing risk, and enjoying all the benefits of the API economy.

This is Session ID:170743

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 October 16, 2018 8:00am - 9:00am
Grand Ballroom 6
  • Content Level All
  • Operating Systems IBMi

8:00am

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



This is Session ID:180277

Speakers
avatar for Erwin Earley

Erwin Earley

Sr Solutions Consultant, Zend by Perforce
With over 20 years working in the IBM i community previously at IBM and now with Zend by Perforce 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, PHP). I... Read More →


Tuesday October 16, 2018 8:00am - 9:00am
Grand Ballroom 1

8:00am

21AB Student Discussion Panel
If you are a student your are invited to participate in this disucssion.

This is Session ID:180325

Moderators
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), 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 →
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 is one of two junior IBM... Read More →
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →


Tuesday October 16, 2018 8:00am - 9:00am
City Center B
  • Content Level All
  • Operating Systems IBMi

8:00am

21AD POWER PICK: IBM i Navigator Performance Tasks
IBM i provides a full suite of tools to manage the performance of your system. The IBM i performance tools are part of the base operating system and are found in Navigator for i; several additional options are enabled when the Performance Tools licensed program product has been installed. This session reviews the performance tools that come with the operating system, covering the basics of these performance tasks and how to effectively use them. This presentation will provide an overview on how to manage your IBM i performance data, use the Performance Data Investigator to graphically view your IBM i performance data, monitor your performance in near-real-time with system monitors, understand your performance trends with graph history, and predict application changes with batch model. Other sessions on the conference agenda will delve deeper into the topics covered in this overview presentation.

This is Session ID:180311

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
"i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.You may contact Dawn by email at DawnMayiCan@outlook.com, find her on twitter at @DawnMayiCan, or connect on LinkedIn at https://www.linkedin... Read More →


Tuesday October 16, 2018 8:00am - 9:00am
Grand Ballroom 5

8:00am

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


Learning Objectives:
1) Understand some easy ways to gain performance with reorganization of physical files.
2) How to find objects on your system that are growing or that you aren't using.
3) Optimization of other objects on your syste,


This is Session ID:170363

Speakers
avatar for Pete Massiello

Pete Massiello

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


Tuesday October 16, 2018 8:00am - 9:00am
Marquis Ballroom B

8:00am

Certification Testing
Please check in at Registration.

Tuesday October 16, 2018 8:00am - 11:30am
Pittsburgh Room
  • Content Level All

9:15am

22AF IBM i and the Paradox of Approximate Computing
No one will argue that computing, across hardware and software, has evolved over the past 30 years to allow us to do things about which our grandparents never dreamed. Would they have guessed that all that computational power, combined with unfathomable volumes of data, would be used to get less accurate answers? That is the strength and beauty of the cognitive era, as computing works like our brains not giving the “right” answer, but to deliver the “best” answer. IBM i, with its integrated database, linkages to the latest programming languages, and connections to the very latest cognitive applications is just as relevant in the era of approximate computing as it was at its inception.



This is Session ID:170756

Speakers
avatar for Alison Butterill

Alison Butterill

WW IBM i Offering Manager, IBM
Alison Butterill is the offering manager for IBM i. She owns the responsibility for the IBM i business, including defining and guiding future directions and strategies. She works with the IBM i sales, marketing, and development teams as well as clients and partners to ensure that... Read More →


Tuesday October 16, 2018 9:15am - 10:15am
Marquis Ballroom A
  • Content Level All
  • Operating Systems IBMi

9:15am

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

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

This is Session ID:170054

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday October 16, 2018 9:15am - 10:15am
City Center A

9:15am

22AC SPONSORED: Off-Site Backup and Disaster Recovery for IBM i
This session will focus on how to optimize your backup and disaster recovery processes for your enterprise and the lessons learned from Hurricane Irma. Derrick will provide an overview of two customers who declared disasters during the hurricane and walk you through how they approached protecting their business-critical data, applications and operations against downtime.

We will share how we have implemented different vaulting and replication technologies for many of our customers who have struggled with the rising costs and complexities of data storage, backup and disaster recovery processes. We offer best-in-class backup and recovery services for the IBM Power System platform, and also Windows. Our solutions can be designed to be cloud-based, on-premise, or a hybrid of both configurations.


All attendees will learn on how to achieve the following goals:
• Virtually eliminate the need to purchase tapes and pay for off-site storage
• Realize labor savings by reducing the amount of time spent managing the
backup process
• Reduce duplication of data and implement flexible data retention policies
• Improve Disaster Recovery Protection with faster recovery times
• Implement a cost-effective DR plan that is convenient to test
• Benefit from a hosted data replication and high availability arrangement on a pay-as-you-go contract basis


This is Session ID:170742

Speakers
avatar for Derrick Smith

Derrick Smith

Solution Architect, Datanational Corporation
Datanational Corporation, an IBM Business Partner – Cloud Specialty Provider, has strategically invested in the business and IT infrastructure to deliver systems, facilities and bandwidth on-demand. As a multi-platform services provider and systems integrator, Datanational has the... Read More →


Tuesday October 16, 2018 9:15am - 10:15am
Grand Ballroom 1

9:15am

22AE VENDOR: Create IBM i Web & Mobile Apps with No Programming (Unless You Want To)
The Valence Framework for IBM i, available for free download, includes a browser-based low-code development utility through which anyone with a solid understanding of their IBM i database can create highly useful apps, such as dashboards and web queries, in just a matter of minutes!  Complete with download-to-Excel functionality, the Valence App Builder tool can also help you create file maintenance apps in which users can adjust content in physical files — you control which fields they can see or edit.  

All of this can be done with no coding required, though advanced developers can extend the app's functionality with RPG or SQL code to handle business logic as needed.  IBM i programmers who really want to get their hands dirty 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, developers and super users alike can crank out highly functional web and mobile apps on IBM i in no time, and with no prior experience in web or mobile development.  Come to this demo session to see how easy it can be to build such an app on your system today!


This is Session ID:170734

Speakers
avatar for Robert Swanson

Robert Swanson

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


Tuesday October 16, 2018 9:15am - 10:15am
Grand Ballroom 6
  • Content Level All
  • Operating Systems IBMi

9:15am

22AH IBM i Security: The Good, the Bad, and the Downright Ugly
Don’t miss out on more than a decade’s worth of market research on the security configurations of IBM i servers and the successes and failures of organizations that run critical applications on them. HelpSystems has audited thousands of IBM i servers around the world, gaining extensive, real-world insight into the deployment state of IBM i security controls.


Learning Objectives:
Join the author of the wildly popular "State of IBM i Security" study for a recap of eye-opening statistics from the current report. Along with the results, this session provides review and tips in seven configuration categories:
• Network-initiated commands & data access
• Server-level security controls
• Profile and password settings
• Administrative capabilities
• Public accessibility to corporate data
• System event auditing
• Virus scanning Learn what steps your own organization must take to address these continually overlooked and dangerous security exposures—including some that are often missed by professional auditors!


This is Session ID:170209

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →


Tuesday October 16, 2018 9:15am - 10:15am
Marquis Ballroom C

9:15am

22AG RPM's for the System Administrator
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? Why the switch? What new skills do I need? How do I sanely manage open source on my system? Come to this session to demystify the bold new world of RPM's.



This is Session ID:180229

Speakers
avatar for Joshua Hall

Joshua Hall

Owner, SoBored
Josh Hall is a passionate advocate of Open Source Software. He advocates for open source by providing education, training, and development through his business, SoBored. In addition, Josh spreads open source knowledge by giving labs and presentations at conferences and user groups.In... Read More →
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 


Tuesday October 16, 2018 9:15am - 10:15am
Marquis Ballroom B
  • Content Level All

9:15am

22AD POWER PICK: The Care and Feeding of Your HMC
Strange but True the HMC is an actual real computer and should be treated as one! In this session we'll talk about proper configuration, especially the network and the firewall built into the system. You will learn how to make it report problems to IBM and how IBM contacts the right people when problems exist. We'll discuss user profile and access and proper restrictions that will allow you to let others use the HMC without risk to the servers it manages. We will show you how to apply maintenance and how to upgrade it. We'll explain how to connect to it remotely and how to run commands from it's command line. Of course we'll tour the interface so that you're comfortable with navigation. What we won't do in this session is discuss how to create partitions, this is an HMC session not a virtualization session!


Learning Objectives:
1. Understand the components and capabilities of the HMC
2. Configure the HMC and its users and security.
3. Update the HMC software.
4. Connect to the HMC remotely to manage IBM i


This is Session ID:170286

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 midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction... Read More →


Tuesday October 16, 2018 9:15am - 10:15am
Grand Ballroom 5

10:30am

23AD POWER Panel: Modernization
For many of us, being "modern" was one of the appeals of building a career working with computers. It was all new and high-tech, and we got to play with the coolest toys. So why now do we need to talk about "modernization"? What exactly is old and needs to be modernized? Is it our beloved IBM i operating system? The Power Systems hardware it runs on? The languages available to us? The tools we use? Or is it as simple as the UI our applications use, and the devices they run on? Is this a problem specific to our community, or is it fairly universal? And is "legacy" a four-letter word, or is it just a euphemism for "proven"? What's the cost of failure to modernize? Come to this panel discussion to learn the answers to these questions and more. Bring your own questions, and we'll try to answer them with the help of our expert panelists.

Got a question to ask during the panel? Submit Now 

This is Session ID:180246

Moderators
avatar for Steven Wolk

Steven Wolk

CTO, PC Richard & Son
Steven Wolk is the CTO for PC Richard & Son, a 110 year old family owned and operated chain of 66 appliance, electronics, and mattress superstores located throughout NY, NJ, CT, and PA. Steve's deep background in retail began on the sales floor while in college, and he's applied those... Read More →

Speakers
avatar for Charlie Guarino

Charlie Guarino

CEO, Central Park Data
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. He is also the founder and President of Central Park Data Systems, Inc., a Long Island and New York City area based IBM midrange consulting and corporate training company. In addition... Read More →
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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for 18 years, the last 11 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 analysis... Read More →


Tuesday October 16, 2018 10:30am - 11:30am
Grand Ballroom 5
  • Content Level All
  • Operating Systems IBMi

10:30am

23AF POWER Panel: Open Source
Open source has moved to the front and center of many IBM i shops. Discuss with open source experts interesting projects in the open source community, the best way for attendees to participate, and barriers to adoption of these technologies and how to overcome them.

Got a question to ask during the panel? Submit Now 

This is Session ID:180245

Moderators
avatar for Mike Pavlak

Mike Pavlak

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

Speakers
avatar for Erwin Earley

Erwin Earley

Sr Solutions Consultant, Zend by Perforce
With over 20 years working in the IBM i community previously at IBM and now with Zend by Perforce 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, PHP). I... Read More →
avatar for Joshua Hall

Joshua Hall

Owner, SoBored
Josh Hall is a passionate advocate of Open Source Software. He advocates for open source by providing education, training, and development through his business, SoBored. In addition, Josh spreads open source knowledge by giving labs and presentations at conferences and user groups.In... Read More →
avatar for Jeffrey Tickner

Jeffrey Tickner

ARCAD Software
Jeff Tickner has worked in Change Management on the IBM I for 17 years at different companies. He is certified in Rational Team Concert as well has having experience with other Change Management packages from SourceSafe to Subversion. Jeff currently works for ARCAD Software, an international... Read More →


Tuesday October 16, 2018 10:30am - 11:30am
Marquis Ballroom A
  • Content Level All
  • Operating Systems IBMi

10:30am

23AA POWER Panel: Security
Hands up everyone who has heard – or even shared - the assertion that IBM i is one of the most secure systems available. Wow, that’s virtually all of you! Unfortunately, that claim comes with a HUGE disclaimer regarding knowledge and effort that most of us prefer to ignore. Of course, security, and it’s regulatory companion, compliance, are both highly-desirable states but what does it really mean to achieve it? Does it involve the OS, your application providers, or just your perimeter firewall? IBM has been steadily adding security-related features with each new OS release but most of us still rely heavily on the simple menu system that we wrote in 1992 to protect our most critical data. It’s time that we “modernize” our approach to IBM i security in the same way we are modernizing our applications so let’s talk about what needs to be tackled when locking things down and how can we avoid breaking the good stuff in the process.

This panel is ready to dispel the myths, disclose the realities, and discuss how to keep your company out of the spotlight.

Got a question to ask during the panel? Submit Now

This is Session ID:180244

Moderators
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →

Speakers
avatar for Thom Haze

Thom Haze

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers, Integrated... Read More →
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 


Tuesday October 16, 2018 10:30am - 11:30am
City Center A
  • Content Level All
  • Operating Systems IBMi

10:30am

23AH POWER Panel: POWER9
POWER9 is here. As many in our community will be looking to upgrade, we want to provide information on what these new servers offer you and your business.

According to IBM, POWER9-based servers are built for data intensive workloads, are enabled for cloud, and offer industry leading performance.

Attend this POWER Panel to learn more.

Got a question to ask during the panel? Submit Now 

This is Session ID:180319

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

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 midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction... Read More →
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
"i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.You may contact Dawn by email at DawnMayiCan@outlook.com, find her on twitter at @DawnMayiCan, or connect on LinkedIn at https://www.linkedin... 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 →


Tuesday October 16, 2018 10:30am - 11:30am
Marquis Ballroom C
  • Content Level All
  • Operating Systems IBMi

11:30am

COMMON Expo
Tuesday October 16, 2018 11:30am - 1:30pm
Grand Ballroom 2-4
  • Content Level All

12:00pm

Lunch in the COMMON Expo
Tuesday October 16, 2018 12:00pm - 1:00pm
Grand Ballroom 2-4

1:30pm

25AF An Administrators Guide to IBM i Access Client Solutions
IBM i Access Client Solutions is the newest 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. Actually the future is already here as in April of 2015 IBM announced that there are no plans to support the r7.1 IBM i Access for Windows client on future versions of the Windows OS. So, this IBM i Access Client Solutions product is the only environment fully supported on the Windows 10 OS and its the strategic direction for IBM i Access workstation client environments. This session will specifically focus on the advanced Administration tools and approaches for IBM i Access Client Solutions.


This is Session ID:170163

Speakers
avatar for Wayne Bowers

Wayne Bowers

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


Tuesday October 16, 2018 1:30pm - 2:30pm
Marquis Ballroom A

1:30pm

25AA Clearing the Fog on SQL Joins
Clear up the confusion on how joins works. Pick the right join type for the job.


Learning Objectives:
1. Better understand how joins work
2. determining the right join for a given situation


This is Session ID:170259

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Tuesday October 16, 2018 1:30pm - 2:30pm
City Center A

1:30pm

25AC CAAC Panel: Be Heard – Your role in the future of IBM i


This is Session ID:180321

Speakers
avatar for David Brault

David Brault

Product Manager / CAAC Member, LANSA
David Brault is the Product Marketing Manager at LANSA, a leading vendor in IBM i application development and integration tools. Since graduating from the University of Wisconsin, David has spent his last 25 years working in the IBM i industry, amassing extensive experience integrating... Read More →
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 →
avatar for Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 


Tuesday October 16, 2018 1:30pm - 2:30pm
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

1:30pm

25AD POWER PICK: Working with JSON in RPG with YAJL
JSON (JavaScript Object Notation) is quickly becoming an important document format for business data interchange, so what's the best way to process it from RPG? JSON provides the same benefits as XML, but is smaller (and so transmits over a network more quickly) and is much more efficient than XML to work with in web applications. Naturally, this means that your RPG business applications need to learn how to speak JSON in order to talk to many of the newer web services or exchange data with many tech-savvy business partners. In this session, Scott will explain how the open source YAJL tool can be used from an RPG program to process JSON with the DATA-INTO opcode, directly with YAJL's API and generate JSON with YAJL.


Learning Objectives:
1. Basic introduction to JSON format
2. How to generate a JSON document in RPG with YAJL
3. How to read a JSON document in RPG with DATA-INTO
4. How to read a JSON document in RPG with the YAJL API


This is Session ID:170320

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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Tuesday October 16, 2018 1:30pm - 2:30pm
Grand Ballroom 5

1:30pm

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


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


This is Session ID:170340

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), 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 →


Tuesday October 16, 2018 1:30pm - 2:30pm
Marquis Ballroom C

1:30pm

25AB Introduction to Securing Applications with DCM
The ability to secure a connection from a client to servers such as HTTP, Telnet, and FTP have been available for many years, but users may still consider the process confusing due to unfamiliar terms and complex configurations. This session will attempt to take a somewhat complicated topic and describe the process of securing applications with system TLS (Transport Layer Security) using DCM (Digital Certificate Manager) in a manner that will reduce complexity and clarify confusion so you can configure your system to take advantage of secure sessions. Topics being discussed include certificate stores, certificate authorities, application definitions, encryption and hashing algorithms, cipher specifications, and getting these items working together to establish a secure network session.

Learning Objectives:
Learn how to generate and sign a certificate, assign it to an application, and configure the client application so a secure session can be established.

This is Session ID:180264

Speakers
avatar for Thom Haze

Thom Haze

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers, Integrated... Read More →


Tuesday October 16, 2018 1:30pm - 2:30pm
City Center B

1:30pm

25AG 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.


This is Session ID:170152

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
"i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.You may contact Dawn by email at DawnMayiCan@outlook.com, find her on twitter at @DawnMayiCan, or connect on LinkedIn at https://www.linkedin... Read More →


Tuesday October 16, 2018 1:30pm - 2:30pm
Marquis Ballroom B

1:30pm

Certification Testing
Please check in at Registration.

Tuesday October 16, 2018 1:30pm - 6:15pm
Pittsburgh Room
  • Content Level All

2:45pm

26AA 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

This is Session ID:170108

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Tuesday October 16, 2018 2:45pm - 3:45pm
City Center A

2:45pm

26AF Introduction and What's New with Db2 Web Query
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


This is Session ID:170095

Speakers
avatar for Doug Mack

Doug Mack

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


Tuesday October 16, 2018 2:45pm - 3:45pm
Marquis Ballroom A

2:45pm

26AE VENDOR: Profound UI and Profound.js: Agile Modernization with Ease!
In this session, we discuss what sets Profound Logic’s suite of integrated, innovative products apart. Learn how Profound UI modernizes green screen applications, how it can run with existing RPG code and work seamlessly on the IBM i. Be introduced to Profound.js and the exciting possibilities of development on IBM i with new talent and technologies.

This is Session ID:180322

Speakers
avatar for Matthew Denninghoff

Matthew Denninghoff

Developer, Profound Logic Software
Matthew has a BS from the University of Kentucky in Computer Science. He’s spent years working with each of many different programming languages, including RPG, JavaScript, C, C++, Java, PHP, various SQL, and--of course--Node.js. His experience is in web development, business applications... Read More →


Tuesday October 16, 2018 2:45pm - 3:45pm
Grand Ballroom 6
  • Content Level All

2:45pm

26AH 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.

This is Session ID:170060

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday October 16, 2018 2:45pm - 3:45pm
Marquis Ballroom C

2:45pm

26AB IFS Security: Don't Leave Your Server Vulnerable
Experts agree that one of the most overlooked areas of IBM i security is the integrated file system (IFS). Despite containing many sensitive things, including the operating system and all of your application libraries and files, IFS security remains a mystery to most administrators.


Learning Objectives:
Attend this important session to learn about securing the IFS, including what users may be doing with little more than a user profile and password:
• Why do we care about the IFS?
• Permissions versus authority
• Root folder access
• Auditing IFS activities
• Read/write versus *ALLOBJ
• Anti-virus considerations


This is Session ID:170213

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →


Tuesday October 16, 2018 2:45pm - 3:45pm
City Center B
  • Content Level All
  • Operating Systems IBMi

2:45pm

26AG Cool Things in Navigator to Be a Rockstar System Administrator
IBM Navigator for i is a powerful new tool to better manage your i environment. Get expert advice for installation and set up to make sure you get this powerful tool up and running at peak efficiency. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Learn ways to protect your system from intrusions, as well as close security holes such as FTP. See how this tool can help you select and install Logical files on your system to improve performance. Learn about the enhancements to this valuable tool in the release of version 7.3, while we see how this tool provides tips and techniques for better and more easily managing your IBM i.


Learning Objectives:
1) Learn how to close down various TCP/IP servers like FTP from intruders
2) How to use the Index Advisor to improve performance
3) Identify if someone is trying to access your IBM i with Intrusion Detection
4) Performance Management graphs


This is Session ID:170527

Speakers
avatar for Pete Massiello

Pete Massiello

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


Tuesday October 16, 2018 2:45pm - 3:45pm
Marquis Ballroom B

2:45pm

26AC Debugging in the Browser: Introduction to Chrome DevTools
Included in the popular (and free!) Google Chrome web browser are some of the most useful front-end development and debugging tools you'll ever need. Even IBM i programmers with little or no background in web development can find useful elements in these tools, as they provide a mechanism for understanding what's happening with any element on a web page communicating with their IBM i server. The tools also provide an effective playground for experimenting with HTML, CSS and JavaScript concepts. In this session Rob will demonstrate how Chrome's integrated DevTools can be used to interrogate data going between an IBM i and a front-end web application, view source code, analyze visual elements and dig into other common aspects of a typical web page. The discussion will also include an introduction to basic JavaScript debugging, JSON (Javascript Object Notation), and DOM (Document Object Model) concepts, which are key components to almost all modern web and mobile apps. Learn how to access Chome DevTools (from Windows or Mac)


Learning Objectives:
1. Understand how to use the most common DevTools elements
2. Become familiar with basic concepts behind JSON and the DOM, all of which can be inspected in DevTools
3. See practical steps to apply when trying to understand where data in a business app is coming from (even if you didn't create the app to begin with!)


This is Session ID:170433

Speakers
avatar for Robert Swanson

Robert Swanson

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


Tuesday October 16, 2018 2:45pm - 3:45pm
Grand Ballroom 1

2:45pm

26AD POWER PICK: Advanced SQL Data Manipulation Language (Double Session)
Part 1 SQL is a very powerful language for accessing and manipulating data. This session will explore some of the more advanced SQL concepts. The session begins with a discussion about thinking “set at a time” vs. row at a time, then continues with Set operations, Sub queries, Common Table Expressions, Derived Tables and more. Part 2 This session will focus on more of the Set at a time concepts of SQL DML. Topics covered include: Grouping Sets, Cube, Rollup, Recursive Common Table Expressions, and OLAP Extensions provided by Db2 i 7.3


Learning Objectives:
1. Improved understanding of SQL language elements related to manipulation of data.
2. Change the thought process of manipulating data from processing rows, to processing sets..


This is Session ID:180112

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Tuesday October 16, 2018 2:45pm - 5:00pm
Grand Ballroom 5

4:00pm

27AA What’s New in IBM i 7.2 & IBM i 7.3
With IBM i 7.1 normal support ending on April 30, 2018, it’s a good time to review the new possibilities that should be considered after upgrading to IBM i 7.2 or IBM i 7.3. In this session, Scott will explain the major features and functions that exist within these releases. You will leave this session with a firm grip on the benefits to be gained on the latest and greatest IBM i has to offer. Attend this session to move your IBM i plans from Coach to First class.



This is Session ID:180298

Speakers
avatar for Scott Forstie

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Tuesday October 16, 2018 4:00pm - 5:00pm
City Center A
  • Content Level All

4:00pm

27AB 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, Linux, AIX and IBM i in a partition, 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, system recovery for journals and SWA synchronization for libraries and IFS. 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.


This is Session ID:170305

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 October 16, 2018 4:00pm - 5:00pm
City Center B

4:00pm

27AG IBM i Network Monitoring, Diagnostics and Troubleshooting
The IBM i OS network communications has changed a lot since the AS/400 primarily communicated to workstations and printers using Twinax and to other computer systems using specialized communications lines. In some ways things are more complex because our IBM i OS systems communicate to a lot of other devices in many different ways, but in other ways things are simpler today because nearly all network communications are built on top of the foundation of Ethernet and TCP/IP. Your IBM i OS Networking health is very important and is it how most of your data and applications are accessed. This session will take a look at approaches to monitoring this IBM i OS Networking health and it's interaction with the network, how to collection diagnostic data and how to troubleshoot problems.



This is Session ID:180105

Speakers
avatar for Wayne Bowers

Wayne Bowers

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


Tuesday October 16, 2018 4:00pm - 5:00pm
Marquis Ballroom B

4:00pm

27AH 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


This is Session ID:170322

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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Tuesday October 16, 2018 4:00pm - 5:00pm
Marquis Ballroom C

4:00pm

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


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


This is Session ID:170341

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), 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 →


Tuesday October 16, 2018 4:00pm - 5:00pm
Marquis Ballroom A

4:00pm

27AC Web Design Tips for Green Screeners
Many green screen programmers using RPG, COBOL and the like often struggle to leverage their skills in the Web and Mobile world due to the paradigm shift from green to GUI then for UI to UX. This session will take you from where you are today to where you need to be tomorrow and beyond, leveraging you existing skillset. User experience is a very large subject and we cannot make you experts in a single session; our goal is to start you off in the right direction. After the session, attendees will have a good understanding how to build and leverage these skills to modernize legacy applications and build new ones.


Learning Objectives:
This session will show you how to:
1. Translate those green paradigms to GUI to leverage skills you already have
2. Design the look of your applications by examining the features of familiar applications
3. Use color in interface design
4. Engage the user We will also show the trend towards splitting user experience from development and how organizations like IBM, Adobe, Microsoft, and looksoftware have met this challenge.
5. Understand mobile and responsive design and just how easy it can be.


This is Session ID:170358

Speakers
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for 18 years, the last 11 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 analysis... Read More →


Tuesday October 16, 2018 4:00pm - 5:00pm
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

5:15pm

28AF Conquer the IBM i World with OpenSSH!
Yes, you can rule the (IBM i) world with just one port! Come discover the many tasks you can do with SSH, including: - Accessing the filesystem - Doing file transfers - Editing files - Running simple SQL - Running CL commands - Looking at active jobs - Accessing a git repository - Running Access Client Solutions (with X11 forwarding) for more advanced tasks


Learning Objectives:
1. Discover the many things you can do with SSH on IBM i
2. Understand the implications of being able to perform many operations on a single port.


This is Session ID:180004

Speakers
avatar for Joshua Hall

Joshua Hall

Owner, SoBored
Josh Hall is a passionate advocate of Open Source Software. He advocates for open source by providing education, training, and development through his business, SoBored. In addition, Josh spreads open source knowledge by giving labs and presentations at conferences and user groups.In... Read More →


Tuesday October 16, 2018 5:15pm - 6:15pm
Marquis Ballroom A

5:15pm

28AA Data Security and Compliance Monitoring with Db2 for i
With additional compliance laws coming from Europe and various states in the US, it is harder to do business in different parts of the world without adequately securing your data. This session will discuss various security compliance laws and provide an overview of how to best secure your data. Topics covered include: Security administrative roles, Object level Security, Row and column access control, PowerSC, and Guardium.



This is Session ID:180170

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Tuesday October 16, 2018 5:15pm - 6:15pm
City Center A

5:15pm

28AD POWER PICK: 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.


This is Session ID:180273

Speakers
avatar for Doug Mack

Doug Mack

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


Tuesday October 16, 2018 5:15pm - 6:15pm
Grand Ballroom 5

5:15pm

28AE 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!



This is Session ID:170732

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 October 16, 2018 5:15pm - 6:15pm
Grand Ballroom 6
  • Content Level All

5:15pm

28AC YiPs Roundtable
If you're a young IBM i user, or new to the system, you're invited to participate on a COMMON/IBM advisory team called Young IT Professionals (YiPs). You'll review COMMON and IBM i initiatives relevant to you and network with your peers.

This is Session ID:180320

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 Steve Pitcher

Steve Pitcher

IBM i Administration, iTech Solutions
Multi-industry IT professional with experience as a developer, systems administrator and IT Director.Skilled in security and collaborative solutions with a focus on IBM i (AS/400 or iSeries). 


Tuesday October 16, 2018 5:15pm - 6:15pm
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

5:15pm

28AH Using Watson from RPG
IBM has been making a splash with Watson and cognitive services. Did you know that you can use IBM Watson from your RPG applications? You can, as long as your IBM i can access the Internet. In this session, Scott explains how to integrate Watson's capabilities into your RPG applications.


Learning Objectives:
1. What IBM Watson and Cognitive Computing are, and why they're exciting news.
2. How Watson is made available, which services it provides.
3. How to call Watson from your RPG programs and get back the results.


This is Session ID:170671

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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Tuesday October 16, 2018 5:15pm - 6:15pm
Marquis Ballroom C

5:15pm

28AB Authority Collection Utility in 7.3 – Locking down Security for Your Sensitive Data Files and Objects
This presentation will introduce a new capability in the 7.3 release called Authority Collection. 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:
1. Learn about new support in 7.3, called authority collection, that helps the system administrator lock down security on sensitive data files and objects.


This is Session ID:170023

Speakers
avatar for Thom Haze

Thom Haze

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers, Integrated... Read More →


Tuesday October 16, 2018 5:15pm - 6:15pm
City Center B

5:15pm

28AG Predictive Performance Management
Can the past predict the future? What about the present - right here and now? And if you know the past, and can predict the future, how can you determine the impact to your applications?  Performance management on IBM i has proactive monitoring features and historical data capabilities, as well as application performance modeling. Attend this session to learn how you can use monitoring to identify and resolve potential issues before they become actual problems, learn about historical performance data and how you can use the past trends to plan for the future, and application modeling to understand what hardware changes will mean to your applications.


Learning Objectives:
1. Learn about monitors in Navigator for i to proactively manage your IBM i.
2. Learn how to project future trends from past history.
3. Learn how to model the application impacts from a hardware upgrade.


This is Session ID:170154

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
"i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.You may contact Dawn by email at DawnMayiCan@outlook.com, find her on twitter at @DawnMayiCan, or connect on LinkedIn at https://www.linkedin... Read More →


Tuesday October 16, 2018 5:15pm - 6:15pm
Marquis Ballroom B
 
Wednesday, October 17
 

8:00am

31AA 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 !!



This is Session ID:180300

Speakers
avatar for Wayne Bowers

Wayne Bowers

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

Scott Forstie

Db2 for i Business Architect, IBM
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.Scott is a frequently published author, speaker at industry... Read More →


Wednesday October 17, 2018 8:00am - 9:00am
City Center A
  • Content Level All
  • Operating Systems IBMi

8:00am

31AF Quick Start to Value with Db2 Web Query
Now that you've heard about DB2 Web Query ,what are some of the ways you can take immediate advantage of it? Import Query/400 definitions and modernize them. Download and install the simplified TRIAL code that includes built in reports for system utilization information. Scared of meta data - don't be - as we'll talk about that too.


Learning Objectives:
1. Learn about ways that you can get immediate value out of DB2 Web Query.
2. Understand the options in modernizing Query/400 reports
3. Learn how to be a hero.


This is Session ID:170098

Speakers
avatar for Doug Mack

Doug Mack

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


Wednesday October 17, 2018 8:00am - 9:00am
Marquis Ballroom A

8:00am

31AB 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.


This is Session ID:170326

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 October 17, 2018 8:00am - 9:00am
City Center B

8:00am

31AC 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.



This is Session ID:180190

Speakers
avatar for Erwin Earley

Erwin Earley

Sr Solutions Consultant, Zend by Perforce
With over 20 years working in the IBM i community previously at IBM and now with Zend by Perforce 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, PHP). I... Read More →


Wednesday October 17, 2018 8:00am - 9:00am
Grand Ballroom 1

8:00am

31AH So Now What? - Using Integrated Web-Services Server and Service Programs
This session shows how a service program that was originally used for a 5250 application can be used to create a web-service. In this presentation, we will work through the steps required to make a number of web-services using a service program, install the web-services on the IBM Integrated Web Services Server and consume the web service using PHP and Java.


Learning Objectives:
1. Understand the process and various options when setting up the Integrated Web-Service Web Server.
2. Understand how to write subprocedures in service programs that can be used for a web service.
3. Understand how to consume a web-service using technologies like PHP.


This is Session ID:170342

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), 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 →


Wednesday October 17, 2018 8:00am - 9:00am
Marquis Ballroom C

8:00am

31AD POWER PICK: An Introduction to the Criticality of Cybersecurity
Few things strike fear in the hearts of business leaders more than the threat of a security breach. Exponential growth in electronic data, coupled with the explosion of interconnected devices, means data is now under constant attack. A new generation of cybersecurity experts has been tasked with defining new ways to secure it. Led by Power Systems security expert and Certified Information Security Manager (CISM), Robin Tatam, this session will discuss: • A (quick!) history lesson on the birth of cybersecurity • All Data Matters! • What the heck is SOX, PCI, and HIPAA? • Causes, costs, and effects of a data breaches on business • The future of data protection You may even discover whether or not Power Systems servers are secure!


Learning Objectives:
1. Learn history of cybersecurity
2. Understand basic cybersecurity terminology


This is Session ID:170736

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, Helpsystems
Robin Tatam is HelpSystems’ Global Director of Security Technologies and a COMMON subject matter expert (SME). As an award-winning speaker on security topics, Robin has been interviewed and quoted by industry magazines and has published numerous trade articles. Robin’s extensive... Read More →


Wednesday October 17, 2018 8:00am - 9:00am
Grand Ballroom 5

8:00am

31AG 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.



This is Session ID:170155

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
"i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.You may contact Dawn by email at DawnMayiCan@outlook.com, find her on twitter at @DawnMayiCan, or connect on LinkedIn at https://www.linkedin... Read More →


Wednesday October 17, 2018 8:00am - 9:00am
Marquis Ballroom B

8:00am

31AI Hands on With IBM Cloud
Interested in the IBM Cloud platform for application development and hosting? If so, come join us. You can get started with a free Cloud (Bluemix) account, register to use API's, connect your phone's sensors to the cloud, analyze social media, and more!

Learning Objectives:
1. Create a new Cloud account
2. Get started with online application development tools like Node RED 3. Have a working idea of how to use IBM Cloud

This lab is a bring your own device (BYOD) session.

Pre-requisites:
It is highly recommended for you to install the following tools on your PC prior to attending the lab:

For Windows, we recommend you have the following installed
• PuTTY SSH Client
• WinSCP to access the filesystem
• Notepad ++ editor

For Mac, we recommend you have the following installed
• SSH Client is already there
• SSHFS to access the filesystem
• Notepad ++ editor

This is Session ID:180324

Speakers
avatar for Mike Pavlak

Mike Pavlak

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


Wednesday October 17, 2018 8:00am - 10:15am
Grand Ballroom 2
  • Content Level All

9:15am

32AF IBM i Access Client Solutions Deployment Best Practices
IBM i Access Client Solutions is the newest 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. Actually the future is already here as in April of 2015 IBM announced that there are no plans to support the r7.1 IBM i Access for Windows client on future versions of the Windows OS. So, this IBM i Access Client Solutions product is the only environment fully supported on the Windows 10 OS and its the strategic direction for IBM i Access workstation client environments. 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.



This is Session ID:180102

Speakers
avatar for Wayne Bowers

Wayne Bowers

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


Wednesday October 17, 2018 9:15am - 10:15am
Marquis Ballroom A

9:15am

32AA Transactional vs. Analytical SQL
Understanding and spotting it: what should an appropriate data model look like? What are the red flags that your data model is not best for your usage? This session will discuss these topics along with strategies for doing more analytical processing of your transactional data. Additional topics covered such as: - virtual vs. ETL mapping - using dimension tables for dates, VINs, customer name, zip code, etc.. Operational Data Stores, Dimensional Data Model and why they are best for analytical analysis will also be discussed.



This is Session ID:180174

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Wednesday October 17, 2018 9:15am - 10:15am
City Center A

9:15am

32AD POWER PICK: Talent Acquisition Resource for the Future
The presentation discusses where and how to find the next generation of resource on IBM i. With many retiring and many looking for IBM i resource where do you turn to find resource. The presentation discusses options for finding resource including: Connecting with Colleges CEF (COMMON Education Foundation) Local user groups connecting with community with student resource Recruiting within from other departments Mentor young or new IT resource Training Consulting and outsourcing Cloud Connecting with IBM i Academic Initiative Job boards and recruiters COMMON bootcamp and training focused for new resource IBM i Fresh Faces Reach out to others – don't reinvent the wheel


Learning Objectives:
1. understand options for finding resource.
2. Find out where and how to find resource.
3. Find out where to turn to find resource.


This is Session ID:180310

Speakers
avatar for Laura Ubelhor

Laura Ubelhor

Consultech Services, Inc.
Laura Ubelhor is owner and operator of Consultech Services, Inc. and longtime advocate for IBM i education. Consultech, established in 1992, specializes in application development and support on IBM i and other platforms. Laura has a Masters of Science in Management Degree from Walsh... Read More →


Wednesday October 17, 2018 9:15am - 10:15am
Grand Ballroom 5
  • Content Level All
  • Operating Systems IBMi

9:15am

32AE Self-Healing Capabilities of Domino 10
Domino 10 has some amazing self-healing capabilities that are going to make every admin’s life much easier. Learn how automatic cluster database symmetry works to ensure both NSFs and DAOS content are kept in sync across cluster mates. Understand how the repair engine remedies any missing databases or NLOs, rebuilds full text indexes, and detects and repairs corrupt NSFs and NLOs. You will also learn how to use the new commands to manually invoke corruption repair and how the new replica synchronization tool and replication currency monitoring work. Get the ins and outs of the functionality of automatic hot view updating and how to setup deletion logging so you know who/what deleted a document.


This is Session ID:180303

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 →


Wednesday October 17, 2018 9:15am - 10:15am
Grand Ballroom 6

9:15am

32ACB 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 vs Node.js) * 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


This is Session ID:170393

Speakers
avatar for Greg Patterson

Greg Patterson

Modernization Specialist, Fresche Solutions
Greg Patterson has been in the IT field for 18 years, the last 11 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 analysis... Read More →


Wednesday October 17, 2018 9:15am - 10:15am
City Center B
  • Content Level All
  • Operating Systems IBMi

9:15am

32AC Stupid Python Tricks
Python has many tools built in and many tools just a web request away. Learn how these tools can save you time and money. See examples parsing CSV files, sending emails, building Excel xlsx files, and more!



This is Session ID:170411

Speakers
avatar for Joshua Hall

Joshua Hall

Owner, SoBored
Josh Hall is a passionate advocate of Open Source Software. He advocates for open source by providing education, training, and development through his business, SoBored. In addition, Josh spreads open source knowledge by giving labs and presentations at conferences and user groups.In... Read More →


Wednesday October 17, 2018 9:15am - 10:15am
Grand Ballroom 1

9:15am

32AH Getting Started with Consuming Web Services on an IWS Server
Consuming web services is an important skill for today's IBM i Developer. This session will give some examples of how a developer can easily consume a web service installed on an IWS server with a back-end RPG program performing all CRUD(Create/Read/Update/Delete) functionality. Topics covered in this session will include - 1. Downloading and getting started with Bootstrap 2. Coding the call to the web service 3. Understanding the JSON returned from the service. 4. Useful websites for getting started Takeaways - 1. Articulate the process of installing and using Bootstrap 2. Understanding the connection to the IWS server 3. Answers to common problems when working with web services and service programs


This is Session ID:180301

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


Wednesday October 17, 2018 9:15am - 10:15am
Marquis Ballroom C

9:15am

32AG Daily Care and Feeding of IBM i
IBM i and IBM Power Systems combine to deliver a fabulously reliable environment. The operating system has rich work management capability and strong error reporting. Despite that you shouldn't ignore it or you will eventually find yourself dealing with something serious. In this session we'll cover the things you need to watch and understand allowing you to deal with them before they become serious issues.


Learning Objectives:
1) Learn where to look and what to look for to know how your system is running.
2) Learn what to configure for automatic reporting of errors and problem.
3) Learn the points at which you need to begin to apply effort well before issues occur.
4) Be able to tell management: "Yes our IBM i is running well!"


This is Session ID:170290

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 midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction... Read More →


Wednesday October 17, 2018 9:15am - 10:15am
Marquis Ballroom B

10:30am

33AA Be a Hero with Database Indexing
Learn about database indexing technology for DB2 for i and the proper way to determine which indexes to create. Not all good indexes are advised and not all advised indexes are good


Learning Objectives:
1. General understanding of database indexing technology
2. why indexes are so important for good performance
3. approaches for determining the right indexes to create


This is Session ID:170241

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
City Center A

10:30am

33AF Taking Db2 Web Query to the Next Level: Advanced Reporting Tips
Simple reports are....simple. But how do deal with the more complex requests you get for reports and leverage techniques in Db2 Web Query to meet those requirements. This session will cover dealing with dates - data range reports, y2y, rolling month issues. We'll show you how to leverage SQL Views and Db2 OLAP Specifications for difficult analytics. We'll even delve into integrating data from Watson into your reports.


Learning Objectives:
1. Get advanced education on reporting techniques
2. Learn about augmenting existing operational data with data from the cloud
3. Discover the power of meta data and data dimension tables for date processing in reports


This is Session ID:180043

Speakers
avatar for Doug Mack

Doug Mack

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


Wednesday October 17, 2018 10:30am - 11:30am
Marquis Ballroom A

10:30am

33AE Exploring NoSQL Databases
Open Source Databases are one of the fastest growing topics of interest today and NoSQL databases are no exception. NoSQL databases provide for storage and retrieval of data that is modeled in ways other than tabular relations used in relational databases. This session will explore why NoSQL databases are important as well as showing how to work with some of the more popular NoSQL databases such as MongoDB.


This is Session ID:180181

Speakers
avatar for Erwin Earley

Erwin Earley

Sr Solutions Consultant, Zend by Perforce
With over 20 years working in the IBM i community previously at IBM and now with Zend by Perforce 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, PHP). I... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
Grand Ballroom 6

10:30am

33AB 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.


This is Session ID:170330

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 October 17, 2018 10:30am - 11:30am
City Center B

10:30am

33AC Real-world IBM i Companies Using Mobile to Improve Business
Requests to “go mobile” are coming from both end-users and executives alike. But what does it mean for a company to “go mobile?” And which parts of the organization should be mobilized? Attend this session to learn how other IBM i shops – across several industries – are building mobile applications that cut costs, improve user productivity, increase data accuracy, and speed up business processes.


Learning Objectives:
Discover different mobile challenges faced by today's IBM i companies and the real-world examples of how they addressed them. Understand the differences between the different type of mobile applications companies can build (Web vs Hybrid vs Native). Review real-world ROI of “going mobile” achieved by IBM i companies.


This is Session ID:170351

Speakers
avatar for David Brault

David Brault

Product Manager / CAAC Member, LANSA
David Brault is the Product Marketing Manager at LANSA, a leading vendor in IBM i application development and integration tools. Since graduating from the University of Wisconsin, David has spent his last 25 years working in the IBM i industry, amassing extensive experience integrating... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
Grand Ballroom 1
  • Content Level All
  • Operating Systems IBMi

10:30am

33AH Consuming Web Services from RPG with HTTPAPI
Web services have taken the world of IT by storm. This session discusses what a Web Service is and how the free HTTPAPI tool can be used to access (i.e. "consume") them from your RPG programs. It will also show you how to process the resulting JSON or XML document using RPG's DATA-INTO and XML-INTO opcodes.


Learning Objectives:
1. What web services are and how they are used
2. The types of web services
3. How to use RPG and HTTPAPI to consume them 4. Examples


This is Session ID:170315

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, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
Marquis Ballroom C

10:30am

33AD POWER PICK: Single Signon
IBM i has the capability to participate in a single sign on environment. What is single sign on? Single sign on is an authentication process where a user can access various applications in the network using one set of login credentials. This presentation will describe the Kerberos protocol and how to map a domain user ID to an IBM i user profile to safely authenticate the user to a 5250 session without passwords being sent across the network.

This is Session ID:180312

Speakers
avatar for Thom Haze

Thom Haze

IBM i Operating System Security Development, IBM
Thom is the lead software developer for Digital Certificate Manager (DCM) and provides cryptography related enhancements to IBM i. He has been working on IBM i and earlier named platforms since 1989 on various projects such as Integrated Windows, Linux, and VMware Servers, Integrated... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
Grand Ballroom 5
  • Content Level All

10:30am

33AG 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.



This is Session ID:180198

Speakers
avatar for Dawn May

Dawn May

Owner, Dawn May Consulting, LLC
"i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.You may contact Dawn by email at DawnMayiCan@outlook.com, find her on twitter at @DawnMayiCan, or connect on LinkedIn at https://www.linkedin... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
Marquis Ballroom B

10:30am

33AI Connect IBM i with Watson and IBM Cloud
Interested in using Watson in your IBM i applications? Come see how easy it is to deploy cognitive applications on your IBM i. Also, deploy a sample IBM Cloud (IBM Bluemix) application that communicates with IBM i.

Learning Objectives:
1. Deploy an application that talks to IBM Watson from IBM i
2. Deploy an application that talks to IBM i from IBM Cloud

This lab is a bring your own device (BYOD) session and pre-registration is required.

Pre-requisites:
It is highly recommended for you to install the following tools on your PC prior to attending the lab:
For Windows, we recommend you have the following installed
• PuTTY SSH Client
• WinSCP to access the filesystem
• Notepad ++ editor
For Mac, we recommend you have the following installed
• SSH Client is already there
• SSHFS to access the filesystem
• Notepad ++ editor

This is Session ID:180323

Speakers
avatar for Mike Pavlak

Mike Pavlak

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


Wednesday October 17, 2018 10:30am - 12:45pm
Grand Ballroom 2
  • Content Level All

11:45am

34AF IBM i OS Management on the Go with IBM i Mobile Access
IBM i Mobile Access is a solution provided as part of the IBM i Access Family of products, that allows administrators and engineers to manage and monitor the IBM i OS and users to access IBM i OS data from a Mobile browser interface! Key benefits of this environment are no client side install or configuration. Everything is installed, configured and administered on the IBM i OS System. This session will focus on the IBM i OS management and monitoring tools made available. We will also highlight the tooling available to administer what functions each user will have access to.



This is Session ID:180101

Speakers
avatar for Wayne Bowers

Wayne Bowers

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


Wednesday October 17, 2018 11:45am - 12:45pm
Marquis Ballroom A

11:45am

34AD POWER PICK: DB2 for i Visual Explain Deep Dive
Using Visual Explain for DB2 for i. Seeing is believing on SQL queries.


Learning Objectives:
1. What is Visual Explain
2. using it to better understand SQL performance
3. learn the different ways to utilize it


This is Session ID:170246

Speakers
avatar for Rob Bestgen

Rob Bestgen

IBM
Rob Bestgen is a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →


Wednesday October 17, 2018 11:45am - 12:45pm
Grand Ballroom 5

11:45am

34AA 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.



This is Session ID:180199

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 →


Wednesday October 17, 2018 11:45am - 12:45pm
City Center A

11:45am

34AB 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.


This is Session ID:170325

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 October 17, 2018 11:45am - 12:45pm
City Center B

11:45am

34AH Node.js & RPG: The Perfect Partners for Business Applications
Node.js has created a great deal of buzz within the IBM i community, and for good reason. The open source language is powerful, scalable, and appeals to developers of all ages. Node.js can be deployed in a number of ways… but how well is it a fit for business applications? In this session, Matthew  will demonstrate that Node.js is an ideal language for business application programming, in addition to your existing RPG efforts.


Learning Objectives:
Attendees of this session will learn: How Node.js is capable of deploying applications that are database-driven and transactional Why Node.js and RPG are perfect partners, and how they integrate for powerful business applications How to manage Node's “Callback Hell” through a development framework


This is Session ID:170189

Speakers
avatar for Matthew Denninghoff

Matthew Denninghoff

Developer, Profound Logic Software
Matthew has a BS from the University of Kentucky in Computer Science. He’s spent years working with each of many different programming languages, including RPG, JavaScript, C, C++, Java, PHP, various SQL, and--of course--Node.js. His experience is in web development, business applications... Read More →


Wednesday October 17, 2018 11:45am - 12:45pm
Marquis Ballroom C

11:45am

34AC Passing Your Next Security Audit: The Challenges of Properly Securing Your IBM i and Maintaining Compliance
The IBM i is a highly securable system, but it presents unique challenges to security administrators and security auditors. Achieving a secure and compliant IBM i environment is often a complex and difficult process. External threats, the array of security regulations and the increasing demands of auditors continue to grow and evolve every day. Attend this session for insights into how to achieve compliance and pass your next security audit.


Learning Objectives:
• Maintaining control of user profiles and login security
• Protecting access to your IBM i system and sensitive data
• Auditing system and database activity


This is Session ID:180292

Speakers
avatar for Richard Marko

Richard Marko

Director, Technical Services - Security Products, Syncsort
Richard Marko is the Director, Technical Services - Security Products for Syncsort. He is a noted industry expert with more than 30 years of experience working with the IBM i platform. For the past 10 years, he has helped companies architect their security and compliance management... Read More →


Wednesday October 17, 2018 11:45am - 12:45pm
Grand Ballroom 1

11:45am

34AG Selecting Your POWER Systems Hosting Environment
When virtualizing IBM POWER Systems you have two primary choices for the hosting environment, VIOS and IBM i. Each of these offers strengths and each has weaknesses. In this session we'll go over more than 35 comparison points putting the two hosting choices side by side. Well cover technical capabilities as well as usability and visual items. We'll look at costs and requirements for each host. Come and select your choice for a hosting partition or confirm that you've gone down the right track.


Learning Objectives:
What requirements would lead you to select VIOS as your hosting environment What requirements would lead you to select IBM i as your hosting environment What are the costs or need-to-knows for each of the two hosts.


This is Session ID:170291

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 midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction... Read More →


Wednesday October 17, 2018 11:45am - 12:45pm
Marquis Ballroom B