Welcome to the MWDUG Website!

Please take a moment to review our site.  Our next meeting will be held Thursday, September 15, 2016 at the IBM Schaumburg Office located at 10 N. Martingale Road, 3rd Floor, Room 3066, in Schaumburg, Illinois 60173 - PLEASE NOTE THE LOCATION HAS CHANGED AND IS DIFFERENT FROM WHERE PREVIOUS MEETINGS HAVE BEEN HELD.

Click here to register for the 3rd Quarter Meeting - September 15, 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


Speaker Bios

Dr. Avijit Chatterjee is a Senior Technical Staff Member in the IBM Competitive Project Office and also a member of the IBM Academy of Technology. Dr. Chatterjee is a thought leader specializing in Big Data, Analytics, Mobile Computing and Enterprise Architecture. His active hands-on research and deep expertise uniquely position him to share his broad knowledge and deep insights with customers worldwide. During his 25 years with IBM, Dr. Chatterjee has provided consulting services to customers, played an instrumental role in launch of products resulting in 6 patent filings, led development of industry solutions and participated in numerous research projects. He has a Ph.D. in Computer Science from the University of Southern California.

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.

Kai Stroh earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in DB2 utilities for z/OS. He designs and builds innovative DB2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around DB2 dumps and knows how to move data and definitions across DB2 versions, and this includes the unique in-house DB2 subsystems which each have their own little technical adaptations.

Agenda for 3rd Quarter Meeting - September 15, 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

Test Data Management - Concepts and Methods
Kai Stroh, UBS Hainer

We will discuss test data management and the issues that DBA's and staff must deal with to supply various DB2 environments with fresh data quickly, efficiently and in a way that saves resources, automates processes and improves data delivery times.  Rapid data provisioning, data masking, and test data management topics with emphasis on DB2 z/OS will be addressed, as well as supporting DB2 LUW, Oracle, SQL Server.

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

How to save 10% and more of your PEAK CPU
Danny Zeitouny, Log-On Software

Log-On Software, an expert in memory management methodologies and performance improvement tools since 1983, continues creating competitive edge solutions for its worldwide customers.  Lately Log-On unveiled its latest breakthrough solution - QuickSelect - a performance improvement solution for DB2, enabling substantial savings when it counts most, without any application changes required.

11:30am - 12:30pm
Run Spark on z Systems to deliver end-to-end Analytics
Dr. Avijit Chatterjee, IBM

Most businesses today are targeting customers as individuals and no longer as segments.  Hence, CxOs have a new boss in town - the customer!  Analytics helps companies cater their products and services to the right customer at the right place and right time.  To understand what the customer wants in real-time, one has to analyze enterprise operational data often residing on on-premises z Systems as well as external data from blogs, social network sites and IoT sources.  Spark helps keep the data in place and run in-memory analytical queries using a federated approach.  It powers a universal compute model acting as a new operating system for analytics.  It supports a wide variety of data formats and supports SQL, streaming, graph and machine learning based computations.  Spark in conjunction with Rocket's Data Virtualization Server running in z/OS can access any z systems data source seamlessly and integrate with analytics results from Spark running on the public cloud accessing external data.

12:30pm - 01:15pm

01:15pm - 02:30pm

IBM Cloud Data Services is Open for Data
Dr. Avijit Chatterjee, IBM

IBM Cloud Data Services (CDS) provides a complete portfolio of managed services for data and analytics.  Using a hybrid, open source-based approach that application developers, data scientists and IT architects seek, IBM CDS addresses their data-intensive needs and delivers both immediate and longer-term benefits.  It gives every member of the data team self-service access to the right tools.

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

Don't let ICIs put your DB2 application in the ICU!
Ulf Heinrich, SEGUS

The what and why of ICIs: The number of incompatible changes being introduced by IBM started off slowly in DB2 9 but has grown to a significant number today.  So much so that there are ways to trace incompatible changes (using IFCIDs and ICI, or Incompatible Change Indicators).

Ways to deal with incompatibilities: This session will discuss the incompatible changes, their potential impact on your applications, as well as provide guidance on how to make it easier to mange/control.

Customer experiences: Now that we all know everything about ICIs, let us have a look at how you can find where the "bad guys" are and how to continuously check that everything is ok.  This presentation will show how you can find out ICI details for static and dynamic SQL, and then we will show real customer results from a "BiF hunt".