Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, December 1, 2016 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 4th Quarter Meeting - December 1, 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 4th Quarter Meeting - December 1, 2016

Agenda for 4th Quarter Meeting - December 1, 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:15am

IBM Big SQL for the DB2 DBA
Jim Wankowski, IBM

The adoption of big data and Hadoop is resulting in a paradigm shift in the IT industry that is rivaling the release of relational databases and SQL in the early 80s. We are seeing an unprecedented explosion of growth of data volume. This growth is the result of the myriad of new data sources that have been created within the last 10 years. Things like machine sensors which collect data from everything from your car to your blender at home, RFID readers, web logs, and especially social media are generating terabytes of data every day. This new “smart data” can provide tremendous business value if it can be mined and analyzed. The problem with all this new data is that the majority of it is unstructured so, storing and analyzing it has far exceeded the capacity of the traditional RDMS and SQL model. The solution to this is Hadoop. Hadoop is really nothing more than a massive parallel file processing architecture. Hadoop allows you to store combinations of both structured and unstructured data. The method used to access the data is called MapReduce. MapReduce was built for large-scale processing on big data, viewed mostly as batch processing. This new technology has created a whole new set of issues. Number one is MapReduce is a very complex programming model requiring specialized skills. There is a growing need for a more OLTP type of capability to access this valuable data. As enterprises start using Apache Hadoop as a central data repository for all data originating from multiple structured and unstructured sources, SQL processing becomes an optimal choice. This presentation will focus on various choices for using SQL on Hadoop such as Hive and IBM's BigSQL. With SQL on Hadoop technologies, it's possible to access big data stored in Hadoop by using the familiar SQL language. Users can plug in almost any reporting or analytical tool to analyze and study the data.

10:15am - 10:30am Break
10:30am - 11:30am

Optimization and Performance in DB2 11 for z/OS?
Troy Coleman, IBM

Query performance and optimization are critical to total cost of ownership with your DB2 for z/OS applications. 12 months after GA, learn about the latest updates and feedback about the DB2 11 enhancements to query performance and optimization. DB2 11 for z/OS is packed with query performance improvements - predicate rewrites to improve indexability, hash join optimizations, duplicate removal enhancements, DPSIs, subqueries.....if you are interested in improving performance for your DB2 applications, then don't miss this session .

11:30pm - 12:15pm


Speaker Bios

Jim Wankowski is currently part of IBM’s Worldwide Cloud Data services team specializing in IBM’s cloud offerings for Hadoop and DB2. Jim has 2+ years of experience with Big Data and more than 30 years of development and database administration experience with DB2 for both z/OS and LUW. Prior to joining IBM, Jim spent 5 years at CA supporting their DB2 z/OS tools, 10 years as the DB2 product manager for Quest Software, and nine years as a DB2 product specialist at Platinum Technology. Jim is a well-known international speaker who has written articles for DB2 Magazine, and Z/Journal, and regularly presents at IDUG, regional DB2 user groups, and vendor seminars worldwide.

Troy Coleman is currently an IBM DB2 Advisor z/OS and brings a variety of skills focused around DB2 including product management, DB2 systems programmer installing and configuring DB2, application DBA, and application developer. Troy has been active in the DB2 community as a board member for the Chicago Midwest Database User Group (MWDUG) and former board member of IDUG as well as holding the prestigious title of IBM Information Management Champion from 2011-2015. He is an internationally recognized consultant and lecturer specializing in DB2 database administration and application architecture with experience on many leading hardware platforms, including DB2 for z/OS, Windows, AIX, Solaris and Linux. Troy was the architect and lead developer of the first wireless database management software for DB2 for LUW, PocketDBA, by Expand Beyond Corp.