Loading…
for WMCPA Spring Conference 2017
Attending this event?
View analytic

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

Tuesday, March 14
 

8:00am

Women in IT
Tuesday March 14, 2017 8:00am - 4:30pm
TBA

9:00am

SQL Programming Overview
Learn how to use advanced SQL features and syntax that can be leveraged from any
programming language that supports SQL. Learn about advanced SQL DDL (Data
Definition Language) features such as identity columns and constraints that enable data
centric programming. Learn how to take your SQL reports and query definitions to the next
level with views, common table expressions, and OLAP specifications. Learn how to use
SQL procedurally with user-defined functions, triggers, and advanced stored procedures.

Speakers
TM

Tom McKinley

IBM Lab Services Consultant, IBM
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was... Read More →


Tuesday March 14, 2017 9:00am - 4:00pm
TBA

6:00pm

Experts Roundtable
Moderators
avatar for Charles Guarino

Charles Guarino

Founder, President, Central Park Data Systems
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been 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 to being a professional speaker across the United States and Europe, he is a frequent contributor of technical and strategic articles and webcasts for the IT... Read More →

Speakers
avatar for Robert Andrews

Robert Andrews

Managing Consultant, IBM
Robert Andrews is a Managing Consultant specializing in security for the IBM Systems Lab Services Power Systems Delivery Practice in Rochester, MN. Besides security, Robert is an expert in DB2, journalizing, and DDM/DRDA. In addition to his technical work at IBM, Robert has been strongly involved in Emergency Management and Communications for almost a decade at all levels from local to federal. Robert has published seven books and holds degrees... Read More →
avatar for Tommy Atkins

Tommy Atkins

Chief Development Officer, TEMBO Technology Labs (Pty) Ltd.
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 In 1988. After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA... Read More →
avatar for Dr. Stefanie Chiras

Dr. Stefanie Chiras

Vice President, IBM Power Systems Offering Management, IBM
Dr. Stefanie Chiras is the Vice President, IBM Power Systems Offering Management. Aspart of the Power Systems brand team, she holds worldwide business responsibility forthe successful execution of the Linux on Power offerings and strategy as well as cloud offerings. This includes driving interlocked plans from development to the go to market. | Stefanie comes to this role with a breadth of technical and business experiences. Hertechnical roles... Read More →
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →
TM

Tom McKinley

IBM Lab Services Consultant, IBM
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was... Read More →
avatar for Tim Rowe

Tim Rowe

IBM Business Architect, IBM Rochester
Tim is the Business Architect for Application Development and Systems Management for IBM i. He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and in to the future. In addition he owns the tools for Accessing and Managing the IBM i operating system. He spends much of his time 'preaching' the modernization story to our IBM i users. In his free time he works as a sound... Read More →
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, HelpSystems
Robin Tatam joined HelpSystems’ PowerTech division in 2009 extending an AS/400 and IBM i consulting career that extends more than a quarter century. Since 2003, Mr. Tatam has consulted with domestic and international clients on security and compliance issues, rising rapidly to the top tier of IBM i security experts. He also has a strong background in midrange application development (RPG, CL, CGI) as well as systems administration. | | Mr... Read More →


Tuesday March 14, 2017 6:00pm - 9:00pm
TBA
 
Wednesday, March 15
 

7:30am

Breakfast Buffet
Wednesday March 15, 2017 7:30am - 8:30am
TBA

8:30am

Why Move to IBM i 7.3
IBM i 7.3 has been out for 6 months now.  Come hear about all the new features that have been added to the IBM i 7.3 release and how these features can bring value to your business.  From major enhancements to DB2 which allow Simplifying Insight into your data, to significant changes throughout the operating system to allow Intelligent Security; from key enhancements in open source to new storage options; from performance analysis to being able to answer business questions with integrated SQL analytics, the 7.3 release has tremendous integrated power. This session will also cover some of the very latest enhancements that have been added in the very latest Technology Refresh. 

Speakers
avatar for Tim Rowe

Tim Rowe

IBM Business Architect, IBM Rochester
Tim is the Business Architect for Application Development and Systems Management for IBM i. He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and in to the future. In addition he owns the tools for Accessing and Managing the IBM i operating system. He spends much of his time 'preaching' the modernization story to our IBM i users. In his free time he works as a sound... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Chicago Lower Level

8:30am

Analyze your SQL Queries with IBM I Navigator IBM ACS Part I
SQL becomes more and more the standard for accessing data in physical files or SQL tables. Contrary to native I/O where the programmer specifies a physical or logical file that is to be used, with SQL the Optimizer decides which or if any index is used or if the complete table/file is read. Long running queries are a nuisance. IBM i Navigator as well as Access Client Solutions (ACS) provide multiple interfaces for recording information about SQL queries and for analyzing the collected data, such as Visual Explain, SQL Plan Cache (Snapshots) or SQL Performance Monitors. All advised indices from both query engines (SQE and CQE) are recorded along with information about how often and when an index was used for the last time. With IBM i Navigator and ACS those information can be accessed and necessary indexes immediately created.


 

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Courtyard 2

8:30am

Database Engineer Roles and Responsibilities
This session will focus on the role and responsibilities of the DB2 for i "database engineer". It will compare and contrast the tasks involved in database "administration" and "engineering", as well as cover the critical success factors from an organizational, philosophical and technical point of view. Included in this session is a description on the security responsibility of the DB Engineer.
 

Speakers
TM

Tom McKinley

IBM Lab Services Consultant, IBM
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Madison

8:30am

Leaders Versus Followers
Do you want to be a leader or a follower?  If you are not interested, and not willing to be in charge, you are better suited to be a follower. However, good followers also perform leadership roles when needed.  Followers influence leaders. Thus, in a definition of leadership, the influencing process is between leaders and followers, not just a leader influencing followers; it’s a two-way street. Knowing how to lead and developing leadership skills will make you a better leader and/or follower.

Learning Objectives:
Evaluate big five personality characteristicsAssess his/her personal leadership style and skillsAdapt his/her leadership style to various situations

Audience:All attendee already in a leadership position or aspiring to be a leader.

Speakers
avatar for Mike McArdle

Mike McArdle

Instructor, Western Technical College
Though Mike McArdle has been involved in RPG programming since the 1970s, his career path has been through the ranks of leadership. He has been the CFO of Luther Hospital in Eau Claire, Wisconsin, the CFO of Desmond’s Formal Wear in LaCrosse Wisconsin, and Assistant Superintendent for Business Operations for several K-12 Wisconsin | school districts. Since 2009 McArdle has taught Business Management along with RPG programming at Western... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Courtyard 3

8:30am

Intro to Node.js
Node.js is here.  Yep, Javascript on the server side of things.  Is this a good thing?  That's what we'll be looking to decipher as we walk through the following points at a high level, all the while relating it to the RPG programmer mindset to more easily draw similarities.

And seriously, Javascript is employment insurance.  You have life insurance and car insurance, and, and, and;  well, why not employment insurance.  Learn something (Javascript, and inherently Node.js) that is applicable to every single website on the internet.

