Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, September 13, 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 3rd Quarter Meeting - September 13, 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 3rd Quarter Meeting - September 13, 2018


08:30am - 09:00am Registration – Coffee, juice, soda, and cofee cake
09:00am - 09:15am Welcome and IBM Announcements
09:15am - 10:30am What's New in Db2 12...or How Do I Keep Up with All This Stuff?
Michael Cotignola, BMC

With Db2 12 being GA for well over a year now… time for a refresh. We’ll take a cursory look at some of the major new features and enhancements to IBM’s Db2 12, including the new branding! Technically, this release delivers enhancements in all the usual categories, and introduces us to the Continuous Delivery Model. We’ll conclude by taking a closer look at LOB compression, a much anticipated feature with lots of promise.
10:30am - 10:45am Break
10:45am -  12:00pm Using New Technologies on System Z to Drive Business Analytics
Jim Knisley, zAnalytics Architect, IBM Corporation

Organizations today have multiple types of data dispersed on multiple platforms. Bringing this data together with a single interface that can satisfy the needs of data scientists, data engineers, business analysts, and application developers has been nearly impossible…until now. This presentation provides an in-depth look at Machine Learning, IBM Open Data Analytics, IBM Db2 12 features that support analytics, IBM Data Virtualization Manager and the IBM Db2 Analytics Accelerator and how you can help solve this data dilemma on the modern mainframe.
12:00pm - 1:15pm Lunch
1:15pm -  2:30pm Db2 for z/OS Gets Agile: Data-as-a-Service and Database-as-a-Service
Robert Catterall, IBM Corporation

This session describes recent Db2 for z/OS enhancements that allow developers to respond to an organization's application requirements with greater speed and agility. Db2 capabilities related to both data-as-a-service (Db2's native REST interface, and its relation to z/OS Connect) and database-as-a-service (automated provisioning, automated deployment, strategic direction, and what it all means for developers and DBAs) are covered.
2:30pm - 2:45pm Break
2:45pm - 4:00pm

The Learning Optimizer: an Overview of IBM Db2 AI for z/OS
Robert Catterall, IBM Corporation

Choosing the optimal access path for a query, and doing that in a few milliseconds or less, is no easy task. Even with the most sophisticated query optimizer on the market (IBM invented cost-based SQL optimization), Db2 for z/OS doesn't always choose the best-performing access path for a query. Why? Largely because Db2 has had to act without information - specific to YOUR environment - that is critically important with regard to effective access path selection. Up until now, that is. The brand-new IBM Db2 AI for z/OS is going to fundamentally change the access path selection story in a positive way. This session will provide an overview of what IBM Db2 AI for z/OS is, how it does what it does, and its potential to substantially improve query execution performance in diverse Db2 for z/OS environments.

Speaker Bios

Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions. In this role, he helps his clients maximize the value they receive from BMC's DB2 products. Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application development, and database administration. He has been working with DB2 since version 1.1. Prior to joining BMC Software in 1996, Michael was a Managing Consultant for a large telecommunications and technology firm in Canada. Michael was president of IDUG and continues to be involved with IDUG in several capacities, and nominated as an IBM Analytics Champion for 2018.

Jim Knisley is currently an zAnalytics Architect with IBM in the Financial Services Sector. He works with many of IBM's largest banking and insurance customers to develop analytics solutions on z/OS. Prior to joining IBM 6 years ago, during his 30+ year career, he has been an application developer, database administrator, and system programmer for Db2 z/OS and IMS for various companies in manufacturing, defense, banking, and insurance. He began his Db2 career on Db2 Version 1.3 and IMS 3.1.

Robert Catterall is a Senior Consulting Db2 for z/OS Specialist with IBM. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of the International DB2 Users Group (IDUG), and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences, and blogs about DB2 for z/OS at http://robertsdb2blog.blogspot.com/