Welcome to the MWDUG Website!

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

Walk-ins are welcome for only $35.00 daily fee applicable to a full year membership.

Agenda for Our Next Meeting
Scroll to the bottom of this page to register.

Agenda for 3rd Quarter Meeting - September 11, 2014

08:30am - 09:00am Registration – Coffee, juice and rolls Registration – Coffee, juice and rolls


09:00am - 09:15am Welcome and IBM Announcements
Paul Bartak, IBM

Welcome and IBM Announcements
Dave Majcher, IBM

09:15am - 10:30am DB2 10 and 11 for z/OS - Implementing and Using Autonomic Statistics
John Iczkovits, IBM

DB2 10 and 11 have a neat feature, automatically executing RUNSTATS on required objects.  By the way, you get to choose when and how to execute RUNSTATS.  The actual implementation, however, is not straight forward.  Come to this presentation and learn how to successfully implement and review the output for this new feature.

Sage Advice: 20 Invaluable DB2 LUW Performance Insights from Around the Globe
Scott Hayes, DBI Software

Two million miles traveled, over two thousand hours of global web meetings, and over twenty years' experiences are combined to compile twenty invaluable DB2 LUW performance insights and tips.  Attendees will be enlightened to understand a NEW WAY of looking at DB2 LUW performance data.  Example SQL and commands will be provided so you can log in at the office and be immediately productive and successful.  Covers V9.7, V10.1, and V10.5.

10:30am - 10:45am Break Break


10:45am - 12:00pm

What Every DB2 for z/OS Professional Needs to Understand about IBM Disk and Tape Virtualization
John Iczkovits, IBM

Modern disk and tape does not resemble older technology.  What is the real picture regarding modern disk and tape?  How does the newer technology change the management of your DB2 environment?  How does performance change?  The real question is, why do I care about this new technology?  Come and find the answers regarding the new technology, and how to best leverage it for your DB2 environment.

DB2 Time Travel Query Patterns for Integration, Monitoring and Profit
Fred Sobotka, FRS Consulting

The bi-temporal capabilities added to the DB2 engine in both the mainframe and LUW releases of version 10 greatly simplify many time-aware use cases.  After taking on a bit of additional ANSI SQL syntax, applications that previously had to rely on triggers, history tables and cumbersome subqueries for versioning can now use temporal tables to improve their overall design.  This session will use temporal examples to show lessons learned from real-world DB2 Time Travel Query implementations.

12:00pm - 01:15pm

Lunch - free, onsite Lunch - free, onsite 


01:15pm - 02:15pm

DB2 11 Catching, Tuning, Trending for SQL Workloads - A Resource and Cost Saving Approach
Ulf Heinrich, SEGUS, Inc.

Statement level statistics introduced with DB2 10 is specifically designed to aid the DBA and Developer to understand their SQL workload.  Together with classic DB2 EXPLAIN Tools, Access Path Comparison and Protection Tools this is the fast path to finding and remediating all SQL performance problems.  Take advantage of these new enhancements within DB2 10 and 11, which enables very efficient capturing of ALL SQL statistics without the overhead of classic workload monitors.  It even allows the capture of all flushed SQL from both the EDM and the DSC.  Once captured, this presentation illustrates ways to analyze and store the SQL, building a complete workload warehouse for further analysis, such as detailed EXPLAIN statistics, retrieval of RTS data, aggregation of static and Dynamic SQL (single and mixed), aggregation of SQL without schema name, and updating of all KPI's.

Automation Everywhere and Time Travel Query
Fred Sobotka, FRS Consulting

OAutomation is not laziness.  It is, in fact, an absolute necessity to staying sane as a DBA.  This session shows DBAs how to automate a variety of labor-intensive tasks with a toolkit of powerful and reliable utilities.  The tips presented cover a wide range of use cases and skill levels, but all are based on real-worldDB2 scenarios.  Numerous functional examples demonstrate how DBAs can exploit OS commands and no-cost software libraries to streamline many common tasks:
  • What will and won't work with DB2 CLP and CLPPlus
  • Demystifying classic UNIX tools, including Perl, sed, awk and xargs
  • Windows PowerShell with (or instead of) Cygwin
  • Patterns for configuration management and rapid deployment
  • Scripting considerations for monitoring local and remote DB2 resources
02:15pm - 02:30pm Break Break 


02:30pm - 03:45pm

zMobile is Ready for the Enterprise!  Are you?
Ahsan Saiyed, IBM


DB2 Cancun:  The New BLU Experience
Calisto Zuzarte, IBM

This session looks at what is new in DB2 Cancun.  This release covers general warehouse query performance enhancements as well as specific improvements with DB2 for BLU acceleration.  How about those analytic queries in your OLTP environment?

Speaker Bios
Scott Hayes is President & Founder of DBISoftware IDUG North America2014 is the 26th North American Conference that Scott has attended. Scott has been a regular speaker at IDUG since 1996, he’s a published author in DB2 Magazine & IBM Data Management Magazine, he writes the DB2 LUW Performance blogs at http://www.dbisoftware.com/blog/db2_performance.php, and he is the founder and host of The DB2Night ShowTM Edutainment Webinar Series that has provided over 500,000 hours of free DB2 education to the DB2 community since 2009.

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 24x7 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.

John Iczkovits
is a Consulting IT Specialist with IBM Advanced Technical Support. He provides DB2 for z/OS technical support and consulting services. His areas of expertise include DB2 data sharing, performance, and availability. His work in IBM includes experience supporting DB2 as a Systems Engineer, Database Administrator, IT Specialist, Consultant, and project lead. He has 32 years of IT experience, ranging from database products such as DB2 and IMS to MVS systems support, including storage management. He has also co-authored IBM redbooks, red papers, white papers, trade magazine articles, and presented at IDUG, SHARE, the DB2 Tech Conference, the Information On Demand Conference, zEXPO Conference, IBM System z Technical Symposium, CMG, and at local DB2 users groups.

Ahsan Saiyed
has been an IBM employee for over 7 years. He began his career supporting the IBM WebSphere System z software portfolio. He initially supported WebSphere Application Server and MQ File Transfer Edition, however up to the end of 2013,  supported Operational Decision Manager on System z for 3 years, under Business Process Management. Since the beginning of 2014, he was appointed the Mobile Capability Leader for System z in the Midwest territory, supporting the IBM MobileFirst portfolio, but primarily focusing on IBM's mobile development solution, Worklight. Together with IBM he has developed many Proof of Technologies, mobile solution customer briefings and technical workshops to help customers radically streamline and accelerate an enterprise’s mobile adoption in addition to how mobile technology can strengthen your organization as well as design smarter, real-time applications.

Fred Sobotka
is the President of FRS Consulting, an IBM business partner specializing in DB2 performance tuning, pureScale clustering, XML enablement, and Oracle to DB2 migrations. He is an IBM Gold Consultant, an IBM Data Champion, and an award-winning IDUG speaker who presents regularly at DB2 conferences across North America and Europe. If you really want to get Fred going, ask him about using DB2 pureXML to analyze iTunes song libraries.

Calisto Zuzarte is Senior technical Staff Member (STSM) in the IBM Canada Lab. He specializes in query optimization and is a DB2 Compiler architect on the Distributed Database Architecture Board. He is also a Research Staff Member in the Centre for Advanced Studies (CAS) at the lab overseeing collaborative Information Management projects between IBM and academia.


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