In this session we will learn about the following:
  • Why Node.js? We already have Java, PHP, Ruby.
  • How to obtain and install Node.js
  • Make Node talk to your RPG and DB2
  • What's this i/o blocking stuff I hear about Node.js?
  • Javascript syntax - brief intro
  • Javascript callbacks - they're everywhere, but how do they affect your programming in Node?
  • Create a simple "hello world" app without using frameworks.


Speakers
avatar for Aaron Bartell

Aaron Bartell

Director of IBM i Innovation, KrengelTech, Inc.
Aaron Bartell directs hands-on application development services using open source technologies for companies running on IBM i. Through consulting engagements, Aaron jump-starts development initiatives while serving as an extension of internal development teams. Aaron facilitates adoption of open source technologies through internal staff training, speaking engagements at conferences, and the authoring of best practices within IBM i industry... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Geneva 3

8:30am

JavaScript 101: First Look from an RPG Perspective
Need Abstract

Speakers
avatar for Richard Milone

Richard Milone

CNX
Richard Milone has worked as an application developer on the IBM i platform and its predecessors of various names for over 25 years. Richard served as Director of IT for Packaging Resources until co-founding CNX Corporation in Chicago in 1996, where his initial focus was on ERP enhancements for the AS/400 and iSeries community. Currently serving as CNX’s Chief Technical Officer, Richard is dedicated to promoting a modern IBM i profile... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Geneva 2

8:30am

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

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Consultant, Zend, A Rogue Wave Company
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. Mike joined Zend as a Solutions Consultant in 2008 working with the sales team and spreading the news about Zend solutions in the IBM midrange arena. Mike lives in suburban Chicago with his wife, five kids, two... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Geneva 1

8:30am

Single Sign On Overview
Wouldn’t it be nice to have just one password? It may be possible using Single Sign On. In this overview level session, we will discuss how the process works. We will cover the steps to setup an IBM i in an existing Windows Environment. Finally, the session will provide some pain points and best practices to consider before implementing Single Sign On. Time and systems permitting, a live demo of the setup and usage will conclude the session.

Speakers
avatar for Robert Andrews

Robert Andrews

Managing Consultant, IBM
Robert Andrews is a Managing Consultant specializing in security for the IBM Systems Lab Services Power Systems Delivery Practice in Rochester, MN. Besides security, Robert is an expert in DB2, journalizing, and DDM/DRDA. In addition to his technical work at IBM, Robert has been strongly involved in Emergency Management and Communications for almost a decade at all levels from local to federal. Robert has published seven books and holds degrees... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Milwaukee

8:30am

IBM I and Power Systems Management Keeping it Current and Best Practices Part 1
1) Setup and verify of Call Home functions on the HMC. Setup of a limited HMC user. A review of HMC command line capability including watching HMC disk space.

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

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

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

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988. After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA... Read More →


Wednesday March 15, 2017 8:30am - 10:00am
Courtyard 1

10:00am

Break
Wednesday March 15, 2017 10:00am - 10:15am
TBA

10:15am

Putting the Pedal to the Metal for Rdi
Need a crash course on seeing if RDi is right for you (hint – it is) but can’t commit an entire day on aworkshop? In this session we will cover the key points of Eclipse navigation, source code editing,program debugging and graphical screen and report design. Even after only one session you will seehow a modern workbench is where you need to be using to stay in the game of application development.

Speakers
avatar for Charles Guarino

Charles Guarino

Founder, President, Central Park Data Systems
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been 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 to being a professional speaker across the United States and Europe, he is a frequent contributor of technical and strategic articles and webcasts for the IT... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Geneva 3

10:15am

Why Use Triggered Programs Session I
This first session will focus on the different types of event triggers available within the definitions of both DDL Tables and DDS Physical Files and why their use can add value to the definition of a DB2 database.

We will discuss how the addition of trigger programs to the database can enhance the integrity and agility of the database and the other knock-on benefits of reducing lines of code in the applications and reduction of required testing time.

Included in this session will be an understanding of the relationships between the application program, the relational database management system (RDBMS) and the trigger program, including the communication requirement between these 3 components.

Speakers
avatar for Tommy Atkins

Tommy Atkins

Chief Development Officer, TEMBO Technology Labs (Pty) Ltd.


Wednesday March 15, 2017 10:15am - 11:45am
Madison

10:15am

Analyze your SQL Queries with IBM I Navigator IBM ACS Part II
Need Abstract

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Courtyard 2

10:15am

Women in Leadership
This session covers the challenges women face in their careers and in particular the challenges they face when moving into leadership roles. Learn about the things you may be doing that are sabotaging your career and what you can do instead. Leave this session with solid ideas on how to be more successful in not only your professional but also your personal life. 

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 experience with the AS/400, iSeries, and i5 platforms. Kim specializes in installing and configuring Domino, Sametime and Connections servers, providing performance... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Chicago Lower Level

10:15am

DevOps for IBMi: Multi-Platform Options with Git, RTC or other SCMs
Most of us on the IBM i now develop in a mix of languages and platforms. Diverse languages have meant different source code management (SCM) and deployment systems. It’s been every IT manager’s “Holy Grail” to manage all the code in the same tool: one repository, one branching system, one way to manage and deploy versions, in the end, one version of the truth. So the traditional native IBM i SCM tools are losing ground and versatility. Welcome SCM tools like Rational Team Concert (RTC) and Git for distributed source control. But each of these SCM tools fail in two key areas on the IBM i: the BUILD or recompile and Deploy of IBM i artifacts. We will explore technology options to bridge these gaps and automate a complete DevOps cycle on IBM i. 

Speakers
avatar for Floyd Del Muro

Floyd Del Muro

Business Development Manager, ARCAD Software
With 26 years of experience on the IBM midrange platform, Floyd is Business Development Manager for the ARCAD Software group. In his role at ARCAD Software, Floyd has been extensively involved in the management of DevOps and Enterprise Modernization projects on IBM i, from planning stages through to delivery. Drawing on his experience in project rollout, managed services and the introduction of agile methods, Floyd is a trusted advisor and... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Geneva 2

10:15am

Introduction to MariaDB for IBM i
Zend and IBM have teamed up once again to answer the call of the open source community by enhancing Zend DBi. Zend DBi is the standard distribution of MySQL for IBM i and is available at no charge from the Zend website. We have now included a MariaDB distribution for more current open source demands. This session explores how to install Zend DBi and the IBM DB2 Storage Engine. MySQL command line functions via PASE will be reviewed as will administering MySQL via the GUI shipped with Zend Server called phpMyAdmin. History and practical examples will round out the presentation with a live demonstration of the DB2 Storage Engine. 

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Consultant, Zend, A Rogue Wave Company
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. Mike joined Zend as a Solutions Consultant in 2008 working with the sales team and spreading the news about Zend solutions in the IBM midrange arena. Mike lives in suburban Chicago with his wife, five kids, two... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Courtyard 3

10:15am

Make Your IBM I Sizzle with Wordpress
Wordpress lets you create a website by choosing a theme and adding your own graphics without touching a line of code. This popular open-source application also has thousands of plugins to add features to your site. Best of all, it runs on IBM i, and can leverage your own DB2 data and RPG programs. Learn why WordPress on the IBM i can be the most powerful WordPress anywhere. Since WordPress is based on PHP and MySQL, you'll get a taste of those technologies as well.

