Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, September 17, 2015 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 3rd Quarter Meeting - September 17, 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 3rd Quarter Meeting - September 17, 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 Defending Against the Legions of Doom:  DB2 Security Best Practices
Dave Beulke

As the Legions of Doom descend on your system you need to be prepared with the best security techniques and strongest configuration safe guarding your data. This presentation discusses the latest DB2 security techniques, the software configurations, and best practices for a resilient comprehensive DB2 security strategy.

The presentation discusses how to design, configure and implement a multi-layered DB2 security perimeter around your data. By having many layers of DB2 security defenses there will be several different security software components helping stop any nasty legion bandits from getting your data. Through proper DB2 security you will learn the secrets to defending your data against the Legions of Doom.
10:30am - 10:45am Break
10:45am - 12:00pm

Keeping up with Technology Can Be a Pain in the aaS
Paul Bartak, IBM

DB2 for z/OS customers are busy as companies cut back and business requirements escalate. Even though they are working with one of the most reliable databases in the industry, there's not a lot of time to keep up with changes which could impact their future. This session will serve to net out some of the key concepts that reside in the Cloud, how they could impact existing systems and future requirements, and some of the names you should know. Go into your next design / planning meeting armed with needed information. This session may also challenge some status quo processes in use today which could limit your future.

12:00pm - 01:15pm

Lunch - Free onsite
01:15pm - 02:30pm

Provisioning with Cloud-style as-a-Service
Maria Sueli Almeida, IBM

This presentation is going to take you through the steps for fast provisioning a DB2 system install/migration through exploitation of z/OSMF Workflow and RESTful API for a Cloud-style DBaaS.  You will also be introduced to DB2 Adapter for z/OS Connect, which will provide the technology for DB2 and API Economics.

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

25 Years of Missed Opportunities?  SQL Tuning Revisited
Ulf Heinrich, Software Engineering

Nothing is more expensive than a missed opportunity” (H. Jackson Brown, Jr).
This is especially true when it comes to SQL Tuning! There are many low-hanging fruits within easy grasp of anyone tasked with tuning their systems. But how do you know what is dangling within reach if you can’t see it? Find out how a modern DB2 z/OS SQL warehouse can collect and store all executed static and dynamic SQL (plex-wide) with basically no overhead. By comparing SQL statements side-by-side, the “easy pickings” will immediately become apparent. But why stop there? Experts can effortlessly dig deeper and find the totally hidden gems: Disc Problem Detection, Delay Detection, Never executed SQL, SQL Timeline. Precisely pinpoint specific areas to target and get the most out of your DB2 system – while reducing costs.