26th Annual New Hampshire / Vermont IBM i User Group Meeting

Thursday, June 6, 2013 - Fireside Inn, West Lebanon NH

This event was free and sponsored by IBM, NHMUG and VTMUG.

IBM Announcements - Steve Fier, IBM

Steve Fier will review the latest IBM Power Systems and IBM i announcements and how our customers are using these new technologies. As IBM i shops upgrade to newer releases like IBM i 6.1 and 7.1 before V5R4 goes to end-of-support in a few months, people are asking "What's new in IBM i and how will this make my life easier?"

A programmer's future: Looking back to see the future - Pete Massiello iTech Solutions

This session looks back at the history of programming and computing. We examine the skill sets that programmers required in the past, examine the skills of those programmers entering the market, and what is required of today's programmers to compete in the future. If you don't invest in yourself, your skills don't remain static, they actually slowly deteriorate compared to the market. We are taking a light hearted look at what we need to do with our careers to compete and excel in today’s market.

I Didn't Know You Could Do That Using SQL - Skip Marchesani

Tired of writing a one-time RPG program with many lines of code to do special or unique things with your tables and data? In many cases you can use SQL instead.

In this session you will learn valuable and time saving techniques with SQL that let you avoid writing code. You will learn how to use SQL subquery or subselect in an SQL SELECT, INSERT, UPDATE, DELETE or CREATE TABLE statement to reference multiple tables without having to do a join of the tables involved, and you will also learn how to use CASE and UNION statements.

This session is based on the SQL function available in V5R4, V6R1 and V7R1 of OS/400 or i5/OS, assumes you have a basic understanding of relational database concepts and SQL.

The Why and How of the iModernize(d) Application Architecture - David Andruchuk CSDA, inc

For most IBM i shops an ongoing initiative is to take advantage of the new offerings IBM has made to the IBM i hardware and software that has defined and set our platform apart from the competitors. The process of converting your non data centric architecture to a data centric architecture can appear to be beyond the reach of many IT staffs.

While the performance gains of modernizing can be easily quantified, the added benefit of flexibility often goes unheralded. Being able to provide faster response to constantly changing business requirements and ever increasing large data demands placed on our environments can be achieved without having to recompile your current programs. Adapting your database access and software development practices is as much a necessity as changing your business to constantly changing market requirements.

In this session we will discuss:

  • The process of converting your DDS defined PF and LFs to DDL defined tabkes, views and indexes
  • Taking advantage of the scalability and flexibility gains offered by modern technologies, both in hardware and in software engineering
  • Adopting the use of views and stored procedures to gain separation between your data model and your programs
  • Designing your system to become easier to implement your web based or graphical UI layer
  • Real life examples of flexibility and performance gains achieved on the path of IBM i(ntegration)


Charles Guarino presents to NHMUG

Charles Guarino - Thursday February 21st, 2013


So you keep hearing about this great tool RDP (Rational Developer for Power Systems Software) but are somewhat intimidated by the prospect of learning it? This session is a primer on RDP basics, including new terminology, connecting to the IBM i, and getting productive with its features, with a large focus on source code editing. The rich graphical environment far exceeds what PDM and SEU can do, and you will be glad you spent the time learning how to harness its power. The more you use this tool, the more you will want to use it. This session includes a live demonstration of the tool.

From STRPDM to RDP - Awesome RSE Navigation

Of all of the perspectives in RDP, the Remote Systems Explorer perspective is where you will likely spend most of your time. It’s quite possible that you’re not using all of the available tools it offers. Not by a long shot. Attend this session and leap to the next level of application development. Here we will discuss advanced RSE concepts including using filter pools, bookmarks and tasks and using the remote scratchpad, just to name a few.

After attending this session you will possess the skills to watch your RSE productivity soar!

Raising the Bar - A Jumpstart to Using SOAP Web Services in RPG

The Internet abounds with available services using Simple Object Access Protocol (SOAP). The process of consuming these services from your programs is a bit tricky, that is until you use one of IBM’s latest tools WSDL2RPG, which is a component of Integrated Web Services (IWS). This tool does the heavy lifting for you and sets up an entire environment with a callable RPG service program. And the best part is this V5R4 and above tool is FREE! Refuse to be intimidated! In this session we’ll work with the tool and review step-by-step the process of testing and consuming a SOAP web service and displaying its information in a working RPG display program. Learn how you can leverage this technology so your applications can explode beyond your own four walls and gain access to vast information resources on the web in real-time. Here is a great place to start your learning - http://www-03.ibm.com/systems/i/software/iws/documentation.html

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

Now that you’ve been consuming web services directly 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 user 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 is a snap!


With an IT career spanning over 25 years, Charles Guarino has been an enterprise application consultant for most of them. Since 1995 he has been founder and President of Central Park Data Systems, Inc., a Long Island based IBM midrange consulting company. He has published numerous technical and strategic articles for the IT community and speaks each year at conferences and user groups across the country. He was inducted into COMMON’s Speaker Excellence Hall of Fame in 2008 and also selected as one of LISTnet's Long Island’s Twenty Top Techies for 2009.