Learning objectives
See what your IBM i can do with WordPress, how you can quickly create a website that will wow the business people in your companyGet a taste of how open source technology runs the webSee your IBM i data and RPG output on a WordPress site on IBM i!

Audience
Developers and others who want to create a great impression of IBM i while adding business value and improving their careers.

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
As the most experienced PHP expert on the IBM i platform, Alan Seiden helps IBM i teams develop smart, high-performance web and mobile applications using PHP, Zend Server, RPG and DB2. Founder of Seiden Group, an independent consultancy, Alan also works closely with some of the best minds at both Zend and IBM on behalf of his clients. | An award-winning speaker, Alan has been called "the performance guru of PHP on IBM i." Alan is a... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Geneva 1

10:15am

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.

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

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, HelpSystems
Robin Tatam joined HelpSystems’ PowerTech division in 2009 extending an AS/400 and IBM i consulting career that extends more than a quarter century. Since 2003, Mr. Tatam has consulted with domestic and international clients on security and compliance issues, rising rapidly to the top tier of IBM i security experts. He also has a strong background in midrange application development (RPG, CL, CGI) as well as systems administration. | | Mr... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Milwaukee

10:15am

Keeping it Current and Best Practices Part II
1) Setup and verify of Call Home functions on the HMC. Setup of a limited HMC user. A review of HMC command line capability including watching HMC disk space.

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

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

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

Speakers
avatar for Larry Bolhuis

Larry Bolhuis

Chief i-entist, Frankeni Technology Consulting, LLC
Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science from Calvin College in 1982 and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988. After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA... Read More →


Wednesday March 15, 2017 10:15am - 11:45am
Courtyard 1

11:45am

Lunch
Wednesday March 15, 2017 11:45am - 12:45pm
TBA

1:00pm

Keynote - Dr. Stefanie Chiras IBM - 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 that 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? But that is the strength and beauty of the cognitive era, as computing works like our brains to give not 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.

Speakers
avatar for Dr. Stefanie Chiras

Dr. Stefanie Chiras

Vice President, IBM Power Systems Offering Management, IBM
Dr. Stefanie Chiras is the Vice President, IBM Power Systems Offering Management. Aspart of the Power Systems brand team, she holds worldwide business responsibility forthe successful execution of the Linux on Power offerings and strategy as well as cloud offerings. This includes driving interlocked plans from development to the go to market. | Stefanie comes to this role with a breadth of technical and business experiences. Hertechnical roles... Read More →


Wednesday March 15, 2017 1:00pm - 2:15pm
TBA

2:30pm

COMMON Certification Testing
Wednesday March 15, 2017 2:30pm - 4:00pm
Courtyard 2

2:30pm

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),  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 and system recovery for journals. This session also takes you through example backup strategies and the steps needed to recover your system after a system failure or disaster.

Speakers
avatar for Debbie Saugen

Debbie Saugen

Director, Business Continuity Services, Help Systems
Debbie Saugen is recognized worldwide as an expert on IBM i Backup/Recovery, Disaster Recovery and High Availability solutions. Prior to joining Helpsystems, 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. As a Common Gold Medal Speaker she enjoys sharing her knowledge speaking at conferences, user groups, along with publishing... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Geneva 1

2:30pm

The Less Frequent Rdi - FAQs More Stuff to Know!
RDi is a game changer and continues to improve how developers are maintaining and developing theirapplications everywhere. And with the breadth of functionality there is almost never enough time toanswer all of the questions at our sessions. Here we will go through some of the most challenging andobscure questions and provide live demonstration to answer them. Let’s learn together how RDi canfurther your productivity in ways you never thought possible.

Speakers
avatar for Charles Guarino

Charles Guarino

Founder, President, Central Park Data Systems
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been 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 to being a professional speaker across the United States and Europe, he is a frequent contributor of technical and strategic articles and webcasts for the IT... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Geneva 3

2:30pm

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.

Learning Objectives:
In this session you will learn how to embed and execute SQL commands from within an HLL respectively RPG. It provides an overview of the commands to use in an application program to exploit SQL scalar functions as well as for updating, deleting and accessing data located in database objects.

Audience: Developers who already discovered the power of SQL and want to profit from those features from within RPG or Cobol. Developers originally coming from other programming languages who want to access data in the same way they are used to do. Developers working in a “multi-(programming)lingual” environment who need or want to embed the same or slightly modified source code in different programming languages.

Level: Beginner

Duration: Single Session

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Geneva 2

2:30pm

Introduction to Database Design and Modeling
This session will focus on the idea, concepts and best practices for database design and physical modeling. While arguably one of the most important factors in building a successful data centric application, database modeling is often overlooked or performed sub optimally. 

Speakers
TM

Tom McKinley

IBM Lab Services Consultant, IBM
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Madison

2:30pm

Leaders are Made Not Born
Vince Lombardi, the legendary Green Bay Packers coach was once quoted as saying: “Leaders are made they are not born.  They are made by hard effort, which is the price which all of us must pay to achieve any goal that is worthwhile.”  Others dating back to the 1840s put forth the “great man” theory.  So to which school of thought do you ascribe?  Let’s study the concept that leaders are made and not born.

Learning Objectives:

  1. Explain both the great man and leaders are made theories

  2. Give at least three reasons why leaders are made and not born

  3. Describe the four idols that kill leadership development

  4. Practice leadership development concepts


Audience:All attendee already in a leadership position or aspiring to be a leader.

Speakers
avatar for Mike McArdle

Mike McArdle

Instructor, Western Technical College
Though Mike McArdle has been involved in RPG programming since the 1970s, his career path has been through the ranks of leadership. He has been the CFO of Luther Hospital in Eau Claire, Wisconsin, the CFO of Desmond’s Formal Wear in LaCrosse Wisconsin, and Assistant Superintendent for Business Operations for several K-12 Wisconsin | school districts. Since 2009 McArdle has taught Business Management along with RPG programming at Western... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Courtyard 3

2:30pm

My First Node.js App
Node.js is a hot hot hot technology right now.  It can be used for many networking type scenarios including building web applications.  In this hands-on lab you will accomplish the following:
  • Learn how to connect to IBM i using SSH and the bash shell.
  • Learn how to create a hello world web application
  • Learn how to install Node.js modules using npm (Node Package Manager)
  • Create a Node.js Websocket chat application from scratch
  • Create a Node.js CRUD (Create, Read, Update, Delete) application from scratch


Speakers
avatar for Aaron Bartell

Aaron Bartell

Director of IBM i Innovation, KrengelTech, Inc.
Aaron Bartell directs hands-on application development services using open source technologies for companies running on IBM i. Through consulting engagements, Aaron jump-starts development initiatives while serving as an extension of internal development teams. Aaron facilitates adoption of open source technologies through internal staff training, speaking engagements at conferences, and the authoring of best practices within IBM i industry... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Courtyard 1

2:30pm

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

Speakers
avatar for Robert Andrews

Robert Andrews

