Welcome to the MWDUG Website!

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

Click here to register for the 2nd Quarter Meeting - June 4, 2015.

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

For details regarding DB2 for LUW, please email David Majcher.

Agenda for 2nd Quarter Meeting - June 4, 2015
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 LOB's
Sheryl Larsen, BMC

10:30am - 10:45am Break
10:45am - 12:00pm

DB2 in the Digital Age
Sheryl Larsen, BMC

This presentation takes a look at DB2 in the 21st Century. A lot has changed over the last 30 years from the structure of the database to the data itself. As the database has become more complex, so too have the obstacles and challenges facing the people who have to manage it. When the digital age is discussed, talk is focused mostly on the front end of applications and how they have to be web and mobile ready. However, these applications often, ultimately funnel the data to and from DB2 on z Systems. Often ignored, the mainframe is the foundation for the digital revolution. There will be winners and there will be losers in the race for digital transformation. Those with the solid foundation have a major competitive advantage in their industry. This presentation focuses on what the modern DB2 database looks like. We will also discuss the new demands facing the database administrators and database managers in the world of global instant access.

12:00pm - 01:15pm

Lunch - BMC will host a Lunch 'n Learn on the following topic:  BMC Next Generation Technology - The New Paradigm
Sheryl Larsen, BMC

This presentation will explore the details of BMC Next Generation Technology for DB2 data management. BMC’s NGT Utilities are digital ready utilities designed to simplify the complex DB2 database of the 21st Century. These utilities redefine what true data management must be in the demanding digital age. We will show the process of building the utilities from the ground up to get a deep understanding of not only the how but they why and most importantly, what does it mean to you and the DB2 industry. A reorg that never takes the data out of RW ever and never sorts? A Load that can be run across a SYSPLEX on multiple nodes from a single job? Is an 85% reduction in resources possible? Can utilities be so resilient that they fix themselves? Can terabytes of unstructured data just become part of routine maintenance? Find out how you can do more than you’re doing now with less work and less resources. A successful digital transformation requires a new simplified solution in data management. The Lunch n Learn will be offered with the Country Springs hot lunch buffet. The buffet will feature oven roasted herb chicken and tenderloin tips. There is no cost to attend.


01:15pm - 02:30pm

Application Development Goodies - What's HOT in DB2 10 and 11 - Make Your Favorite DBA Love You
Steen Rasmussen, CA Technologies

The past couple of DB2 releases has been interesting in terms of providing both Development and Database Administrator a wealth of features to do “autonomic computing” and to preserve development time getting new/ changed applications to market faster than ever before. You “JUST” need to identify how you can take advantage of these COOL new “things” and how to make your favorite DBA your best friend. After all – making DB2 successful requires the application development teams AND the DBA’s to get together and work together. We will discuss some of the latest features related to how applications can take advantage of DB2 but also how these application changes need to be understood by the Database Administrators.

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

Too Many Fights in Your Marriage with Runstats - Get Your Life Back
Steen Rasmussen, CA Technologies

Runstats has always been a challenge in terms of what syntax to use, how much statistics to collect and how frequent to collect these statistics. The past couple of DB2 releases have introduced some interesting features which can assist you in several ways to both automate and figure out which statistics the Optimizer would like to see in order to make better recommendations. We will look into the RUNSTATS profiles and the two different FEEDBACK tables populated by the Optimizer.