The New England Midrange Users Group








Contact an Officer

 Download Annual    Invoice

Home Page



Next Meeting - Wednesday, June 21, 2017 - Intro to SQL Performance Tools and Methods


The New England Mid-Range Users Group is organized as a resource for users of IBM System i, i Series and AS/400 systems. If you were looking for the New England M User's Group (MUMPS) goto


Date: Wednesday, June 21, 2017

Sign in 5:15PM; Speaker 6:00-7:15PM; Dinner to follow

Place: Jimmy G's Tavern (formerly Ambrosia Tavern), 116 Elm Street, North Attleboro, MA 02760
Topic: Intro to SQL Performance Tools and Methods
Speaker: Jim Denton
Dinner: Chicken Marsala; or Angus Steak Tips; or Baked Haddock; or Veggie Panini(Vegetarian). Also included are appetizers, salad, dessert, and coffee/tea.

Cost:  NEMUG Members $30, Guests $40, Students $10. Make check payable to: NEMUG. Mail to: NEMUG, c/o Eileen Newell, 455 Smith Street, N. Attleboro, MA 02760 or register on the NEMUG web site, , and pay at the door.

R.S.V.P. to Rasa Pizzi. Register on the web, , or e-mail .
We must receive your reply no later than Friday, June 16, 2017.
** No shows will be billed, unless cancellation is received by Tuesday, June 20, 2017. **

NOTE:  As mandated in our by-laws, annual elections will be held at this meeting.  Anyone interested in an office please notify us prior to the start of this meeting to be added to the candidate pool.


Intro to SQL Performance Tools and Methods


DB2 for i SQL performance is a big topic and can't be covered in a short amount of time! But this session will provide a valuable overview of three major areas.

• The first is the process of query optimization including the DB2 for i approach, critical inputs, sources of metadata, the outputs of query optimization, and the tools that provide feedback on the optimizer's choices.

• The second area is indexing strategy and addresses the two types of SQL indexes, how they work, when and what kind of index to create, and some advanced indexing options.

• The third area covers the system level tools that can be used to monitor and tune SQL activity including the SQL plan cache and SQL catalogs.

Jim Denton is a senior consultant in the Lab Services DB2 for i team where his responsibilities include both customized skills transfer and hands on consulting. Jim specializes in SQL performance, data-centric programming, and database modernization. Jim started his IBM career in 1981 as an S/38 operating system programmer. Before joining the consulting team, his key assignments included ten years as a systems performance specialist, five years as the lead “JDE on i” performance analyst, three years as a consultant at the IBM Benchmark and Briefing Center in Montpellier France, and a total of eleven years as an operating system developer, including five years designing and implementing enhancements to DB2 for i.

NEMUG Officers

President Dawn Dawson, The Moore Company (401) 315-6351
Vice President Chip DiFolco, Callico (774) 227-7373
Secretary Rasa Pizzi, Franklin Sports, Inc. (781) 573-2443, (508) 944-1545
Treasurer Eileen Newell, FGX International (401) 719-2337
IBM Liaison Rick Cowles, IBM (781) 895-4714
Webmaster Jerry Perreault (401) 949-2613
NE Conference Liaison Chip DiFolco, Callico (774) 227-7373 cdifolco@callico.comMessage from the President

Message from the President

It was great to have Rob Bestgen from IBM at our last meeting to share SQL Writing Tips & Techniques with us. I know I learned quite a bit from this presentation like how you have to change your mindset with regards to Native Record Level Access vs. with SQL and how you can combine Multiple SQL Statements and create either a Simplified or Single SQL Request and the Create or Replace statement. He shared some very helpful hints for all of us to use. Thanks Rob for a great presentation!!!

Joining us on June 21st will be another IBM’er – Jim Denton. He will be presenting ‘Intro to SQL Performance Tools and Methods’. His topic will focus on three main areas: Query Optimization, Indexing Strategy and System Level Tools. I believe this will be a great follow up to Rob’s session. As a reminder, this is the last meeting until September. If you have any topic or topics you would like us to focus on next year, please let us know – whether you plan to attend or not.
Chip DiFolco, Vice President NEMUG
E-mail Notification
If you are not on our e-mail list, go to the web site at and click on the "Subscribe" button to be added to the list.


Welcome to the following New and Renewing Member Companies

(as of 10/31/16)


Aurora Technologies



Franklin Sports, Inc.


JH Lynch

Jim Mason

The Moore Company


Thank you for your support of NEMUG!
If your company has not registered yet, go to the website to download the annual invoice for membership (on left side of the home page). Bring a check (payable to NEMUG) and the form with you to get the member prices at the meeting.

(Schedule is subject to change)

 June 21 — What's new in DB2 for I, Jim Denton (IBM)


click here--> Dick Evans says Thank You! <---click here


Click for NEMUG Apparel



The next meeting
Wednesday, June 21, 2017


Manage your subscription to NEMUG emails


Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Subscribe
For Email Marketing you can trust

The Maxava iFoundation, established by Maxava, to support non-profit IBM i user groups, has awarded a grant to NEMUG.  We are proud to be recognized by the Foundation, and to have been selected for this award.  We look forward to a lasting relationship with them.

Click on either of the links to learn more about Maxava, and the Maxava iFoundation.


Click to see a 1968 midrange computer!




Copyright 2011-2012 New England Midrange Users Group

Site created and maintained by Jerry Perreault  -- Last updated June 07, 2017 -- Best Viewed at 800x600

Top of Form