Managing Consultant, IBM
Robert Andrews is a Managing Consultant specializing in security for the IBM Systems Lab Services Power Systems Delivery Practice in Rochester, MN. Besides security, Robert is an expert in DB2, journalizing, and DDM/DRDA. In addition to his technical work at IBM, Robert has been strongly involved in Emergency Management and Communications for almost a decade at all levels from local to federal. Robert has published seven books and holds degrees... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Milwaukee

2:30pm

IBM HTTP Server (Powered by Apache) Overview
Learn about what the HTTP server is and how it can work for you. Get to know the fantastic features of the latest IBM HTTP Server for i (powered by Apache) version 2.4. Quickly and easily get your HTTP server up and running using the IBM Web Administration for i GUI interface. This session will introduce the HTTP Server on i, some of the key differences on i, some of the areas that are tightly integrated into the IBM i operating system. We will also take a look at the key important topic of security and how to configure the HTTP server securely and the different options available. In addition, the very latest new features will be covered, as there are many new additions in the latest Apache 2.4 version.

Learning Objectives:
The user will have a basic understanding of the IBM HTTP Server. They will be equipped to deploy a Web site in a secure manner. By the end of this session, attendees will understand:
  • Key design points and basic configuration that every Web server requires
  • How to get your web site up and running using the graphical integration wizards provided by IBM Web Administration for i
  • New features for IBM HTTP Server for i (powered by Apache ) version 2.4, such as SNI, OCSP, ECDSA cipher, TLS1.2, new authentication mechanism, remote IP, HTTP server subsystem definition, etc.
  • The basics of web security and securing the HTTP server


Speakers
avatar for Tim Rowe

Tim Rowe

IBM Business Architect, IBM Rochester
Tim is the Business Architect for Application Development and Systems Management for IBM i. He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and in to the future. In addition he owns the tools for Accessing and Managing the IBM i operating system. He spends much of his time 'preaching' the modernization story to our IBM i users. In his free time he works as a sound... Read More →


Wednesday March 15, 2017 2:30pm - 4:00pm
Chicago Lower Level

4:00pm

Break
Wednesday March 15, 2017 4:00pm - 4:15pm
TBA

4:15pm

IBM i OS and Power System Upgrade Testing
Using a real world example of a small IT department we look at the testing
needed for a large upgrade. From strategic test management and planning to risk
management and resource allocation. Concepts covered include how to identify
testing points, determine risk, and implement responsible quality assurance.

Learning Objectives:
Understanding testing strategies, tactics, and design.
Determine risks to system quality.
Aligning testing with risk exposure.
When to use risk based testing, static testing, behavioral testing, or structural
testing for best results.

Audience:
IT department personal who want to deliver solid testing for upgrades. Any
system administrator who is concerned about the testing their system is
subjected to. Consultants who are in the upgrade/hardware/admin sphere and
want to enhance their testing offering. QA professionals who want understand
what the technical team is testing and evaluating before hand off.

Session has won COMMON Speaker of Merit award

Speakers
avatar for Von Enselman

Von Enselman

