Join NHMUG and Doug Mack on April 15th for a new Lunch and Learn

Tax day has been pushed out, so now instead of having to stress out about meeting the tax deadline, relax and come join us Thursday, April 15th, for an hour of new information related to the IBM DB2 Web Query tool with Doug Mack from IBM.

Get those reports up and running in no time!

You bring the lunch and we'll supply the education.


Thanks to our friends at iTech Solutions Group we can have this virtual meeting!

Come join us on Thursday April 15th starting at noon Eastern time for an hour of education about the new updates for the IBM DB2 Web Query tool with Doug Mack.

Title: What's new with Db2 Web Query - a LOT!

Overview: The IBM i BI and datawarehousing tool set called Db2 Web Query for i continues to evolve. The new EZ-Report can create a report over a file/table or SQL statement in seconds. With the addition of IBM i Services (and ACS Insert from Examples), you can quickly build reports to monitor system metrics (limits, utilizations, storage), etc. New version 2.3.0 extends abilities to simplify the building of dashboards with powerful visualizations. New software packages (Scheduler or RunTime User Editions) allow you to expand usage to an almost unlimited user community in a much more economical way.

Our Presenter - Doug Mack

Mack Doug

Doug Mack is a Db2 for i Analytics Consultant in IBM’s Systems Lab Services organization. In that role he serves as Db2 Web Query Product Manager and leads the consulting team providing Db2 for i expertise.

Doug is a regular speaker at customer events including COMMON, IBM Technical Conferences and Executive Briefings and has written many articles and white papers on the attributes ofDb2for i for analytics.

You can follow Doug on Twitter @mckdrmoly or his blog



Have you heard about the amazing podcast created by the dynamic duo of Peg Tuttle and Tony Turetsky called the The Incredible i Show?  You've got to check this out!

Join Peg and Tony as they sit down with IBM i users and professionals to chat about your favorite IT system. Hear from innovators, thought leaders, and everyday users about how they run the i in their shops and what this powerful platform has allowed them to accomplish in their business. 

One of our favorite things to learn is the breadth of companies our favorite platform is used in.

You might even see a few names that are familiar to some of us in the NHMUG and VTMUG groups!

Check it out at the Common site or available at your favorite podcast location. 

 Due to COVID-19 the NHMUG Meeting for March with Donna Westmoreland has been canceled. We will reschedule at a future date.


Donna Westmoreland Presents Change Managment on Thursday March 19th at the Backyard Brewery in Manchester NH

“In life, change is inevitable. In business, change is vital” – Warren G. Bennis

Our March meeting is centered on the idea of CHANGE and what we must do to meet the challenge of change in business.

So come and join us for our next NHMUG meeting on Thursday March 19th, 2020 at the Backyard Brewery in Manchester NH with Donna Westmoreland of Midrange Dynamics to present on Change Management. 


Session 1:

DevOps and CI/CD Pipelines in the IBM i World: We do it, our customers do it, and you can too!

Donna Westmoreland

DevOps is the force that empowers modern development teams to deal with constant change, while improving quality and reducing downtime. Implementing modern development using DevOps practices, agile development strategies, and tools on the IBM i adds significant benefits for your team and your business. 

In this session, we’ll provide a practical look at what DevOps and CI/CD (Continuous Integration / Continuous Delivery) are and how they map to the IBM i, demystifying the concepts and cutting back the hype. You’ll walk away with a practical understanding of how you can integrate with, or drive, your digital transformation using DevOps in your own environment.


Learning Objectives:

  1. Discuss DevOps practices, frameworks, and tools in the context of IBM i application modernization
  2. Discuss how the IBM i fits into the overall IT CI/CD pipeline.
  3. Understand what open source tools will, and will not, deliver for DevOps on IBM i
  4. Dramatically reduce production downtime and shorten timelines


Session 2:

Modernization – Yes! Now How Do I Get Started?

You know what needs to happen; let’s talk about how to make it happen. Successful modernization involves leveraging your development team’s business knowledge to accomplish your modernization goals and keep the IBM i front and center in your IT infrastructure.

In this session, you will learn how to harness existing business knowledge, create a plan, and arm yourself with the right tools. We’ll discuss various strategies to fit your business needs, plus staffing, education, training, development strategies, and implementation considerations. You’ll leave with a better understanding of the steps you need to take to tackle a range of modernization projects effectively and how to present a strong plan to your business stakeholders.

Learning Objectives:

1) How to structure your modernization projects
2) How to evaluate best in class tools to aid in modernization
3) Understand the perception of success and exceeding expectations

4) See the simplicity and power of digital transformation with REST using RPG on IBM i

Session 3:
Change Management Tool Demo

Donna will demo a tool currently being used for change management by customers of Midrange Dynamics.



Donna is the CTO for Midrange Dynamics North America.

Experience gained from leading major projects, including application modernization at hundreds of corporations has given Donna a well-rounded view of development needs, audit requirements, and testing principles.

NHMUG Welcomed Jesse Gorzinksi on Thursday January 16th at the Backyard Brewery in Manchester NH

IBM has embraced the Open Source community and now we have access to any number of tools for the IBM i.  Come listen to one of the primary drivers at IBM in the Open Source realm as he speaks on a broad range of topics from the use of Node.js and Python to tools available for Machine Learning and finally the future of Open Source on the IBM i.

 What better way to engage a younger generation of developers than by showing them all that the IBM i has to offer in the Open Source arena.