Charles is currently a COMMON Application Development Subject Matter Expert and President and monthly Q&A host of LISUG, a Long Island IBM System i Users Group.


Dawn May - performance topics

Dawn May - Wednesday November 7, 2012

Navigating the World of Performance

IBM provides many performance tools for i, but what does each tool do and when is the best time to use it? This session will help answer those questions by providing an overview of many System i Navigator, IBM Systems Director Navigator, and green-screen performance tools that can be used to collect performance data, view historical data, and analyze performance issues. Learn which tools to use to provide your `first level of defense` for preventing serious performance problems and understanding system performance. Learn which tool to pull out of your toolbox if a problem does occur and you need to analyze and fix the problem.

Performance Data Investigator

The IBM Systems Director Navigator for i has `Performance` tasks that includes many traditional i performance tasks. It also has the ability to manage your performance data collections. The most exciting feature is the `Investigate Data` task, which provides the ability to graphically view your i performance data; Collection Services, Disk Watcher, Job Watcher, and Performance Explorer data can all be 'investigated' through this interface. This session will go through all the capabilities of the Performance Data Investigator.

IBM i Systems Management Enhancements

The IBM i development team has been very busy working on improving the IBM Systems Management solutions for i. This session will review the latest offerings and enhancements and will include the new iAccess Solutions client and Navigator for i enhancements that will be available later this fall. These enhancements provide not only new features, but also improved performance and ease of use.


Dawn May is a Senior Technical Staff Member with IBM in Rochester, Minnesota. Dawn's current position is a consultant on IBM Systems Director in IBM Lab Services and Training. Prior to this, Dawn was the lead of the Performance and Scalability Services Center. Previous responsibilities include technical lead for the IBM i Systems Software Development organization and IBM i Business Architect where she had the responsibility for the overall strategy and plan for the core components of i. Dawn also had technical leadership responsibilities for i performance and diagnostic tools and led the development of the 6.1 and 7.1 performance tools enhancements, which included the "Performance" tasks in the IBM Systems Director Navigator for i Web console. Other past responsibilities include testing, SNA and TCP/ IP communications development , service tools development, and work management development.

Dawn May is a senior technical staff member at IBM in Rochester, Minn. She’s the technical lead for the IBM i Systems Software Development organization and an IBM i Business Architect. Dawn’s responsible for the overall strategy and plan for the core components of i. Dawn also has technical leadership responsibilities for i performance and diagnostic tools; she led the development of the 6.1 performance tools enhancements, which includes the new Performance tasks in the IBM Systems Director Navigator for i5/OS Web console. Past responsibilities include testing, SNA and TCP/ IP communications development, service tools development and work management development.

Dawn also maintains a blog, i Can Technical Tips for i.


25th Annual New Hampshire / Vermont IBM i User Group Meeting

Thursday, June 14, 2012 - Fireside Inn, West Lebanon NH.

Power and IBM i Roadmap - Steve Fier, IBM

Steve will review IBM announcements since last June's meeting. These will include updates to IBM i and Power Systems servers, and new storage products. How are customers using new capabilities like Solid State Drives or DB2 enhancements to be more productive?

IBM PureSystems - Tom Capasso, IBM

Tom will review the April 2012 IBM announcement of IBM PureSystems. These new servers run IBM i, AIX, Linux and Windows on Power and Intel processors. They offer "Integration by design" and "A simplified experience". Sound familiar? Learn how IBM PureSystems complement (but do not replace) traditional Power Systems servers. (See also Steve Will's blog entry at http://ibmsystemsmag.blogs.com/you_and_i/2012/04/ibm-puresystems-and-ibm-i.html

High Availability – Go Local or Go Cloud? - Simon O'Sullivan, Senior Vice President, Maxava

2011 was the most expensive year in history for Natural Disasters. IT Managers are under pressure to backup more data and if disaster strikes - data loss is not an option! IBM i sites worldwide are changing the way they look at Disaster Recovery and High Availability. Tape backups no longer provide the protection that most modern businesses demand – recovery times are just too long and the recovery points can lead to lost data. The problem is that alternative solutions seem too expensive or too complicated. Is the emergence of Cloud DR the game changer? Simon O’Sullivan of Maxava will outline the latest DR & HA options open to IBM i sites.

Google Apps and your IBM i - David Andruchuk, CSDA, inc

Google Apps is a suite of products that lets you create different kinds of online documents, work on them in real time with other people, and store your documents and your other files -- all online, and all for free. With any device with an Internet connection, you can access documents and files from any computer, anywhere in the world as can your employees, your clients or your vendors. This presentation will give you an overview of the many possibilities of what you can do using Google Apps and your IBM i DB2 data. The possibilities are endless for using Google Apps such as using a Google spreadsheet for physical inventories, using a Google calendar to publish manufacturing date schedules or Employee vacations or birth dates and even distributing reports as PDF in Google documents.

What we will be covering:

  • Learn about what Google Apps are and how they can benefit an IBM i shop
  • Learn how DB2 table data can be converted to use as a Google spreadsheet
  • Learn how to convert an IBM i report to a PDF and publish as a Google document
  • Learn how to convert DB2 table date data to publish as a Google calendar