Quality Assurance Specialist, Independant - Quality Assurance Consulting
 Yvonne Enselman is an independent consultant specializing in quality assurance and software testing based in Chicago. She has had articles published in IBM Systems Magazine and IT Jungle and currently blogs forSystem iDeveloper. Seeing a void, she has founded iThusiasm as a vehiclefor "Energizing IBM i on Power System Professionals through enthusiasm andadvocacy."  She has served as a director for both The Omni User Group(Chicago's... Read More →


Wednesday March 15, 2017 4:15pm - 5:30pm
Courtyard 3

4:15pm

Tips and Techniques for Shrinking Backup/Recovery Windows on IBM
New hardware and tape technology in combination with software enhancements in Backup Recovery and Media Services (BRMS) using Concurrent and Parallel Saves, Flashcopy, and Save-while-active 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!

Speakers
avatar for Debbie Saugen

Debbie Saugen

Director, Business Continuity Services, Help Systems
Debbie Saugen is recognized worldwide as an expert on IBM i Backup/Recovery, Disaster Recovery and High Availability solutions. Prior to joining Helpsystems, 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. As a Common Gold Medal Speaker she enjoys sharing her knowledge speaking at conferences, user groups, along with publishing... Read More →


Wednesday March 15, 2017 4:15pm - 5:30pm
Courtyard 1

4:15pm

How to Create Trigger Programs - Session II
This session, building on session 1, will look into the physical construction of trigger programs for the various types of triggers and examine in detail the parameter list passed into the trigger program from the RDBMS. This will be a discussion on general principles of trigger construction as the specific code will depend on the file and its content and the purpose trying to be achieved.

Heritage/Legacy applications have very specific problems when triggers are introduced into the database. The reason for this is typically that the heritage application code is not built to cater for the additional actions and responses introduced by the use of triggers.

This session will introduce a modified trigger construction which will allow a trigger program to be attached to a D/B file without risk to the application, or need to modify the application code, and will also assist it the evolution of the application programs to become responsive to trigger actions.

Speakers
avatar for Tommy Atkins

Tommy Atkins

Chief Development Officer, TEMBO Technology Labs (Pty) Ltd.


Wednesday March 15, 2017 4:15pm - 5:30pm
Madison

4:15pm

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.

Speakers
avatar for Floyd Del Muro

Floyd Del Muro

Business Development Manager, ARCAD Software
With 26 years of experience on the IBM midrange platform, Floyd is Business Development Manager for the ARCAD Software group. In his role at ARCAD Software, Floyd has been extensively involved in the management of DevOps and Enterprise Modernization projects on IBM i, from planning stages through to delivery. Drawing on his experience in project rollout, managed services and the introduction of agile methods, Floyd is a trusted advisor and... Read More →


Wednesday March 15, 2017 4:15pm - 5:30pm
Geneva 1

4:15pm

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 of a fit is it for business applications?

In this session, Alex will demonstrate that Node.js is an ideal language for business application programming, in addition to your existing RPG efforts. 

Attendees of this session will learn:
How Node.js is capable of deploying applications that are database-driven and transactionalWhy Node.js and RPG are perfect partners, and how they integrate for powerful business applicationsHow the Profound.js framework and conversion service enables you to modernize and implement Node.js on IBM i quickly and easily

Speakers
avatar for Alexander Roytman

Alexander Roytman

CEO, Profound Logic
Alex Roytman is the founder and CEO of Profound Logic Software, a leading provider of IBM i modernization tools and services. Starting as a software architect, Alex now has more than 15 years of experience working with the IBM i and the latest Web and Mobile technologies. His expertise and passion in the field of Web and Mobile development have led his company to create many popular modernization tools, win multiple awards for innovation, and... Read More →


Wednesday March 15, 2017 4:15pm - 5:30pm
Chicago Lower Level

4:15pm

Data Breaches: Is IBM I Really at Risk?
Despite an avalanche of regulatory mandates and industry awareness, news
headlines remain chock full of stories about data breaches. Although Power
Servers often live inside the safety of the perimeter firewall, the risk of suffering a
data leak or data corruption remains high.

Would you know if a data breach happened? How would a breach affect your
business?

Join noted IBM i security expert and certified auditor, Robin Tatam, as he
discusses common ways that this supposedly “secure” operating system may
actually be vulnerable and who the culprits might be.

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, HelpSystems
Robin Tatam joined HelpSystems’ PowerTech division in 2009 extending an AS/400 and IBM i consulting career that extends more than a quarter century. Since 2003, Mr. Tatam has consulted with domestic and international clients on security and compliance issues, rising rapidly to the top tier of IBM i security experts. He also has a strong background in midrange application development (RPG, CL, CGI) as well as systems administration. | | Mr... Read More →


Wednesday March 15, 2017 4:15pm - 5:30pm
Milwaukee

4:15pm

Apache Web Server Magic on IBM i
Anyone who uses a web server will appreciate the techniques shown here:
-- How to configure SSL encryption (HTTPS)
-- Create user-friendly and search-engine friendly URLs over any web application
-- Use Apache as a load-balancing proxy server
-- Prevent outsiders from accessing your web application
-- Change the ports (80, 443, 10080, more) and determine if they are running properly
-- How to provide multiple domain names in one Apache configuration
-- Ensure that both "www" and non-"www" requests go to the same place
-- How to debug your configuration
-- And more, as time allows!

learning objectives:
Understand how to secure the Apache web server on IBM iLearn to use Apache's most useful features, including search engine opimization, logging, and virtual hosts

audience:Administrators and developers seeking to prepare their systems for web applications, improve performance, and improve security.

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
As the most experienced PHP expert on the IBM i platform, Alan Seiden helps IBM i teams develop smart, high-performance web and mobile applications using PHP, Zend Server, RPG and DB2. Founder of Seiden Group, an independent consultancy, Alan also works closely with some of the best minds at both Zend and IBM on behalf of his clients. | An award-winning speaker, Alan has been called "the performance guru of PHP on IBM i." Alan is a... Read More →


Wednesday March 15, 2017 4:15pm - 5:30pm
Geneva 3

4:15pm

Consuming Web Services from RPG with HTTPAPI
Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic
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. His efforts to help programmers have earned him many accolades and awards.


Wednesday March 15, 2017 4:15pm - 5:30pm
Geneva 2

4:15pm

What's the Fuss? Using Procedures and Service Programs
Need Abstract

Speakers
avatar for Jim Buck

Jim Buck

President, WMCPA
President


Wednesday March 15, 2017 4:15pm - 5:45pm
Courtyard 2

5:30pm

Sponsor Showcase
The sponsors take over to dazzle and entertain for a while. Free food and 2 adult beverages.

Wednesday March 15, 2017 5:30pm - 7:30pm
TBA

7:30pm

Evening Entertainment
Wednesday March 15, 2017 7:30pm - 10:00pm
TBA
 
Thursday, March 16
 

7:30am

Breakfast Buffet
Thursday March 16, 2017 7:30am - 8:30am
TBA

8:30am

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

Speakers
avatar for Tim Rowe

Tim Rowe

IBM Business Architect, IBM Rochester
Tim is the Business Architect for Application Development and Systems Management for IBM i. He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and in to the future. In addition he owns the tools for Accessing and Managing the IBM i operating system. He spends much of his time 'preaching' the modernization story to our IBM i users. In his free time he works as a sound... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Chicago Lower Level

8:30am

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 shortcutseasily 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 adifference. Use them all? No contest.

Speakers
avatar for Charles Guarino

Charles Guarino

Founder, President, Central Park Data Systems
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been 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 to being a professional speaker across the United States and Europe, he is a frequent contributor of technical and strategic articles and webcasts for the IT... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Geneva 3

8:30am

A deep Dive Into Row and Column Acess Control
This session will focus on the ideas and concepts behind data governance and control based on user roles and responsibilities. The presentation will take a deep dive into the new (7.2) DB2 for i Row and Column Access Control (RCAC) feature, function and benefits. 

Speakers
TM

Tom McKinley

IBM Lab Services Consultant, IBM
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Madison

8:30am

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

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

Audience: Developers who already use embedded SQL and would like to exploit advanced SQL technologies, such as consuming result sets or accessing IFS files within their embedded SQL programs.

Level: Advanced

Duration: Single Session

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Geneva 2

8:30am

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

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

Audience:
Developers using open source languages such as PHP, Node.js, Python, or Ruby on IBM i with DB2.

Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
As the most experienced PHP expert on the IBM i platform, Alan Seiden helps IBM i teams develop smart, high-performance web and mobile applications using PHP, Zend Server, RPG and DB2. Founder of Seiden Group, an independent consultancy, Alan also works closely with some of the best minds at both Zend and IBM on behalf of his clients. | An award-winning speaker, Alan has been called "the performance guru of PHP on IBM i." Alan is a... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Geneva 1

8:30am

The Five Key Elements of Leadership
We often perceive leadership as the role of the CEO or other members of the senior leadership team, but it should be first and foremost demonstrated at the team and/or department level of an organization.  Effective leadership can have a positive impact on the lives of everyone.  After all, a bad boss can impact not just the immediate environment, but the whole organization and even one’s personal life.  If you know some of the basics of leadership theory you can be a more effective team member.  Leadership is the process of influencing to achieve organizational objectives through change. Let’s learn about the five key elements of leadership and how to apply them.

Learning Objectives:
Describe the five key elements of leadershipEvaluate leadership effectivenessPractice leadership elements in a hypnotical setting

Audience:All attendee already in a leadership positon or aspiring to be a leader.

Speakers
avatar for Mike McArdle

Mike McArdle

Instructor, Western Technical College
Though Mike McArdle has been involved in RPG programming since the 1970s, his career path has been through the ranks of leadership. He has been the CFO of Luther Hospital in Eau Claire, Wisconsin, the CFO of Desmond’s Formal Wear in LaCrosse Wisconsin, and Assistant Superintendent for Business Operations for several K-12 Wisconsin | school districts. Since 2009 McArdle has taught Business Management along with RPG programming at Western... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Courtyard 3

8:30am

What's New in IBMi Security in 7.1, 7.2 and 7.3
This presentation will cover the extensive list of security enhancements added by IBM in the 7.1, 7.2 and recently announced 7.3 operating system releases. The 7.3 security changes include the major security enhancement called Authority Collection plus exciting new support to Audit Network Communication sessions into and out of your IBM i Server.

Speakers
avatar for Robert Andrews

Robert Andrews

Managing Consultant, IBM
Robert Andrews is a Managing Consultant specializing in security for the IBM Systems Lab Services Power Systems Delivery Practice in Rochester, MN. Besides security, Robert is an expert in DB2, journalizing, and DDM/DRDA. In addition to his technical work at IBM, Robert has been strongly involved in Emergency Management and Communications for almost a decade at all levels from local to federal. Robert has published seven books and holds degrees... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Milwaukee

8:30am

IBM i and Power Systems Management: Daily system Monitoring, Tuning, Clean-Up and Spooled File Handling Part I
1) Explore graphical methods for monitoring IBM i Performance. This includes Management Central and IBM Navigator for i System Monitors

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

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