Why Node.js

Jesse Gorzinski

Surely you've heard about Node.js. It's one of the fastest growing runtimes. But why? Come gain an understanding of this unique runtime, its several benefits, and the work IBM is doing in the community to provide best-practices and ready-to-use artifacts. Node.js is being used by enterprises to quickly deliver differentiating solutions, and it is fully ready to power key pieces of your enterprise as well!


Getting Started with Machine Learning

The emerging realm of AI and Machine Learning can bring seemingly-limitless opportunity for your enterprise (and perhaps even mankind). How can you leverage these new technologies from IBM i?

This session will provide an overview of what technologies you can be using from your IBM i today. We will cover various AI/ML packages available to run on the system, as well as the cloud-based capability of IBM Watson. After all, IBM i has always been a data-centric platform. Surely, Db2 for i houses mission-critical and intensely valuable data. Coupling AI and ML with this data can bring an unprecedented amount of innovation.

Python and IBM i

Python can do many, many things, but can you use Db2 on IBM i? Of course! RPG? Definitely! In this talk, get an introduction to some of the connectivity libraries that can be used to integrate with IBM i, while also exploring some common pitfalls and solutions for them.

The Future of Open Source on IBM i

The world of open source is fast-moving and exciting, with innovation happening at mind-numbing speeds! Come to this session for some updates on the latest or coolest stuff that's available at your fingertips, as well as some predictions about what may be coming in the future. Certainly, exciting times lie ahead!



Jesse Gorzinski works for the IBM i development lab in Rochester, MN.

He is the Business Architect of open source technologies.

Jesse, who was doing RPG programming at the age of 18, is an expert on application development on IBM i, as well as system access and modernization.

His hobbies include playing with his dog, replacing complex applications with 5-line Python programs, and advocating for the use of new technologies on IBM i!

Prior to his 2006 employment at IBM, Jesse worked with the AS/400 as an I/T administrator for an IBM customer in the finance/mortgage industry, where he specialized in data backup/recovery, process optimization, and information integrity.

 He has a Bachelor's degree in Computer Science as well as a Master of Business Administration degree


NHMUG Welcomes Charlie Guarino on Thursday November 21st at the Backyard Brewery in Manchester NH 

Interaction between internal and external systems is becoming more the norm. Learn about the use of web services as a way to accomplish this interaction utilizing both XML and JSON.

The PDFs from Charlie's session have been added.  Click on the title of the session for that presentation.

The “Best Stuff” of Advanced RDi


Once you have a solid basic understanding of RDi you will want to attend this advanced session that demonstrates many of the finer points of application development. Here is where you can truly customize RDi to watch your development time shrink and performance soar.

Introduction to Processing XML in RPG and SQL Too!

XML has quickly become a standard method of encoding data. It can be used for full document transmittals or data provided via a web service.The extraction of this data into useable information is called parsing. RPG provides two different methods for parsing.

This session goes step by step through the entire process of receiving an XML document to successfully parsing it to a database file. The XMLINTO and XML-SAX statements will be reviewed. The challenges and requirements of both statements will be discussed.

At the end of this session, you will be able to identify which parsing method works best for your particular situation. Included with this session are program listings that you can take back and put to use immediately. Updates to this session include i7.1 TR6’s exciting SQL XML processing.

Learning Objectives:

  1. Gain a basic understanding of XML syntax
  2. Learn how XML parsing has been implemented into RPG
  3. See live examples of the XML parsers at work

i Can Serve You – Providing Web Services From Your IBM i

Now that you’ve been consuming web services, get ready to turn the tables and become the web service provider. Using IBM’s Integrated Web Services server for ILE you too can launch programs to access your database and provide your system’s information to external users such as web developers.

We will go step by step through the process of creating a program to receive a parameter and return database values. Next we will implement this program on to the built-in web services server and demonstrate how to test and deploy it using IBM’s graphical Web Administration tool. Since the tool is wizard-driven deploying web provider side web services has never been easier!

XML and JSON REST Web Services for Everyday RPG and SQL Consumption

A web service extends your applications in a way that no traditional programming can. They allow you to get real time information for almost any requirement.

We’ll discuss what web services are, how they function and how you can begin using them on your own system. Get step-by-step instructions on the entire Web service process from receiving an XML or JSON document to successfully parsing its information to a display or database file. See working RPG code of an XML parsing program and watch how we consume a RESTful web service.

Updates include i7.1 SQL enhancements which make consuming web services a snap. This session includes source code to get started using dynamic Web services today!


Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.

He is a member of COMMON’s Speaker Excellence Hall of Fame and a proud recipient of the Al Barsa Memorial Scholarship Award. Additionally, he participates on COMMON’s Strategic Education Team. Other professional endeavors have included the roles of President and monthly Q&A host of the Long Island System User’s Group LISUG (

Today, along with the team at Central Park Data Systems, he is serving individuals and companies on a worldwide basis though his consulting work and award-winning speaking engagements.

Charles is a true people person and can often be found at conferences sharing his expertise on RDi and other IBM i topics.

Email - This email address is being protected from spambots. You need JavaScript enabled to view it..
LinkedIn -
Twitter - @charlieguarino