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 aNEW WAY of looking at DB2 LUW performance data.  Example SQL and commands will be provided so you can login 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

Automating Access Path Management in DB2 for z/OS
Jim Wankowski, CA

Most DBAs today do not have the time or bandwith to effectively monitor, manage, and maintain application access paths.  DB2 has been introducing automatic facilities such as Real-Time statistics to help make application performance, and maintenance management more "hands off".  DB2 V10 introduced several new features focused particularly on managing statistics, access paths, and to assist in managing application performance.

This presentation will discuss real-time statistics and the new maintenance features added in V10 such as autonomic statistics, and statistics profiles.  It will also cover application optimization features such as plan management policies, statement level optimization, and the new production modeling capability.

Key topics covered include:

  • Real-Time statistics
  • Performance Profiles
  • Maintenance for Performance
    • Reorganization
      • Autonomic Statistics
  • Managing Access Paths
  • Plan Management Policies
  • Rebind EXPLAIN (ONLY)
  • Statement Level Optimization
  • Production Modeling

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 pewerful 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.

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
- (unavailable)

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.

Jim Wankowski has more than 29 years of development and database administration experience with DB2 for both z/OS and LUW. Jim started his DB2 career by participating in the original DB2 beta program in 1984 with Northrop Aircraft in Los Angeles. Jim is currently a principal consultant with CA Technologies supporting their DB2 z/OS tools. Prior to joining CA, Jim spent 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 has regularly presented at IDUG NA, IDUG EMEA, IDUG AP, IBM Technical conference (IOD), regional DB2 user groups, and vendor seminars worldwide.

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