31st Annual New Hampshire / Vermont IBM i User Group Meeting

Thursday, June 20 2019 - Fireside Inn, West Lebanon NH

We are excited that Steve Fier and Ted Holt presented this year. For those of you that have had the pleasure to hear them in the past you know the value they bring to the table from both the hardware and software perspectives

This event was free to IBM i professionals, and sponsored by NHMUG and VTMUG

  

IBM Announcements - Steve Fier, IBMSteve Fier

Steve talked about the new I OS version 7.4 and provided an overview of IBM i 7.3 TR6.

Highlights included:

  • Security Enhancements
  • DB2 for i
  • Continuous Availability – DB2 Mirror
  • Access Client Enhancements

About Steve

Steve Fier has been with IBM over 30 years, initially starting as a systems engineer, and then becoming a senior marketing specialist. His current role is POWER Platform Leader for the Northeast, responsible for former System i and System p products. Steve's areas of expertise include application development, DB2 for i, Windows Integration and Server Consolidation.

Refactoring RPG: What, Why and How - Ted Holt - Profound Logic Software

Download Refactoring-RPG.pptx

Refactoring is rewriting source code in such a way that the new code behaves as the current code does, but is easier to read, understand, modify, enhance and debug. Refactored code takes advantage of features that were not available, or were ignored, when the code was written. This presentation, which is geared toward the RPG programmer, is given by Ted Holt, who has been writing RPG programs since 1982 and has programmed in RPG II and every version since then. Ted explains what refactoring is and is not, why you should refactor, when you should not refactor, and how to refactor RPG. If you have old RPG code in your shop (and who doesn't?), this presentation is for you.

Ted Holt

Say Yes to Change - Ted Holt

Download Say-Yes-to-Change.pptx

Nobody likes to tell the bigwigs that changing the software to accommodate a change in business requirements is impractical or impossible. Whereas we need to say yes, we often say no because we lack time and resources to modify the software systems we support. Abstraction, the hiding of unnecessary detail, makes software more flexible and open to change, and makes programmers more productive. In this session, Ted Holt shows how to use such common techniques as SQL views, logical files, and service programs to build software that can respond to changing business requirements. Aren’t you tired of saying no?

21st-Century CL - Ted Holt

Download 21st-centry-CL.pptx

IBM i Control Language (CL) has long been used as a language for both operations and job control. In recent releases of IBM i (V5R3 thru 7.2) IBM has delivered many long hoped for and long requested enhancements to CL for both environments.

Enhancements include new commands as well as new extensions to existing commands. What are these new features and functions? How can they be used? What's the very latest that CL has to offer? This session will answer those questions and more.

About Ted

Ted Holt is a Senior Software Developer with Profound Logic Software, a provider of modernization solutions for the IBM i world. He has worked within the information technology industry since 1981, primarily with IBM midrange computers. His industry experience includes the fields of manufacturing, healthcare, education, retail, and wholesale. He holds a master's degree in computer science from the University of Southern Mississippi and has taught in community colleges, universities, and vocational/technical schools.

Ted is the author of several books on programming topics, including OpenQuery File Magic!, Complete CL, Power CL, Qshell for iSeries and the MC Press Encyclopedia of Tips, Techniques, and Programming Practices for iSeries and AS/400. He is a regular speaker for the RPG and DB2 Summit and serves as technical editor and writer for Four Hundred Guru, a technical newsletter published by itjungle.com.


 

On Thursday March 21st, 2019 Pete Massiello brought us up to speed on things related to the care of your IBM i

Meeting Handouts:

Putting the pieces together
Cool things in Navigator for IBM i
Differences in classic GUI HMC and Enhanced GUI
Tips and Tircks to improve performance

HMC, IBM I, FSP, & Firmware: Putting All the Pieces Together

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

petemassiello

Cool Things in Navigator to be a Rockstar System Administrator

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

Moving from HMC Classic GUI to the New Enhanced GUI

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

Tips and Tricks to Improve System Performance and Save Disk Space

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

Biography

Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions throughout his career and is currently the President of iTech Solutions Group, an IBM Premier Business Partner delivering solutions and services to IBM i shops throughout the United States. He is a member of IBM's certification test writing team and an IBM Certified Systems Expert with certifications in iSeries Design, Administration, Virtualization, Implementation, LPAR, and HMC Management.

Pete has a BS in Computer Science from Hofstra University and an MBA from the University of New Haven. He was President of COMMON from 2010 to 2012, and is now Immediate Past President, a COMMON Hall of Fame speaker, and a frequent speaker at user groups all over the world. In 2011, IBM established the Champions award for Power Systems; Pete was one of the first recipients.


 

On Thursday January 24th, 2019 Erwin Earley discussed PHP, shell programming and more

Session Handouts

What can PHP on IBM i do for you

PHP and Databse Access

Openi - Exploring Open Source Solutions on IBM i

Shell Programming

What can PHP on IBM i do for you?

You have no doubt heard about PHP on IBM I and may have found yourself thinking ‘that’s nice, but what can PHP do for me?’ This session sets out to answer that question.

In this session we will take a look at the application modernization capabilities provided by PHP as well as the ability to leverage open source applications utilizing the ubiquitous LAMP stack (although we spell ours iAMP) that PHP along with MariaDB provides for IBM i.

The session will highlight the open source toolkit for calling ILE programs from PHP scripts, the DB2 language extensions that facilitate integrating DB2 access into your PHP programs, and the MariaDB storage engine for deploying open source applications on IBM I while having the data for those applications resident in DB2.

By the end of this session you will be able to answer the “what” question and also found yourself asking the “why” question – as in why haven’t I implemented these solutions yet.

EarwinEarley

PHP and Database Access

As the “glue” that holds the LAMP stack together, PHP is used both as the language to represent the business logic of a web application as well as leveraging data from various data sources including relational databases.

The session will start out with a look at the basic database access and manipulation functions provided by PHP. From there we will explore the PHP language extensions for accessing and working with data resident in DB2 on IBM i.

Additionally, we will take a look at how PHP accesses MySQL/MariaDB data and how that data can actually be stored in DB2 without any code changes.

Finally, we will take a look at how the PHP language can be used to build solutions from multiple disparate data sources – specifically in our case we will look at how data from DB2 and data from MariaDB can be represented together to deliver holistically (from a data perspective) solutions.

Openi – Exploring Open Source Solutions on IBM i

Open Source solutions continue to be in vogue for businesses large and small and you might be surprised at the wealth of open source solutions that are available for you to leverage directly on the IBM i platform.

This session will explore IBM’s adoption of open source packages and repositories as well as open source solutions available on IBM i including PHP, SAMBA, node.js, Python, and Ruby.

Along the way we well also explore how to install/enable tools such as bash, git, zip, perl and others in the PASE environment. This session will open your eyes to what is possible on your IBM i.

Shell Programming

If you are going to work in the Linux operating system, or PASE for that matter, then understanding how to program in the shell is an important skill that you must possess.

This session will introduce you to the basic shells that are available and go through a number of programming constructions including looping, functions, and I/O processing.

Closing

IBM i Trivia - the meeting will conclude with “IBM i Trivia Jeopardy”. There will be a few answers to question. A small prize will be awarded to those who correctly question the answer.

Biography

Erwin is currently a Senior Solutions Consultant at Rogue Wave Software working with the Zend line of products (Zend Server, Zend Studio) primarily with IBM i customers.

Prior to starting with Rogue Wave Erwin was a managing consultant in IBMs Lab-Based Services organization responsible for the implementation of cloud-based solutions leveraging IBM’s PowerVC solution as well as Dev/Ops solutions centered around Chef and Docker.

Also played a key role in the propagation of open source technologies in IBMs Power community. Erwin was involved in the initial enablement and rollout of Linux on the Power platform as well as PHP support on IBM i. Erwin has expertise in a variety of technologies including virtualization, storage, networking, and operating systems including AIX, IBM i, and several distributions of Linux including RedHat, SuSE and Ubuntu.

Erwin is a frequent speaker at various user groups and technical conferences and has authored numerous articles on Linux, PHP, virtualization, and systems management.


 

On Thursday November 29, 2018 Rob Bestgen discusses the world of SQL and Db2

SQL Writing Tips and Techniques

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

Handout: SQL Writing Tips and TechniquesRobBestgen

Satisfy 'the Business' with DB2 Web Query

Db2 Web Query for i is a well-known, though likely underutilized, product in the IBM i world. Web Query provides many ways to consolidate and visualize information from data. This session delves into several ways to combine the power of Web Query with Db2 for i to improve your reporting and analytics experience. Wow the business people and empower them to do more themselves. The session will also review how to acquire, download and install the product using the ez-install capability to be up and running quickly (in trial mode.) There are even built in reports to get you started.

Handout: Satisfy the Business using DB2 Web Query

Accessing Data Outside of DB2 for i

There's a world of data out there that can improve and integrate with your own business data. Come to this session to see how the Web and other databases can be available to you via Db2 for i and SQL.

Handout: Accessing Data Outside Of DB2 for i

Vote on:

Transactional vs analytical SQL

SQL performance got you down? SQL statements looking like spaghetti? Proper database design for the intended usage is important for long term success and good performance. There is a difference between transactional and analytical processing and it is useful to understand the difference. What should an appropriate data model look like? What are the red flags that your data model is not best for your usage? This session will discuss these topics along with strategies for handling cases when analytical processing is required against your transactional data. Additional topics touched on include: - real time vs. ETL transformations - using dimension tables for dates, VINs, customer names and zip codes - Operational Data stores – and Dimensional Data Models.

Handout: Transactional vs Analytical

Or:

DataBase Security. Or Leave it to the Hackers

Data has value and it is a critical asset to a business. When a business is "hacked", it means data is stolen or destroyed and the company's reputation is tainted, possibly permanently. Plus, with new compliance laws, there can be legal consequences for not properly securing and managing data. Worse, if you have access to the data, you become a suspect! This session discusses the importance of data, distinguishes different types of data, identifies the many ways data can be breached, and what to do to protect your data. Topics covered include: Personal Information, Security administrative roles, Object level Security, row and column access control, PowerSC, and more.

Handout: Database Security - Or Leave it to the Hackers

Closing

IBM i Trivia - the meeting will conclude with “IBM i Trivia Jeopardy”. There will be a few answers to question. A small prize will be awarded to those who correctly question the answer.

Biography

Rob Bestgen is an IBM Db2 for i architect and consultant. In his 30+ years at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, chief architect of the Db2 for i SQL Query Engine (SQE), and product development manager of various products. Rob is currently a proud member of the Db2 for i Lab Services team, helping customers utilize the amazing capabilities of Db2 for i, IBM i, and Db2 Web Query for i. Rob is also the product development manager for Db2 Web Query for i, the popular IBM i product for query reporting and analytics. Besides working directly with customers, he is also a frequent presenter at user conferences.