Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, March 10, 2016 at the IBM Chicago Technical Exploration Center (TEC). The IBM TEC is located in the Hyatt Building at 71 South Wacker in Chicago.

Click here to register for the 1st Quarter Meeting - March 10, 2016.

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 Our Next Meeting - March 10, 2016

Agenda for 1st Quarter Meeting - March 10, 2016

08:30am - 09:00am Registration – Coffee, juice, soda and rolls
09:00am - 09:15am Welcome and IBM Announcements
Sheryl M. Larsen, BMC
09:15am - 10:30am Tuning Queries Like a DB2 Developer
Jase Alpers, IBM

Tuning DB2 applications for optimal DB2 performance does not need to be a complex exercise. Most SQL performance problems can be easily solved by identifying and resolving differences between the optimizer's expectations and reality. In this session, we'll walk through the process used at the lab to identify and resolve access path performance problems. We'll discuss the primary reasons optimizer "gets it wrong" along with options to correct the poor performance.
10:30am - 10:45am Break
10:45am - 12:00pm

Compliance with Compliments! Viable DB2 z/OS Workload Tracking
Ulf Heinrich, SEGAS Inc.

Audit and Compliance is a need that many companies want and have to fulfill. There's different ways and tools that promise to be able to do it, but what can they really do and what are the associated costs? This presentation introduces DB2 10/11 technology exploitation that delivers any DML, DDL, DCL being executed in a DB2 environment along with identification details. Learn how you can run Audit analytics against a long-term repository, pinpointing who executed a query, when and from where. Analyze your entire workload to understand access patterns and abnormalities.

12:00pm - 01:15pm

Lunch - Free onsite
Sponsored by SEGUS  
01:15pm - 02:30pm

Runstats Challenges for Optimal Query Performance
Jase Alpers, IBM

Accurate and relevant statistics are the basis of reliable good query performance. How do I identify the important statistics? How do I manage statistics collection? How do I handle statistics on tables that fluctuate dramatically in data volume? What features do DB2 10 for z/OS and DB2 11 for z/OS provide to help with Runstats challenges? In this session, we'll answer these questions and more as we discuss various Runstats challenges and misconceptions.

02:30pm - 02:45pm Break
02:45pm - 04:00pm

Understand Your Impact on Capacity Planning
4Rick Weaver, Data Kinetics

DB2 performance issues can affect your IBM Monthly License Charge (MLC). This presentation will discuss how tuning DB2 applications can increase capacity for more workloads without impacting the IBM monthly license charge.

Speaker Bios

Jase Alpers is part of the DB2 for z/OS optimizer development team out of the IBM Silicon Valley Lab. He is a frequent speaker on DB2 query optimization having presented at IOD as well as many DB2 user groups over the years. Jase has more than 15 years’ experience with DB2 in application development, consulting, DB2 support, and DB2 optimizer development. Prior to joining the DB2 optimizer team, Jase led the SQL performance and Relational Data Systems DB2 support teams. Jase's work is focused on driving improvements to DB2 query optimization as well as deep dive analysis and resolution of SQL

Ulf Heinrich is the Director of Solutions Delivery at SOFTWARE ENGINEERING GmbH. He specializes in DB2 recovery issues and database maintenance, focusing on the growing requirement for cost reduction and 24×7 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. He’s involved in the development of SE’s maintenance and recovery solutions.

Rick Weaver Over the past 25 years, Rick Weaver has become a well-known mainframe expert specializing in database protection, replication, recovery and performance. Because of his vast expertise, he has authored numerous articles, white papers and other valuable pieces on database technologies, and frequently spoken on the subjects of database recovery and performance at conferences, symposiums and user groups.