Mid-Range Michiana Users Group


The Michiana Mid-Range Users Group meets on the third Thursday of every month except December for presentations and round table discussions related to IBM System i and other mid-range systems.  Watch this page for topic and location information.

Meetings will be held at noon at

CIBER Innovation and Technology Center
4100 Edison Lakes Parkway, Suite 240
Mishawaka, IN  46545

Lunch will be provided

Register for the meetings you plan to attend

We are having trouble with our registration form, please sent your reservation to Vicki Pawloski at vpawloski@ciber.com
Please include the following in your email:
- The date of the meeting(s) you plan to attend
- The name and email address of the people you are registering for

The next MRMUG meeting will be:

Thursday February 18, 2016
Lunch will be provided!

Topic Optimizing SQL Performance on DB2 for IBM i

 Learn how to improve your SQL query performance on DB2 for i – learn about the SQL Query Engine (SQE) and how to optimize the SQL statement itself, index creation strategy including indices over calculated fields, and advanced topics like Encoded Vector Indices (EVI) and Materialized Query Tables (MQT). 

Learn about optimizing tables for in-memory access and Solid State Drives (SSD) plus learn about other SQL features that you may not even know about - XMLTABLE, FULL OUTER JOIN, FIRST n ROWS, DECFLOAT, column masks, TIMESTAMP precision, and the OLAP functions ROW_NUMBER and RANK. 

Speaker – Andrew Clark

Andrew Clark has been working on the IBM i platform for more than 25 years, beginning with the "super-secret" Mankato project on a pre-release version of os/400, and an internship at IBM Rochester working on the Query ("QQ")  team.  He has experience in multiple languages (C++, MI, Java, VB, RPG, COBOL, PLI, CL, JavaScript, Delphi, PHP, ExtJS, etc.) as well as a background in green-screen, Windows, mobile and web development.  He is an expert on everything DB/SQL on IBM i, and has extensive cross-database experience with Microsoft Access, SQL Server, Oracle and DB2/LUW.

Important information if you are still running V5R4 or V6R1!

Support for V6R1 ended on September 30, 2015!
·   Service Extension for V6R1 is available t an additional cost.  Software Maintenance is a required pre-requisite for Service Extension.

Extended support for V5R4 has ended!
Support for V5R4 ended on September 30, 2013.
·   Service Extension for V5R4 ends September 30, 2016.

MRMUG Membership

  • Corporate Membership (unlimited)    $100 per year
  • Individual Membership                     $50 per year

If you would like to join MRMUG, send an e-mail with your name, company name, and contact information to one of the following board members, or just sign up for a meeting and show up!

Craig Nelson                   cnelson@ciber.com
Jim Manuszak                JAManuszak@hotmail.com
Kathy Rogina                 
Vicki Pawloski                vpawloski@ciber.com
Stephanie Thomas          mrmugug@gmail.com