Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, June 7, 2018 at the IBM Chicago Technical Exploration Center (TEC) located in the Hyatt Center, 71 South Wacker Drive, 6th Floor, Chicago, IL  60606.  

Click here to register for the 2nd Quarter Meeting - June 7, 2018.

Walk-ins are welcome for only $35.00 daily fee applicable to a full year membership.


MWDUG Headquarters

MWDUG c/o Technical Registration Experts, Inc. (TREX) 
303 West State Street
Geneva, IL 60134  
Phone: 630-578-3991
Fax: 630-262-1520 
E-mail:  mwdug@trexperts.com

New Contact: Jeffrey Miller or Sue Reed
Website: http://www.mwdug.org


Agenda for 2nd Quarter Meeting - June 7, 2018


08:30am - 09:00am Registration – Coffee, juice, soda, and cofee cake
09:00am - 09:15am Welcome and IBM Announcements
Sheryl Larsen, BMC & IBM
09:15am - 10:15am Selling Your Mainframe to Upper Management
Sheryl Larsen, BMC, WW Db2 Z Solution Strategist

The topic for this presentation was a request from many BMC customers. This will give you ammunition educating upper management on justifying keeping, growing, relocating data on the Mainframe. You’ll get a tone of Db2 Z bragging material. This meeting is sponsored by BMC and she will eventually mention their solutions.
10:15am - 10:30am Break
10:30am -  11:30am Birds Eye View of BMC Db2 Development Labs
John Barry, BMC, Supercharged Db2 Product Manager

John Barry is a 20-year veteran of Db2 and currently manages the production of superior technology that greatly enhances your mainframe environment. IBM provides the boiling water with the Z14 and Db2 12. BMC turns the water into steam to power your enterprise. John will update you on the BMC Db2 solutions and include a taste of futures.
11:30am - 12:30pm Lunch
12:30pm -  01:30pm Total Environment Simulation – Workload Replay in an Agile World
Ulf Heinrich, Software Engineering (SEGUS Inc.), Director of Solutions Delivery

Is your production cloning for development/testing a quick and fully automated procedure? Does it consider differences of the underlying hardware and does it allow to choose and automatically run SQL workloads? Maybe your Db2 cloning needs an upgrade! By using a highly customizable XML script and by exploiting virtualization features we can make a clone YOUR clone and even make it behave like production. However, most importantly SQL Capture/Replay fills the gap of automatically running your production workload for testing. It captures production SQL 24/7 by exploiting highly efficient IFCID-via-OPx technology and it filters and prepares statements for replay. This enables shops to capture any SQL being ever executed and keep them in sets of workloads to be selected for testing. As an integrated part of Db2 cloning, this adds up to a comprehensive cloning solution, not only for objects and data, but even for production workloads. Learn how to integrate individual task for flexible automation and how to choose from four different levels of testing. The levels include simple anomaly alerting, access path verification, cloning and workload capture/replay to easily discover different behavior resulting from changes, like new application releases, or environment upgrades. Find out how easily you can pick and choose from KPI based test automation.
1:30pm - 1:45pm Break
01:45pm - 02:45pm

SQL Procedural Language - Creative Uses
David Simpson, Vice President, Themis

The SQL PL language is useful for writing stored procedures, user defined functions (UDFs) and triggers. The language is becoming more powerful with each release. This session will cover the basics of the language and give you some samples to take home and try!

• Overview of SQL PL
• Strengths and Limitations of SQL PL
• Sample stored procedures for use anywhere!
• Sample user defined functions for use anywhere!
• SQL PL and Triggers .

02:45pm - 03:00pm Break
3:00pm – 4:00pm Access Path Stability on Db2 for z/OS - Best Practices
David Simpson, Vice President, Themis

Db2 has provided some great features for stabilizing performance through changes in the environment, particularly through a Db2 version upgrade. In this session we will look at the evolution of access path stability over the last few releases and provide some thoughts on best practices for implementation.

Speaker Bios

Sheryl M. Larsen is a Worldwide Db2 Z Solutions Strategist at BMC. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest DB2 User Group - www.mwdug.org, an IBM Z Champion and a member of the Northern Illinois University Computer Science Alumni Council.

John Barry is a 20-year veteran of Db2 and currently manages the production of superior technology that greatly enhances your mainframe environment.

Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24x7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under real-world recovery pressure. His activities cover EMEA, as well as North America through SE’s U.S. subsidiary, SEGUS Inc. As a member of SE’s Request Board he’s working closely with customers and the development labs.

David Simpson is currently Vice President at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.