The Michiana Mid-Range Users Group meets on the
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
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
Please include the following in your
- The date of the meeting(s) you plan to attend
- The name and email address of the people you are registering for
MRMUG meeting will be:
Lunch will be provided!
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
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,
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
Extended support for V5R4 has ended!
Support for V5R4 ended on September 30, 2013.
Service Extension for V5R4 ends September 30, 2016.
- Corporate Membership (unlimited) $100 per
- 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!
Jim Manuszak JAManuszak@hotmail.com