4) Various System values you should understand.

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

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 In 1988. After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Courtyard 1

8:30am

The Basics of HTML and the DOM Lab Part I
Need Abstract

Speakers
avatar for Christian Hur

Christian Hur

IT-Web Instructor, Gateway Technical College
Christian Hur is an IT-Web Instructor at Gateway Technical College in Racine, Wisconsin, where he teaches courses in Web Development and Microsoft SharePoint. Christian has more than 20 years’ experience in Web development and has built many websites and Web-based applications using various Web technologies. He developed his first personal web site while an undergraduate at CSU, Fresno, in1994. | | He’s an author for MC Press... Read More →


Thursday March 16, 2017 8:30am - 10:00am
Courtyard 2

10:00am

Break
Thursday March 16, 2017 10:00am - 10:15am
TBA

10:15am

COMMON Certification Testing
Thursday March 16, 2017 10:15am - 11:45am
Courtyard 2

10:15am

Getting Started On the Road to Compliance
Everyone knows that security is a critical corporate objective, but many of us
struggle with where to begin. We may be running legacy applications, or new
client-server solutions, but either way we have users accessing our corporate
data from more avenues than ever before. We , need to make sure that our data
is secure from all of them. But where do we begin?
Join this important session to learn about getting started down the road to
compliance with logical steps to get there, including:

1st Gear Finding The Compliance On-Ramp
2nd Gear Leverage The Base IBM i Capabilities
3rd Gear Protect Against Network Access
4th Gear New Options with V6R1
5th Gear Advanced Options (Anti-Virus, Encryption)
6th Gear Maintaining Ongoing Compliance

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, HelpSystems
Robin Tatam joined HelpSystems’ PowerTech division in 2009 extending an AS/400 and IBM i consulting career that extends more than a quarter century. Since 2003, Mr. Tatam has consulted with domestic and international clients on security and compliance issues, rising rapidly to the top tier of IBM i security experts. He also has a strong background in midrange application development (RPG, CL, CGI) as well as systems administration. | | Mr... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Milwaukee

10:15am

What IBM i Professionals can Learn from NASA
The NASA moonshot initiative in the 1960s and 1970s was groundbreaking in the
use of information technology and advanced developments. Correspondingly
testing and quality assurance was mandatory, extensive, and equally inventive.
Using examples from history we will discuss current issues such as disaster
recovery (the Apollo One fire), test coverage (Apollo 13), specifications and
prototypes (the development of the LM), user ability and experience (Apollo 14),
and further education development (Apollo 17).

Learning Objectives:
Explore disaster recovery, High Availability, testing, and implementation of quality
assurance in a unique and informative way.

Audience
Testers and Developers interested in furthering QA knowledge. Anyone who was
interested in the Mercury/Gemini/Apollo program in the 1960s.

Speakers
avatar for Von Enselman

Von Enselman

Quality Assurance Specialist, Independant - Quality Assurance Consulting
 Yvonne Enselman is an independent consultant specializing in quality assurance and software testing based in Chicago. She has had articles published in IBM Systems Magazine and IT Jungle and currently blogs forSystem iDeveloper. Seeing a void, she has founded iThusiasm as a vehiclefor "Energizing IBM i on Power System Professionals through enthusiasm andadvocacy."  She has served as a director for both The Omni User Group(Chicago's... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Geneva 1

10:15am

The Need to Percolate Errors - Session III
Picking up from the references in the first 2 sessions relating to the communication between triggers, RDBMS and applications, this session examines the need and benefits for a standardized method of trapping and communicating errors.

In a modernized application environment where the use of sub-procedures, modules with procedures and external procedures wrapped in service programs becomes the norm, it is important that all errors are trapped and a standardized method for “Percolating” error conditions up the “Call Stack” is introduced.

The error handling method introduced here can be used in all application and trigger situations and closely simulates the percolation method used by the operating system itself.

Speakers
avatar for Tommy Atkins

Tommy Atkins

Chief Development Officer, TEMBO Technology Labs (Pty) Ltd.


Thursday March 16, 2017 10:15am - 11:45am
Madison

10:15am

IBM I IFS Containers
In this session we will introduce the ibmichroot (IBM i Chroot) open source project.  Think of this technology being similar to being able to create a bunch of micro instances of IBM i all on a single instance of IBM i.  This is accomplished by using PASE's chroot utility and is what I'm terming "IFS Containers".

This technology is excellent for those running applications in PASE (i.e. Node.js, Ruby, Python, PHP).  It will keep PASE applications completely separate from one another so there is no toe stepping.  I often use this technology for creating separate environments for development, testing, staging and production.

Further, the ibmichroot project facilitates the download and install of AIX binaries from perzl.org.  perzl.org hosts hundreds of open source programs from the Linux world that have been made to work on AIX.  Some of the more notable ones include: gcc, Git, Nginx, joe (server-side editor), bash, zsh, Perl, bzip2, ghostscript, Ruby and many more.  Having these tools on IBM i brings about a new level of parity with other platforms.

On final note, yum support was recently added to the ibmichroot project and we will be talking about how that is a game changer for IBM i and open source.

In this session we will learn the following:
  • What are containers and how are they used
  • Learn about chroot command
    Manual chroot IFS Container creation
  • Introduce IBM i Chroot project and how to install it
  • Creating new IFS Containers using IBM i Chroot project
  • Learn about pre-packaged IFS Container configurations and how to make your own
  • How to install open source packages

Speakers
avatar for Aaron Bartell

Aaron Bartell

Director of IBM i Innovation, KrengelTech, Inc.
Aaron Bartell directs hands-on application development services using open source technologies for companies running on IBM i. Through consulting engagements, Aaron jump-starts development initiatives while serving as an extension of internal development teams. Aaron facilitates adoption of open source technologies through internal staff training, speaking engagements at conferences, and the authoring of best practices within IBM i industry... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Geneva 3

10:15am

Getting Started with API's from RPG
Need Abstracts

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic
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. His efforts to help programmers have earned him many accolades and awards.


Thursday March 16, 2017 10:15am - 11:45am
Geneva 2

10:15am

Securing Email on IBM i
 IBM Domino is a very robust application environment that provides a multitude of services and hosts a rich set of security mechanisms.  Come to this session to learn what to look for in analyzing your environment and why it is essential to change default settings to properly secure your servers. You will learn how to properly lock down your Domino servers.

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 experience with the AS/400, iSeries, and i5 platforms. Kim specializes in installing and configuring Domino, Sametime and Connections servers, providing performance... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Chicago Lower Level

10:15am

Daily System Monitoring, Tuning, Clean-Up, and Spooled File Handling Part II
1) Explore graphical methods for monitoring IBM i Performance. This includes Management Central and IBM Navigator for i System Monitors

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

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

4) Various System values you should understand.

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

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 In 1988. After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Courtyard 1

10:15am

The Basics of HTML and the DOM Lab Part II
Need Abstract

Speakers
avatar for Christian Hur

Christian Hur

