Loading…
LUG 78 has ended
Welcome to Rochester and the 78th LUG meeting - celebrating 25 years!

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

Sunday, September 15
 

6:00pm

First Time Attendee Meeting/Lynne Benedict
This session provides the first time attendee and experienced LUG members with an overview of what to expect during the week, LUG operations, and the web site. The focus is on actions you should take during the week.

Sunday September 15, 2019 6:00pm - 7:00pm
DoubleTree Hotel - Boardroom A & B

7:00pm

LUG Member Reception - DoubleTree/LUG members and IBM
This is an opportunity to have informal discussion with other LUG members, renew old acquaintances, and meet some of the IBM development team. There are no presentations, no agenda, just discussion, refreshments and hors d'oeuvres.

Sunday September 15, 2019 7:00pm - 9:30pm
DoubleTree Hotel - University Hall
 
Monday, September 16
 

6:45am

Registration and Breakfast
Things to do on arrival at the meeting this morning: Bring a photo ID (such as driver's license) or passport (for non-US members) Pick up your registration packet Meet your IBM Advocate ... be sure to contact them before the meeting Find a place to sit near the front Pick up a connector device for voting and asking questions (connector number is on the back of your connector card)

Monday September 16, 2019 6:45am - 8:00am
IBM Rochester

8:00am

Welcome and Introductions/Dave R Nelson, Lynne Benedict, Larry Bolhuis, Stacy Benfield
This session will include important information and administrative details about the meeting, including: LUG welcome, Introduction of LUG board, Introduction of new LUG member companies, IBM executive welcome, COMMON Overview, and logistics for the week

Monday September 16, 2019 8:00am - 9:00am
025-2 E105 (Main Tent)

9:00am

Power Systems Update/Terry Thomas, Gina L King
Gina King (Director, Global Power Ecoysystem & Alliances) and Terry Thomas (Director of Offering Management for Cognitive Enterprise Systems) will provide an update on IBM Power Systems plans and priorities.

Monday September 16, 2019 9:00am - 10:00am
025-2 E105 (Main Tent)

10:00am

Break
Monday September 16, 2019 10:00am - 10:15am
025-2

10:15am

IBM i for Innovators by Innovators/Steve Will, Alison K Butterill
Innovation is fueling the IBM i business, both for clients and in development. Alison Butterill, Offering Manager, and Steve Will, Chief Architect, will talk about the direction of IBM i, with the future strategy & roadmap supplemented by showing what clients are doing today.

Monday September 16, 2019 10:15am - 11:15am
025-2 E105 (Main Tent)

11:15am

Db2 for i Update/Scott Forstie
This session will include an explanation of the current technologies have been added to the database. Scott will highlight some recent enhancements as well as preview the enhancements planned for IBM i 7.3 and IBM i 7.4, coming in 4Q/2019. www.ibm.com/developerworks/ibmi/techupdates/db2 ibm.biz/Db2foriServices ibm.biz/IBMi_ACS

Monday September 16, 2019 11:15am - 12:00pm
025-2 E105 (Main Tent)

12:00pm

LUG Member Photos/William Fuhrman, Greg Gallas
Need a photo for the LUG web site? Come to the IBM Photo lab for a portrait that we'll post to the LUG site for you.

Monday September 16, 2019 12:00pm - 12:45pm
Photo Lab 25-2

12:00pm

Lunch
Monday September 16, 2019 12:00pm - 1:00pm
025-2

1:00pm

Modernization on IBM i/Tim Rowe
There are many myths about IBM i.  What is it capable of when it comes to the world of Applications.  The good news, the IBM i is celebrating its 31st birthday and all those applications written back then still work today!  Of course, the bad news is all of those applications written back then still run today.  Developers have not been forced to make radical changes on IBM i, so often they think that new is not possible.  We will spend a few minutes looking at all the options for writing the very latest in Modern programs on IBM i yet without having to throw away everything you have today. Modernization on IBM i is very much a Possible Mission.

Monday September 16, 2019 1:00pm - 1:30pm
025-2 E105 (Main Tent)

1:30pm

IBM Db2 Mirror for i/Kristopher Whitney
This session will describe Db2 Mirror at a high level but also focus on what characteristics of a workload/application are a good fit for Db2 Mirror.  We will conclude with a roadmap discussion on what is coming in the few releases of Db2 Mirror.

Monday September 16, 2019 1:30pm - 2:30pm
025-2 E105 (Main Tent)

2:30pm

Break and Networking
Monday September 16, 2019 2:30pm - 3:00pm
025-2

3:00pm

Member Minute/LUG member
Are you having trouble getting started with DDL? If so, then come see how a LUG member guided the way into the new world of DDL at his company. He will cover how a single SQL source can be used to deploy a DDL object to any library by the use of a single command. This command has become the backbone of their company's DDL campaign and hopefully it will help inspire your usage of DDL too. He will address any decisions that must be made as well as considerations to be aware of for the beginning steps into DDL. He will also cover solutions to issues that you may also experience during your DDL journey.

Monday September 16, 2019 3:00pm - 3:30pm
025-2 E105 (Main Tent)

3:30pm

Open Source Strategy/Jesse Gorzinski
You may have noticed that IBM has been embracing open source technologies lately. Why has it been such a strong force in the IBM roadmap? Because open source technologies can bring a lot of business value to the enterprise! But, what does it mean for you? Come learn how leveraging open source can position your IBM i business for future success by lowering I/T costs, enabling innovative solutions, aligning with industry skills, and more!

Monday September 16, 2019 3:30pm - 4:00pm
025-2 E105 (Main Tent)

3:30pm

QMGTOOLS/SYSSNAP/Brian J Bohner
Collect debug data faster, better, and always correctly for IBM i Support so that you can get your issue resolved quicker. Get the inside scoop on IBM's standard data collection tool along with a behind the scenes look at IBM Support tricks for analyzing all of that data efficiently.

Monday September 16, 2019 3:30pm - 4:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

4:00pm

Power Systems I/O Trends and Directions/Douglas Gibbs, Simon Porstendorfer
This session will review 2019 Power9 hardware announcements and latest IO features for IBM i.

Monday September 16, 2019 4:00pm - 5:00pm
025-2 E105 (Main Tent)

4:00pm

JSON Everyday Use/John Eberhard
JavaScript Object Notation, or JSON, is a widely used technology for information interchange on the web. This session provides an overview of JSON and describe how the JSON abilities integrated into Db2 for i allow for the easy use of JSON. In particular, the session will describe the use of the JSON_TABLE function to convert a JSON object to relational table, including several examples of using JSON_TABLE to utilize data available on the web. In the other conversion direction, the session will describe the JSON publishing functions, which create JSON objects using SQL statements. Using this knowledge, you can easily use the power of JSON within your own IBM i applications.

Monday September 16, 2019 4:00pm - 5:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

6:00pm

Marriott/LUG and IBM
This is an opportunity for informal discussion with other LUG members, IBMers who are giving presentations, and the IBM development team. You should contact your IBM i advocate or premium services contact to meet you for dinner.

Monday September 16, 2019 6:00pm - 9:00pm
Marriott Hotel Ballroom
 
Tuesday, September 17
 

6:45am

Breakfast
Tuesday September 17, 2019 6:45am - 8:00am
025-2

8:00am

Member Minute/LUG member
A LUG member will share their strategy and tool used to transform the old legacy business systems to be modularized.

Tuesday September 17, 2019 8:00am - 8:30am
025-2 E105 (Main Tent)

8:30am

Node.js Connectivity/Mark Irish
As you look to use Node.js for developing business applications, you might be wondering how you can use it to call your existing IBM i programs and Db2 tables. The IBM i Open-Source Software Team has developed a number of free, high-quality tools that assist you in accomplishing this task. In this talk, I will briefly discuss your options for connecting to IBM i and Db2 for i from Node.js, both locally and remotely, then cover in-depth how to configure, connect, and perform simple and complex queries and call programs. This talk will lay the groundwork for developing Node.js applications that compliment your current IBM i programs.

Tuesday September 17, 2019 8:30am - 9:30am
025-2 G201 (Forest/Minnesota - Breakouts)

8:30am

RPG Updates/Barbara Morris
A brief overview of recent and upcoming enhancements A discussion of what we are considering for the future for RPG

Tuesday September 17, 2019 8:30am - 9:30am
025-2 E105 (Main Tent)

9:30am

Break and Networking
Tuesday September 17, 2019 9:30am - 10:00am
025-2

10:00am

Live Partition Mobility and Simplified Remote Restart Automation Tool/Bob Foster
This session will explain how the LPM/SRR Automation tool can help customers control their LPM and SRR operations to a higher degree than the base HMC functions. It has features that allow you to quickly evacuate a frame for maintenance across many different frames and then quickly return the lpars back to their original settings. Customer scripts can be incorporated into the tool. The tool is a web-based application that can be installed and up and running in minutes. There are over 400 customers world-wide that use this tool.

Tuesday September 17, 2019 10:00am - 11:00am
025-2 G201 (Forest/Minnesota - Breakouts)

10:00am

ACS Updates & SQL Services for the App Dev/Tim Rowe, Scott Forstie
IBM i Access Client Solutions (ACS) is the strategic (aka best) interface for accessing and managing your IBM i. In this session Scott and Tim will spend some time taking a walk down the ACS lane. We will be showing you some of the more recent updates that have been added to ACS. Many of these are things that will help simplify or improve accessing or managing your IBM i. The latest and greatest version of ACS is easily accessed by downloading it from our download site - http://ibm.biz/IBMi_ACS

Tuesday September 17, 2019 10:00am - 11:00am
025-2 E105 (Main Tent)

11:00am

AI / Machine Learning on IBM i/Ross Cruickshank
In this talk, we will look at the capabilities for exploiting artificial intelligence tools and techniques since the "AI Summer" of the 1980s to the current excitement around machine-learning (ML) and deep-learning (DL). What makes ML different from a developers perspective, this time around? What value can be realised on or from the IBM i platform by incorporating AI? We'll demonstrate how easy it is for developers to incorporate ML into applications, and to build services based on AI capabilities on the cloud and on IBM i

Tuesday September 17, 2019 11:00am - 12:00pm
025-2 E105 (Main Tent)

11:00am

Query/400 and Showcase query modernization, and other Db2 Web Query topics/Doug Mack
This will be a potpourri of Db2 Web Query topics, including getting your feedback on things we're working on, like a showcase query conversion tool, and MSP/ISV licensing. We'll also show you some of the new reports for the Systems Administrator, and share with you how customers are using Db2 Web Query's ETL tool in creative ways!

Tuesday September 17, 2019 11:00am - 12:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

12:00pm

Lunch
Tuesday September 17, 2019 12:00pm - 1:00pm
025-2

12:15pm

First Time Attendee Discussion with the LUG Board
Join other first time LUG conference attendees to share your experiences with the LUG board. We want your ideas on how to improve the LUG experience.

Tuesday September 17, 2019 12:15pm - 1:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

1:00pm

DevOps - Overview/Andrew Clark (ARCAD Software)
DevOps is not just about tooling, but rather it is a changed mindset that encompasses Development, Operations, and users/stakeholders as well.  This session aims to not only answer many of the high-level questions you might have about DevOps, but also to provide concrete examples of implementing DevOps in IBM i organizations. Learn about some of the common roadblocks that many organizations have when trying to move to DevOps, and some of the steps that can be taken to overcome those obstacles.  Most importantly, this presentation should help to convince you that DevOps is not a passing fad that is going to take resources away from your "real" projects, but rather it is a fundamental shift that will make development faster, more efficient, more responsive, and (most importantly, to many) less costly with minimal investment.

Tuesday September 17, 2019 1:00pm - 2:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

1:00pm

Application Modernization Best Practices/Jim Diephuis
We have been talking about 'modernization' for a long time. What are we talking about? What are we trying to achieve? What are some of the things we should be doing to move toward it? How do we know if we are doing it right? How will we know when we are done? This presentation will attempt to answer some of those questions.

Tuesday September 17, 2019 1:00pm - 2:00pm
025-2 E105 (Main Tent)

2:00pm

A Message from Stephen Leonard, General Manager of Cognitive Systems/Stephen A Leonard
Stephen Leonard, General Manager of Cognitive Systems, will provide an update on the Cognitive Systems business

Tuesday September 17, 2019 2:00pm - 2:45pm
025-2 E105 (Main Tent)

2:45pm

Break and Networking
Tuesday September 17, 2019 2:45pm - 3:15pm
025-2

3:15pm

Knowledge Center/Nick Fernholz
Learn how to submit feedback when you find issues in the IBM Knowledge Center documentation, and some tips and tricks for viewing documentation in the Knowledge Center.

Tuesday September 17, 2019 3:15pm - 3:30pm
025-2 E105 (Main Tent)

3:15pm

DCM - What's New/Thomas Haze
An enhanced version of DCM has been in the works for quite some time now and is nearing the point for general availability. This presentation will demonstrate the awesome features of the new DCM user interface to better manage your digital certificates and application definitions to help secure your client’s connections to the server. A live demonstration will show the process to secure a telnet session using the features of the Enhanced DCM GUI.

Tuesday September 17, 2019 3:15pm - 4:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

3:30pm

Database Reorganization/Quinton Kramer
In this session, we will take a look at Reorganize Physical File Member and where it fits inside the database engineer’s toolbox. · What is it? · Why should we make use of it? · What are some best strategies for implementation, with large databases in mind? · What is new? Join a fresh face on a topic that is long overdue for conversation!

Tuesday September 17, 2019 3:30pm - 4:00pm
025-2 E105 (Main Tent)

4:00pm

Managing Open Source - CHROOTS/YUM/Erwin Early (Rogue Wave Software)
You may have heard about the latest news with open source:  RPMs!  As a system administrator, you may have lots of questions.  What does this mean for me?  Come to this session to demystify this bold new world.  IN doing so, you will learn important facets of open source management, like checking software levels, installing updates, and more.  Also, learn how to leverage chroot-based containers to allow for separated, isolated environments.  What best practices should you follow?  Also, we explore the support options for the open source technologies you are leveraging.

Tuesday September 17, 2019 4:00pm - 5:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

4:00pm

It's IBM i, darn it! Why the Name Matters/Jesse Gorzinski
That's right, it's IBM i! Not iSeries, System i, AS/400, or i5. Come to this session for a civil look at why it's important to use the operating system's correct name, whether you're hiring, job-searching, looking for solutions, or anything else. It's definitely not your grandmother's AS/400 any more!

Tuesday September 17, 2019 4:00pm - 5:00pm
025-2 E105 (Main Tent)
 
Wednesday, September 18
 

6:45am

Breakfast
Wednesday September 18, 2019 6:45am - 8:00am
025-2

8:00am

Member Minute/LUG member
A LUG member will present "Like Changing Tires on a Moving Car: Database Modernization without the Disruption".

Wednesday September 18, 2019 8:00am - 8:30am
025-2 E105 (Main Tent)

8:30am

Python/Mike Pavlak (Fresche Solutions)
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 business cases for Python on IBM i.

Wednesday September 18, 2019 8:30am - 9:30am
025-2 G201 (Forest/Minnesota - Breakouts)

8:30am

RPG Best Practices/Barbara Morris
The features of ILE RPG that allow you to write "modern" code Which old features to avoid How using service programs can modernize your development, both new function and maintenance

Wednesday September 18, 2019 8:30am - 9:30am
025-2 E105 (Main Tent)

9:30am

Break and Networking
Wednesday September 18, 2019 9:30am - 10:00am
025-2

10:00am

IBM i Public Cloud Offerings/Kristopher Whitney
This session will be an update on the latest Public Cloud offerings and some high level use cases.  A few of the high level operational considerations such as migration, backup, and DR will be discussed. We'll also discuss how IBM i fits into the hybrid Cloud story with PowerVC and Open Shift.

Wednesday September 18, 2019 10:00am - 11:00am
025-2 E105 (Main Tent)

10:00am

Git/Mike Pavlak (Fresche Solutions)
Git is a version control system that often gets confused for a source change management system. In this session we’ll explore an introduction to git basics via the web and command line, understand how git compares with change management, where git fits in to the development team and how to move forward with version control, with or without change management.  In order to understand how essential the role of git works in modern development we will also review the DevOps pipeline and how to get there from RPG. 

Wednesday September 18, 2019 10:00am - 11:00am
025-2 G201 (Forest/Minnesota - Breakouts)

11:00am

DS8K Updates/Clint A Hardy
DS8K update session.

Wednesday September 18, 2019 11:00am - 12:00pm
025-2 E105 (Main Tent)

11:00am

Creating APIs in 5 minutes with Node.js and Loopback/Stephanie Rabbani (Seiden Group)
The API economy is here, and your IBM i applications should be part of it! Stephanie will show you how to use the open-source Loopback framework, based on Node.js, to create dynamic  REST APIs with little or no coding. We will install Loopback and the brand-new IBM i Loopback connector, then use it to create an API that accesses Db2, lightning fast! Come see how quickly you can deliver your data with Node and Loopback, plus eat some chocolate.

Wednesday September 18, 2019 11:00am - 12:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

12:00pm

Lunch
Build your own deli sandwich. Ham, turkey, roast beef with assorted cheese and breads. Lettuce, tomato, onion, and condiments. Pickle spears and Potato Salad, fresh fried kettle chips.
Vegetarian option Hummus

Wednesday September 18, 2019 12:00pm - 1:00pm
025-2

12:15pm

International LUG Member Discussion/LUG Board
Discussion with the LUG board and other LUG members from outside the USA. The group will identify issues specific to the these LUG members.

Wednesday September 18, 2019 12:15pm - 1:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

1:00pm

Member Minute/LUG Member
Anhui Rural Credit Union in China had just upgraded their new generation core banking application in 2018. They've successfully ran the application under new infrastructure for almost a year. In the session, they will introduce the background of this new project, the status of the application/system running recently,  and some of their technical highlights.

Wednesday September 18, 2019 1:00pm - 1:30pm
025-2 E105 (Main Tent)

1:30pm

Test Centric Development/Andrew Clark (ARCAD Software)
"Testing" is a dirty word to many, and "automated testing" is the forgotten ugly-stepchild of the entire DevOps process or general development for that matter. This session aims to not only answer many of the high-level questions you might have about testing and how it relates to development, but also to provide concrete examples of implementing "Test Centric Development" (TCD) in IBM i organizations. Learn about some of the tooling that is available to implement TCD and how to employ a testing process that works within your organization's Development framework.  Understand terms like "micro services", MVC, xUnit and "scriptable".  Most importantly, this presentation should help to convince you that testing is critical, and that you cannot realize the full benefits of a successful DevOps / Development  strategy without a rock-solid testing strategy in place.

Wednesday September 18, 2019 1:30pm - 2:30pm
025-2 G201 (Forest/Minnesota - Breakouts)

1:30pm

Temporal Tables/Sarah A Mackenzie
Have you ever wanted to know what data was in your table six months ago? Has data ever been deleted from your table that you now need to retrieve? Maybe you want to know when and who made a change to a row in your table? Temporal Tables, introduced in IBM i 7.3, is a data centric solution that allows you to keep track of the history of your SQL tables. Once enabled, you can use simple SQL queries to ask questions about your data at a specific point in time or over a range of time. This session will explain Db2 for i Temporal Tables and generated fields as well as give many examples that you can use in your applications.

Wednesday September 18, 2019 1:30pm - 2:30pm
025-2 E105 (Main Tent)

2:30pm

Break and Networking
Wednesday September 18, 2019 2:30pm - 3:00pm
025-2

3:00pm

R you ready to analyze your data with R?/Stephanie Rabbani (Seiden Group)
Love data? Check out "R," a programming language for number crunching and analytics. R enables business users and developers to test financial models, assess risk, and analyze trends, then to translate the results into print-quality charts and graphs. Free and open source, R is available with IBM i 7.4. Empower your business with R.

Wednesday September 18, 2019 3:00pm - 4:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

3:00pm

RDi Updates/Steve Ferrell (HelpSystems)
Building upon success:
- RDi helps you be more productive!
- What’s new since last year?
- What’s coming in the next release?
What’s coming in a future release?
- Update on iDocs – LUG Requirement
Questions to consider:
How often do you update RDi?
What do you use for Version Control?
DEVOPS – How do you build and distribute?


Wednesday September 18, 2019 3:00pm - 4:00pm
025-2 E105 (Main Tent)

4:00pm

Ask The Experts/LUG & IBM
Always popular, this is your opportunity to meet with the IBM developers, one on one, with no holds barred on the questions.

Menu:
Meatballs
Chex Mix cups
Cup Cakes Vanilla and Chocolate
Flatbread Pizza Display - vegetarian option(cheese pizza) Cheese and Pepperoni

Assorted Wines, Beer, Soda, Water

Wednesday September 18, 2019 4:00pm - 6:00pm
001-1 IBM Cafeteria
 
Thursday, September 19
 

6:45am

Breakfast
French Toast butter, warm syrup
Breakfast ham slices
Hard boiled eggs
Fresh fruit
Pastries, bread, and bagels
Yogurt cups
Beverages - orange juice, milk, ice tea, water, coffee, soda

Thursday September 19, 2019 6:45am - 8:00am
025-2

8:00am

A Data Journal Extraction Tool for Security/Jim Diephuis, Terrence Forrest
Need a little more detail for your auditors than the audit journal can provide? need to know who is changing critical tables and what the changes are? Then you need to learn about the journal extract tool and how it can fill in the gaps in the audit tools. This is a new lab services asset being developed. The tool extracts the information from your data journals and puts it into a form that allows you to easily read and interpret the changes being made.

Thursday September 19, 2019 8:00am - 8:30am
025-2 G201 (Forest/Minnesota - Breakouts)

8:00am

Websphere Application Server Updates/Frederick W Rowe
As always, we continue to evolve and improve the WebSphere App Server for IBM i, and this short talk will bring you up-to-date on the most important changes, including support for IBM i v7r4.

Thursday September 19, 2019 8:00am - 8:30am
025-2 E105 (Main Tent)

8:30am

PHP/Erwin Earley (Rogue Wave Software)
PHP has been available on the IBM i platform for 12+ years and as such you may think there is nothing new to talk about – but you would be selling PHP sort to think that!  In this session we will explore enhancements to PHP in the latest release (7.x) including significant performance improvements.  We will also take a look at the breath of solutions that can be implemented with PHP, both readily deployable applications like LAMP-based solutions, as well as custom developed applications leveraging Db2 and ILE resources.  Additionally, the session will take a look at application frameworks that can be used to rapidly develop applications with basic data functionality.

Thursday September 19, 2019 8:30am - 9:30am
025-2 G201 (Forest/Minnesota - Breakouts)

8:30am

RDi Use Cases/Edmund Reinhardt
RDi Use Cases: RDi is the ultimate swiss army knife for IBM i development.  Let's look at some of the different tasks that you can use it for. 1) Help! My boss just threw me a bug in this massive ugly code base.  How can I get my arms around how this thing is supposed to work? 2) Help! We keep shipping bugs to our customers and it looks bad.  How can I know my code is tested? 3) Help! I am developing embedded SQL, how can I know this query is getting the info I need with acceptable performance? 4) Help! I am developing embedded SQL and the MS SQL guys just threw me this long query I am supposed to embed in my RPG. 5) Help! I need to fix the behavior and appearance of a green screen.  The last DDS DSPF expert just retired. 6) Help! I need to write some Java/Python/? code and store it in the IFS 7) Help! I need to write a web service to call my RPG program. and more... RDi to the rescue when you are feeling overwhelmed.

Thursday September 19, 2019 8:30am - 9:30am
025-2 E105 (Main Tent)

9:30am

Break and Networking
Thursday September 19, 2019 9:30am - 10:00am
025-2

10:00am

Call Home Support Updates/Perry Dykes
The session will describe specific updates to our existing  electronic support tools, and also describe upcoming enhancements for specific Power and Storage offerings such as electronic problem management, proactive support and new predictive failure technology put in place for a select set of products.  As normal, the presentation will provide reference information for new members who may not be that familiar in the resources section, best practices with respect to common issues. Perry Dykes, the speaker, will also be available for questions during the week as well, including the Ask the Experts session.  Lastly, we wish to gather the of level of interest of some new functions and entertain unique requirements to determine our path going forward to offer enhanced capabilities that meets your evolving electronic support tool set needs.

Thursday September 19, 2019 10:00am - 11:00am
025-2 E105 (Main Tent)

10:00am

AI / ML on IBM i - Deep Dive/Ross Cruickshank
A safe place to play with AI, open source and IBMi integration! This session will give you hands-on experience with  + yum/rpm model for open source technology install and maintenance + Node-red flow based programming + Watson Assistant chatbot capability + DB2 for i integration and particularly the Db2 for i Services + sample integrations with CL and RPG + external API integration - Weather data for example + Internet of Things - publishing and subscribing The use of Node-RED means there is no dependence on RPG, COBOL, CL, Java and the like - the tool allows for rapid application development, with minimal need for coding: attendees spend more of the time building prototype applications quickly rather than on understanding syntax and build steps.

Thursday September 19, 2019 10:00am - 12:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

11:00am

Node.JS - Building Apps/Mark Irish
Some developers may be resistant to using Node.js as they think it will be difficult to learn, or that none of their old RPG, C, CL, or COBOL programs will be accessible from Node.js. This talk will dispel those myths and demonstrate how to build applications that compliment the work that your developers have already done. In particular I will demonstrate how to create a simple Node.js application using the itoolkit package to call RPG programs and CL commands. We then take that application and expand its capability with LoopBack, a Node.js package that allows you to create quick and simple APIs. Throughout the talk I will highlight best practices for keeping your code maintainable and performant. After the talk, you will have a much better understanding of how Node.js compliments the the traditional IBM i technology stack.

Thursday September 19, 2019 11:00am - 12:00pm
025-2 E105 (Main Tent)

12:00pm

Lunch
Build your own burger, Potato Salad, Assorted chips, Garden Salad and Baked Beans (Veggie burgers available upon request)

Thursday September 19, 2019 12:00pm - 1:00pm
025-2

1:00pm

LUG Business/LUG members only
Possible Topics Operations topics Financial report Membership, new member eligibility Bylaws and policy review LUG Strategy Other discussion LUG members will discuss and vote on candidate requirements which are posted on the web site. The author (or someone designated by the author) of the requirement will make a case for formal approval by a two thirds vote of the attending companies. If there is time, members will discuss requirements with IBM Work Complete, those recommended for closure, and requirements requested by members. Add a comment to the requirement discussion if you want a requirement on the agenda. Note: At least one representative from each company must attend the LUG business sessions.

Thursday September 19, 2019 1:00pm - 3:00pm
025-2 E105 (Main Tent)

3:00pm

Break and Networking
Thursday September 19, 2019 3:00pm - 3:30pm
025-2

3:30pm

IBM i Box of Chocolates/Steve Will
Steve will cover a mixture of interesting topics, including the Requirements process from the IBM side.

Thursday September 19, 2019 3:30pm - 4:00pm
025-2 E105 (Main Tent)

4:00pm

Securing your IBM i File Transfer/Thomas Barlen
There is almost no IBM i environment that does not perform a file transfer in or out of an IBM i environment. Most of the time this is done via batch FTP procedures. The credentials (user and password) that is used for a batch file transfer is stored in clear text. In addition, the data transfer is typically done in unencrypted format, thus rendering credentials and sensitive business data in clear text in the network. This session will introduce various options (FTP and SSH) that IBM i provides out of the box to implement secure file transfer. This includes network encryption options, different authentication mechanisms, etc.

Thursday September 19, 2019 4:00pm - 5:00pm
025-2 G201 (Forest/Minnesota - Breakouts)

4:00pm

REST APIs/Tim Rowe
REST APIs - Rest APIs are key to the world these days. IBM i includes a REST services infrastructure and engine that greatly simplifies the ability to take an existing RPG or COBOL program (or SRVPGM) and create a running REST interface with a few simple clicks. Applications have been connecting to ILE apps for a while now. The latest support now also lets you directly access Db2 for i with a REST API. We will dive into this New support to help you understand how to build Rest APIs with only SQL.

Thursday September 19, 2019 4:00pm - 5:00pm
025-2 E105 (Main Tent)

6:00pm

Rochester Golf and Country Club/LUG and IBM
This is an opportunity for informal discussion with other LUG members, IBMers who are giving presentations, and the IBM development team. You should contact your IBM i advocate or premium services contact to meet you at the reception.

Menu:
Cheese and Crackers
Fresh Fruit & Berries
Garden Salad
Grilled Salmon with Cucumber Dill Sauce
Chicken Marsala
Carved Prime Rib
Green Beans Amandine
Parslied Baby Red Potatoes
Crème Brulee and English Trifle

Thursday September 19, 2019 6:00pm - 9:00pm
Rochester Golf and Country Club
 
Friday, September 20
 

6:45am

Breakfast
Friday September 20, 2019 6:45am - 8:00am
025-2

8:00am

Open Source - Where to get Help/Jesse Gorzinski
Open Source is rapidly bringing new innovation to the platform. As you choose to embrace these rapidly-moving technologies, you may naturally need some help along the way. In this session, we will explore what to do (and what NOT to do) to get your questions answered, or how to receive guidance, support, or professional services if needed.

Friday September 20, 2019 8:00am - 8:30am
025-2 E105 (Main Tent)

8:30am

Using ACS Visual Explain to understand query performance/Linda M Swan
Linda will provide an explanation of how to use Visual Explain (VE) to understand query performance. Understanding why the optimizer chose the given plan is not always crystal clear but with a little effort in understanding the VE at hand you can often discover where the optimizer can use a little help. This session will include several of the most commonly confronted problems seen by the development lab from a field support perspective. Whether your problem query is caused by inefficient use of indexes, poor join order, outdated statistics, missing indexes, a poorly formed question of the data or some other reason, you can use Visual Explain in IBM i Access Client Solutions to gain the needed insight to move forward.

Friday September 20, 2019 8:30am - 9:45am
025-2 E105 (Main Tent)

9:45am

Break and Networking
Friday September 20, 2019 9:45am - 10:00am
025-2

10:00am

Hidden Gems/Various Speakers
Several LUG members and IBMer's will share their favorite IBM i features, tips, or tricks.

Friday September 20, 2019 10:00am - 10:30am
025-2 E105 (Main Tent)

10:30am

Winter Meeting Preview and Closing Comments/Stacy Benfield, Dave R Nelson, Dutch Holland
A brief review and discussion of topics for the Winter 2020 meeting. Closing comments will follow.

Friday September 20, 2019 10:30am - 11:00am
025-2 E105 (Main Tent)