IT-Web Instructor, Gateway Technical College
Christian Hur is an IT-Web Instructor at Gateway Technical College in Racine, Wisconsin, where he teaches courses in Web Development and Microsoft SharePoint. Christian has more than 20 years’ experience in Web development and has built many websites and Web-based applications using various Web technologies. He developed his first personal web site while an undergraduate at CSU, Fresno, in1994. | | He’s an author for MC Press... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Courtyard 2

10:15am

Web Services with PHP on IBM i
Service-oriented architectures are taking over the data center world and PHP makes integrating with that world simple and powerful. This session discusses the diversity of the world of Web Services and explores an example of REST and SOAP web services talking between two remote IBM i severs. The evolution of inter-program communication will be reviewed as a basis for conceptualizing the business value of PHP Web services. 

Speakers
avatar for Mike Pavlak

Mike Pavlak

Solution Consultant, Zend, A Rogue Wave Company
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. Mike joined Zend as a Solutions Consultant in 2008 working with the sales team and spreading the news about Zend solutions in the IBM midrange arena. Mike lives in suburban Chicago with his wife, five kids, two... Read More →


Thursday March 16, 2017 10:15am - 11:45am
Courtyard 3

11:45am

Lunch
Thursday March 16, 2017 11:45am - 12:45pm
TBA

1:00pm

Keynote - Tim Rowe
Need Abstract

Speakers
avatar for Tim Rowe

Tim Rowe

IBM Business Architect, IBM Rochester
Tim is the Business Architect for Application Development and Systems Management for IBM i. He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and in to the future. In addition he owns the tools for Accessing and Managing the IBM i operating system. He spends much of his time 'preaching' the modernization story to our IBM i users. In his free time he works as a sound... Read More →


Thursday March 16, 2017 1:00pm - 2:15pm
TBA

2:30pm

Lessons Learned Building IBM i Mobile Applications
Lessons Learned Building IBM i Mobile Applications

The number one new development for IBM i customers takes the form of mobile applications. Being able to transform data into information and deliver it to any user, on any device, anywhere, at any time, is normally the first mobile application. Being able to modernize workflow to improve user efficiency and effectiveness with the "anywhere, anytime” approach ensures that IT is providing systems to enable businesses can become agile, compete better in local and global markets, and succeed in a modern world.

Building and delivering mobile applications often appears to be a difficult task. There are many tools, many vendors, and many architectures and approaches to consider. Traditionally, IBM i applications are lengthy procedural applications and don’t lend themselves to mobile delivery. This session will outline many lessons learned while building mobile applications for IBM i companies.

We will cover the tools that can be used, the modernization techniques that can be leveraged, and the new approaches that are required to deliver mobile applications from an IBM i base. He will discuss building new mobile applications and repurposing existing IBM i applications - both green screen and web - to be delivered to mobile devices in a modern world.

Learning Objectives:
  • Understand differences between IBM i green and mobile apps
  • Gain some design ideas for mobile apps

Speakers
avatar for Trevor Perry

Trevor Perry

Modernisation Strategist, Fresche Legacy
Trevor provides innovative strategies to IBM i users around the world. Well-known in the IBM i community for leading efforts to promote modernisation, he specializes in setting strategy and direction, aligning business and IT, guiding evolution of IT DNA and motivating entire companies.


Thursday March 16, 2017 2:30pm - 4:00pm
Geneva 2

2:30pm

Water Cooler Topics I'll Show You Mine If You Show Me Yours
With our industry changing so fast you never know what’s current and what’s not. This session willdiscuss a variety of topics, all relevant to our community as IT professionals. But you won’t just sit therepassively. Like any water cooler discussion, you’ll be asked to participate with your own opinions oncurrent topics. You can expect the actual topics to be very timely and career-worthy, so the next timeyou’re at your own water cooler you’ll sound like a pro!

Speakers
avatar for Charles Guarino

Charles Guarino

Founder, President, Central Park Data Systems
With an IT career spanning over 30 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been 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 to being a professional speaker across the United States and Europe, he is a frequent contributor of technical and strategic articles and webcasts for the IT... Read More →


Thursday March 16, 2017 2:30pm - 4:00pm
Chicago Lower Level

2:30pm

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).

Speakers
avatar for Debbie Saugen

Debbie Saugen

Director, Business Continuity Services, Help Systems
Debbie Saugen is recognized worldwide as an expert on IBM i Backup/Recovery, Disaster Recovery and High Availability solutions. Prior to joining Helpsystems, 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. As a Common Gold Medal Speaker she enjoys sharing her knowledge speaking at conferences, user groups, along with publishing... Read More →


Thursday March 16, 2017 2:30pm - 4:00pm
Courtyard 1

2:30pm

Intro to SQL Routines: Procedures, Functions and Triggers
SQL is much more than a query language. This session introduces you to the three basic types of SQL programs: Triggers, Functions, and Procedures. Learn how to let the DB do more work on your behalf. 

Speakers
TM

Tom McKinley

IBM Lab Services Consultant, IBM
Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i in Rochester MN. His main focus is complex query performance associated with Business Intelligence running on Very Large Databases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was... Read More →


Thursday March 16, 2017 2:30pm - 4:00pm
Madison

2:30pm

Failure to Modernize - The Real Cost
Need Abstract

Speakers
avatar for Jim Buck

Jim Buck

President, WMCPA
President


Thursday March 16, 2017 2:30pm - 4:00pm
Geneva 1

2:30pm

Node.js Transacts with DB2 and RPG
When IBM introduced Node.js to IBM i they included a full fledge DB2 for i database driver written directly against the SQL CLI APIs.  No middle layer JDBC or MySQL in the mix.  They also provided the iToolkit, a seamless way to call RPG (or any other type of resource or program on IBM i) directly from Node.js.  Very cool.  This means adopting Node.js doesn't mean abandoning your huge investment in RPG; instead you can revitalize it.  That makes good business sense.

In this session we will do the following:


  • Walk through the various features and ways to communicate with existing DB2 tables directly from Node.js.
  • Talk about blocking and non-blocking database i/o
  • How to interface with DB2 for i Services to create a cool realtime WebSockets app that displays WRKACTJOB type information
  • Introduce XMLSERVICE and its feature set.
  • Walk through the various features and ways to communicate with existing RPG programs directly from a Node.js program that is running on the same IBM i!  
  • Show how to do iterative development using the Node.js REPL capabilities (programming in a real-time response environment) - a great tool and approach for learning how to code in
  • Learn how to modularize your Node.js calls to RPG to make them reusable.
  • Discuss how to make stateful requests to an RPG *SRVPGM.


Speakers
avatar for Aaron Bartell

Aaron Bartell

Director of IBM i Innovation, KrengelTech, Inc.
Aaron Bartell directs hands-on application development services using open source technologies for companies running on IBM i. Through consulting engagements, Aaron jump-starts development initiatives while serving as an extension of internal development teams. Aaron facilitates adoption of open source technologies through internal staff training, speaking engagements at conferences, and the authoring of best practices within IBM i industry... Read More →


Thursday March 16, 2017 2:30pm - 4:00pm
Geneva 3

2:30pm

Factor Authentication on IBM i / Authority Collection Utility in 7.3.
Best practices recommend using more than one factor to secure logins and other critical processes.  Using industry standard algorithms, two factor authentication now comes to IBM i.  This quick session covers one of the latest tools to help secure your IBM i!  And then stick around for part 2.  The second 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 the object authority is set to the most secure value while still allowing an application to run successfully.  These presentations are a must see for security administrators and application developers.

Speakers
avatar for Robert Andrews

Robert Andrews

Managing Consultant, IBM
Robert Andrews is a Managing Consultant specializing in security for the IBM Systems Lab Services Power Systems Delivery Practice in Rochester, MN. Besides security, Robert is an expert in DB2, journalizing, and DDM/DRDA. In addition to his technical work at IBM, Robert has been strongly involved in Emergency Management and Communications for almost a decade at all levels from local to federal. Robert has published seven books and holds degrees... Read More →


Thursday March 16, 2017 2:30pm - 4:00pm
Milwaukee

4:00pm

Break
Thursday March 16, 2017 4:00pm - 4:15pm
TBA

4:15pm

Adopting the Percolation Paradigm - Session IV
Here we examine the method of adopting and inserting the error handling methodology into existing/new application code without creating risks but at the same time creating a “catch-all” paradigm within a program.

We will also look at the existing set of error handling procedures and review the construction and the code. This is essential to allow for the “adoption of ownership” so that future enhancements and additions can be made to the existing procedures.

Speakers
avatar for Tommy Atkins

Tommy Atkins

Chief Development Officer, TEMBO Technology Labs (Pty) Ltd.


Thursday March 16, 2017 4:15pm - 5:45pm
Madison

4:15pm

Configuring and Using IBM I Auditing Features
Did you know that IBM i includes powerful auditing features? Join this session to
learn about activating and utilizing IBM i’s built-in forensic capabilities.

You will learn about:
• Security audit journal
• Audit data management
• Configuring the ‘Audit’ system values
• A user profile’s *AUDIT special authority
• Object auditing
• User auditing
• Data reporting options

You will also learn about what system auditing does *not* capture, and how to
prevent that from causing you to fail an audit.

Speakers
avatar for Robin Tatam

Robin Tatam

Director of Security Technologies, HelpSystems
Robin Tatam joined HelpSystems’ PowerTech division in 2009 extending an AS/400 and IBM i consulting career that extends more than a quarter century. Since 2003, Mr. Tatam has consulted with domestic and international clients on security and compliance issues, rising rapidly to the top tier of IBM i security experts. He also has a strong background in midrange application development (RPG, CL, CGI) as well as systems administration. | | Mr... Read More →


Thursday March 16, 2017 4:15pm - 5:45pm
Milwaukee

4:15pm

Consuming JSON Documents and Web Services with SQL
 XML and JSON become more and more important for data exchange especially when using web services. While XML was supported by SQL since Release 7.1, access to JASON documents is not introduced before Release 7.3 TR 1. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically 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 JASON answers returned by web services can be consumed.

Learning Objectives:
Learn how JSON documents located in either the IFS or an XML column 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.

Audience: Developers and Users who are experienced in SQL Queries and need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services or simply want to enhance their SQL know-how.

Level: Advanced

Duration: Single Session

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Thursday March 16, 2017 4:15pm - 5:45pm
Geneva 2

4:15pm

PHP Tricks for the RPG Programmer: Graphics, Excel, PDFs, E-Mail and More
Ever want to enhance RPG programs with PDFs, spreadsheets, charts and graphics, or connect to web services, without complicating your RPG program? Help is here from PHP and DB2. PHP not only builds web sites, but it can be called by RPG programs. Alan will show how to accomplish marvelous tasks by calling PHP from ordinary RPG programs via DB2's web service support, a fast, flexible technique that's a handy trick in itself.
Examples will include:Creating graphs and charts based on DB2 dataExcel spreadsheets from your dataPDF files from your dataConnecting to external JSON-based web services while keeping the RPG simpleSend flexible email messages, including HTML format and attachments, and using any SMTP server, including an Exchange serverYou will come away brimming with ideas to add pizzazz to your applications.

Learning objectives:
How to use SQL to call a web service, including a simple PHP-based web serviceHow RPG can use SQL to call the web service.Put it together: RPG calls PHP via a web service, creating graphical output from RPG in a simple manner

Audience:

  1. Those wishing to add non-traditional functionality to RPG programs without adding proprietary or complicated tools

  2. Web developers (PHP, Ruby, etc.) who want their scripts to be accessible from RPG.

  3. Fans of DB2 who wish to see a practical use of the new web service consumption capabilities of DB2.


Speakers
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
As the most experienced PHP expert on the IBM i platform, Alan Seiden helps IBM i teams develop smart, high-performance web and mobile applications using PHP, Zend Server, RPG and DB2. Founder of Seiden Group, an independent consultancy, Alan also works closely with some of the best minds at both Zend and IBM on behalf of his clients. | An award-winning speaker, Alan has been called "the performance guru of PHP on IBM i." Alan is a... Read More →


Thursday March 16, 2017 4:15pm - 5:45pm
Geneva 3

4:15pm

Backup IBM I Data to the Cloud
Need Abstract

Speakers
avatar for Tim Rowe

Tim Rowe

IBM Business Architect, IBM Rochester
Tim is the Business Architect for Application Development and Systems Management for IBM i. He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and in to the future. In addition he owns the tools for Accessing and Managing the IBM i operating system. He spends much of his time 'preaching' the modernization story to our IBM i users. In his free time he works as a sound... Read More →


Thursday March 16, 2017 4:15pm - 5:45pm
Geneva 1

4:15pm

Managing your IBM I Startup and Shutdown
In days gone by the IBM Supplied program QSTRUP combined with a couple options on CHGIPLA was good enough for most IBM i shops. It started what seemed to be needed and anything else we stumbled through after each IPL. When it was time to shut down a PWRDWNSYS or ENDSBS command took down whatever was running. We were happy.

Today though we often see dozens of subsytems running many web servers, other needed batch jobs and services. We see monitors and queue processing jobs and many writers. For security purposes we should be starting only the TCP servers that we need, not all of them. Likely we should not start IPV6 and start things in sequence as well.

Further considerations may be needed in an HA environment. These include not starting jobs until iASPS are available and starting different IP interfaces and services depending on production or backup mode of the server. We may want to handle special startup modes while doing PTFs, backups or other system maintenance.

In this session we will work with customizing that startup. We'll discuss staring PASE jobs with QSH, web server jobs and more. We'll discuss prestart jobs and autostart jobs. And finally we will also work with sequencing the shutdown of the system. As part of this we'll discuss some simple ways to know what needs to be shut down and smoothly handling that.

Objectives:
1) Learn how to control which startup program will run on your IBM i.
2) Examine the various servers to start and how to control them.
2) Learn options for starting different services.
3) Consider ways to control the startup of your server in different operting modes.
4) Understanding an orderly shutdown of your IBM i server.

Audience:
IBM i System Administrators

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 In 1988. After spending many years as a developer Larry began working on communications, networking, and systems management tasks. Years of working with SNA... Read More →


Thursday March 16, 2017 4:15pm - 5:45pm
Chicago Lower Level